Prepare the bank reconciliation statement

Assignment Help Financial Accounting
Reference no: EM13999460

K.R Solutions

K.R Solutions' Cash Book at 30th November 2014 showed an overdrawn position of £3,630 which did not match with her bank statement which shown an overdrawn balance of £3,078. Detailed examination of the two records revealed the following:

The debit side of the cash book had been undercast by £300.

A cheque for £1,560 in favour of Z Suppliers Ltd., had been omitted by the bank from its statement, the cheque having been debited to another customer's account.

A lodgement of £1080 on 30th November had not been credited by the bank.

Interest amounting to £228 had been debited by the bank but not entered in the cash book.

Required:

Reconcile the balance of the cash book and bank statement to the corrected bank balance.

Reconcile the cash book balance to the balance of the bank.

Wheels Ltd

Wheels Ltd has received his bank statement for the year to 30 September 2014. At the date, his balance at the bank amounted to £14,130 whereas his own cash book showed a balance of £20,000. His accountant investigated the matter, and discovered the following discrepancies:

Hay had brought down his opening cash book balance of £6,585 as a debit balance instead of as a credit balance.

Hay had entered a payment of £560 in his cash book as £650.

Cheques drawn by Hay in July 2014 to the value of £7,210 had not been presented to the bank.

One of Hay's customers had agreed to settle their debts £450 by direct debit though nothing was entered in the cash books yet. Unfortunately, the bank had credited the direct debit to another customer's account.

Required:

Make any necessary entries in the cash book as at 30 September 2014.

Prepare a bank reconciliation statement as at 30 September 2014.

Oliver Spence

Oliver Spence, a sole trader, received a bank statement for the month of May as follows:

For the corresponding period, Oliver Spence's own records contained the following bank

Required:

Prepare the bank reconciliation statement as at 31 May 2014 from the cash book and the bank statement to the corrected bank balance.

Workings: (reconciliation of beginning balances of cash book and bank statement)

Oliver Spence continued his business in June 2014 and his bank account was given as follows:

May

 

Dr.

Cr.

Balance

 

1

Opening balance

 

 

85

 

3

123456

150

 

65

O/D

9

123450

42

 

107

O/D

14

Sundry credit

 

210

103

 

18

Interest

24

 

79

 

20

Sundry credit

 

350

429

 

22

123457

220

 

209

 

23

123448

100

 

109

 

24

Standing order - rent

10

 

99

 

25

Sundry credit

 

531

630

 

26

Credit transfer - Mills

 

25

655

 

28

423460

100

 

555

 

30

123459

405

 

150

 

31

Closing balance

 

 

150

 

The corresponding bank statement for the month of June 2014 was:

May

 

 

£

May

 

 

£

 

14

Cheque from G. Smith

210

 

1

Balance b/d

 

57

 

20

Cash Sales

350

 

3

Electricity

123456

150

 

25

Cheque from F Jones

410

 

22

Wages

123457

222

 

25

Cheque from R Black

121

 

23

Purchases

123458

415

 

31

Cheque from W Wayne

196

 

30

Rent

123459

405

 

31

Balance c/d

 

9

 

31

Purchases

123460

 

47

 

 

 

1 296

 

 

 

 

1 296

 

 

 

 

 

 

 

 

 

 

 

 

Required:

Prepare the bank reconciliation statement as at 31 May 2014 from the cash book and the bank statement to the corrected bank balance.

Workings: (reconciliation of beginning balances of cash book and bank statement)

The beginning balance of the bank statement

£ 85

Less: Unpresented cheques - last month (42+100)

142

The beginning balance of the cash book

(57) O/D

 

 

 

 

Attachment:- Assignment.zip

Reference no: EM13999460

Questions Cloud

Element of the contract law formula : Which of the following is NOT an element of the contract law formula? Which state is not a member of the 9th Circuit
Explain how sarbanes-oxley strengthened the enforcement : Explain how Sarbanes-Oxley strengthened the enforcement of securities fraud and helped with the implementation of accounting reforms.
The fixed asset turnover ratio : The fixed-asset turnover ratio for 2011 was 3.25. Calculate Pinewood's net sales for 2011.
What was the gain or loss on the sale of the equipment : Lawler Clothing sold manufacturing equipment for $16,000. Lawler originally purchased the equipment for $80,000, and depreciation through the date of sale totaled $71,000. What was the gain or loss on the sale of the equipment?
Prepare the bank reconciliation statement : Prepare the bank reconciliation statement as at 31 May 2014 from the cash book and the bank statement to the corrected bank balance.
What amount will calaveras value the pickup trucks : At what amount will Calaveras value the pickup trucks? How much gain or loss will the company recognize on the exchange? Assume the exchange has commercial substance.
Which critical health care error does the article address : Find a newspaper or scholarly article where a health care organization or a provider was found guilty of malpractice, criminal negligence, false credentials, failure to treat or patient abandonment. Which critical health care error does the article..
Discuss the reason for the arrest of danny and his friends : Discuss the reason for the arrest of Danny and his friends. Did detective Johnson have a reason to initially search and question the men? What is the standard for a search
Why is arson so difficult to prove : Explain 4 different times Why is arson so difficult to prove? What requirements do you need to prove arson in criminal law

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd