EA$5-$E$3$ COMPLETE A BANK RECONCILIATION FOR POND MAINTENANCE CORP.

In this exercise, you will complete a bank reconciliation as of $12/31/2026$ for Pond Maintenance Corp. One of your primary goals is to ensure that the file can be easily understood by the end user. Use this information to populate the reconciliation:

Deposits in Transit: $$10,100$ and $$1,000$

NSF Check: $$7,150$

Notes Receivable: $$7,000$

Outstanding Checks: $$3,100$ and $$600$

Bank Charges: $$1,100$

The bank erroneously deposited a $$250$ check written to TreeSky Industries into the bank account of Pond Maintenance Corp.

The bank statement reflects a $\frac{12}{31}\frac{?}{26}$ balance of $$94,200,$ while the company's general ledger reflects a $\frac{12}{31}\frac{?}{26}$ cash balance of $$102,600.$

Modify the appearance of the reconciliation using Format Painter and Quick Styles. Set a conditional formatting rule that will highlight the bank balance if it exceeds $$90,000.$ Apply a header that displays the filename and file path and a footer that displays the current time. Ensure that all column widths, row heights, and font sizes are appropriately adjusted.