Question

In: Accounting

Bank Reconciliation The Chicago Scooter Company's bank statement for the month of June indicated a balance...

Bank Reconciliation The Chicago Scooter Company's bank statement for the month of June indicated a balance of $10,500. The company's cash account in the general ledger showed a balance of $8,670 on June 30. Other relevant information includes the following:

  1. Deposits in transit on June 30 total $7,800.
  2. The bank statement shows a debit memorandum for a check printing charge of $60.
  3. Check number 160 payable to Simon Company was recorded in the accounting records for $372 and cleared the bank for this same amount. A review of the records indicated that the Simon account now has a $54 credit balance and the check to them should have been $426.
  4. Outstanding checks as of June 30 totaled $8,700.
  5. Check No. 176 was correctly written and paid by the bank for $609. The check was recorded in the accounting records as a debit to accounts payable and a credit to cash for $735.
  6. The bank returned a NSF check in the amount of $1,026.
  7. The bank included a credit memorandum for $1,890 representing a collection of a customer's note. The principle portion was $1,800 and the interest portion was $90. The interest had not been accrued.

Required
a. Prepare the June bank reconciliation for Chicago Scooter Company.
b. Prepare any necessary adjusting entries.

Solutions

Expert Solution

Solution

Chicago Scooter Company

a. Bank Reconciliation Statement

Chicago Scooter Company

Bank Reconciliation Statement

For the Month Ended June 30

Balance as per bank records

$10,500

Add: deposits in transit

$7,800

Less: outstanding checks

($8,700)

($900)

Adjusted bank balance

$9,600

Balance as per cash records

$8,670

Less: bank charges

($60)

Add: error in recording check no. 176

$126

Less: NSF Check

($1,026)

Add: collections by bank

$1,890

$930

Adjusted cash balance

$9,600

b. Adjusting entries:

Date

Account Titles and Explanation

Debit

Credit

Jun-30

Miscellaneous Expenses

$60

Cash

$60

(To record bank charges)

Jun-30

No entry for check no. 160

Jun-30

Cash

$126

Accounts Payable

$126

(To reverse the error in recording check no. 176)

Jun-30

Accounts Receivable

$1,026

Cash

$1,026

(To record NSF check)

Jun-30

Cash

$1,890

Notes Receivable

$1,800

Interest Revenue

$90

(To record notes, including interest revenue collected by bank)

Note: for check no. 160, both bank and cash records have recorded the same amount. Though there exists an error in recording, the error is not reflected in the bank reconciliation statement as both the bank and cash records recorded $372.


Related Solutions

The Circus Company's bank statement for the month of April showed a balance per bank of...
The Circus Company's bank statement for the month of April showed a balance per bank of $7,000. The company's Cash account in the accounting records had a balance of $5,659 at April 30. Other information is as follows:  Cash receipts for April 30 recorded on the company's books were $6,000 but this amount does not appear on the bank statement.  The bank statement shows a debit memorandum for $40 for check printing charges.  Check No. 119 payable...
Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash...
Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash balance of $5,000.17. •The cash ledger account on that date shows a balance of $4,262.83. •Four outstanding checks totaled $717.75. •A $410.90 deposit made after banking hours on July 31 does not appear in the bank statement. •On July 30, the bank returned J.B. Ball’s NSF check for $50.25, received as payment of an account receivable. •The bank statement showed $24.74 interest earned on...
The Tarragon Trading Company's bank statement for the month ofNovember showed a balance per bank...
The Tarragon Trading Company's bank statement for the month of November showed a balance per bank of $7,000. The company's Cash account in the general ledger had a balance of $5,659 at 30 November. Other information is as follows:(1)    Cash receipts for 30 November recorded on the company's books were $5,200 but this amount does not appear on the bank statement.(2)    The bank statement shows a debit memorandum for $40 for cheque printing charges.(3)    The total amount of cheques still...
The Hartman Boat Company's bank statement for the month of November showed a balance per bank...
The Hartman Boat Company's bank statement for the month of November showed a balance per bank of $6,919. The company's Cash account in the general ledger had a balance of $5,659 at November 30. Other information is as follows: (1)    Cash receipts for November 30 recorded on the company's books were $5,200 but this amount does not appear on the bank statement. (2)    The bank statement shows a debit memorandum for $40 for check printing charges. (3)    The total amount...
The Oriole Boat Company's bank statement for the month of November showed a balance per bank...
The Oriole Boat Company's bank statement for the month of November showed a balance per bank of $8,800. The company's Cash account in the general ledger had a balance of $6,778 at November 30. Other information is as follows: (1) Cash receipts for November 30 recorded on the company's books were $6,020 but this amount does not appear on the bank statement. (2) The bank statement shows a debit memorandum for $40 for check printing charges. (3) Check No. 119...
16. Owen Company's unadjusted book balance at June 30 is $14,440. The company's bank statement reveals...
16. Owen Company's unadjusted book balance at June 30 is $14,440. The company's bank statement reveals bank service charges of $120. Two credit memos are included in the bank statement: one for $1,490, which represents a collection that the bank made for Owen, and one for $200, which represents the amount of interest that Owen had earned on its interest-bearing account in June. Based on this information, Owen's true cash balance is: Multiple Choice $14,440. $16,010. $15,730. $16,250. 17. At...
The Carla Vista Boat Company's bank statement for the month of November showed a balance per...
The Carla Vista Boat Company's bank statement for the month of November showed a balance per bank of $8,500. The company's Cash account in the general ledger had a balance of $5,536 at November 30. Other information is as follows: (1) Cash receipts for November 30 recorded on the company's books were $6,480 but this amount does not appear on the bank statement. (2) The bank statement shows a debit memorandum for $50 for check printing charges. (3) Check No....
Bank Reconciliation and Entries The cash account for Pala Medical Co. at June 30, 20Y1, indicated...
Bank Reconciliation and Entries The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $12,020. The bank statement indicated a balance of $14,010 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: Checks outstanding totaled $5,040. A deposit of $5,250, representing receipts of June 30, had been made too late to appear on the bank statement. The bank collected $2,730 on...
Bank Reconciliation and Entries The cash account for Pala Medical Co. at June 30, 20Y1, indicated...
Bank Reconciliation and Entries The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $12,630. The bank statement indicated a balance of $14,690 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: Checks outstanding totaled $5,290. A deposit of $5,510, representing receipts of June 30, had been made too late to appear on the bank statement. The bank collected $2,860 on...
Bank Reconciliation and Entries The cash account for Pala Medical Co. at June 30, 20Y1, indicated...
Bank Reconciliation and Entries The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $14,880. The bank statement indicated a balance of $17,060 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: Checks outstanding totaled $6,140. A deposit of $6,400, representing receipts of June 30, had been made too late to appear on the bank statement. The bank collected $3,330 on...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT