Catalina Holdings Ltd. (CHL), a Calgary-based property management company, is owned by Leslie Smeal. Leslie received the
Question:
Catalina Holdings Ltd. (CHL), a Calgary-based property management company, is owned by Leslie Smeal. Leslie received the monthly statement for the company, which showed a balance of $26,936.89 at October 31, 2020. She is trying to prepare a bank reconciliation for CHL’s bank account. The balance in the Cash account in the company’s accounting system at that date was $21,260.16. Leslie reviewed the bank statement and the company’s accounting records and noted the following.
1. After comparing the cheques written by the company and those deducted from the bank account in October, Leslie determined that all six cheques (totalling $6,180) that had been outstanding at the end of September were processed by the bank in October. However, two of the cheques that had been written in October and mailed by CHL had not been cashed. These were cheques #5109 for $10,505.10 and #5112 for $5,303.07.
2. A review of the deposits showed that a deposit made by the company on September 30 for $11,532 was recorded by the bank on October 1, and a deposit of $12,314.10 that was made through the night deposit slot late on the evening of October 31 was recorded in the company’s accounting system but had not yet been recorded by the bank.
3. The October bank statement also showed the following:
• Service fees of $92 were deducted.
• Interest of $19.99 was deposited.
• A cheque for $1,125.58 that had been part of CHL’s deposit on October 23 was not honoured by the bank because the client had insufficient funds.
• Cheque #5101, which was for a utility payment, was incorrectly recorded by CHL’s bookkeeper as $960 when the actual cheque was for $690 (which was the correct amount owing by CHL).
• A customer had transferred $3,110.25 to CHL’s account electronically to settle the balance they owed CHL.
Required
a. Prepare a bank reconciliation as at October 31. Items that were outstanding last month but have been processed this month should no longer affect the bank reconciliation, since both the company and the bank now have them recorded.
b. How much cash does CHL actually have available as at October 31?
c. Prepare adjusting journal entries to record all the necessary adjustments to bring the Cash account to its correct balance.
Step by Step Answer:
Understanding Financial Accounting
ISBN: 9781119406921
2nd Canadian Edition
Authors: Christopher D. Burnley