Journal Entry

User Generated

pc26380

Business Finance

Description

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:

  1. 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.


Unformatted Attachment Preview

# 1 2 3 Budgetary Fund Balance Encumbrances Outstanding Estimated Revenues Revenues Appropriations Estimated Other Financing Uses—Interfund Transfers Out Expenditures Other Financing Uses—Interfund Transfers Out Transaction Government levied $2,000,000 of General Fund Property tax for the fiscal year with an estimated uncollectible amount of $400,000. The General Fund paid $350,000 on the vouchers payable that were outstanding at the end of FY 2013. 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 Receivable—Current Estimated Uncollectible Current Taxes Taxes Receivable—Delinquent 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 Balance—Nonspendable—Inventory of Supplies Fund Balance—Restricted—General Government Fund Balance—Restricted—Public Safety Fund Balance—Restricted—Public Works Fund Balance—Restricted—Health and Welfare Fund Balance—Restricted—Culture and Recreation Fund Balance—Committed—General Government Fund Balance—Committed—Public Safety Fund Balance—Committed—Public Works Fund Balance—Committed—Health and Welfare Fund Balance—Committed—Culture and Recreation Fund Balance—Assigned—General Government Fund Balance—Assigned—Public Safety Fund Balance—Assigned—Public Works Fund Balance—Assigned—Health and Welfare Fund Balance—Assigned—Culture and Recreation Fund Balance—Unassigned Budgetary Fund Balance Encumbrances Outstanding Estimated Revenues Revenues Appropriations Estimated Other Financing Uses—Interfund Transfers Out Expenditures Other Financing Uses—Interfund Transfers Out Account DR CR
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

#

1

2
3

Budgetary Fund Balance
Encumbrances Outstanding
Estimated Revenues
Revenues
Appropriations
Estimated Other Financing Uses—Interfund Transfers Out
Expenditures
Other Financing Uses—Interfund Transfers Out

Transaction
Government levied $2,000,000 of General Fund Property tax for the fiscal year with an estimated uncollectible
amount of $400,000.

The General Fund paid $350,000 on the vouchers payable that were outstanding at the end of FY 2013.

The General Fund paid the $13,000 reported as Due to Other Funds at the end of FY 2013. This amount was
reported as In...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags