Expert answer:Journal Entry

Expert answer:Assignment Option #1: Government TransactionsUsing 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 entriesRequirements: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.
act470_studenttemplate_ct_mod07_opt1__1_.xlsx

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

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades