Question

In: Accounting

   Question 3 Mr A Mathews, a client of your firm, has provided you with the...

  

Question 3

Mr A Mathews, a client of your firm, has provided you with the following bank statement and bank account details in respect of the month ended 31 December 2016.

STATEMENT OF ACCOUNT - YOUR BANK LTD

Statement date - 31 December 2016.

Account No 123456

Date              Particulars           Debit     Credit    Balance

01-Dec-16 Balance forward

61,526 Cr

01-Dec-16 Cheque 1233

5,000

56,526 Cr

01-Dec-16 Lodgement

6,000

62,526 Cr

03-Dec-16 Cheque 1234

6,600

55,926 Cr

05-Dec-16 Direct Debit ESB

1,350

54,576 Cr

06-Dec-16 Credit Transfer VAT Refund

4,800

59,376 Cr

07-Dec-16 Cheque 1235

2,820

56,556 Cr

10-Dec-16 Lodgement

5,550

62,106 Cr

15-Dec-16 Cheque 1236

25,488

36,618 Cr

18-Dec-16 Credit Transfer Receivables Payment

11,550

48,168 Cr

20-Dec-16 Bank Charges for qtr ended Sept 09

660

47,508 Cr

21-Dec-16 Cheque 1237

21-Dec-16 Cheque 1238

22-Dec-16 Lodgement

3,885

9,645

1,500

43,623 Cr Cr

33,978 Cr

35,478

23-Dec-16 Standing Order Leasing

4,500

30,978 Cr

The books and records of A Mathews show the followings transactions through the bank account for the month of December 2016:

Date

Receipts

K            Date

Payments

K

2/12/16

Balance

62,526   1/12/16

Direct debit ESB

1,350

2/12/16

Cheque 1234

6,060

9/12/16

Lodgement

5,400   5/12/16

Cheque 1235

2,820

12/12/16

Cheque 1236

14,688

14/12/16

Bank charges

660

19/12/16

Cheque 1237

3,885

20/12/16

Cheque 1238

9,645

23/12/16

Lodgement

1,500 24/12/16

Cheque 1239

12,921

24/12/16

Cheque 1240

4,233

28/12/16

Lodgement

12,900 28/12/16

Cheque 1242

6,291

  

31/12/16              Balance

19,773

82,326               

82,326

1/1/2017

Balance

19,773               

You are required to:

Outline in brief why the regular preparation of bank reconciliations is important.

3 Marks

Write up the adjustments that are necessary to correct the bank account in A Mathew’s books.

10 Marks

Prepare the bank reconciliation statement for A Mathews as at 31 December 2016.

7 Marks Total 20 Marks

Solutions

Expert Solution

A monthly reconciliation helps to catch and identify any unusual transactions that might be caused by fraud or accounting errors, especially if the business uses more than one bank account. Reconciling your account also helps you identify account management or administrative issues that need attention.

Adjustments
Balance as per books $19,773
Add: Lodgement of 9/12/2016 recorded less in books 150
Add: Vat Refund received on Dec,6 4,800
Add:Account Receivables directly received at bank 11,550
$ 500
Less: Cheque no 1234 wrongly entered in books as 6060 instead of 6600 540
Less: Chequ0e no 1236 wrongly entered in books as 14688 instead of 25488 10800
Less: amount paid for leasing as per standing order by bank 4500
$-15,840
True Book Balance $ 20,433
Bank Reconciliation Statement
as at December 31,2016
Balance as per bank $      30,978
Add: Lodgements in transit 12900
Less:Oustanding Cheques
Cheque 1239 12,921
Cheque 1240 4,233
Cheque 1242 6,291        (23,445)
Balance as per books $      20,433

Related Solutions

You are asked to write a memo to your client, Mr. Carter regarding his tax question....
You are asked to write a memo to your client, Mr. Carter regarding his tax question. ● Your paper should not be more than 2-3 pages, double spaced ● The format should be as follows: ○ Restate the issue / question (first paragraph) ○ Explain the facts in relation to your research (middle paragraphs) ■ Cite a primary or authoritative material at least once ■ Refer the the tax form the information would be reported on ■ Include calculations and...
You are the supervising manager at an engineering firm. A client has requested your firm work...
You are the supervising manager at an engineering firm. A client has requested your firm work on a project that is handled frequently by your employees. The standard hours for projects of this nature is 36 hours for one engineer. You have decided to hand this incoming project to a brand new hire who just graduated with her engineering degree. What should your expectation be regarding the standard of 36 hours for this particular project? Why?
The ABC Company, a client of your firm, has come to you with the following problem....
The ABC Company, a client of your firm, has come to you with the following problem. it has three clerical employees who must perform the following functions: Maintain the general ledger Maintain the accounts receivable ledger Issue credits on returns and allowances Reconcile the bank account Handle and deposit cash receipts Assuming equal abilities among the three employees, the company asks you to assign the five functions to them to maximize internal control. Assume that these employees will perform no...
The Kernow Company, a client of your firm, has come to you with the following problem....
The Kernow Company, a client of your firm, has come to you with the following problem. It has three clerical employees who must perform these functions:             i)         Maintain general ledger             ii)        Maintain purchase (creditors) ledger             Iii)       Maintain sales (debtors) ledger             iv)       Prepare cheques for signature (including checking supporting documentation)             v)         Maintain expenses journal (recording expenses paid)             vi)       Issue sales credit notes             vii)      Reconcile bank statement             viii)     Handle and bank cash receipts....
The Kernow Company, a client of your firm, has come to you with the following problem....
The Kernow Company, a client of your firm, has come to you with the following problem. It has three clerical employees who must perform these functions:             i)          Maintain general ledger             ii)        Maintain purchase (creditors) ledger             Iii)       Maintain sales (debtors) ledger             iv)        Prepare cheques for signature (including checking supporting documentation)             v)         Maintain expenses journal (recording expenses paid)             vi)        Issue sales credit notes             vii)      Reconcile bank statement             viii)     Handle and bank cash receipts....
Question 3 (15 marks) Mr Wong was one of the partners of a local law firm,...
Question 3 Mr Wong was one of the partners of a local law firm, namely Wong, Lee & Chan. A few months ago, while carrying out his duty as a partner, Mr Wong was introduced to Tom, a manager of NanoLife Insurance Ltd (“NanoLife”), which is a client of the firm. Occasionally Mr Wong was invited by Tom to hold seminars for NanoLife’s staff training programme. In one of the seminars, Mr Wong met Jack who was the head of...
You are being consulted as a young forensic investigator. Here are the facts: Your client, Mr....
You are being consulted as a young forensic investigator. Here are the facts: Your client, Mr. Clean, comes to you with the following true story. Mr. Clean owned with a partner, Mr. Dirty, a coin-operated laundry. Mr. Dirty recently passed away and his family discovered over $1,000,000 worth of coins in Mr.Dirty's two-bedroom apartment. Mr. Clean is astounded to hear this and immediately goes back to the business to check some business statistics that he heretofore never bothered checking and...
Your firm has a client who has been a management accountant for many years and is...
Your firm has a client who has been a management accountant for many years and is now also teaching part-time at TAFE and has recently acquired a rental property. We prepared his Tax Return, sent it out for signature. He has sent the Tax Return back to us unsigned, saying that we had made an error in claiming a tax deduction for the interest and expenses for the first four months that he owned the rental property, as it was...
You work for a marketing firm that has a large client in the automobile industry. You...
You work for a marketing firm that has a large client in the automobile industry. You have been asked to estimate the proportion of households in Chicago that have two or more vehicles. You have been assigned to gather a random sample that could be used to estimate this proportion to within a 0.04 margin of error at a 95% level of confidence. a) With no prior research, what sample size should you gather in order to obtain a 0.04...
You work for a marketing firm that has a large client in the automobile industry. You...
You work for a marketing firm that has a large client in the automobile industry. You have been asked to estimate the proportion of households in Chicago that have two or more vehicles. You have been assigned to gather a random sample that could be used to estimate this proportion to within a 0.02 margin of error at a 80% level of confidence. a) With no prior research, what sample size should you gather in order to obtain a 0.02...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT