Reconciliation is the single most important habit in bookkeeping. It proves that what your books say matches what the bank says. Without it, every report — profit, cash, taxes — rests on unverified data. Here's how it works and how to do it well.
What reconciliation is
A bank reconciliation compares the transactions and ending balance in your accounting records with your bank statement for the same period. If they match — after accounting for timing differences — your cash is verified. If they don't, something is missing, duplicated or wrong.
The same process applies to credit cards, loans, payment processors and any account with an external statement.
Why it matters
- Catches errors: duplicate entries, missed transactions, wrong amounts.
- Detects fraud: unauthorized charges and altered payments show up.
- Makes reports reliable: your P&L and balance sheet depend on it.
- Simplifies tax time: your CPA gets a verified file.
What you need
- The bank or card statement for the period
- Access to your accounting software (QuickBooks Online, Xero or similar)
- Last period's reconciliation report
Step by step
1. Make sure transactions are imported and categorized
All feed transactions through the statement end date should be categorized or matched. Enter any missing items, such as checks not in the feed.
2. Start the reconciliation
In your accounting software, choose the account and enter the statement end date and ending balance. Both QuickBooks Online and Xero have dedicated reconciliation tools.
3. Confirm the beginning balance
It should equal last period's reconciled ending balance. If it doesn't, something in a prior period was changed — investigate before continuing.
4. Match transactions
Tick off each transaction that appears on both the statement and in your books. Pay attention to amounts and dates.
5. Investigate differences
When the difference isn't zero, look for:
- Missing transactions: on the statement but not in the books (bank fees, interest, transfers).
- Duplicates: the same transaction entered twice, often from a feed plus a manual entry.
- Wrong amounts: transposed digits are common (for example, 54 vs 45 — differences divisible by 9 are a clue).
- Timing differences: checks written but not cleared, deposits in transit.
- Wrong account: a transaction posted to the wrong bank or card.
6. Finish and save the report
When the difference is zero, complete the reconciliation and save the report with the statement. Never force a reconciliation with an unexplained adjustment.
7. Review
A second person reviews the reconciliation report, especially any old uncleared items.
Credit cards and processors
- Credit cards: payments from your bank to the card are transfers, not expenses. Recording them as expenses double-counts.
- Payment processors (Stripe, PayPal, Shopify Payments): payouts are net of fees and refunds. Record gross sales, fees and refunds separately so revenue and costs are accurate, and reconcile the clearing account.
How often to reconcile
Monthly at minimum, as part of the month-end close. High-volume businesses benefit from weekly reconciliation of their main operating account.
Red flags to escalate
- Transactions you don't recognize
- Vendor payments to new or changed bank details
- Repeated small charges from unknown merchants
- Large uncleared checks older than 90 days
Escalate these to the business owner immediately. Changes to vendor bank details should always be verified through a known contact. See security for financial data.
Common mistakes
- Reconciling to the feed instead of the statement. Feeds can be incomplete.
- Forcing a balance with an adjustment entry.
- Ignoring old uncleared items. They accumulate and hide errors.
- Editing reconciled periods. Lock closed periods.
Records
Keep statements and reconciliation reports organized by month. The IRS explains business recordkeeping requirements (IRS).
A worked example: reconciling a checking account
Here's a simplified reconciliation for an operating account at month-end. All figures are illustrative.
| Item | Amount |
|---|---|
| Ending balance per bank statement | $48,250.00 |
| Add: deposits in transit (customer check deposited on the 31st, credited on the 2nd) | +$3,400.00 |
| Less: outstanding checks (#1042 for $1,150 and #1045 for $600) | −$1,750.00 |
| Adjusted bank balance | $49,900.00 |
| Ending balance per books | $50,035.00 |
| Less: bank fee not yet recorded | −$35.00 |
| Less: customer payment recorded twice in the books | −$100.00 |
| Adjusted book balance | $49,900.00 |
The two adjusted balances agree, so the account is reconciled. Two journal entries are needed: one to record the $35 fee and one to reverse the duplicate $100 payment.
A reconciling-items log
Keep a running log so old items don't hide:
| Date found | Item | Amount | Type | Action | Cleared on |
|---|---|---|---|---|---|
| Sep 30 | Check #1042 outstanding | $1,150 | Outstanding check | Confirm with vendor if not cleared in 60 days | |
| Sep 30 | Duplicate customer payment | $100 | Book error | Reversed | Sep 30 |
Any outstanding check older than about 90 days deserves a follow-up. Vendors may never have received it, and unclaimed funds rules may eventually apply.
Payment processors: the clearing-account method
Stripe, Square, Shopify Payments and PayPal deposit net amounts after fees and refunds. If you record only the net deposit, revenue and fees are both understated. A clearing account fixes this:
- Record gross sales into a "Processor clearing" account
- Record processor fees as an expense out of clearing
- Record refunds and chargebacks out of clearing
- Record the payout as a transfer from clearing to the bank
At month-end, the clearing balance should equal funds the processor is holding but hasn't paid out yet. If it drifts, something is missing.
Checklist: a reviewer's five-minute check
- Do the statement ending balance and date match the actual statement?
- Is the reconciliation dated and signed off by the preparer?
- Are any reconciling items older than 60 days?
- Do any adjustments go to "uncategorized" or "suspense" accounts?
- Was the period locked after reconciliation?
A reviewer who can't answer yes to the first, second and fifth questions should send it back.
Common reconciliation shortcuts that cause problems
- Reconciling to the bank feed instead of the statement. Feeds can miss or duplicate transactions. The official statement is the source of truth.
- Forcing a difference. Posting an "adjustment" to make the numbers agree hides the error rather than finding it. Small unexplained differences often point to a duplicate or a transposed number, such as $1,250 entered as $1,520.
- Skipping zero-activity accounts. Dormant accounts still need a monthly check, since fraud on an unwatched account can go unnoticed for months.
- Reconciling only cash. Credit cards, loans and processor clearing accounts need the same discipline.
- No second pair of eyes. Even a light monthly review by the owner or an accountant deters errors and fraud.
Keep each month's reconciliation report with the statement in your records.
The bottom line
Reconcile every account, every month, to the statement — and have someone review it. It's the foundation for every financial decision you make.
ExecWing bookkeepers reconcile every bank, card and processor account monthly. See Bookkeeping.
Sources
- IRS, Recordkeeping.
Want a dedicated assistant who already knows this playbook?
ExecWing places full-time, managed assistants from the Philippines with US leaders. Month-to-month, from $1,900/mo. See pricing or how it works.
Book a 20-minute fit call