Can you please help me create a Bank reconciliation and the necessary journal entries for the below attached documents?

Transcribed Image Text:

Name: Accounting Essentials (GACG1047)- Assignment Two 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 Deposits (Cash Receipts) Cheques Written (Cash Payments) 4 7 10 15 187 17 2,130 22 1,404 23 721 225 4,208 29 5,105 $19,895 $ 3,174 Cheque 113 $1,930 1,407 114 1,472 1,559 115 2,413 116 689 117 230 118 118 119 307 120 1,326 121 640 122 3,016 123 741 Total $12,882 Date 2023 Oct. 1 Balance 31 31 Account No. 101 Post Explanation Ref Debit Credit Balance 13542.00 Cr4 19895.00 33437.00 CP8 12882.00 20555.00 Name: Accounting Essentials (GACG1047)- Assignment Two 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 Deposits (Cash Receipts) Cheques Written (Cash Payments) 4 7 10 15 187 17 2,130 22 1,404 23 721 225 4,208 29 5,105 $19,895 $ 3,174 Cheque 113 $1,930 1,407 114 1,472 1,559 115 2,413 116 689 117 230 118 118 119 307 120 1,326 121 640 122 3,016 123 741 Total $12,882 Date 2023 Oct. 1 Balance 31 31 Account No. 101 Post Explanation Ref Debit Credit Balance 13542.00 Cr4 19895.00 33437.00 CP8 12882.00 20555.00

Answer rating: 100% (QA)

Answer Cash balance in bank needs to be arrived at 31 st March 2018 hence the given entries are to be entered in cash receipts and cash payments journal to reflect the correct account balance Cash Rec... View the full answer