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. S. 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 Question 2 of 25 Bank Reconciliation November 30, 2022 $ Cashbalance per Bank Add 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 $ $ $ $ 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) 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 (To record cheque printing charges) Nov 30 (To record NSF cheque)