Question

In: Accounting

On 30 April 2020 Chen & Chan Ltd had a cash balance as per company records...

On 30 April 2020 Chen & Chan Ltd had a cash balance as per company records of $5,644.50 debit. The bank statement from Brisbane Bank on that date showed a credit balance of $7,825.35. A comparison of the statement with the cash account revealed the following facts:

  1. The bank statement included a debit entry of $60 for bank fees.
  2. Unpresented cheques at 30 April totalled $1,276.25, and outstanding deposits were $795.40.
  3. Included with the cheques paid was a cheque issued by Smith Pty Ltd to R. Thomas for $600 that was incorrectly charged to Chen and Chan Ltd by the bank.
  4. A $3,000 note receivable was collected by the bank for Chen & Chan Ltd on 30 April plus $80 interest. The bank charged a collection fee of $20. No interest has been accrued on the note.
  5. On 30 April the bank statement showed a dishonoured cheque of $700 that had been issued by C. Rogers, a customer to Chen & Chan Ltd.

Required:

  1. Prepare the bank reconciliation for Chen & Chan Ltd as at 30 April 2020.
  2. Prepare the necessary adjusting entries for Chen & Chan Ltd as at 30 April 2020.
  3. Narrations are not required.

Solutions

Expert Solution

Bank Reconciliation Statement
Balance as per bank statement 7825.35 balance as per books 5644.5
Add: Add:
Deposits in transit 795.4 Note collection (3000+80-20) 3060
Check wrogly charged 600
Subtotal 9220.75 Subtotal 8704.5
Less: Less:
Outstanding checks 1276.25 Service charges paid 60
NSF check 700
Adjusted balance as per bank 7944.5 Adjusted balance as per books 7944.5
Adjusting entries:
S.no. Accounts title and explanations Debit $ Credit $
a. Cash account 3060
Collection charges 20
     Notes receivable 3000
     Interest revenue 80
(for notes collected)
b. Misc. expense 60
    Cash account 60
(for service charges levied)
c. Accounts receivable 700
    Cash account 700
(for NSF check recorded)

Related Solutions

On 31 May 2019 Interactive Ltd had a cash balance as per company records of $18,000...
On 31 May 2019 Interactive Ltd had a cash balance as per company records of $18,000 debit. The bank statement from Community Bank on that date showed a credit balance of $ 16,800. A comparison of the statement with the cash account revealed the following facts: 1.      The bank statement included a debit entry of $120 for managing the company’s account. 2.      Cash sales of $1,882 on 12 May were deposited in the bank. The cash receipts journal entry were incorrectly made...
On July 31, 2020, Crane Company had a cash balance per books of $6,190.00. The statement...
On July 31, 2020, Crane Company had a cash balance per books of $6,190.00. The statement from Dakota State Bank on that date showed a balance of $7,700.00. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $25. 2. The bank collected $1,500 for Keeds Company through electronic funds transfer. 3. The July 31 receipts of $1,200.00 were not included in the bank deposits for July. These...
Whispering Company had bonds outstanding with a maturity value of $279,000. On April 30, 2020, when...
Whispering Company had bonds outstanding with a maturity value of $279,000. On April 30, 2020, when these bonds had an unamortized discount of $10,000, they were called in at 106. To pay for these bonds, Whispering had issued other bonds a month earlier bearing a lower interest rate. The newly issued bonds had a life of 10 years. The new bonds were issued at 102 (face value $279,000). Ignoring interest, compute the gain or loss. Loss on redemption $ Ignoring...
3) If you were preparing comparative balance sheets as of April 30, 2020 and April 2019...
3) If you were preparing comparative balance sheets as of April 30, 2020 and April 2019 for a small, local retailer, which specific balance sheet accounts would you expect to see changes in?  Identify which of these accounts you would anticipate to increase or decrease.  Which of the 3 categories of financial ratios (liquidity, solvency, profitability), would be affected by these changes in the Balance Sheet accounts?  Indicate whether the category or categories would improve or deteriorate identifying which ratios within each of...
Brighton Ltd has unadjusted trial balance as follows on 30 June 2020. Debit Credit Cash at...
Brighton Ltd has unadjusted trial balance as follows on 30 June 2020. Debit Credit Cash at bank 20,820 Accounts receivable 6,800 Prepaid insurance 5,200 Office supplies 1,200 Motor vehicles 108,000 Accumulated depreciation – Motor vehicles 45,000 Equipment 2,850 Accumulated depreciation – Equipment 1,120 Accounts payable 7,900 Bank loan 42,100 Unearned rental revenue 1,150 Capital 45,600 Drawings 13,100 Rental revenue 55,200 Salaries expense 24,200 Repairs and maintenance expense 4,100 Office supplies expense 9,900 Electricity expense 1,900 Totals 198,070 198,070 Additional information:...
On July 31, 2020, Sandhill Co. had a cash balance per books of $6,340.00. The statement...
On July 31, 2020, Sandhill Co. had a cash balance per books of $6,340.00. The statement from Dakota State Bank on that date showed a balance of $7,890.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $21.00. 2. The bank collected $1,720 for Sandhill Co. through electronic funds transfer. 3. The July 31 receipts of $1,397.30 were not included in the bank deposits for July. These...
White Ltd has adjusted trial balance as follows on 30 June 2020. Debit Credit Cash 1,280,000...
White Ltd has adjusted trial balance as follows on 30 June 2020. Debit Credit Cash 1,280,000 Service fee revenue 81,000 Account receivable 650,000 Prepaid insurance expense 55,000 Equipment 980,000 Accumulated depreciation-Equipment 305,000 Salaries expense 753,000 Depreciation expense 21,000 Accounts payable 281,000 Loan 730,000 Capital 400,000 Drawings 15,000 Retained earnings 310,000 Rent expense 23,000 Sales 7,021,000 Rent revenue 6,000 Cost of goods sold 4,100,000 Prepaid rent expense 71,000 Inventory 430,000 Accrued service fee revenue 11,000 Insurance expense 25,000 Interest expense 50,000...
Auburn Company Worksheet (partial) For the Month Ended April 30, 2020 Adjusted Trial Balance Income Statement...
Auburn Company Worksheet (partial) For the Month Ended April 30, 2020 Adjusted Trial Balance Income Statement Balance Sheet Account Titles Dr. Cr. Dr. Cr. Dr. Cr. Cash 10,000 Accounts Receivable 7,840 Prepaid Rent 2,280 Equipment 23,050 Accumulated Depreciation—Equip. 4,900 Notes Payable 5,700 Accounts Payable 4,920 Owner’s Capital 27,960 Owner’s Drawings 3,650 Service Revenue 15,590 Salaries and Wages Expense 10,840 Rent Expense 760 Depreciation Expense 650 Interest Expense 57 Interest Payable 57 Totals 59,127 59,127 Worksheet data for auburn company are...
Crane Cable Trial Balance April 30, 2020 Debit Credit Cash $4,200 Accounts Receivable 3,100 Supplies 900...
Crane Cable Trial Balance April 30, 2020 Debit Credit Cash $4,200 Accounts Receivable 3,100 Supplies 900 Equipment 10,500 Accumulated Depreciation―Equip. $1,360 Accounts Payable 2,300 Salaries and Wages Payable 700 Unearned Service Revenue 900 Owner’s Capital 13,040 Service Revenue 5,500 Salaries and Wages Expense 3,500 Advertising Expense 700 Miscellaneous Expense 350 Depreciation Expense 550 $23,800 $23,800 Horace Culpepper reviewed the records and found the following errors. 1. Cash received from a customer on account was recorded as $630 instead of $580....
The April 30 bank statement for KMaxx Company and the April ledger account for cash are...
The April 30 bank statement for KMaxx Company and the April ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other Balance Balance, April 1 $6,000 April 5 #101 $ 700 5,300 April 9 $2,500 7,800 April 12 #102 200 7,600 April 19 #103 500 7,100 April 22 #104 1,000 6,100 April 27 EFT payment $200 5,900 April 29 NSF check 100 5,800 April 30 Service charge 25 5,775 Cash (A) April 1 Balance 6,000 April 8 2,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT