Question

Sunland Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2017, the company’s Cash account per its general ledger showed a balance of $6,823.90. The bank statement from Emporia State Bank on that date showed the following balance.

EMPORIA STATE BANK
Checks and Debits Deposits and Credits Daily Balance
5-317,053.00
A comparison of the details on the bank statement with the details in the Cash account revealed the following facts
1. The statement included a debit memo of $57.00 for the printing of additional company checks
2. Cash sales of $900.15 on May 12 were deposited in the bank. The cash receipts entry and the deposit slip were incorrectly made for $950.15. The bank credited Sunland Company for the correct amount
3. Outstanding checks at May 31 totaled $285 25, and deposits in transit were $1.897.15.
4. On May 18, the company issued check No. 1181 for $684.00 to H. Moses, on account. The check, which cleared the bank in May, was incorrectly journalized and posted by Sunland Company for $648.00
5. A 52.792.00 note receivable was collected by the bank for Sunland Company on May 31 through electronic funds transfer
6. Included with the canceled checks was a check issued by Tomins Company to C. Pernod for $343.00 that was incorrectly charged to Sunland Company by the bank
7. On May 31, the bank statement showed an NSF charge of $465.00 for a check issued by Sara Ballard, a customer to Sunland Company on account
Prepare the bank reconciliation at May 31, 2017. (List items that increase balance as per bank & books first. Round answers to 2 decimal places, eg. 52.75)

Answer 1

Bank account reconciliation:

Bank account balance $7,053

+ Deposits in transit $1,897.15

+ Check charged by error $343

- Outstanding checks ($285.25)

Reconciled bank account $9,007.90

Cash account reconciliation:

Cash account balance $6,823.90

+ Note receivable collected by bank $2,792

- Bank fees for printing checks ($57)

- Error on deposit slip ($50)

- Error on recording check ($36)

- NSF check ($465)

Reconciled cash account $9,007.90