Please help, i need help for filling out the bank reconcilliation table in the format presented. The list of accounts to use for the table are Bank balance per statement,Blanace per cheque book, bank services, correction of cheque eroor, outstanding deposit, EFT receipt, Interest Paid by bank, NSF cheques, Reconciled balance
Current Attempt in Progress
Oriole Holdings Ltd.(OHL).a Calgary-based property management company,is owned by Elizabeth Brown.Elizabeth received the monthly statement for the company,which showed a balance of $29,106.89 at October 31,2024.She is trying to prepare a bank reconciliation for OHL's bank account. The balance in the Cash account in the company's accounting system at that date was $21,160.13.Elizabeth reviewed the bank statement and the company's accounting records and noted the following: After comparing the cheques written by the company and those deducted from the bank account in October,Elizabeth 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 OHL had not been cashed These were cheques #5109 for $11,525.10 and 5112 for $5,468.85. 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,384.60 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 $93.00were deducted. Interest of $18.99was deposited. A cheque for$1,182.58 that had been part of OHL's deposit on October 23was not honoured by the bank.because the client had insufficient funds. Cheque#5101,which was for a utility payment,was incorrectly recorded by OHL's bookkeeper as$810.00 when the actual cheque was for $180.00(which was the correct amount owing by OHL). A customer had transferred$3,964.00 to OHL's account electronically to settle the balance it owed OHL
Oriole Holdings Ltd Bank Reconciliation As of October 31,2024
