Question

In: Accounting

The bookkeeper of Notting Hill Ltd is in the process of preparing the end of month...

The bookkeeper of Notting Hill Ltd is in the process of preparing the end of month bank reconciliation. The following information has been obtained:

Notting Hill Ltd

Bank Reconciliation Statement as at 31 May 2019

Balance as per bank statement

2,950 Cr

Add Deposits in transit

330

3,280 Cr

Less Unpresented cheques

# 911           380

# 913           920

# 925       20,100

(21,400)

Balance as per bank ledger account

$ 18,120 Cr

Bank Statement

Notting Hill Ltd

Date

Particulars

Debit

Credit

Balance

2019

June 1

Balance

2,950 Cr

3

Cash

330

3,280 Cr

6

Cheque 925

20,100

16,820 Dr

9

Cash

39,000

22,180 Cr

14

Cheque 926

19,400

2,780 Cr

15

Cheque 911

380

2,400 Cr

15

Cheque 927

3,500

1,100 Dr

15

Cash

60,060

58,960 Cr

17

Cheque 928

29,300

29,660 Cr

19

Bank Charges

50

29,610 Cr

23

Cash

39,700

69,310 Cr

29

Dishonoured cheque

7,300

62,010 Cr

30

Interest

710

62,720 Cr

CASH RECEIPTS JOURNAL

Date

2019

Particulars

Rec. No

Debits

Credits

Bank

Discount Expense

Accounts Receivable

Cash Sales

Other

Jun 9

Cash Sales

050

39,000

39,000

15

Alpha Ltd

051

60,060

440

60,500

23

Cash Sales

052

39,700

39,700

28

Beta Ltd

053

25,300

     25,300

CASH PAYMENTS JOURNAL

Date

2019

Particulars

Chq. No

Credits

Debits

Bank

Discount Revenue

Accounts Payable

Wages

Sundry

Jun 2

Gamma Supplies Ltd

926

19,400

600

20,000

15

Wages

927

3,500

3,500

17

Omega Trade Ltd

928

29,300

29,300

20

Postage

929

53

53

26

Wages

930

9,300

9,300

Required:

  1. Complete and total the cash journals. Post the totals to the bank ledger to determine the final balance.

  1. Prepare the Bank Reconciliation Statement at the end of June.

Solutions

Expert Solution


Related Solutions

Smith Ltd. was in the process of preparing year-end adjusting entries for the year ended December...
Smith Ltd. was in the process of preparing year-end adjusting entries for the year ended December 31, 2018. Smith Ltd. had the following balance in their books (ledger): Dr. Cr. Accounts Receivable $91,000 Allowance for Sales Discounts $4,500 Allowance for Sales Returns 3,300 Allowance for doubtful accounts 12,200 Additional Information: Total Credit Sales during 2018:     $66,000 The Company estimated the following for the year-end December 31, 2018 purposes: Expected Sales discounts $3,500 Expected Sales returns 4,100 Accounts receivable should...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its financial statements for the year ended 30 June 2018. Whilst preparing the financial statements, you become aware of the following situations: On 1 July 2017, the directors made a decision, using information obtained over the last couple of years, to revise the useful life of an item of manufacturing equipment. The equipment was acquired on 1 July 2015 for $800,000, and has been depreciated...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its financial statements for the year ended 30 June 2018.  Whilst preparing the financial statements, you become aware of the following situations: On 1 July 2017, the directors made a decision, using information obtained over the last couple of years, to revise the useful life of an item of manufacturing equipment.  The equipment was acquired on 1 July 2015 for $800,000, and has been depreciated...
Budgets: Discussion question RD Ltd. is in the process of preparing its budgets for 2020. The...
Budgets: Discussion question RD Ltd. is in the process of preparing its budgets for 2020. The company produces and sells a single product, Z, which currently has a selling price of £100 for each unit. The budgeted sales units for 2020 are expected to be as follows: Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec 5,000 5,500 6,000 6,000 6,250 6,500 6,250 7,000 7,500 7,750 8,000 7,500 The company expects to sell 7,000 units in January...
Rooey Ltd, the retailer of Zara clothing, is preparing its end of year financial statements at...
Rooey Ltd, the retailer of Zara clothing, is preparing its end of year financial statements at 31 December 2020. The balance sheet shows only two non-current assets, buildings and equipment. After depreciation entries were completed for the year ending 31 December 2020, the accumulated depreciation of its non-current assets were as follows:                                                                                                        $                                  Buildings                                                 24,200,000                                  Accumulated Depreciation                     (5,000,000)                                                                    Equipment                                                7,000,000                                  Accumulated Depreciation                      (3,800,000) The company applies the revaluation model to buildings and the cost model to equipment. At 31 December 2020, the following...
Q10.14 - As of 1 July 2019, Acer Ltd leases a building from Hill Ltd. The...
Q10.14 - As of 1 July 2019, Acer Ltd leases a building from Hill Ltd. The building has a fair value at 1 July 2019 of $1 972 000. The lease agreement details are as follows. Length of lease 10 Years Commencement date 1 July 2019 Annual lease payment, payable 30 June each year commencing 30 June 2020 $350,000 Estimated economic life of the building 10 Years Residual value at the end of the lease term $20 000 Residual value...
Max Petfood Ltd. is preparing an inventory listing for April 30, its fiscal year-end. The following...
Max Petfood Ltd. is preparing an inventory listing for April 30, its fiscal year-end. The following items have been identified: Description Shipment from supplier, arrived in April 29, but inspected, found defective, and will be returned. $ 73,200 Shipment from supplier, in transit April 30, arrived May 2, shipped FOB destination. $ 20,800 Shipment from supplier, in transit April 30, arrived May 10, shipped FOB shipping point. $ 8,300 Shipment to customer, shipped April 29, in transit April 30, FOB...
Yates Manufacturing Ltd. is preparing its year-end financial statements. Yates is a private enterprise. The controller,...
Yates Manufacturing Ltd. is preparing its year-end financial statements. Yates is a private enterprise. The controller, Theo Kimbria, is confronted with several decisions about statement presentation for the following items. 1. Management has decided to switch from the FIFO inventory cost formula to the average cost inventory cost formula for all inventories. Instructions: For each of the changes that Yates Manufacturing Ltd. made in the current year, advise Theo on whether the change is a change in accounting policy, a...
15. In the process of assisting the bookkeeper of SWIFT SERVICES to rectify the trial balance...
15. In the process of assisting the bookkeeper of SWIFT SERVICES to rectify the trial balance at 28 February 20.1, the following errors, which resulted in the disequilibrium of the totals of the trial balance, were traced. Control accounts are in use. (a) The total of the February 20.1 cash payments journal amounting to R29 800, has not been transferred to the bank account in the general ledger. The entity operated on a bank overdraft. (b) A payment of R300...
QUESTION 3: Maritime Ltd is in the process of closing its books for the year-end. What...
QUESTION 3: Maritime Ltd is in the process of closing its books for the year-end. What is the impact for each of the following adjustments in each of the following: Statement of Financial Performance Statement of Financial Position Cash Flow Statement Scenario 1: Maritime Ltd purchased a new range of boat steering parts from an overseas manufacturer. The company has estimated that warranty costs will be 4% of total sales. Total sales for the current income year is $640,000. Scenario...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT