Use the attached template to complete a bank reconciliation (Chapter 5) based on the following information:

Deposits in Transit: $800 and $1,100

NSF Check: $200

Notes Receivable: $4,000

Outstanding Checks: $620, $950, and $1,730

Bank Charges: $100 When recording check #1200 written for $5,000, the company erroneously recorded the amount as $1,200. The bank statement reflects a January 31, 2020 balance of $18,300, while the companys general ledger reflects a January 31, 2020 cash balance of $17,000. Be sure to include this date in the Bank Reconciliation report header.

Use appropriate formulas to calculate all subtotals and totals. All dollar amounts should be formatted using the Accounting Number format, with no decimals.

Apply the Heading 3 Quick Style to cells C8, G8, C17 and G17. Set a conditional formatting rule that will highlight the beginning bank balance with yellow flll and dark yellow text if it exceeds $17,000. Apply a header to the worksheet that displays the current date in the right section and a footer that displays the filename in the left section. Ensure that all column widths, row heights, and font sizes are appropriately adjusted. Add the appropriate borders to your bank reconciliation.