80.2K

Verified Solution

Link Copied!

The bank portion of last month's bank reconciliation for Sandhill Ltd. at February 28 was as follows: SANDHILL LTD. Bank Reconciliation February 28 Cash balance per bank Add: Deposits in transit $17,951 3,119 21,070 Less: Outstanding cheques #3451 $1,957 2,145 #3470 4,102 $16,968 Reconciled cash balance The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at February 28. The March bank statement showed the following: SANDHILL LTD. Bank Statement March 31 Amounts Deducted from Account (Debits) Amounts Added to Account (Credits) Date Description Feb. 28 Opening balance Mar. 1 Cheque, No. 3451 1 Deposit Balance 17,951 15,994 19,113 1,957 3,119 2145 16 069 FULL SCREEN The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at February 28. The March bank statement showed the following: Amounts Added to Account (Credits) 3,119 SANDHILL LTD. Bank Statement March 31 Amounts Deducted from Date Description Account (Debits) Feb. 28 Opening balance Mar. 1 Cheque, No. 3451 1,957 1 Deposit 2 Cheque, No. 3470 2,145 4 Deposit 9 Cheque, No. 3471 1,671 10 Returned cheque-NSF, J. Mustafa 873 10 NSF fee 35 15 EFT, loan payment 1,202 19 Cheque, No. 3472 1,823 26 Deposit 31 EFT, collection on account from M. Boudreault 31 Bank service charges and credit card fees 89 1,973 Balance 17,951 15,994 19,113 16,968 18,941 17,270 16,397 16,362 15,160 13,337 16,597 3,260 613 17,210 17,121 Sandhill's cash receipts and payments for the month of March showed the following: The reconciled cash balance per bank agreed with the reconciled cash balance per books after the bank reconciliation at February 28. The March Amounts Added to Account (Credits) 3,119 SANDHILL LTD. Bank Statement March 31 Amounts Deducted from Date Description Account (Debits) Feb. 28 Opening balance Mar. 1 Cheque, No. 3451 1,957 1 Deposit 2 Cheque, No. 3470 2,145 4 Deposit 9 Cheque, No. 3471 1,671 10 Returned cheque---NSF, J. Mustafa 873 10 NSF fee 35 15 EFT, loan payment 1,202 19 Cheque, No. 3472 1,823 26 Deposit 31 EFT, collection on account from M. Boudreault 31 Bank service charges and credit card fees 89 1,973 Balance 17,951 15,994 19,113 16,968 18,941 17,270 16,397 16,362 15,160 13,337 16,597 3,260 613 17,210 17,121 Sandhill's cash receipts and payments for the month of March showed the following: Cash Receipts Cash Payments ryed. A Division of John Wiley & Sons Inc. 613 17,210 31 Bank service charges and credit card fees 89 17,121 Sandhill's cash receipts and payments for the month of March showed the following: Cash Receipts Amount Date Mar. $1,973 3,260 4,013 $9,246 26 Cash Payments Date Number Amount Mar. 7 3471 $1,671 15 3472 1,283 29 3473 4,919 31 $7,873 Additional information: 1. The EFT loan payment should have been recorded by the company on March 15, but this entry was missed. The payment included $84 of interest and a $1,118 payment on the loan principal. 2. The bank made an error processing cheque #3472 3. The EFT collection was not previously recorded. 4. Bank service charges and credit card fees totalling $89 were not previously recorded. Calculate the cash balance per books at March 31, prior to reconciliation Caash balance per books at March 31 $ 2. The bank made an error processing cheque #3472. 3. The EFT collection was not previously recorded. 4. Bank service charges and credit card fees totalling $89 were not previously re Calculate the cash balance per books at March 31, prior to reconciliation. Caash balance per books at March 31 What is the amount of the deposits in transit at March 31? Deposit in transit $ What is the amount of the outstanding cheques at March 31? Outstanding cheques Prepare the bank reconciliation at March 31. (List items that increase balance as per bank & books first.) YAP LTD. Bank Reconciliation March 31 $

Answer & Explanation Solved by verified expert

See Answer