In: Accounting
Listed below (in alphabetical order) are the general ledger and budgetary accounts for the City of Walland. All balances are year end, unless otherwise noted. All accounts have a normal balance. At the end of the year, the City Council passed an ordinance that all outstanding orders would be honored in the following fiscal year. Also, the Finance Officer set aside $40 for equipment replacement.
Requirements:
1. Prepare the Statement of Revenues, Expenditures, and Changes in Fund Balance for the year ended June 30, 20X4.
2. Prepare the Balance Sheet for the year ended June 30, 20X4.
3. Prepare all necessary closing entries.
City of Walland
Preclosing Trial Balance
For the Year Ended June 30, 20X4
Advance to Enterprise Fund................................................................................ 1,000
Allowance for Uncollectible Taxes...................................................................... 300
Appropriations.................................................................................................... 8,850
Budgetary Fund Balance...................................................................................... 150
Cash..................................................................................................................... $5,000
Due from Special Revenue Fund......................................................................... 100
Encumbrances Outstanding................................................................................. 60
Encumbrances...................................................................................................... 60
Estimated Revenues............................................................................................. 9,000
Expenditures – Capital Outlay............................................................................ 2,500
Expenditures – Operating.................................................................................... 6,340
Fund Balance (July 1, 20X3)............................................................................... 9,505
Investments......................................................................................................... 2,500
OFS – Proceeds from Sale of Vehicle.................................................................. 50
OFS – Transfer from Capital Projects Fund....................................................... 60
OFU – Transfer to Debt Service Fund................................................................ 100
OFU – Transfer to Enterprise Fund.................................................................... 200
Revenues – Other................................................................................................ 1,250
Revenues – Property Taxes................................................................................. 7,500
Salaries Payable................................................................................................... 50
Special Item – Proceeds from Sale of Land.......................................................... 350
Supplies............................................................................................................... 175
Taxes Receivable.................................................................................................. 1,500
Vouchers Payable................................................................................................ 350
Statement of Revenues, Expenditures, and Changes in Fund Balances | ||||
item | General | other governmental funds | total governmental funds | |
Revenues | ||||
Estimated revenues | $9,000 | $9,000 | ||
Revenues | $1,250 | $1,250 | ||
property taxes | $7,500 | $7,500 | ||
Total revenues | $16,500 | $1,250 | $17,750 | |
Expenditures | ||||
Current: | ||||
operating expenditure | $6,340 | $6,340 | ||
supplies | $175 | $175 | ||
Capital outlay | $2,500 | $2,500 | ||
Total expenditure | $9,015 | $0 | $9,015 | |
Excess/(deficiency) of revenue over expenditure | $7,485 | $1,250 | $8,735 | |
Other financing sources(uses) | ||||
Sale of vehicle proceeds | $50 | $50 | ||
Transfers-in | $60 | $60 | ||
Transfers-out to debt service fund | -$100 | -$100 | ||
Transfers-out to enterprise fund | -$200 | -$200 | ||
Total other financing sources (uses) | -$190 | $0 | -$190 | |
Special financing item | ||||
Proceeds from sale of land | $350 | $350 | ||
Net change in fund balance | $7,645 | $1,250 | $8,895 | Excess/(deficiency) of rev over exp + Total Other Financing sources(uses) + Proceeds from sale of land |
Fund balance in beginning | $9,505 | $9,505 | ||
Fund balance in end | $17,150 | $1,250 | $18,400 |