Question

In: Accounting

vBelow is information about Lisa Ltd’s cash position for the month of June 2019. 1. The...

vBelow is information about Lisa Ltd’s cash position for the month of June 2019.

1. The general ledger Cash at Bank account had a balance of $21,200 on 31 May.

2. The cash receipts journal showed total cash receipts of $292,704 for June.

3. The cash payments journal showed total cash payments of $265,074 for June.

4. The June bank statement reported a bank balance of $41,184 on 30 June.

5. Outstanding cheques at the end of June were: no. 3456, $1,448; no. 3457, $84; no. 3460, $70 and no. 3462, $410.

6. Cash receipts of $10,090 for 30 June were not included in the June bank statement.

7. Included on the bank statement were:  a dishonoured cheque written by a client James Ltd, $136  a credit for an electronic transfer from a customer of $644  interest earned, $44  account and transaction fees, $120

Required:

a) Update the cash receipts and cash payments journals by adding the necessary adjustments and calculate the total cash receipts and cash payments for June.

b) Post from cash receipts and cash payments journals to the Cash at Bank ledger account and balance the account. (1 mark)

c) Prepare a bank reconciliation statement at 30 June.

d) What is the amount of cash that should be reported on the 30 June balance sheet?

Solutions

Expert Solution

a.

Cash Receipts Journal
Date Particulars Cash at Bank
30-Jun Progress, Total    292,704.00
Dishonoured Check -         136.00
Electronic transfer            644.00
Interest revenue              44.00
Total    293,256.00
Cash Payment Journal
Date Particulars Cash at Bank
30-Jun Progress, Total    265,074.00
Account & Transaction fee            120.00
Total    265,194.00

b.

Cash at Bank
01-Jun Beg Bal 21200 30-Jun Cash payment journal    265,194.00
31-Dec Cash Receipt Journal    293,256.00 30-Jun End Bal      49,262.00
   314,456.00    314,456.00

c.

LISA LTD
Bank Reconciliation Statement
as at 30 June
Balance as per bank statement Cr    41,184.00
Add: Outstanding deposit    10,090.00
Less: Unpresented cheques:
No 3456    1,448.00
No 3457          84.00
No 3460          70.00
No 3462       410.00      2,012.00
Balance as per Cash at Bank account Dr    49,262.00

d . 49,262


Related Solutions

