Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you complete the bank reconciliation? I believe I got the first part done, but I'm not 100% it's right. I attached all the previous

Can you complete the bank reconciliation? I believe I got the first part done, but I'm not 100% it's right. I attached all the previous documents that you'll need to complete it.image text in transcribed

\fNow that you have completed the end of month posting procedure, you are required to prepare a bank reconciliaton as at June 30, 2015. 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)Prepare the bank reconciliation statement as at June 30, 2015. To do this, you will need to use: the previous month's bank reconciliation statement, and the current month's bank statement and cash journals Note that the bank reconciliation statement provided below may contain more rows than required. 2)Use the bank reconciliation statement to record the relevant reconciling items in the general journal. 3)Post entries recorded in the general journal to the appropriate ledger accounts according to the company's accounting policies and procedures. 4)Record the updated balance of each ledger account in the Balance row of each ledger, even for ledgers with a balance of zero. Although each ledger already has a running balance, the Balance row must still be filled out in order to receive full points. 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. There may be entries in the general journal that require posting to both a control account and a subsidiary ledger. In these cases, after you have posted to both ledgers, you should enter the reference for both the general ledger account and the subsidiary ledger account in the Post Ref. column to indicate that you have posted to both accounts. For example, if the reference number for the control account is 110 and the reference number for the subsidiary ledger account is 110-1, you should type '110/110-1' into the Post Ref. column. 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. Show All Bank ReconciliationGeneral JournalSubsidiary LedgersGeneral Ledger 97334230981034 ANSWERED (Q=822.bankRecQuestion) The Adrenaline Hut Bank Reconciliation Statement June 30, 2015 $ $ 76007 76007 Balance per bank: Add: 15291246919276 deposit in transit deposit in transit|3 3169 80362589819867 deposit in transit|6 deposit in transit 600 15860666042810 NOANSWER 3769 3769 07377890297906 79776 79776 Deduct: 72761333109791 outstanding chec No. 865 6900 91747134096766 outstanding chec No. outstanding check 866 1530 35053959964185 NOANSWER No. 8430 16895574642761 09102272581011 8430 71346 71346 Adjusted balance per bank 16934167681770 71039 71039 Balance per book Add: 70900106301215 interest earned interest earned|31 317 23574263861022 NOANSWER 27471564052983 NOANSWER 09718866342655 317 317 36309725088086 71356 71356 Deduct: 07453673641629 bank service cha bank service charge 10 29980337822414 NOANSWER 26262251981053 NOANSWER 90622729749859 10 10 20309690875341 71346 71346 Adjusted balance per book 19506892865298 NOANSWER '100','Cash','110', '110-1','ARC - Gre (Q=823.generalJournalBankRec) GENERAL JOURNAL Date Account and Explanation Ju 20 Sales Returns and Allowances n Ju 20 n ARC - Croquet and Cricket Post Ref. Debit 401 Credit 656 110/110-3 656 (sales return) Ju 20 Merchandise Inventory n 120 Ju 20 n 500 Cost of Goods Sold (sales return) 368 368 Ju 28 APC - Sports 'R Us n Ju 28 n 210/210-5 Merchandise Inventory 120 1,600 1,600 (purchase return) 84684366990953 NOANSWER Ju 30 n (select) 34516628736281 NOANSWER (select) 59659122741940 NOANSWER Ju 30 n (select) 20283683011214 NOANSWER (select) 07076077319715 NOANSWER Ju 30 n (select) 04225170209201 NOANSWER (select) 83143682743750 NOANSWER Ju 30 n (select) 19141078375936 NOANSWER (select) 36686318494909 NOANSWER (Q=824-110-5.AcctsRec5_bankRec) SUBSIDIARY LEDGERS Account: ARC - Jump Around Account No. 110-5 Date Description Ref. Debit Credit Ma 31 Balance y Jun 6 Repayment Balance 4,915 DR CRJ 4,915 0 Jun 17 Credit sale SJ 5,376 5,376 DR Jun 24 Credit sale SJ 50,784 56,160 DR 06778170010877 NOANSWER Jun 30 04509317609470 NOANSWER Jun 30 08161301354489 NOANSWER Jun 30 28858111900086 NOANSWER Jun 30 Balance 25942867555188 NOANSWER (Q=824-110-6.AcctsRec6_bankRec) Account: ARC - The Locker Room Account No. 110-6 Date Description Ref. Debit Credit Balance Ma 31 Balance y Jun 16 Repayment 4,201 DR CRJ Jun 26 Credit sale SJ 1,700 2,501 DR 7,168 9,669 DR 81903221669818 NOANSWER Jun 30 92483353816410 NOANSWER Jun 30 00017063462919 NOANSWER Jun 30 84271459142775 NOANSWER Jun 30 50131831832103 Balance NOANSWER (Q=825-100.Cash_bankRec) GENERAL LEDGER Account: Cash Account No. 100 Date Description Ref. Ma y 3 Total from cash receipts 0 journal CRJ Jun 3 Total from cash payments 0 journal CPJ Credit 3 Balance 1 Jun Debit Balance 71,346 DR 119,159 190,505 DR 42,907 147,598 DR 08591716612980 NOANSWER Jun 3 0 48451453501650 NOANSWER Jun 3 0 72461463085176 NOANSWER Jun 3 0 88246431978794 NOANSWER Jun 3 0 91164497055394 NOANSWER Ju n 3 0 51768401337142 Balance NOANSWER (Q=825-110-0.ARControl_bankRec) Account: ARC - Accounts Receivable Control Account No. 110 Date Ma y Description Ref. Debit Credit 3 Balance 1 Balance 32,321 DR Ju n 2 Sales return from Croquet and 0 Cricket GJ Ju n 3 Total from sales journal 0 SJ Ju n 3 Total from cash receipts journal 0 CRJ 656 68,576 31,665 DR 100,241 DR 30,144 70,097 DR 89997476528170 NOANSWER Ju n Ju n Ju n 3 0 98445887509151 NOANSWER 3 0 51538747050831 NOANSWER 3 0 47807347494476 NOANSWER Ju n Ju n 3 0 79008208121442 NOANSWER 3 0 Balance 12806036862340 NOANSWER (Q=825-210-0.APControl_bankRec) Account: APC - Accounts Payable Control Account No. 210 Date Description Ref. Debit Ma y 2 Purchase return to Sports 'R 8 Us GJ Jun 3 Total from purchases journal 0 PJ Jun 3 Total from cash payments 0 journal Balance 3 Balance 1 Jun Credit 47,634 CR CPJ 1,600 46,034 CR 21,720 18,991 67,754 CR 48,763 CR 25285892820063 NOANSWER Jun 3 0 87274431695428 NOANSWER Jun 3 0 56430924039623 NOANSWER Jun 3 0 74180151322837 NOANSWER Ju n 3 0 Balance 60485700048883 NOANSWER (Q=825-403.InterestRevenue_bankRec) Account: Interest Revenue Account No. 403 Date Description Ref. Debit Credit Balance Ma 31 Balance y 0 00948715384400 NOANSWER Jun 30 48354992423349 NOANSWER Jun 30 64113435588128 NOANSWER Jun 30 51192150726664 NOANSWER Jun 30 Balance 32258062060971 NOANSWER (Q=825-571.InterestExpense_bankRec) Account: Interest Expense Account No. 571 Date Description Ref. Debit Credit Ma 31 Balance y Balance 0 27021737014018 NOANSWER Jun 30 11548649468109 NOANSWER Jun 30 38316583175373 NOANSWER Jun 30 22310350487001 NOANSWER Jun 30 Balance 22444291248577 NOANSWER (Q=825-572.BankCharges_bankRec) Account: Admin. Expense - Bank Charges Account No. 572 Date Description Ref. Debit Credit Ma 31 Balance y Balance 0 59966042511230 NOANSWER Jun 30 82427959581046 NOANSWER Jun 30 71464853188337 NOANSWER Jun 30 59508505959019 NOANSWER Jun 30 Balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Canadian Cases In Financial Accounting

Authors: Carol E. Dilworth, Joan E. D. Conrod

2nd Edition

256111405, 978-0256111408

More Books

Students also viewed these Accounting questions

Question

Show that the estimator given in Eq. (D.14) is biased.

Answered: 1 week ago

Question

6. What information processes operate in communication situations?

Answered: 1 week ago

Question

3. How can we use information and communication to generate trust?

Answered: 1 week ago