Get reliable answers to your questions at Westonci.ca, where our knowledgeable community is always ready to help. Explore a wealth of knowledge from professionals across different disciplines on our comprehensive platform. Our platform provides a seamless experience for finding reliable answers from a network of experienced professionals.

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.


Sagot :

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