#	Transaction	Account	DR	CR
1	Government levied $2,000,000 of General Fund Property tax for the fiscal year with an estimated uncollectible amount of $400,000.
2	The General Fund paid $350,000 on the vouchers payable that were outstanding at the end of FY 2013.
3	The General Fund paid the $13,000 reported as Due to Other Funds at the end of FY 2013. This amount was reported as Internal Payables to Business -type Activities at the government-wide level.
	Assume that it is Tax Year 2014. Complete the yellow area for the General Fund only.
	Chart of Accounts for General Fund
	Cash
	Taxes ReceivableCurrent
	Estimated Uncollectible Current Taxes
	Taxes ReceivableDelinquent
	Estimated Uncollectible Delinquent Taxes
	Interest and Penalties Receivable on Taxes
	Estimated Uncollectible Interest and Penalties
	Due from Other Funds
	Due from State Government
	Inventory of Supplies
	Vouchers Payable
	Tax Anticipation Notes Payable
	Due to Other Funds
	Due to Federal Government
	Due to State Government
	Fund BalanceNonspendableInventory of Supplies
	Fund BalanceRestrictedGeneral Government
	Fund BalanceRestrictedPublic Safety
	Fund BalanceRestrictedPublic Works
	Fund BalanceRestrictedHealth and Welfare
	Fund BalanceRestrictedCulture and Recreation
	Fund BalanceCommittedGeneral Government
	Fund BalanceCommittedPublic Safety
	Fund BalanceCommittedPublic Works
	Fund BalanceCommittedHealth and Welfare
	Fund BalanceCommittedCulture and Recreation
	Fund BalanceAssignedGeneral Government
	Fund BalanceAssignedPublic Safety
	Fund BalanceAssignedPublic Works
	Fund BalanceAssignedHealth and Welfare
	Fund BalanceAssignedCulture and Recreation
	Fund BalanceUnassigned
	Budgetary Fund Balance
	Encumbrances Outstanding
	Estimated Revenues
	Revenues
	Appropriations
	Estimated Other Financing UsesInterfund Transfers Out
	Expenditures
	Other Financing UsesInterfund Transfers Out

Assignment Option #1: Government Transactions

Using the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for each of the following government fund transaction:

Perform the required journal entries

Requirements:

Complete all work on the spreadsheet attached to this assignment; it will be your only deliverable.

Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file for grading.

Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.