Question

In: Accounting

On October 31 Larkspur Ltd. received its bank statement from Provincial Bank. It stated that Larkspur...

On October 31 Larkspur Ltd. received its bank statement from Provincial Bank. It stated that Larkspur had a balance of $9,660 at October 31. The company’s general ledger showed a cash balance of $10,220 at that date. A comparison of the bank statement and the accounting records revealed the following information:

Bank service charges for the month were $40.
The company had written and mailed out cheques with a value of $1,530 that had not yet cleared the bank.
A cheque from one of Larkspur’s customers in the amount of $800 that had been deposited during the last week of October was returned with the bank statement as NSF.
An electronic funds transfer payment (EFT) of $250 for monthly insurance expense was automatically deducted from Larkspur’s bank account on October 22. Larkspur’s bookkeeper had forgotten to record this transaction.
During the month, the company’s bookkeeper had recorded a cheque (#1872) paid for utilities as $575 rather than $755 (which was the amount written on the cheque and processed by the bank).
The cash receipts for October 31 amounted to $820 and had been deposited in the night drop slot at the bank on the evening of October 31. These were not reflected on the bank statement for October

Solutions

Expert Solution

sollution

Larkspur Ltd
Bank Reconciliation - at October 31
Bank's Cash balance Company's cash balance
Particulars Particulars Amount
Ending balance as per Bank Statements $9,660.00 Ending Balance as per cash books $10,220.00
Additions: Additions:
Deposit In Transit $820.00
Deductions:
Deductions: NSF CHEQUE $800.00
Insurance Expenses $250.00
Outstanding Checks $1,530.00 Incorrect recording of check($755-$575) $180.00
Service Charge $40.00
Adjusted bank balance $8,950.00 Adjusted Cash balance $8,950.00
Larkspur Ltd
S.no Account Title Debit credit
a Miscellaneous Expense $40
cash 40
(To record Service Charge )
b No Journal Entry Required
c Accounts receivables $800
cash 800
(To record NSF Check from customer)
d Insurance expenses $250
cash 250
(To record Insurance Exp.)
e Utilities expenses $180
cash $180
(To record correction entry for check no 1872
f No Journal Entry Required

Related Solutions

When Pharoah Holdings Ltd. received its bank statement for the month of October, it showed that...
When Pharoah Holdings Ltd. received its bank statement for the month of October, it showed that the company had a cash balance of $14,849 as at October 31. Pharoah’s general ledger showed a cash balance of $17,390 at that date. A comparison of the bank statement and the accounting records revealed the following information: 1. Bank service and credit card charges for the month were $7. 2. A cheque, in the amount of $520, from one of Pharoah’s customers that...
The October 31 bank statement of Spooky Halloween Costumes Ltd. (SHC) has just arrived from TD...
The October 31 bank statement of Spooky Halloween Costumes Ltd. (SHC) has just arrived from TD Bank. To prepare the SHC bank reconciliation, you gather the following data: SHC’s Cash account shows a balance of $2,256.14 on October 31. The October 31 bank balance is $4,023.05. The bank statement shows that SHC earned $38.19 of interest on its bank balance during October. This amount was added to SHC’s bank balance. SHC pays utilities of $250 and insurance of $100 by...
Friends, Inc. received its bank statement for the month ended 12/31/18. The bank statement showed a...
Friends, Inc. received its bank statement for the month ended 12/31/18. The bank statement showed a balance of $10,102.87. The company’s general ledger showed a balance of $8,656.11. The following items were discovered when comparing the bank statement to the books of the company: The bank charged check processing fees of $25.00. There was a $1,825.52 automatic withdrawal to pay the mortgage. Of the $1,825.52, $1,572.86 was for interest which had been accrued. The bank charged Friends, Inc. account $250.00...
Question 4 The October 31 bank statement of Spooky Halloween Costumes Ltd. (SHC) has just arrived...
Question 4 The October 31 bank statement of Spooky Halloween Costumes Ltd. (SHC) has just arrived from TD Bank. To prepare the SHC bank reconciliation, you gather the following data:     SHC’s Cash account shows a balance of $2,256.14 on October 31.     The October 31 bank balance is $4,023.05.     The bank statement shows that SHC earned $38.19 of interest on its bank balance during October. This amount was added to SHC’s bank balance.     SHC pays utilities of...
Question 4 The October 31 bank statement of Spooky Halloween Costumes Ltd. (SHC) has just arrived...
Question 4 The October 31 bank statement of Spooky Halloween Costumes Ltd. (SHC) has just arrived from TD Bank. To prepare the SHC bank reconciliation, you gather the following data:     SHC’s Cash account shows a balance of $2,256.14 on October 31.     The October 31 bank balance is $4,023.05.     The bank statement shows that SHC earned $38.19 of interest on its bank balance during October. This amount was added to SHC’s bank balance.     SHC pays utilities of...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance of $4,188.30 as at 31 January 2020. The cash balance on the company’s books at 1 January 2020 was $176.00 (debit). The progressive totals of the Cash Receipts Journal and the Cash Payments Journal before considering items 1 to 5 below were $21,475.40 and $17,622.10 respectively. The following reconciling items were identified: (1) Un-presented cheques amounted to $501.25. (2) Debits included in the bank...
Roper Electronics received its bank statement from Northern Regional Bank for the month of August with...
Roper Electronics received its bank statement from Northern Regional Bank for the month of August with a balance of $11,740.00 as of August 31. Northern Regional Bank also collected a $5,000.00 notes receivable from Roper Electronic's customer on August 1. The customer owed interest on the receivable for the period March 1 to August 1 at 12% annual interest. Northern Regional Bank charged a $35.00 fee for the collection service.The bank statement reveals a bank service charge of $20.00. A...
Problem 1: The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows....
Problem 1: The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows. WEEZ Ltd Bank Reconciliation 31 October 2017 Cash balance per bank Add: Deposits in transit $ 12 444.70   1 530.20 13 974.90 Less: Outstanding cheques Cheque number Cheque amount 2451 2470 2471 2472 2474 $ 1 260.40 720.10 844.50 503.60 1 050.00 4 378.60 Cash balance per the General Ledger $ 9 596.30 The November bank statement had a balance of $17 069.40 and...
Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance...
Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance of $15,180. Meanwhile its Cash book balance at March 31, 2019 stood $8,140. In addition, the Accountant of Broadway Enterprises was presented with the following information: Bank charges for the month were shown as $250 as per bank statement. Cheques issued to two creditors-Alloy Limited for $900 (cheque #253) and Ben Lion for $270 (cheque #258) were not presented to the bank and remain...
The following information applies to the questions displayed below.] On October 31, 2018, the bank statement...
The following information applies to the questions displayed below.] On October 31, 2018, the bank statement for the checking account of Blockwood Video shows a balance of $13,079, while the company’s records show a balance of $12,356. Information that might be useful in preparing a bank reconciliation is as follows: a. Outstanding checks are $1,255. b. The October 31 cash receipts of $810 are not deposited in the bank until November 2. c. One check written in payment of utilities...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT