I need help complete the tables below. I have finished some parts but I'm not sure if it's correct or not. If you see something wrong please let me know. Thank you!
A Bank reconciliation Now that you have finished recording all of the transactions for the month of June, you are required to prepare a bank reconciliaton as at 30 June 2022. The purpose of the bank reconciliation process is to reconcile the balance of cash shown in the company's ledger account against the balance of cash reported in the bank statement. Instructions for bank reconciliation 1) Identify any reconciling items and record the relevant reconciling items in the appropriate journals. To do this, you will need to use: - the previous month's bank reconciliation statement, and - the current month's bank statement Note that the general journal is not provided on this page of the practice set because you are required to use other journals to record those reconciling items. When you enter items into the journals, if a cheque number is not required, you need to fill the appropriate input box with an X. 2) Post entries recorded in the journals to the appropriate ledger accounts according to the company's accounting policies and procedures 3) Total the Cash at Bank columns in the special journals. Record the amount in the Total row of each journal. On this web page, you are not required to total the rest of the columns in the special journals. You will total these columns and post them to the ledger in the next stage of the practice set. 4) Post the total of the Cash at Bank columns in the special journals to their corresponding ledger account. To confirm that the posting has been performed, a posting reference is recorded in the last row of the special journals. 5) Prepare the bank reconciliation statement as at 30 June 2022. The bank reconciliation statement provided below may contain more rows than required. All answers can be entered as positive or negative numbers as required. Back-On-Track functionality Please note that any answers from previous pages carried through onto this page (either on the page or in a popup information page) have been reset, if necessary, to the correct answers. Your particular answers from previous pages are no longer shown. Remember: - Enter all answers to the nearest whole dollar. - When completing the journals, if a cheque number is not required, you need to fill the appropriate input box with an X. - You are also required to apply the journals and ledgers instructions Before pressing the Submit answers button, we recommend that you click the Show All tab and check that all relevant accounting records have been completed. \begin{tabular}{|l|l|l|l|l} \hline Show All & Bank Reconciliation & Special Journals & Subsidiary Ledgers & General Ledger \\ \hline \end{tabular} The Adrenaline Hut Bank Reconciliation Statement As at 30/06/2022 Balance as per bank statement: Add: deposit in transit Total Less: unpresented cheque No. CR Total Adjusted bank balance Balance as per ledger account Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account', as indicated under the additional nstructions above. Since all transactions in this journal affect the Cash at Bank account, you are asked to enter the name of the appropriate account credited in these ransactions into the Account column so that the type of transaction can be determined by the name of the account entered into this column. The two GST columns in this journal refer to the same GST account (being the account that is used to record the GST related to applicable cash receipts). Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account', as indicated under the additional instructions above. Since all transactions in this journal affect the Cash at Bank account, you are asked to enter the name of the appropriate account debited in these transactions into the Account column so that the type of transaction can be determined by the name of the account entered into this column. cash payments). SUBSIDIARY LEDGERS Account: ARC - Croquet and Cricket Account No. 110-4 Account: ARC - Balls ' n All (Q=8031106. AcctsRec6_bankRec) Account No. 110-6 (Q=804100. CashAtBank_bankRec ) GENERAL LEDGER Account: Cash at Bank Account No. 100 Account: ARC - Accounts Receivable Control (Q=8041100. ARControl_bankRec) Account No. 110 Account: Interest Payable (Q=804-201.InterestPayable_bankRec) Account No. 225 ( Q=804403. InterestRevenue_bankRec) Account: Interest Revenue Account No. 403 Account: Interest Expense (Q=804-571.InterestExpense_bankRec) Account No. 571 Account: Bank Charges (Q=804-572.BankCharges_bankRec) Account No. 572 A Bank reconciliation Now that you have finished recording all of the transactions for the month of June, you are required to prepare a bank reconciliaton as at 30 June 2022. The purpose of the bank reconciliation process is to reconcile the balance of cash shown in the company's ledger account against the balance of cash reported in the bank statement. Instructions for bank reconciliation 1) Identify any reconciling items and record the relevant reconciling items in the appropriate journals. To do this, you will need to use: - the previous month's bank reconciliation statement, and - the current month's bank statement Note that the general journal is not provided on this page of the practice set because you are required to use other journals to record those reconciling items. When you enter items into the journals, if a cheque number is not required, you need to fill the appropriate input box with an X. 2) Post entries recorded in the journals to the appropriate ledger accounts according to the company's accounting policies and procedures 3) Total the Cash at Bank columns in the special journals. Record the amount in the Total row of each journal. On this web page, you are not required to total the rest of the columns in the special journals. You will total these columns and post them to the ledger in the next stage of the practice set. 4) Post the total of the Cash at Bank columns in the special journals to their corresponding ledger account. To confirm that the posting has been performed, a posting reference is recorded in the last row of the special journals. 5) Prepare the bank reconciliation statement as at 30 June 2022. The bank reconciliation statement provided below may contain more rows than required. All answers can be entered as positive or negative numbers as required. Back-On-Track functionality Please note that any answers from previous pages carried through onto this page (either on the page or in a popup information page) have been reset, if necessary, to the correct answers. Your particular answers from previous pages are no longer shown. Remember: - Enter all answers to the nearest whole dollar. - When completing the journals, if a cheque number is not required, you need to fill the appropriate input box with an X. - You are also required to apply the journals and ledgers instructions Before pressing the Submit answers button, we recommend that you click the Show All tab and check that all relevant accounting records have been completed. \begin{tabular}{|l|l|l|l|l} \hline Show All & Bank Reconciliation & Special Journals & Subsidiary Ledgers & General Ledger \\ \hline \end{tabular} The Adrenaline Hut Bank Reconciliation Statement As at 30/06/2022 Balance as per bank statement: Add: deposit in transit Total Less: unpresented cheque No. CR Total Adjusted bank balance Balance as per ledger account Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account', as indicated under the additional nstructions above. Since all transactions in this journal affect the Cash at Bank account, you are asked to enter the name of the appropriate account credited in these ransactions into the Account column so that the type of transaction can be determined by the name of the account entered into this column. The two GST columns in this journal refer to the same GST account (being the account that is used to record the GST related to applicable cash receipts). Note: In order to receive full points, for each transaction you must select an account under the column labelled 'Account', as indicated under the additional instructions above. Since all transactions in this journal affect the Cash at Bank account, you are asked to enter the name of the appropriate account debited in these transactions into the Account column so that the type of transaction can be determined by the name of the account entered into this column. cash payments). SUBSIDIARY LEDGERS Account: ARC - Croquet and Cricket Account No. 110-4 Account: ARC - Balls ' n All (Q=8031106. AcctsRec6_bankRec) Account No. 110-6 (Q=804100. CashAtBank_bankRec ) GENERAL LEDGER Account: Cash at Bank Account No. 100 Account: ARC - Accounts Receivable Control (Q=8041100. ARControl_bankRec) Account No. 110 Account: Interest Payable (Q=804-201.InterestPayable_bankRec) Account No. 225 ( Q=804403. InterestRevenue_bankRec) Account: Interest Revenue Account No. 403 Account: Interest Expense (Q=804-571.InterestExpense_bankRec) Account No. 571 Account: Bank Charges (Q=804-572.BankCharges_bankRec) Account No. 572
