Question

Prepare a bank reconciliation for Show Me, Inc., as of June 30 from the following information:

(a) The June 30 balance shown on the bank statement is $5,796.
(b) Outstanding checks at June 30 totaled $330.
(c) A deposit of $424 made on June 30 was not included in the balance shown on the bank statement.
(d) The bank statement contained an adjustment of $410 for a note receivable collected by the bank on behalf of Show Me, Inc. ($382 principal and $28 interest).
(e) A bank charge of $34 was made to the account during June. Although the company was expecting a charge, the amount was not known until the bank statement arrived.
(f) The bank erroneously charged a $340 check of Shirt, Inc., against the Show Me, Inc., bank account.
(g) The June 30 balance in the general ledger Cash account, before reconciliation, is $6,026.
(h) The bank statement included a notice that a customer's check for $172 that had been deposited on June 14 had been returned NSF.
Required:
(1) Prepare the bank reconciliation for Show Me, Inc., as of June 30.
(2) Prepare the appropriate adjusting entry(ies) or show the reconciling items in a horizontal model, for Show Me, Inc., related to the bank reconciliation.

Answer 1

bank account reconciliation:

bank account balance $5,796

- outstanding checks $330

+ deposits in transit $424

+ error from Shirt, Inc., check $340

reconciled balance $6,230

cash account reconciliation:

cash account balance $6,026

+ note collected $410

- bank fee $34

- NSF check $172

reconciled balance $6,230

assets = liabilities + equity

cash acc. rec. notes rec. int. rec.

204 172 -382 -28 = 0 + -34

income statement

revenues - expenses = net income

0 - 34 = -34

All the adjustments are considered cash flows from operations.