repare a bank reconciliation as of December 31, 2020
The data you will need is as follows:
Balance per bank statement as of December 31, 2020 $1,738
Deposits in transit as of December 31, 2020 $ 2,500
Outstanding checks as of December 31, 2020 $3,235
Correct Cash Balance as of December 31, 2020 $4,003
Balance per Books as of December 31, 2020 $5,628
Interest collected by the bank in December, 2020
but not recorded in books as of
December 31, 2020 $ 600
Bank service charges deducted by the bank in
December, 2020 but not recorded in
books as of December 31, 2020 $ 75
IN EXCEL FORMAT PLEASE
Step by step
Solved in 2 steps with 1 images
