Question

In: Accounting

The following information relates to the June 2018 cash transactions for Allmar Pty Ltd. The following...

The following information relates to the June 2018 cash transactions for Allmar Pty Ltd.

  1. The following unpresented cheques (outstanding cheques) appeared on the 31st May 2018 bank reconciliation:

Cheque no.

Amount ($)

6539

1,207.60

6548

3,605.00

6549

317.40

6555

575.60

6558

990.00

  1. All cheques except for cheque no. 6558 are included in the 30th June 2018 bank statement. On 31st May 2018, a deposit of $5,163.00 was outstanding.
  2. In the company’s records the cash balance at 31st May 2018 was $39,659.56 debit.
  3. Total cash payments of $99,565.60 were credited to cash at bank for the month of June 2018.
  4. Total cash receipts for June were $104,291.40, but $3,964.90 of these were received on 30th June are outstanding as they have not yet been credited by the bank.
  5. The bank statement at 30th June 2018 shows a closing credit balance of $53,852.26.
  6. The following information only appeared on the bank statement in June, service charges of $64.80; a $190.80 returned cheque due to insufficient funds in the drawer’s account; and the 31st May deposit of $5,163.00 which was credited by the bank on 1st June.
  7. Cheque no. 6585, written for telephone expenses on 20th June, and recorded by the company at $1,978.00, was correctly paid by the bank as $1,996.00
  8. The June bank statement shows a debit of $1,165.00 for a cheque which was not written by Allmar Pty Ltd, but which was incorrectly debited to their account by the bank.
  9. The following cheques are included in the company’s records but do not appear on the company’s bank statement for June:

Cheque no.

Amount ($)

6598

574.80

6599

5,137.40

6614

4,181.20

6615

3,987.00

Required:

  1. Prepare the cash bank account in the general ledger as a result of the adjustments required to balance the account to the bank statement for the month of June 2018.
  2. Prepare the bank reconciliation as at 30th June 2018.
  3. Explain how a dishonoured cheque would be treated by Allmar’s bank and why it is treated this way

Solutions

Expert Solution

Cash bank account:

Dr Cr

Date

Particulars

Bank ($)

Date

Particulars

Bank ($)

June 1, 2018

Opening balance

$39,659.56

By payments

$99,565.60

To receipts

$104,291.40

June 31, 2018

By Service charges

$64.80

June 31, 2018

By dishonoured cheque

$190.80

June 31, 2018

By short payment for telephone expenses [$1996-$1978]

$18

June 31, 2018

By Closing balance (bal.fig.)

$44111.76

$143950.96

$143950.96

Bank Reconciliation Statement:

Allmar Pty Ltd.

Bank Reconciliation Statement

For the month June, 2018

Balance as per bank statement

$53,852.26

Balance as per books (adjusted balance)

$44111.76

Add:

Wrong debit by bank

$1,165

Deposit in transit

$3,964.90

$5129.9

Deduct:

Outstanding cheques-

6558

$990

6598

$574.80

6599

$5,137.40

6614

$4,181.20

6615

$3,987.00

($14870.4)

Adjusted bank balance

$44111.76

Adjusted book balance

$44111.76

Treatment of returned cheque :

When a cheque is deposited by the client into the bank, the bank credits client's account. But when the same cheque is returned due to insufficient funds in drawer's account the bank debits client account. So the Allmar's bank account debits All Mar bank account i.e. reduces the bank balance.


Related Solutions

The following information relates to the June 2018 cash transactions for Allmar Pty Ltd. The following...
The following information relates to the June 2018 cash transactions for Allmar Pty Ltd. The following unpresented cheques (outstanding cheques) appeared on the 31st May 2018 bank reconciliation: Cheque no. Amount ($) 6539 1,207.60 6548 3,605.00 6549 317.40 6555 575.60 6558 990.00 All cheques except for cheque no. 6558 are included in the 30th June 2018 bank statement. On 31st May 2018, a deposit of $5,163.00 was outstanding. In the company’s records the cash balance at 31st May 2018 was...
The following information relates to Lindisfarne Travel Pty Ltd as at 30 June 2020: Unearned Revenue...
The following information relates to Lindisfarne Travel Pty Ltd as at 30 June 2020: Unearned Revenue 3,200 Accumulated Depreciation - Furniture & Fittings 76,500 Travel Expense 182,000 Salary Payable 500 Cash at Bank 45,500 Loan (paid in two years) 35,000 Sales Revenue 1,272,000 Prepaid Rent 8,000 Accounts Payable 26,500 Accounts Receivable 79,500 Furniture & Fittings 176,500 Capital ??? Depreciation Expense- Furniture & Fittings 24,500 Required: Prepare a classified Narrative Balance Sheet. Marks will be deducted for including items that do...
The following information relates to ABC Pty Ltd for the years ended 30 June Year 3...
The following information relates to ABC Pty Ltd for the years ended 30 June Year 3 and Year 2: Year 3 $ Year 2 $ Total assets Owners’ equity 6,020,000 3,250,000 5,470,000 3,200,000 Annual sales Net profit (after tax) Weighted average number of ordinary shares issued 6,100,000 810,000 10,234,518 3,154,350 475,200 10,046,430 Required: Calculate the net profit margin, asset turnover, earnings per share and debt to total assets ratios for ABC Ltd for the year ended 30 June Year 3
The following information relates to the inventory of Cameras Ltd during June. June 1 Beginning Inventory...
The following information relates to the inventory of Cameras Ltd during June. June 1 Beginning Inventory 80 units @ $7.00 3 Purchased 90 units @ $8.80 10 Purchased 110 units @ $9.90 12 Sold 90 units 17 Sold 80 units 25 Sold 30 units Cameras Ltd uses a perpetual inventory system, purchases are GST inclusive. Showing calculations, determine the cost of the ending inventory (assuming there have been no stock losses) and the cost of sales, using the following three...
The following information relates to Egoly Ltd for the year ended 30th June 2019: EGOLY LTD...
The following information relates to Egoly Ltd for the year ended 30th June 2019: EGOLY LTD BALANCE SHEET AS AT 30th JUNE 2019 2019 2018 $ $ ASSETS Current Assets    Cash at bank 67,710 59,666    Accounts receivable 252,760 283,290    Inventory 1,107,600 951,400    Prepaid expenses 113,600 35,500 Total current assets 1,541,670 1,329,856 Non-current assets    Equipment 1,263,800 823,600    Accumulated depreciation – equipment (238,560) (143,136) Total non-current assets 1,025,240 680,464 TOTAL ASSETS 2,566,910 2,010,320 LIABILITIES & SHAREHOLDERS...
The balance sheet of Murdoch Pty Ltd as at 30 June 2019 reveals the following information:...
The balance sheet of Murdoch Pty Ltd as at 30 June 2019 reveals the following information: $(‘000s) Paid-up Capital (1,000,000 shares) 3,000 Bank Overdraft 1,000 Accounts Payable 1,500 Mortgage Bonds, $1,000 face value (10%) 4,000 You are also given the following additional information about the firm: a) The company’s marginal tax rate is 30 cents in a dollar. The proportion of tax collected from the company that is claimed by shareholders is 0.6. b) The market price per mortgage bond...
The following information relates to the 2020 debt and equity investment transactions of Sarasota Ltd., a...
The following information relates to the 2020 debt and equity investment transactions of Sarasota Ltd., a publicly accountable Canadian corporation. All of the investments were acquired for trading purposes and accounted for using the FV-NI model, with all transaction costs being expensed. No investments were held at December 31, 2019, and the company prepares financial statements only annually, each December 31, following IFRS. 1. On February 1, the company purchased Williams Corp. 12% bonds, at par value for $560,000, plus...
The following information relates to the 2017 debt and equity investment transactions of Wildcat Ltd., a...
The following information relates to the 2017 debt and equity investment transactions of Wildcat Ltd., a publicly accountable Canadian corporation. All of the investments were acquired for trading purposes and accounted for using the FV-NI model, with all transaction costs being expensed. No investments were held at December 31, 2016, and the company prepares fi nancial statements only annually, each December 31, following IFRS 9. Dividend and interest income are not recorded or reported separately from other investment income accounts....
The following data are revealed by King Kong Pty Ltd at 30 June 2019. Cash balance...
The following data are revealed by King Kong Pty Ltd at 30 June 2019. Cash balance at 1 July 2018 $50 000 Gain on sale of equipment 6 000 Income tax payments 21 000 Cash paid to suppliers 153 500 Cash received from customers 425 500 Proceeds from issue of shares 216 000 Proceeds from sale of land 76 000 Depreciation expense 55 000 Interest payments 30 000 Payments of long-term debt 16 500 Payments to employees 78 000 Dividends...
The following information relates to a company ABC Ltd for the year ended 30 June 2020:...
The following information relates to a company ABC Ltd for the year ended 30 June 2020: Transaction totals for the year ended 30 June 2020 R Credit purchases of raw materials 503750 Freight on raw materiasl purchased (on credit) 99833 Sales of finished producgts 11440000 Direct Labour: Factory wages 828600 Pension fund contributions paid by employer 172500 Medical aid paid by employer 227200 UIF Contributions paid by employer 8144 Indirect Labour 500250 Electricity Factory 211450 Administration offices 127900 Rent Expenses...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT