The account reconciliation process
Last reviewed 2026-09-18
The steps below are ordered by dependency rather than by convention. Each one produces something the next step needs, and skipping ahead is how a reconciliation reaches a conclusion it has not earned.
1. Fix the date and the scope
Name the account, the entity, the period end and the currency before anything is extracted. An account reconciled “at month end” where the ledger was pulled on the 2nd and the statement covers to the 30th has a built-in difference nobody will find, because it is not on either side — it is in the framing.
2. Obtain independent evidence
Get the external statement first, not last. Requesting it after the difference appears biases what you look for, and it puts the reconciliation on the critical path of somebody else's response time at exactly the point in the close when there is no slack.
Record where it came from and who produced it. In eighteen months, the question asked of this reconciliation will not be what the difference was; it will be whether the figure it was compared against was the right one.
3. Prove the population arrived whole
Before comparing balances, establish that the data you have is all the data there is. That means a control total from outside the file: the statement's own closing balance, a record count the sending system reports separately, a batch header from the transmission.
A file whose debits equal its credits has proved internal consistency and nothing about completeness. If a transmission dropped 400 of 12,000 rows, the 11,600 that arrived still balance. Accept the file whole or reject it whole; a partial import is the one failure mode a reconciliation cannot detect afterwards, because everything downstream ties against the rows that arrived.
4. Match gross against gross
Pair transactions on both sides. Debits against debits, credits against credits, never a net position against a net position. Matching in strength order — exact reference, then amount and date, then amount within a date window — and recording which rule made each match, so that a match made by the loosest rule can be reviewed separately.
5. Classify what is left
Every unmatched item falls into one of three kinds, and they are not interchangeable:
| Kind | What it is | Resolution |
|---|---|---|
| Rounding | An arithmetic artifact of translation or allocation, with no underlying transaction | Closed by policy |
| Unmatched | Records exist on both sides and have not been tied | Matched, usually automatable |
| Unexplained | A real movement with no established cause | Investigated by a named person |
Only the third is an investigation. Reporting the three as one number is how a pack comes to describe an account as clean.
6. Investigate what is unexplained
An unexplained difference needs four things recorded before the reconciliation is complete: the amount, a named owner, what evidence would settle it, and a date by which it is expected. A cause is set by a person, with their name and the date against it. Nothing about the shape of a difference establishes what caused it — an amount that looks like a duplicate payment is not a duplicate payment until somebody has looked.
7. Review and record
Preparer and reviewer are different people, the reviewer's question is whether each reconciling item is supported rather than whether the sheet balances, and both names and dates are kept with the reconciliation. The reconciliation is the record; the balance is just its last line.
What a monthly reconciliation report should carry
- Account, entity, period end, currency, and the presentation scale that currency uses.
- Both balances and their sources, each with the date and system it came from.
- Reconciling items listed individually, each with its evidence reference.
- Residuals split by kind, not summed.
- Aged unexplained items, with owner and expected resolution date.
- Preparer, reviewer, and the dates they each signed.
Checks that catch a reconciliation that only looks finished
- Does any reconciling item appear in the same form as last month? If so it is a suspense balance with a reconciliation's clothes on.
- Do the gross debits and gross credits tie separately, or only in net?
- Does every item over the threshold name a document, rather than a category?
- Did the population arrive whole, evidenced from outside the file?
- Is anything closed as “immaterial” that is actually unexplained? Those are different statements and only one of them is a cause.
Common questions
- Who should perform and review an account reconciliation?
- Different people. The preparer assembles the comparison and the evidence; the reviewer tests whether each reconciling item is supported by something checkable. Both names and both dates belong on the record.
- How long should an unexplained difference stay open?
- As long as the investigation genuinely takes, provided it has a named owner, a stated evidence requirement and an expected date. What should not happen is that it is carried forward unchanged; an unexplained item that ages without any of those three has stopped being investigated.
- Can account reconciliation be automated?
- Matching can be, and largely should be — it is mechanical and it is where most of the volume sits. Classifying a residual and establishing a cause cannot be, because a cause is a claim about what happened in the business, and no amount of pattern matching over the numbers produces one.
About Valcenra
Valcenra decomposes a financial movement into drivers that tie to the underlying records, keeps rounding, unmatched and unexplained residuals apart rather than summing them, and refuses to state a conclusion it cannot support — naming the field it needs and the conclusion that field decides. It is read-only: it drafts and computes, and it does not post journals, move money or approve anything. Talk to us.