Below is information about Lisa Ltd’s cash position for the month of June 2019. 1. The...
Below is information about Lisa Ltd’s cash position for the month of June 2019. 1. The general ledger Cash at Bank account had a balance of $21,200 on 31 May. 2. The cash receipts journal showed total cash receipts of $292,704 for June. 3. The cash payments journal showed total cash payments of $265,074 for June. 4. The June bank statement reported a bank balance of $41,184 on 30 June. 5. Outstanding cheques at the end of June were: no....
Required information Following is the June 30, 2019, statement of net position for the City of...
Required information Following is the June 30, 2019, statement of net position for the City of Bay Lake Water Utility Fund. CITY OF BAY LAKE Water Utility Fund Statement of Fund Net Position June 30, 2019 Assets Current assets: Cash and investments $ 1,776,504 Accounts receivable (net of $13,377 provision for uncollectible accounts) 307,099 Accrued utility revenue 500,100 Due from General Fund 29,317 Interest receivable 82,017 Total current assets 2,695,037 Restricted assets: Cash 9,201 Capital assets: Land $ 1,782,497 Buildings...
The Statements of Financial Position for Lexington Limited as at 30 June 2019 and 30 June...
The Statements of Financial Position for Lexington Limited as at 30 June 2019 and 30 June 2020 are provided below: Lexington Ltd Statement of Financial Position as at 30 June 2020 2019 Assets $ $ Cash at bank 64,580 38,400 Accounts Receivable 82,800 35,000 Inventory 112,500 102,850 Prepaid Advertising 14,400 14,000 Machinery 310,000 282,500 Less: Accumulated Depreciation (50,000) (52,000) Total Assets $534,280 $420,750 Liabilities Accounts Payable 157,000 59,300 Dividends payable 15,000 - Wages payable 20,700 25,000 Loan 125,000 130,000 Total...
The Statements of Financial Position for Kiwi Limited as at 30 June 2019 and 30 June...
The Statements of Financial Position for Kiwi Limited as at 30 June 2019 and 30 June 2020 are provided below: Kiwi Limited Statement of Financial Position as at 30 June 2019 2020 Assets $ $ Cash at Bank 68,000 56,000 Accounts Receivable 121,000 139,000 Inventory 44,000 41,000 Land 241,000 241,000 Plant and Machinery 319,000 414,000 Less: Accumulated Depreciation (10,000) (89,000) Total Assets $783,000 $802,000 Liabilities Accounts Payable 55,000 54,000 Tax Payable 16,000 23,000 Loan 536,000 362,000 Total Liabilities $607,000 $439,000...
1.The following information is available for the Savvy Company for the month of June. a. On...
1.The following information is available for the Savvy Company for the month of June. a. On June 30, after all transactions have been recorded, the balance in the company's Cash account has a balance of $17,202. b. The company's bank statement shows a balance on June 30 of $19,279. c. Outstanding checks at June 30 total $2,984. d. A credit memo included with the bank statement indicates that the bank collected $770 on a note receivable for Savvy. e. A...
Part B Bruce Manufacturing Ltd’s post-closing trial balance at 30 June 2019 included the following balances:...
Part B Bruce Manufacturing Ltd’s post-closing trial balance at 30 June 2019 included the following balances: Machinery Control (at cost) $244 480 Accumulated Depreciation – Machinery Control 113 800 Fixtures (at cost) 308 600 Accumulated Depreciation – Fixtures 134 138 The Machinery Control and Accumulated Depreciation – Machinery Control accounts are supported by subsidiary ledgers. Details of machines owned at 30 June 2019 are as follows: Machine Purchase Cost Estimated Estimated date useful Life residual value 1 28 Apr 2015...
The following information is available for the Savvy Company for the month of June. On June...
The following information is available for the Savvy Company for the month of June. On June 30, after all transactions have been recorded, the balance in the company's Cash account has a balance of $17,202. The company's bank statement shows a balance on June 30 of $19,279. Outstanding checks at June 30 total $2,984. The bank collected $770 on a note receivable that is not yet recorded by Savvy Company. A $67 NSF check from a customer, J. Maroon is...
Account June 30 2020 June 30 2019 $ $ Cash and cash equivalents 95,800 64,000 Debtors...
Account June 30 2020 June 30 2019 $ $ Cash and cash equivalents 95,800 64,000 Debtors 231,600 157,200 Inventory 96,720 104,400 Plant and equipment 100,000 75,000 Accumulated depreciation – plant and equipment (40,000) (29,000) Total assets 484 120 371,600 Creditors 71,000 74,400 Accrued expenses 30,000 33,000 Long-term loan 100,000 50,000 Capital and reserves 283,120 214,200 Total liabilities and owners equity 484 120 371,600 Sales 440,000 Less: Cost of goods sold 296,000 Gross profit 144,000 Operating expenses (including depreciation) 84,000 Net...
Statements of Financial Position of Company S -as at 30 June 2019 ($) 2018 ($) Asset...
Statements of Financial Position of Company S -as at 30 June 2019 ($) 2018 ($) Asset Cash at bank 22000 0 Accounts receivable 22000 18000 Inventory 88000 56000 Equipment 56000 46000 Accumulated depreciation – equipment -24000 -16000 Land 35000 50000 Buildings 75000 75000 Accumulated depreciation – buildings -15000 -10000 Total assets 259000 219000 Liabilities Accounts payable 45000 39000 Equity Share capital 204000 174000 Retained earnings 10000 6000 Total liabilities and equity 259000 219000 Statements of Profit & Loss - as...
QUESTION ONE The Statements of Financial Position for Lexington Limited as at 30 June 2019 and...
QUESTION ONE The Statements of Financial Position for Lexington Limited as at 30 June 2019 and 30 June 2020 are provided below: Lexington Ltd Statement of Financial Position as at 30 June 2020 2019 Assets $ $ Cash at bank 64,580 38,400 Accounts Receivable 82,800 35,000 Inventory 112,500 102,850 Prepaid Advertising 14,400 14,000 Machinery 310,000 282,500 Less: Accumulated Depreciation (50,000) (52,000) Total Assets $534,280 $420,750 Liabilities Accounts Payable 157,000 59,300 Dividends payable 15,000 - Wages payable 20,700 25,000 Loan 125,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT