Question

In: Accounting

General and Subsidiary Ledger Entries; Reconciliation The City of Beverly Heights General Fund had the following...

General and Subsidiary Ledger Entries; Reconciliation The City of Beverly Heights General Fund had the following transactions, among others, in 20X7:

1. Appropriations were made as follows: Personal Services $111,400 Contractual Services 8,700 Materials and Supplies 8,500 New Patrol Cars 21,000 Other 12,000 $161,600

2. General Fund cash, $2,000, was paid to a Debt Services Fund to provide for debt service.

3. A long-term note of $8,300, including interest of $1,300, and a short-term note of $2,500 (including $150 interest) came due. The Beverly Heights Council had not made appropriations for these items. The necessary action was taken, and the notes and interest were paid.

4. General Fund cash, $100,000, was paid to an Enterprise Fund to finance construction of a new auxiliary generator, and $50,000 was contributed to establish a central motor pool facility. The Enterprise Fund will repay the General Fund in 10 equal annual installments beginning January 1, 20X9.

5. The council increased the appropriation for personal services by $500.

6. Materials and supplies are accounted for on the purchases method. The beginning inventory was $200; $8,500 of materials and supplies were ordered during the year. A new patrol car costing $20,000 was also ordered.

7. The following expenditures were made by the city: Personal Services $111,700 Contractual Services 8,700 Materials and Supplies 7,500 New Patrol Cars 21,200 Other 11,800 $160,900

8. The new patrol cars were received. The balance of the materials order is expected early next year. The council passed amendments to its appropriations necessary to make the foregoing expenditures legal. The expenditures were paid.

9. Materials and supplies on hand at year end amounted to $1,000.

REQUIRED: (a) Prepare the general journal entries required to record the transactions in the General Ledger and in the Expenditures Ledger of the Beverly Heights General Fund. Assume that there were no outstanding encumbrances at the end of 20X6.

(b) Prepare a trial balance of the Expenditures Ledger and prove its agreement with the General Ledger control accounts.

Solutions

Expert Solution

Solution:-

(a) Prepare the general journal entries required to record the transactions in the General Ledger and in the Expenditures Ledger of the Beverly Heights General Fund. Assume that there were no outstanding encumbrances at the end of 20X6:-

Particulars Debit Credit
1. Beverly Heights General Fund $161,600
New Patrol Cars fund $21,000
Material and supplies fund $8,500
Contractual services fund $8,700
Personal service fund $111,400
Other funds $12,000
2. Beverly Heights General Fund $2,000
debt service fund $2,000
debt service fund $2,000
Bank $2,000
3. Beverly Heights General Fund

$10,800

Long term note fund $7,000
Short term funds $2,350
Interest funds $1,450
Bank

= 7,000 + 2,350 + 1,450

= $10,800

4. General Fund $100,000
Enterprise fund $50,000
Bank

= $50,000 + $100,000

= $150,000

5. Beverly Heights General Fund $500
personal services fund $500
6. Material supplies $200
Inventory $200
7&8   Materials and supplies

= 8,500 - 7,500

=$1,000

Other funds $200
Personal services

=  [$111,400 + 500] - $111,700

= $200

New Patrol Cars funds

= 21,200 -  21,000

= $200

Beverly Heights General Fund

= 900 + 200 + 200 - 200

= $1,100

Other funds $11,800
Bank $160,900
Material and supplies payables $100
9. Inventory $1,000
Materials and supplies on hand $1,000

(b) Prepare a trial balance of the Expenditures Ledger and prove its agreement with the General Ledger control accounts:-

Account names Amount Amount
Beverly Heights General Fund

= 161,600 + 2,000 + 10,800 + 500 - 1,100

= $173,800

Bank

= 2,000 + 10,800 + 150,000 + 160,900

= $323,700

Enterprise funds

= 100,000 + 50,000

= $150,000

Material supplies

= 1,000 - 200

= $800

Inventory $800
Material and supplies payable $100
Total

= 173,800 + 150,000 + 800

= $324,600

= 323,700 + 800 + 100

= $324,600


Related Solutions

Prepare the General Ledger journal entries for the General Fund for the City of Corona for...
Prepare the General Ledger journal entries for the General Fund for the City of Corona for the fiscal year ended May 31, 2018. The budget was formally adopted. Estimated revenues are $8,520,000 and appropriations are estimated to be $8,204,500. Revenues were received for $6,562,000. Purchase orders were issued for $2,950,000. Purchase orders were filled for $2,436,000. The invoice amount was $2,443,000, which has been paid. Expenditures, not encumbered, amounted to $3,225,000 which was paid.
Prepare entries in general journal form to record the following transactions in General Fund general ledger...
Prepare entries in general journal form to record the following transactions in General Fund general ledger accounts for fiscal year 2019. Use modified accrual accounting for the General fund only -The legal budget for the year provided for $900,000 of estimated revenues, $800,000 appropriations, and $50,000 transfer out to debt service fund. -Issued $ 250,000 of purchase orders outstanding for office supplies. -Property taxes were levied in the amount of $400,000. It is estimated that 2 percent of the taxes...
he printout of the Revenues and Appropriations subsidiary ledger accounts for the General Fund of the...
he printout of the Revenues and Appropriations subsidiary ledger accounts for the General Fund of the City of Augusta for the first quarter of the fiscal year appeared as follows: Revenues Ledger Est. Revenues Revenues Balance Account Ref. Account Title Dr(Cr) Cr(Dr) Dr(Cr) 3/4020 Taxes—Real Property 101 Budget Authorization 764,000 764,000 102 Received in Cash 212,600 551,400 3/4050 Licenses and Permits 101 Budget Authorization 114,000 114,000 102 Received in Cash 11,400 102,600 3/4070 Intergovernmental Revenue 101 Budget Authorization 64,000 64,000...
a) Approval of bad debt write-offs and the reconciliation of accounts receivable subsidiary ledger and the general ledger control account.
  Explain why each of the following combinations of tasks should or should not be separated to achieve adequate internal control: a) Approval of bad debt write-offs and the reconciliation of accounts receivable subsidiary ledger and the general ledger control account. b) Distribution of payroll cheques to employees and approval of employee time cards. c) Posting of amounts from both the cash receipts and the cash disbursements journals to the general ledger. d) Writing cheques to suppliers and posting to...
how to make general ledger, bank reconciliation
how to make general ledger, bank reconciliation
The City of Mocksville had the following pre-closing account balances in its General Fund as of...
The City of Mocksville had the following pre-closing account balances in its General Fund as of April 30, 2020. Debits and credits are not separated; each account had its “normal” balance. Among the expenditures recorded this year is an amount expended on supplies ordered at the end of the previous year. Assume that encumbrances do not lapse and that the City failed to make the journal entry(s) necessary to re-establish the encumbrance in the current year. Required: (a) Prepare all...
The City of Comstock had a total General Fund balance of $1,400,000 at the end of...
The City of Comstock had a total General Fund balance of $1,400,000 at the end of its fiscal year. The year end balance sheet reports inventory of material and supplies of $60,000. City Council passed an ordinance that all revenue received from hotel occupancy taxes must be used for beautification projects in the City. The City received $280,000 in hotel occupancy taxes and spent $225,000 on beautification projects this year. The City received a Federal grant of $120,000 for specifically...
match each subsidiary ledger and general ledger post one on each description
match each subsidiary ledger and general ledger post one on each description
What journal entries do accountants do everyday? What is general ledger reconciliation? How do you reconcile...
What journal entries do accountants do everyday? What is general ledger reconciliation? How do you reconcile the general ledger (explain the steps from a real company perspective)? Why do accountants need to do journal entries when accounting software can automatically create journal entries? What are daily adjusting entries and give an example?
The City of Castleton’s General Fund had the following post-closing trial balance at June 30, 2019,...
The City of Castleton’s General Fund had the following post-closing trial balance at June 30, 2019, the end of its fiscal year: Debits Credits Cash $ 418,000 Taxes Receivable—Delinquent 590,000 Allowance for Uncollectible Delinquent Taxes $ 196,000 Interest and Penalties Receivable 26,980 Allowance for Uncollectible Interest and Penalties 11,860 Inventory of Supplies 16,800 Vouchers Payable 155,500 Due to Federal Government 66,490 Deferred Inflows of Resources—Unavailable Revenues 402,000 Fund Balance—Nonspendable—Inventory of Supplies 16,800 Fund Balance—Unassigned 203,130 $ 1,051,780 $ 1,051,780 Record...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT