Bank reconciliation
Bank reconciliation worksheet
Compare bank and book balances with deposits in transit, outstanding checks, fees, interest, and adjustment rows.
Sign in to keep templates for reuse.
PreviewPrintable bank reconciliation worksheet
$650.00 varianceBank reconciliation
May bank reconciliation
Northwind Studio - Operating Checking 1042 - Statement 2026-04-30 - Prepared by Maya Chen
Balance summary
| Bank statement balance | $5,000.00 |
|---|---|
| Adjusted bank balance | $5,350.00 |
| Book balance | $4,725.00 |
| Adjusted book balance | $4,700.00 |
| Variance | $650.00 |
Adjustment summary
| Deposits in transit | $800.00 |
|---|---|
| Outstanding checks | $450.00 |
| Bank fees | $25.00 |
| Interest earned | $0.00 |
| Book adjustments | $0.00 |
| Bank adjustments | $0.00 |
Reconciliation items
| Date | Description | Type | Amount | Status | Owner |
|---|---|---|---|---|---|
| 2026-04-25 | Check 1189 | Outstanding Check | $450.00 | Open | Noah |
| 2026-04-28 | Client deposit batch | Deposit In Transit | $800.00 | Open | Maya |
| 2026-04-30 | Monthly service fee | Bank Fee | $25.00 | Cleared | Maya |
Outstanding and review checklist
- Review Check 1189 on 2026-04-25 for $450.00 with Noah.
- Review Client deposit batch on 2026-04-28 for $800.00 with Maya.
Notes
Resolve review rows before closing the month.