The December 31, 2020 bank balance is $100,000 as per the bank statement. The following cheques were
Fantastic news! We've Found the answer you've been seeking!
Question:
The December 31, 2020 bank balance is $100,000 as per the bank statement.
The following cheques were written and had not been cashed as of December 31:
Cheque Date | Cheque Number | Amount |
January 6, 2020 | 5 | $1,050 |
May 14, 2020 | 18 | $7,500 |
June 23, 2020 | 26 | $380 |
August 12, 2020 | 32 | $528 |
October 25, 2020 | 35 | $6,350 |
December 18, 2020 | 46 | $350 |
December 23, 2020 | 51 | $105 |
December 23, 2020 | 52 | $8,000 |
December 24, 2020 | 53 | $7,777 |
The CFO left cheques 51, 52, and 53 in the office during the holidays and did not mail them until January 4, 2021.
In addition, the controller deposited a cheque for $2,500 at an ATM on December 31, 2020 that was not reflected in the bank account until January 4th, 2021?
Required:
Prepare the bank reconciliation (in Excel) for December 31, 2020 and provide your thought process where needed.
Related Book For
Horngrens Accounting
ISBN: 978-0133855371
10th Canadian edition Volume 1
Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo Ann L. Johnston, Peter R. Norwood
Posted Date: