Question
The Budgetary Comparison Schedule for the City of Salem appears in Illustration 2-16. Assume the general and subsidiary ledgers for the General Fund were lost
The Budgetary Comparison Schedule for the City of Salem appears in Illustration 2-16. Assume the general and subsidiary ledgers for the General Fund were lost after a water pipe burst. You are charged with reproducing the journal entries that took place during the year ended December 31, 2020. Use the Excel file provided to prepare summary journal entries, including subsidiary ledger entries, for the following events:
a. Record the original budget.
b. Record the revisions to the budget.
c. Record the actual revenues.
d. Record the encumbrances, assuming all expenditures originated as encumbrances and the encumbrance and expenditure are equal in amount.
e. Record the actual expenditures and reversal of the associated encumbrance.
CITY OF SALEM Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual: General Fund For The Year Ended December 31, 2020 Budgeted Amounts REVENUES Property Taxes Other Local Taxes Charges for Services Intergovernmental Miscellaneous TOTAL REVENUES Original 14,677,000 11,562,500 1,613,011 7,892,080 1,504,977 37,249,568 Final 14,677,000 11,562,500 1,613,011 8,047,907 1,388,385 37,288,803 Actual Amounts Budgetary Basis 15,361,830 11,761,522 1,601,435 7,098,698 1,262,549 37,086,034 Variance with Final Budget 684,830 199,022 (11,576) (949,209) (125,836) (202,769) EXPENDITURES Current General Government Judicial Administration Public Safety Public Works Health and Welfare Education Parks and Recreation Community Development TOTAL EXPENDITURES 3,567,838 1,351,000 7,753,002 4,541,651 4,823,267 8,963,248 2,983,861 872,594 34,856,461 3,489,870 1,497,845 8,325,564 4,984,353 4,440, 167 8,929,725 3,097,528 904,168 35,669,220 3,453,502 1,456,734 8,216,347 4,602,273 4,418,294 8,887,834 3,055,325 899,209 34,989,518 36,368 41,111 109,217 382,080 21,873 41,891 42,203 4,959 679,702 2,393, 107 1,619,583 2,096,516 476,933 REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES): Transfers (to) other funds (3,560,000) (3,560,000) (3,257,000) (3,257,000) (3,256,899) (3,256,899) 101 101 477,034 Excess of revenues and other sources over (under) expenditures and other uses FUND BALANCE - Beginning of Year FUND BALANCE - End of Year (1,166,893) 12,338,963 11,172,070 (1,637,417) 12,338,963 10,701,546 (1,160,383) 12,338,963 11,178,580 477,034 General Ledger Debits Credits Subsidiary Ledger Debits Credits a. Record the original budget Revenues control account Estimated Revenues ledger: Appropriations control account Appropriations subsidiary ledger. Other Financing Uses subsidiary ledger: Transfers out General Ledger Debits Credits Subsidiary Ledger Debits Credits b. Record the budget revisions Revenues subsidiary ledger: Appropriations subsidiary ledger: Other Financing Uses subsidiary ledger: c. Record the Actual Revenues General Ledger Debits Credits Subsidiary Ledger Debits Credits Revenues subsidiary ledger. General Ledger Debits Credits d. Record the encumbrances Subsidiary Ledger Debits Credits Encumbrances subsidiary ledger. General Ledger Subsidiary Ledger e. Record the actual expenditures and Encumbrance Reversals Debits Credits Debits Credits Encumbrances subsidiary ledger. Expenditures Control Expenditures subsidiary ledger: CITY OF SALEM Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual: General Fund For The Year Ended December 31, 2020 Budgeted Amounts REVENUES Property Taxes Other Local Taxes Charges for Services Intergovernmental Miscellaneous TOTAL REVENUES Original 14,677,000 11,562,500 1,613,011 7,892,080 1,504,977 37,249,568 Final 14,677,000 11,562,500 1,613,011 8,047,907 1,388,385 37,288,803 Actual Amounts Budgetary Basis 15,361,830 11,761,522 1,601,435 7,098,698 1,262,549 37,086,034 Variance with Final Budget 684,830 199,022 (11,576) (949,209) (125,836) (202,769) EXPENDITURES Current General Government Judicial Administration Public Safety Public Works Health and Welfare Education Parks and Recreation Community Development TOTAL EXPENDITURES 3,567,838 1,351,000 7,753,002 4,541,651 4,823,267 8,963,248 2,983,861 872,594 34,856,461 3,489,870 1,497,845 8,325,564 4,984,353 4,440, 167 8,929,725 3,097,528 904,168 35,669,220 3,453,502 1,456,734 8,216,347 4,602,273 4,418,294 8,887,834 3,055,325 899,209 34,989,518 36,368 41,111 109,217 382,080 21,873 41,891 42,203 4,959 679,702 2,393, 107 1,619,583 2,096,516 476,933 REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES): Transfers (to) other funds (3,560,000) (3,560,000) (3,257,000) (3,257,000) (3,256,899) (3,256,899) 101 101 477,034 Excess of revenues and other sources over (under) expenditures and other uses FUND BALANCE - Beginning of Year FUND BALANCE - End of Year (1,166,893) 12,338,963 11,172,070 (1,637,417) 12,338,963 10,701,546 (1,160,383) 12,338,963 11,178,580 477,034 General Ledger Debits Credits Subsidiary Ledger Debits Credits a. Record the original budget Revenues control account Estimated Revenues ledger: Appropriations control account Appropriations subsidiary ledger. Other Financing Uses subsidiary ledger: Transfers out General Ledger Debits Credits Subsidiary Ledger Debits Credits b. Record the budget revisions Revenues subsidiary ledger: Appropriations subsidiary ledger: Other Financing Uses subsidiary ledger: c. Record the Actual Revenues General Ledger Debits Credits Subsidiary Ledger Debits Credits Revenues subsidiary ledger. General Ledger Debits Credits d. Record the encumbrances Subsidiary Ledger Debits Credits Encumbrances subsidiary ledger. General Ledger Subsidiary Ledger e. Record the actual expenditures and Encumbrance Reversals Debits Credits Debits Credits Encumbrances subsidiary ledger. Expenditures Control Expenditures subsidiary ledger
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started