To do Bank Reconciliation first, we need to fill in the CPJ, CRJ, GJ etc. So, given:

Fill in the:

Thanks!

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 2020. 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 statemente 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 proceduresa. 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 2020. 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 provided in previous weeks. 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. If you want to print this page, please read and follow the special printing information to ensure you can print the special journals in full. Bank statement June MRMC Adelaide branch Emilia Fowler 416 Dench Avenue Adelaide, SA 5000 Account No 94723723 Page No. 1 Spine Tinglers Debit Credit $5,200 $580 $1,170 $3,731 $9,300 $4,048 $861 $3,527 $581 $4,330 $3,366 $2,925 Date Particulars 1 JUN BALANCE BROUGHT FORWARD 1 JUN 629 2 JUN DEPOSIT - Cliffs Notes 2 JUN 630 4 JUN DEPOSIT - Attic Books 5 JUN 631 6 JUN DEPOSIT - Gimmicks 6 JUN 632 7 JUN 633 7 JUN 634 11 JUN 635 11 JUN 636 11 JUN DEPOSIT - Cliffs Notes 12 JUN 637 15 JUN 638 15 JUN DEPOSIT - Cash sales 17 JUN DEPOSIT - Paige Turners 19 JUN 639 19 JUN CHEQUE RETURNED - Paige Turners 19 JUN 640 26 JUN DEPOSIT - Cash sales 27 JUN 642 30 JUN DEPOSIT - Cash sales 30 JUN 643 30 JUN 644 30 JUN TRANSACTION FEE 30 JUN INTEREST Balance $74,080 CR $68,880 CR $69,460 CR $68,290 CR $72,021 CR $62,721 CR $66,769 CR $65,908 CR $62,381 CR $61,800 CR $57,470 CR $54,104 CR $57,029 CR S53,472 CR $50,029 CR $53,557 CR $55,257 CR $51,576 CR $49,876 CR $45,427 CR $72,307 CR $67,846 CR $99,139 CR $97,091 CR $91,691 CR $91,679 CR $92,261 CR $3,557 $3,443 $3,528 $1,700 $3,681 $1,700 $4,449 $26,880 $4,461 $31,293 $2,048 $5,400 $12 $582 Last statement to This statement to Total debits Total credits Final balance 31/05/2020 30/06/2020 $57,086 $75,267 $92,261 CR Proceeds of cheques will not be available until cleared. All entries for the last business day are subject to verification and authorisation. Any items not paid, or withdrawn, will be adjusted by reversal entry on a later statement Bank reconciliation statement - May Spine Tinglers Bank Reconciliation Statement As at 31/05/2020 Balance as per bank statement: Add: deposit in transit from Attic Books deposit in transit from Cliff's Notes 74,080 CR 3,731 580 000000000000000000000000000000 4,311 78,391 CR Less: unpresented cheque unpresented cheque Adjusted bank balance No. 629 5,200 No. 630 1,170 6,370 72,021 CR Balance as per ledger account 72,021 DR CASH RECEIPTS JOURNAL 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 credited 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. Date Cost of Account Post Ref. Other Debit Cash at Discount Bank Allowed 4.048 Credit Accounts Receivable Accounts 4.048 Sales Revenue Sales Jun 1 ARC - Gimmicks 110-5 Jun 10 ARC - Cliff's Notes 110-1 2,925 325 3,250 3,528 3.528 1,638 110-6 1,700 1,700 26,880 26.880 15.904 Jun 13 Sales Revenue Jun 16 ARC - Paige Turners Jun 20 Sales Revenue Jun 25 ARC - Cough-up bookstore Jun 27 Sales Revenue Jun 29 ARC - Attic Books X 110-3 18.118 18.118 X 31.293 31.293 17,955 110-4 2,396 2.396 Jun 29 Sales Revenue X 34.272 34,272 16,344 Jun 30 (select) Jun 30 (select) Jun 30 (select) 100000 111111 Jun 30 (select) Jun 30 select Jun 30 select) Total Post Reference CASH PAYMENTS JOURNAL 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. Credit Date Account Cheque No. Post Ref. Accounts Payable Debit Wages Other Inventory Expense Accounts 9,300 861 Cash at Discount Bank Received 9,300 140 631 632 221 861 633 220 1,241 2,286 581 634 130 635 210-6 4.330 3,527 581 4,330 3,366 3,557 636 210-2 3,400 34 637 3,557 Jun 1 Prepaid Rent Jun 3 Electricity Payable Jun 4 Wages Payable Jun 5 Office Supplies Jun 7 APC - Bookheamoth Jun 8 APC - Booked Inn Jun 11 Wages Expense Jun 12 APC - Albatross Jun 14 APC - Noir Novels Jun 18 Wages Expense Jun 23 APC - Albatross Jun 25 Wages Expense Jun 30 Inventory Jun 30 Salary Expense 638 210-1 3.443 3,443 639 210-5 3,681 3,681 640 4.449 4,449 2,646 641 210-1 2.700 54 642 4,461 4,461 2.048 643 644 X 545 2,048 5,400 5,400 Jun 30 (select) Jun 30 select Jun 30 select) DIL 100001 Jun 30 (select) Jun 30 (select) Jun 30 (select) Total Post Reference SUBSIDIARY LEDGERS Account: ARC - Attic Books Account No. 110-4 Date Ref. Debit Credit Balance 2,396 DR May Jun Description 31 Balance 29 Repayment 30 CRJ 2,396 Jun Jun 30 9 Jun 30 Account: ARC - Paige Turners Account No. 110-6 Date Ref. Debit Credit Balance May Jun Description 31 Balance 16 Repayment 25 Credit sale 1,700 CRJ SJ 2,416 DR 716 DR 25,673 DR Jun 24,957 Jun 30 Jun 30 Jun 30 GENERAL LEDGER Account: Cash at Bank Account No. 100 Date Ref. Debit Credit Description 31 Balance 30 Balance 72,021 DR May Jun Jun 30 Jun 30 Account: ARC - Accounts Receivable Control Account No. 110 Ref. Debit Credit Balance Date May Jun Jun Description 31 Balance 20 Sales return from Cough-up bookstore 30 26,720 DR 24,524 DR GJ 2,196 Jun 30 Jun 30 >