Answered step by step
Verified Expert Solution
Question
1 Approved Answer
As accountant for William Associates, you are required to perform a bank reconciliation at the end of June 2013. The bank reconciliation statement for the
As accountant for William Associates, you are required to perform a bank reconciliation at the end of June 2013. The bank reconciliation statement for the previous month is set out below: Bank Reconciliation Statement As at 31 May 2015 Balance as per bank statement Add: Outstanding deposit Less: Unpresented cheque no. Balance as per Cash at Bank account $879.75 Cr 390.00 1,269.75 1008 161.60 1,108.15 Dr Abridged cash receipts and cash payments journals before finalisation and posting are: Cash Receipts Journal Date 2015 Account Cash at bank June 2 N Burney $ 142.55 5 Sales $ 240.55 9 R Denis $ 310.25 12 16 26 Sales $ 187.85 Sales $ 310.25 22 Rush Ltd $ 380.65 27 Sales $ 75.45 29 Sales 354.35 30 Sales 87.55 Sales $ 65.45 Sales $ 241.34 $ 2,396.24 Cash Payments Journal Date Account Cheque no. Cash at Bank 2015 June 2 Stationary 1010 $57.70 Advertising 1012 180.90 Wages and salaries 1014 405.15 Petty cash 6 Roy & Sons Wages and salaries 1015 23.55 1016 63.36 1018 402.50 16 Sales commission 1020 33.82 17 Shaun Ltd 1021 105.51 25 Wages and salaries 1024 437.35 26 T Garner 1025 42.15 Central Groceries 1026 46.86 Donation - Blue Cross 1027 11.00 28 Roy & Sons 1028 85.14 30 Freight inwards 1029 24.25 N. Brice 1030 90.82 2.010.06 NB. A new book keeper has prepared the accounts and made a number of mistakes. Therefore the following checques are cancelled: 1011, 1013, 1017, 1019, 1022 and 1023 BANK STATEMENT DATE PARTICULARS DEBIT CREDIT BALANCE 2015 June 1 Balance 879.75 Cr 2 1010 $ 57.70 822.05 $ 390.00 1,212.05 Cr $142.55 1,354.60 5 1008 $161.60 1,193.00 $ 240.55 1,433.55 7 1012 $ 180.90 1,252.65 1014 $ 450.15 802.50 1015 $ 23.55 778.95 $310.25 1,089.20 Cr 12 1016 S 63.36 1,025.84 Cr 1018 $402.50 623.34 $187.85 811.19 1020 $ 33.82 777.37 16 62 $310.25 1,087.62 22 1021 $105.51 982.11 $380.65 1,362.76 Direct payment to Myke $ 400.00 962.76 27 $ 75.45 1,038.21 28 1024 $ 437.35 600.86 D Finley Returned cheque $ 65.00 535.86 Cr 30 10 1025 $ 42.15 493.71 Bank fees $ 50.00 443.71 1026 $ 46.86 396.85 Cr $ 354.35 751.20 Govt. bond Interest $235.00 986.20 888888888888888 Cr Cr Cr Cr Cr Additional information: Cheque no. 1014 for $405. 15 is entered correctly in the Cash Payment Journal but appeared in the Bank Statement as $450.15. Required: A. Starting with the totals shown, complete the cash receipts and cash payments journals, amending or adding to them as necessary for the month of June. (10 marks) B. Prepare the Cash at Bank ledger account showing the final balance at 30 June 2013. (10 Marks) C Prepare the bank reconciliation statement as at 30 June 2013 (10 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started