Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cullumber Holdings Ltd. (CHL), a Calgary-based property management company, is owned by Linda Williams. Linda received the monthly statement for the company, which showed a

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed Cullumber Holdings Ltd. (CHL), a Calgary-based property management company, is owned by Linda Williams. Linda received the monthly statement for the company, which showed a balance of $31,776.89 at October 31,2024 . 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 $27,387.07. Linda 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, Linda 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 $11,846.40 and #5112 for $5,385.96. 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 $13,949.70 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 $84.00 were deducted. - Interest of $23.99 was deposited. - A cheque for $1,177.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 $540.00 when the actual cheque was for $450.00 (which was the correct amount owing by CHL ). - A customer had transferred $2,254.75 to CHL's account electronically to settle the balance it owed CHL. Add Less Prepare a bank reconciliation as at October 31. (Hint: 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.) (List items that increase balance as ber bank and books first. Enter answers to 2 decimal places. e.q. 125.25.) Balance per Bank Statement Balance per Cheque Book Bank Services Correction of Cheque Error Outstanding Deposit EFT Receipt Interest Paid by Bank NSF Cheque Outstanding Cheques Reconciled Balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Standards Board Webster S Timeline History 1971 2006

Authors: Icon Group International

1st Edition

0546876501, 978-0546876505

More Books

Students also viewed these Accounting questions