Question

Sandhill Co. of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2022, the companyâs Cash account per its general ledger showed a balance of $6,833.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
XXX XXX 5-31 7,063.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 $59.00 for the printing of additional company checks.
2. Cash sales of $902.15 on May 12 were deposited in the bank. The cash receipts journal entry and the deposit slip were incorrectly made for $952.15. The bank credited Sandhill Co. for the correct amount.
3. Outstanding checks at May 31 totaled $285.25, and deposits in transit were $1,899.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 Sandhill Co. for $648.00.
5. $2,804.00 was collected from a customer note receivable by the bank for Sandhill Co. on May 31 through electronic funds transfer.
6. Included with the canceled checks was a check issued by Tomins Company to C. Pernod for $341.00 that was incorrectly charged to Sandhill Co. by the bank.
7. On May 31, the bank statement showed an NSF charge of $475.00 for a check issued by Sara Ballard, a customer, to Sandhill Co. on account.

Required:
Prepare the bank reconciliation at May 31, 2022.

Answer 1

Solution :

                          Bank Reconciliation

         Particulars                                                        Amount($)      Amount($)

Cash of balance as per bank statement                                            7063

Add : the deposit in transit                                         1899.15

         the bank error - bridge check                            341

                                                                                                            2240.15

                                                                                                            9303.15

Less : outstanding checks                                                                   285.25

Adjusted cash balance as per bank                                                   9017.90

Cash of balance as per books                                                           6833.90

Add : collection of notes receivable                                                  2804

                                                                                                            9637.90

Less : NSF check                                                        475

         Error in May, 12 transaction(902.15-952.15)     50

         Error in recording - 1181 (684 -648)                   36

Check printing charge                                                 59

                                                                                                              620

Adjusted cash balance as per books                                               9017.90