Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer it only if you know how to solve it. THANK YOU! Accounting Cycle Project - Chapter 9 Following is the trial balance of

Please answer it only if you know how to solve it. THANK YOU!image text in transcribed

Accounting Cycle Project - Chapter 9 Following is the trial balance of City of Kendall Green's General Fund at December 31, 2019. Using MS-Excel, prepare well-formatted worksheets as follows: (a) closing entries (b) a post-closing trial balance. (c) a statement of revenues, expenditures, and changes in fund balance for the year ended December 31, 2019 (d) a balance sheet at December 31, 2019. Debits Credits Cash $ 20,000 Property taxes receivable 30,000 Due from other funds 10,000 Vouchers payable $ 15,000 Unassigned fund balance, January 1, 2019 25,000 Revenuesproperty taxes 325,000 Revenuesother 35,000 Expendituressalaries 280,000 Expenditures-materials 20,000 Transfer out to Debt Service Fund 40,000 Encumbrancesmaterials 4,000 Budgetary fund balance reserved for encumbrances 4,000 Estimated revenues--property taxes 325,000 Estimated revenuesother 40,000 Appropriationssalaries 290,000 Appropriationsmaterials 25,000 Appropriationstransfer out to Debt Service Fund 40,000 Budgetary fund balance 10,000 Totals $769,000 $769,000 Accounting Cycle Project - Chapter 9 Following is the trial balance of City of Kendall Green's General Fund at December 31, 2019. Using MS-Excel, prepare well-formatted worksheets as follows: (a) closing entries (b) a post-closing trial balance. (c) a statement of revenues, expenditures, and changes in fund balance for the year ended December 31, 2019 (d) a balance sheet at December 31, 2019. Debits Credits Cash $ 20,000 Property taxes receivable 30,000 Due from other funds 10,000 Vouchers payable $ 15,000 Unassigned fund balance, January 1, 2019 25,000 Revenuesproperty taxes 325,000 Revenuesother 35,000 Expendituressalaries 280,000 Expenditures-materials 20,000 Transfer out to Debt Service Fund 40,000 Encumbrancesmaterials 4,000 Budgetary fund balance reserved for encumbrances 4,000 Estimated revenues--property taxes 325,000 Estimated revenuesother 40,000 Appropriationssalaries 290,000 Appropriationsmaterials 25,000 Appropriationstransfer out to Debt Service Fund 40,000 Budgetary fund balance 10,000 Totals $769,000 $769,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using QuickBooks Online For Accounting

Authors: Glenn Owen

3rd Edition

0357391691, 9780357391693

More Books

Students also viewed these Accounting questions

Question

How does a table differ from other data organization methods?

Answered: 1 week ago

Question

How would you describe Mark Zuckerberg as a team leader?

Answered: 1 week ago