Prepare a bank reconciliation as of December 31, 2020. Use the format shown in Illustration 7A.2 on page 7-35 of our textbook.

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