Acc 240 Principles of Financial Acct: Bank Reconciliation

All the information needed is in the attached document. Please complete on an excel page or google spreadsheet.

The Mask Company needs their cash account and bank statement reconciled.
Listed below is the information necessary to reconcile the cash account for March.
ALL NUMBERS are in Dollars.
Bank statement balance at March 31: $12,293
NSF check: 350
Bank collected a payment from a customer – Mask was unaware of the payment: $981
Outstanding checks
Check # 709 – 397
Check # 711 – 242
The bank charged the company a fee for new checks: 25
Deposit in Transit: 1,962
Company’s Cash account balance at March 31: 13,010
There were no outstanding checks or deposits in transit at February 28th.
Required: Prepare a two part bank reconciliation with any necessary adjusting entries for March.