How to reconcile a bank statement

Reconciling means explaining the gap between what the bank says you have and what your own records say. The two almost never match on the day the statement is cut, and that is normal. The point is not to make them equal; it is to account for every dollar of the difference.

The formula

If that adjusted balance equals what your books say, you are reconciled.

Two of those terms explain almost every difference:

Deposits in transit. Money you recorded as received but that had not cleared when the cycle was cut. A check deposited on the 30th that clears on the 2nd sits in your books and not on the statement.

Outstanding checks and payments. The reverse. You wrote a check on the 28th, recorded it, and the recipient banked it in the following month. It is out of your books already and not yet off the statement.

Neither is an error. They are timing, and they resolve themselves next cycle.

The steps

1. Get both sides into a comparable shape. Your statement, and your ledger for the same period, both as lists of dated amounts.

This is where converting the PDF earns its keep. Pick your bank, drop the statement in, and you get a spreadsheet with the transactions split into columns. Then it is a sort and a comparison instead of a finger on a page. The conversion runs in your browser, so a document with your full transaction history does not go anywhere.

2. Check the statement against itself first. Before comparing anything, confirm the statement is internally consistent. Beginning balance plus deposits minus withdrawals should equal the ending balance, and those four figures are printed in the summary box on page one.

Our converter does the row-level version of this automatically: it walks the running balance column and tells you whether every row’s arithmetic closes. If it does not, stop, because you are about to reconcile against an incomplete extraction.

3. Tick off what matches. Work through the statement and mark each transaction that also appears in your records. Sorting both lists by amount is faster than sorting by date, because amounts are unique enough to match on and dates disagree by design.

4. List what is left. Two piles. On the statement but not in your books. In your books but not on the statement.

5. Explain each one. Everything in those two piles is one of:

Category	Which pile	What to do
Deposit in transit	Books only	Expect it next cycle. No action.
Outstanding check	Books only	Expect it next cycle. No action.
Bank fee	Statement only	Record it. This is the most commonly missed item.
Interest earned	Statement only	Record it.
NSF or returned item	Statement only	Record it, and the fee, and chase the payer.
Automatic payment you forgot	Statement only	Record it.
Duplicate entry	Books only	Delete one.
Transposed number	Either	Fix it. See below.
Genuine bank error	Statement only	Rare, but real. Dispute it, and mind the deadline.

6. Apply the formula. Adjusted balance against your books. If they agree, you are done, and you should also now update your records with every fee, interest payment and automatic debit from step 5.

When it does not balance

The difference itself tells you what to look for.

Divisible by 9. Almost certainly transposed digits: 54 entered as 45, 1,250 as 1,520. The difference between a number and its transposition is always a multiple of 9. Divide the difference by 9 and it hints at the magnitude.

Exactly twice a transaction amount. A sign error. Something recorded as a debit that was a credit, or the reverse. Halve the difference and look for a transaction of that exact value.

Exactly equal to a transaction amount. Something is missing from one side, or entered twice on the other. Search both lists for that number.

A round number like 12.00 or 35.00. A fee. Check the statement for a maintenance or overdraft charge that never made it into your books.

Nothing obvious. Split the period in half and reconcile each half. Two rounds of that narrows it to a handful of transactions, which is faster than staring at the whole month.

Reconciling several months at once

This is the situation most people are actually in, and it is worth being honest about: it is much harder than doing it monthly, because an unexplained item could belong to any cycle.

Do it in order, oldest first, and close each month before starting the next. The ending balance of one reconciliation is the starting point of the next, so an error you carry forward gets compounded rather than isolated.

Convert each statement, then merge the results into one sheet for the overall view, but reconcile cycle by cycle. And run the duplicate finder on the merged file first: overlapping periods are the single most common reason a multi-month reconciliation refuses to close, and a duplicated row looks exactly like a real one.

If you are on QuickBooks

The reconciliation happens inside the software, but it needs the transactions first, and QuickBooks Desktop will not take a CSV.

Convert the statement straight to QBO rather than going through a spreadsheet. Beyond saving a step, the transaction IDs are derived from the transaction contents, so reimporting the same period does not create duplicates. That is precisely the failure mode that makes a QuickBooks reconciliation impossible to close.