Reconciliation is the check every other number in your books depends on: until the cash is proven, nothing built on top of it can be trusted. A workpaper is how you prove it — a short, disciplined layout that reconciles the bank's view of an account to your own. Below is that layout, blank and ready to fill.
The reconciliation identity
The reconciliation workpaper
Fill the amount column from left to right down the sheet: enter the statement's ending balance, list the timing adjustments, and carry the adjusted balance down to compare against your book balance. The account is reconciled when the final difference is zero.
| Line | Amount |
|---|---|
| Statement ending balance (per bank) | |
| Add: deposits in transit | |
| Less: outstanding checks and withdrawals | |
| Adjusted bank balance (A) | |
| General ledger cash balance (per books) | |
| Add: bank credits not yet recorded (e.g. interest) | |
| Less: bank charges and fees not yet recorded | |
| Adjusted book balance (B) | |
| Difference (A − B) — must equal zero |
How to work the workpaper
Begin with the two balances you already have: the ending balance printed on the bank statement, and the cash balance your books show for the same date. They rarely match on the first look, and that is expected — the gap is almost always timing. Deposits in transit are payments you recorded and deposited that haven't posted at the bank yet; outstanding checks and withdrawals are payments you issued that haven't cleared. Adjust the statement balance for both to get the adjusted bank balance.
Then adjust your book balance for anything the bank did that you haven't recorded yet — interest credited, a service charge, a returned item. Those belong on the book side because they are real transactions your books simply haven't caught up to. When both sides are adjusted, the difference should be zero. If it is, the account is reconciled and every number built on that cash can be trusted. For the full concept, read the bank reconciliation reference.
When the difference won't reach zero
A difference that refuses to close is telling you something specific: a transaction entered twice, a payment never recorded, a prior reconciliation that was forced through, or an opening balance that was wrong from the start. The workpaper's value is that it isolates which side the problem is on, but finding and fixing the cause can be genuinely hard. Our bank reconciliation service traces a stubborn difference to its source, and a free read-only QuickBooks review tells you what is keeping an account from reconciling before any work begins.