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. 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? (1 mark)

Expert Solution

ekkarill92 answered 2 years ago

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....

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...

below is information from XYZ Inc. as of june 30, 2017. 1.) Cash on the books...

below is information from XYZ Inc. as of june 30, 2017. 1.) Cash on the books as of June 30 is $42,754.16. cash on the bank statement for the same day is $52,351.46. 2) A deposit of $5220.94 did not appear on the bank statement. 3.) outstanding checks totaled $3936.80. 4.) A check for $1920 returned with the statement was recorded incorrectly in the check register as $1380. The check was for cash purchase of merchandise inventory. 5.) The bank...

. Below is information about actual sales of a product for June and July and the...

. Below is information about actual sales of a product for June and July and the expected sales of August, September and October. Selling price for the product is $100. June $230,000, July $240,000, August $220,000, September $280,000 and October $310,000. November $340,000 Costs of Goods Sold equals to 70% of Sales. The end of inventory policy is 40% of the next month of quantity sales. Inventory is purchased on continuous basis during the month. 60% of inventory costs are...

Given the information below find gross profit percentage for the month of June ( do not...

Given the information below find gross profit percentage for the month of June ( do not include % sign) Guest Hotel Inc. Income Statement for the period ending June 30, 2019 Sales Food 212,323 Beverage 77,776 Total Sales - Cost of Sales Food 73,046 Beverage 27,691 Total cost of goods sold - Gross Profit - Controllable Expenses Salaries & Wages 113,286 Occupancy 35,130 Office & General 12,778 Utilities 10,441 Transportation 5,250 Kitchen supplies 5,746 Professional fees 6,300 Advertising 10,215 Insurance...

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...

Question