The City of Rockport has a checking account with First Bank. The city’s cash balance on February 28, 20X1, was $30,000. The deposit balance on the bank’s books on February 28, 20X1, was also $30,000. The following transactions occurred during March.

All cash receipts are deposited via a night depository system after the close of the municipal business day. Therefore, the receipts are not recorded by the bank until the succeeding day.

On March 31, the bank charged the City of Rockport $100 for miscellaneous bank services.

1. Prepare the journal entries on the bank’s books for check 262 and the deposit of March 10.

2. Prepare the journal entries for all March transactions on the books of the City of Rockport.

3. Post all transactions for March to T-accounts for the City’s Cash in Bank account and the bank’s Deposit account. Assume only checks 261 to 263 have been presented to the bank in March, each taking 4 days to clear the bank’s records.

4. Prepare a bank reconciliation for the City of Rockport, March 31, 20X1. The final three City of Rockport transactions of March had not affected the bank’s records as of March 31. What adjusting entry in the books of the City of Rockport is required on March 31?

5. What would be the cash balance shown on the balance sheet of the City of Rockport on March 31, 20X1?

Transcribed Image Text:

Date Check Number Amount Explanation 261 262 $11,500 9,500 12,000 15,000 16,000 8,000 21,000 25,000 Payment of previously billed consulting fee Payment of accounts payable Collection of taxes receivable Acquisition of equipment for cash Collection of license fees receivable Payment of accounts payable Payment of interest on municipal bonds Collection of taxes receivable 3/6 3/10 3/14 263 3/28 3/30 3/31 264 265