How to reconcile a bank statement (without spreadsheets).

What "reconciliation" actually means

Reconciliation is the boring word for a fairly important thing: do your records and your bank's records describe the same set of transactions? It's the financial-software equivalent of double-checking that the numbers you read out loud match the numbers on the page.

For a checking or savings account, the question is whether every deposit and withdrawal you know about appears on the statement, and whether every transaction on the statement matches something you remember. For a credit card, it's the same question framed differently: did your purchases and payments produce the new balance the bank is claiming?

The reason this matters even if you trust your bank: banks occasionally get things wrong (returned payments that never get unposted, duplicate Zelle pulls, paper-check posting delays, ATM withdrawals that net out incorrectly). More commonly, youremember a transaction differently than it landed (you split a restaurant bill and forgot the Venmo received hasn't come through yet). Reconciliation makes the discrepancy visible while it's still small.

The only formula you need

For a checking or savings account:

opening balance
+ sum of all credits (deposits, transfers in, interest)
− sum of all debits  (checks, withdrawals, fees, transfers out)
= closing balance

For a credit card:

previous balance
+ purchases + cash advances + fees + interest
− payments − credits (refunds, statement credits)
= new balance

If both sides agree to the cent, you're reconciled. If they don't, something is missing or duplicated — and the gap is exactly the amount you need to track down. Even a $0.01 difference matters; it almost always points to a transaction you typed in twice, an amount you got backwards, or a transaction your bank posted in a different period than you thought.

Method 1: by hand (the calculator-and-statement approach)

This is the oldest and most reliable method:

1. Print or open the statement PDF. Find the opening balance and the closing balance — they're usually labelled and bolded at the top.
2. Pick one column to be your "credits" column and another to be "debits." Highlight every transaction on the statement, classifying each one.
3. Add up the credits. Add up the debits. Take opening + credits − debits.
4. If the result matches the closing balance, you're done. If not, look for: transactions split across statement-period boundaries, sign errors (debits typed as credits), or fees you didn't know about.

This method takes 15-30 minutes per statement and is tedious enough that almost no one does it monthly. But it teaches you what the math looks like, which is useful context when software disagrees with you later.

Method 2: spreadsheet (the patient-person approach)

The middle-ground method. You type every transaction into a spreadsheet — one row per transaction with a Date, Description, Credit, Debit, and a running Balance column. Set a formula at the bottom that computes opening + sum(credits) − sum(debits) and compares it to the closing balance.

The catch: data entry is brittle.

• One mistyped digit and the spreadsheet says everything checks out but the real reconciliation is off.
• Bank-provided CSV exports (if your bank offers them) help but rarely use the same column layout as your spreadsheet — you spend more time importing than reconciling.
• Quarterly summaries require copy-pasting across three monthly tabs and the formulas tend to break when you move rows.

For a single account checked once a year (tax time), spreadsheets are fine. For multiple accounts checked every month, the friction adds up fast.

Method 3: software (the read-the-PDF approach)

The third way is to use software that reads the same PDF your bank already sends you, extracts every transaction automatically, runs the reconciliation formula, and only shows you a problem when one exists.

This is what CentProof does. Drop in a PDF, get a reconciliation pass or fail within seconds. If the formula doesn't balance, CentProof shows you the discrepancy by name (purchases differ from the row sum by $51.22, or payments are missing $4,364.50) and lets you decide whether to commit the statement with a manual-override note for your own records.

There are other tools that do this too — most of the mainstream personal-finance apps reconcile silently as part of their bank-sync process. The trade-off is that those tools want you to give them your bank password and store your transaction history on their servers, which is the topic of this other guide. CentProof skips that side of the trade entirely by reading the PDFs locally on your Mac.

What to do when reconciliation fails

A failed reconciliation isn't a disaster — it's information. The math is telling you that something is inconsistent between the statement and your records (or, occasionally, that the statement's own internal math disagrees with itself; this happens more often than you might think, usually around posting-date edge cases).

The diagnostic order that works:

1. Confirm the period boundaries. The most common cause of a small failed reconciliation is a transaction your bank posted on the first or last day of the statement period that you remembered as belonging to the previous or next month.
2. Look for sign errors. A debit typed as a credit (or vice versa) shows up as a gap equal to twice the transaction amount, which is suspicious-looking and usually leads you right to the row.
3. Search for the exact gap amount. If reconciliation says you're off by $145.32, there's usually a single transaction for $145.32 that's either missing or duplicated. Search your statement for that string.
4. Check for fees you didn't know about. Foreign-transaction fees, ATM fees, and monthly account maintenance fees often appear on a separate line that the casual reader misses.

If you genuinely can't close the gap and the statement's own math doesn't add up, that's a real bank-side error. Call the number on the statement and have them walk through the period with you. It happens.

Why bother at all

If you're curious why anyone reconciles when their bank already has a closing balance they trust: the point isn't to find the closing balance. The point is to verify the compositionof how you got there. Reconciliation is what makes "I spent $130 on groceries last month" a number you can stand behind instead of an estimate.

For freelancers and 1099 workers, this matters at tax time: every deductible expense needs a transaction-level receipt, and reconciliation is the audit trail that connects the deduction to the bank record. For couples splitting expenses, reconciliation is the difference between an honest settlement and a passive-aggressive spreadsheet argument. For people who just want to know where their money actually went, it's the only way to be sure.