Can you please help make a balance bank reconciliation together with the Journal entries of the below-attached file?

Transcribed Image Text:

Name: 1. Using the Bank Statement below for October and the columns of the cash receipts journal, cash payments journal and the cash ledger account-Prepare a Bank Reconciliation for Romeo's Roses and prepare all necessary journal entries to bring the books up to date. (value 23) A partial chart of accounts includes the following: cash 101, accounts receivable 110, notes receivable 120, interest revenue 420, utilities expense 640, and bank charges expense 670. In addition: Cheque 123 was written to pay the utility bill (assume any errors were made by the company bookkeeper. The credit memo is for a notes receivable that the bank collected for $4000 plus interest on our behalf. The debit memo indicated a cheque from R Walters had been returned NSF. October Total Cash Accounting Essentials (GACG1047) - Assignment Two Date Deposits (Cash Receipts) 4 7 10 15 17 22 23 25 29 2023 Oct. 1 Balance 31 31 $ 3, 174 1,407 1,559 187 2,130 1,404 721 4,208 5,105 $19,895 Explanation Post Ref Cr4 CP8 Cheques Written (Cash Payments) Cheque Total Debit 19895.00 ........113 114 115 116 117 118 119 120 121 122 123 Credit $1,930 1,472 2,413 689 230 118 307 1,326 640 3,016 741 $12,882 Account No. 101 12882.00 Balance 13542.00 33437.00 20555.00 Name: 1. Using the Bank Statement below for October and the columns of the cash receipts journal, cash payments journal and the cash ledger account-Prepare a Bank Reconciliation for Romeo's Roses and prepare all necessary journal entries to bring the books up to date. (value 23) A partial chart of accounts includes the following: cash 101, accounts receivable 110, notes receivable 120, interest revenue 420, utilities expense 640, and bank charges expense 670. In addition: Cheque 123 was written to pay the utility bill (assume any errors were made by the company bookkeeper. The credit memo is for a notes receivable that the bank collected for $4000 plus interest on our behalf. The debit memo indicated a cheque from R Walters had been returned NSF. October Total Cash Accounting Essentials (GACG1047) - Assignment Two Date Deposits (Cash Receipts) 4 7 10 15 17 22 23 25 29 2023 Oct. 1 Balance 31 31 $ 3, 174 1,407 1,559 187 2,130 1,404 721 4,208 5,105 $19,895 Explanation Post Ref Cr4 CP8 Cheques Written (Cash Payments) Cheque Total Debit 19895.00 ........113 114 115 116 117 118 119 120 121 122 123 Credit $1,930 1,472 2,413 689 230 118 307 1,326 640 3,016 741 $12,882 Account No. 101 12882.00 Balance 13542.00 33437.00 20555.00

Answer rating: 100% (QA)

Bank Reconciliation Statement Bank balance per statement Oct 31 Bank balance per statement Oct 31 33... View the full answer