The bank portion of last month's bank reconciliation for Oriole Ltd. at February 28 was as follows: ORIOLE LTD. Bank Reconciliation February 28 Cash balance per bank $17,968 Add: Deposits in transit 3,137 21,105 Less: Outstanding cheques #3451 $1,951 #3470 2,145 4,096 Reconciled cash balance $17,009 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) Date 3,137 1,961 ORIOLE LTD. Bank Statement March 31 Amounts Deducted from Description Account (Debits) Feb. 28 Opening balance Mar. 1 Cheque, No. 3451 1,951 1 Deposit 2 Cheque, No. 3470 2,145 4 Deposit 9 Cheque, No. 3471 1,690 10 Returned cheque-- NSF, J. Mustafa 870 10 NSF fee 35 15 EFT, loan payment 1,212 19 Cheque, No. 3472 1,833 26 Deposit 31 EFT, collection on account from M. Boudreault 31 Bank service charges and credit card fees 88 Balance 17,968 16,017 19,154 17,009 18,970 17,280 16,410 16,375 15,163 13,330 16,608 3,278 613 17,221 17,133 Oriole's cash receipts and payments for the month of March showed the following: Cash Receipts Cash Payments Date Amount Date Number Amount Mar. 4 $1,961 Mar. 7 3471 $1,690 26 3,278 15 3472 1,383 31 3,983 29 3473 4,932 $9,222 $8,005 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 $83 of interest and a $1,129 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 $88 were not previously recorded. 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 317 Deposit in transit What is the amount of the outstanding cheques at March 317 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 $ > $ A S A Prepare any journal entries required from the reconciliation. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter o for the amounts.) Date Account Titles and Explanation Debit Credit Mar. 31 (To record EFT collections) 31 (To record bank charges and fees) 31 (To record NSF cheque and fee) 31 (To record EFT loan payment)