The bank portion of last month's bank reconciliation for Sandhill Limited at October 31 is shown here: SANDHILL LIMITED Bank Reconciliation October 31 Cash balance per bank $25.110 Add: Deposits in transit 2.690 27.800 Less: Outstanding cheques #2472 $1.450 42473 1.520 #2474 978 3.948 Reconciled cash balance $23,852 The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at October 31. The November bank statement showed the following: SANDHILL LIMITED Bank Statement November 30 Amounts Deducted from Account (Debits) Amounts Added to Account (Credits) Date Oct. 31 Nov 1 Description Balance 25.110 23,660 Cheque. No, 2472 Depok 1.450 1 SANDHILL LIMITED Bank Statement November 30 Amounts Deducted from Date Description Account (Debits) Oct 31 No 1 Cheque, No 2472 1.450 1 Deposit 2 Cheque. No. 2473 1,520 3 Deposit 4 Cheque, No. 2475 3,195 7 Deposit 8 Cheque No. 2476 5.780 10 Cheque. No: 2477 1.200 14 Deposit 15 Cheque. No. 2478 3.700 15 EFT salaries 7,000 20 Deposit 25 Returned cheque -- NSF. Glasson Developments 400 25 NSFfee 9 26 Cheque. No: 2479 1.300 27 Deposit 28 EFT, collection of not receivable and interest 30 Cheque No. 2481 1042 30 EFT, salaries 7.000 30 Bank service charges 5 Amounts Added to Account (Credits) Balance 25.110 23,660 2.690 26,350 24,830 2354 27.184 23.989 1.880 25,869 20.089 18.889 5.650 24.539 20,839 13.839 5,890 19.729 19.329 19.320 18.020 2400 21.420 5.122 26,542 25,500 18.500 18.495 The cash records per books for November showed the following Date . Date Nov. 1 Cash Payments Number 2475 2476 2477 2478 Cash Receipts Amount 3 $2,354 7 1.880 12 5,650 20 5,908 27 3,400 30 3.310 $22.502 2 2 8 15 15 18 20 29 30 2479 EFTsables 2480 2481 2482 EFTsalarios Amount $3.195 4880 1.200 3,700 1.300 7,000 1.174 1042 1.750 7.000 $32.241 Additional information 1 The EFT collection on November 28 was not previously recorded. The collection of the note was for $4,300 plus $822 interest. Interest was not previously accrued. 2 EFT payments are recorded when they occur. 3. The bank did not make any errors Two errors were made by the company one in recording a cheque and one in recording cash receipt. The correction of any errors in the recording of cheques should be made to Accounts Payable. The correction of any errors in the recording of cash receipts should be made to Accounts Receivable. Prepare the bank reconciliation at November 30. (List items that increase balance as per bank & books first.) SANDHILL LIMITED Bank Reconciliation November 30 Balance per bank statement Add : Deposits in transit $ $ $
