- - View Policies Current Attempt in Progress Pina Colada Coffee Limited's bank statement for the month of November 2022 showed a balance per bank of $7.120. The company's general ledger Cash account showed a balance of $5,779 at November 30. Other information is as follows: 1. Cash receipts for November 30 recorded on the company's books were $5,320, but this amount does not appear on the bank statement 2. The bank statement shows a debit memorandum for $64 for cheque printing charges. 3. Cheque #119 payable in the amount of $358 to Holt Corporation was recorded in the general journal and cleared the bank for $358. A review of the accounts payable records shows a $27 credit balance in Holt's account and that the total payment should have been for $385. 4. The total amount of cheques outstanding at November 30 was $5,962. 5. Cheque #138 was correctly written and paid by the bank for $329. The cash payment journal reflects an entry for Cheque #138 as a debit to Accounts Payable and a credit to Cash for $392. 6. The bank returned an NSF cheque from a customer for $680. 7. The bank statement included a deposit for $1,380, which represents the electronic collection of customer accounts which have not yet been recorded on the company's books. Prepare a bank reconciliation for Pina Colada Coffee Limited at November 30, 2022. (list items that increase balance first.) PINA COLADA COFFEE LIMITED Bank Reconciliation 2 PINA COLADA COFFEE LIMITED Bank Reconciliation November 30, 2022 Accounts payable error Cash Balance per Books Cash balance per Bank Cheque printing Deposit in transit Electronic collections NSF cheque Outstanding cheques Reconciled cash balance per bank Reconciled cash balance per books $ $ $ . - 2 . Prepare any journal entries necessary as a result of the bank reconciliation (Credit account titles are automatically indented when the amount is entered. Do not indent manually. List all debit entries before credit entries.) Date Account Titles and Explanation Debit Credit Nov 30 (To correct error in recording Cheque #138) Nov 30 (To record collection of accounts receivable) Nov 30 ricarony JUSTICE TESUT OF LOHIRTELUTILITICU LUTE TEESUT ETURY indented when the amount is entered. Do not indent manually. List all debit entries before credit entries.) Date Account Titles and Explanation Debit Credit Nov 30 (To correct error in recording Cheque #138) Nov 30 (To record collection of accounts receivable) Nov 30 (To record cheque printing charges) Nov 30 (To record NSF cheque) Current Attempt in Progress Listed below are items that may be useful in preparing the March 2022 bank reconciliation for Kelvin Industrial Using the code letters below, insert in the space before each item the letter where the amount would be located or otherwise treated in the bank reconciliation process. Code A A. . Located or Treated Add to the cash balance per books. Deduct from the cash balance per books Add to the cash balance per bank. Deduct from the cash balance per bank Does not affect the bank reconciliation C. D. E 1. Included with the bank statement materials was a cheque from Angus Reeds for $65 stamped "account closed B 2. The bank statement included a bank service charge of $45 in payment of the annual safety deposit box fee. 3. The bank statement included a bank service charge of $18 for three books of blank cheques for Kelvin Industrial 4. The bank statement contains a credit of $38.00 for interest earned on the chequing account balance during the D E month, 5. The deposits of March 30 and March 31, for $4 282 and $4,391 respectively, were not included on the bank statement -12 E. Does not affect the bank reconciliation 1. Included with the bank statement materials was a cheque from Angus Reeds for $65 stamped "account closed." 2. The bank statement included a bank service charge of $45 in payment of the annual safety deposit box fee. 3. The bank statement included a bank service charge of $18 for three books of blank cheques for Kelvin Industrial 4 : 4. The bank statement contains a credit of $38.00 for interest earned on the chequing account balance during the month. 5. The deposits of March 30 and March 31, for $4,282 and $4,391 respectively, were not included on the bank statement. 6. Two cheques totalling $742.44, which were outstanding at the end of February, cleared in March and were returned with the March statement 7. The bank statement included a credit of $85 for the monthly interest on a certificate of deposit that the company owns. 8. Four cheques, #3416, #3420,#3422, #3423, totalling $7.412.32, did not clear the bank during March 9. On March 24, $2,600 was credited by the bank to Kelvin Industrial bank account as an electronic funds transfer from a customer in payment of its account. This was not recorded in advance by the company, 10. On March 31, Kelvin Industrial paid its $650 utility bill using the bank online payment system. As Kelvin Industrial initiated this payment, it recorded it in advance of receiving the bank statement