Reconciliation: How Two Sets of Records Come to Agree

Two people wrote down the same events. You recorded what you spent; your bank recorded what it processed. Neither is a copy of the other, which is the entire point. If the two independently produced records agree, the events probably happened the way both of them say. If they disagree, one of them is wrong, and it is worth knowing which.

That comparison is reconciliation. It is the oldest control in accounting and it survives in every serious system, including the one underneath this app.

What reconciliation actually is

The word gets used loosely for any kind of tidying. In accounting it means something specific: take two records of the same events from two independent sources, line them up item by item, and account for every difference.

The classic shape is a subtraction. The bank knows about everything it has processed. You know about everything you have done, including the items it has not caught up with yet.

When the middle term is fully explained, the reconciliation is done. When something in it cannot be named, you have found either a mistake in your records or a transaction you did not make, and those are very different problems with the same first symptom.

Why the two numbers differ

A first-time reconciler usually assumes a mismatch means an error. Most of the time it means the two records are looking at the same events from different moments.

The timing differences are not sloppiness, they are how the payment system is built. A deposited check has an availability schedule set by regulation rather than by your bank’s goodwill: under Regulation CC a depositary bank must make funds from a local check available for withdrawal no later than the second business day following the banking day of deposit.^[4] Until then, one record shows money you cannot yet spend.

The card side is stranger. A hold moves nothing. In a 2024 consent order, the CFPB laid out the mechanics: a $40 debit card purchase lowers the available balance immediately, but those funds “are not placed in a separate account or otherwise set aside,” and the current balance does not fall until the institution pays the merchant at settlement, “usually days later.”^[1] Two balances, both correct, describing different stages of one purchase.

That lag is also where overdraft fees are decided, because settlement happens in a nightly batch and the charge is a flat amount per item rather than a percentage of the shortfall. Which items get charged depends on the sequence a bank posts the batch in, which is the one piece of this machinery that varies from bank to bank.

Pending and posted are one purchase

The feed shows a coffee shop charge on Monday as pending, and the same charge on Wednesday as posted, sometimes for a slightly different amount because a tip was added. Those are not two purchases. A tool that counts both has overstated your week, and a tool that throws the pending record away has lost the timestamp of when you actually spent the money.

Matching the pending record to the posted one keeps a single event with a single history: the date you bought the coffee, the final amount, and the fact that both records describe one cup. That match is the smallest and most common reconciliation there is, and it happens hundreds of times a month in an ordinary household.

The method, in five steps

1. 1
   Fix the period and the two endpoints

   Take one account and one statement. Write down the closing balance the bank reports, and the balance your own records show on the same date. If you have never done this, the gap can look alarming and usually is not.
2. 2
   Tick off what both sides agree on

   Work down the statement and mark each line that matches an entry you already have, by amount and approximate date. Most lines clear in this pass, which is why the job gets faster every month you do it.
3. 3
   List what only the bank has

   Fees, interest, automatic payments you forgot, and anything you did not record. Each of these becomes a new entry in your records. This is the step that finds the subscription you thought you cancelled.
4. 4
   List what only you have

   Outstanding checks, deposits in transit, card charges still in flight. These need no correction; they need naming. Their total is the middle term of the equation above.
5. 5
   Explain the remainder, or dispute it

   Whatever is left after the first four steps is an error on one side. Recheck your own entry first, since transposed digits are more common than bank mistakes. If your entry is right, the charge is the bank's problem and yours to report.

Step three is the one people skip, and it is where the money usually is. A fee you did not know about is not a difference to be explained away, it is a real expense that belongs in your records like any other.

LumaLedger

Ledger

Found while reconciling · Sep statement

AccountTypeDebitCredit

DRBank feesExpense12.00

CRChecking ··4417Asset12.00

Balanced12.0012.00

The clock reconciliation protects

There is a practical reason to do this monthly rather than whenever the mood strikes. Consumer protections for electronic transfers run on deadlines that start when the statement is sent, not when you get around to reading it.

Regulation E sets a tiered scheme. Report the loss or theft of an access device within two business days and liability is capped at the lesser of $50 or the amount of unauthorized transfers before notice; wait longer and the cap rises to $500. For transfers that simply appear on a statement, the consumer must report within 60 days of the institution sending it, after which the caps no longer protect transfers the institution can show timely notice would have prevented.^[3]

On the other side, the institution has duties too. It generally must determine whether an error occurred within 10 business days of your notice, or take up to 45 days if it provisionally credits your account for the disputed amount so you have use of the funds while it investigates.^[2]

The output is the exception list

A reconciliation that ends with “the balances match” has produced one bit of information. A useful one ends with a list: three items that did not line up, what each of them is, and what happens next. Accountants call those exceptions, and the discipline is that every exception gets a resolution rather than a shrug.

The categories are few. A duplicate, where the same purchase arrived twice. A balance that does not line up, where the account’s computed total disagrees with the statement. An entry that cannot be posted, because it is missing something a ledger requires. Each resolves either by correcting your records or by contacting the institution, and writing down which one happened is what keeps next month’s reconciliation from rediscovering it.

How LumaLedger reconciles

Doing this by hand once a month is a reasonable ritual, and it is a poor use of a person’s evening when the same work is mechanical. The ledger underneath LumaLedger runs the matching passes automatically: pending records against their posted counterparts, transfers between your own accounts against each other, card payments against the statement they pay, and suspected duplicates against the original.

Statement reconciliation is the explicit version. Give an account a statement date and the closing balance, and the engine compares it with the balance computed from your entries. A match is recorded along with the bank’s figure as of that date. A mismatch opens an exception carrying both numbers, because the gap is the useful part.

On any individual transaction, the Ledger shows what it was matched with and anything still needing review, so a pending charge that never posted or a possible duplicate is visible on the record itself rather than buried in a report. The entries behind all of it are ordinary double-entry journal entries, which is what makes the balances derivable rather than stored: why a household ledger keeps books the way a business does covers the mechanism.

Whichever way you do it, the habit is worth more than the tooling. A monthly pass over one account, with every difference named, turns your records from an estimate into something you can act on, and catches the charge that should not be there while the deadline that protects you is still open. The rest of the routine is in the month-end review this step belongs to.