01 · The two sides
What is being compared
Two systems, or four. A ledger against a statement, or an invoice against a PO against a receipt against a contract.
Reconciliation & Audit
An invoice against a purchase order against a receipt against a contract price. A claim against point-of-sale against inventory against an agreement. DataTwin reconciles N-way at whatever grain the question needs, with tolerance rules and fuzzy matching where identifiers disagree across systems, and every match carries the document that supports it. The result is auditable rather than asserted, which matters more than the match rate the moment somebody challenges it.
Any two sides, one exception register
Any two sides, matched N-way
Live process
Whatever the two sides are
DataTwin
Matches N-way, then names what did not match
One exception register
Why this matters A reconciliation that produces a number is half a reconciliation. The half that matters is the list of differences, each with a reason, an age and somebody’s name against it.
Read-only to start — nothing changes in your ledgers or your source systems. Every stage runs on the same engine that powers the DARP Framework and FSCP: acquire, process, govern, report.
The engine
Bank against book and invoice against receipt feel like different jobs. They are the same seven decisions with different sources, which is why they run on one engine rather than on a tool for each and a spreadsheet for the rest.
01 · The two sides
Two systems, or four. A ledger against a statement, or an invoice against a PO against a receipt against a contract.
02 · The grain
Line, header, batch or balance. Most failed reconciliations are two sides compared at different grains.
03 · The key
A reference, or an amount and a date, or a name that is spelled differently in each system.
04 · The tolerance
Rounding, exchange rates and fees mean exact equality is often the wrong test.
05 · The timing
Cut-off, settlement cycles and in-transit items make a real difference look like an error.
06 · The reason
A difference without a reason is a to-do. A difference with a reason is either resolved or accepted.
07 · The sign-off
Preparer, reviewer, date. A reconciliation nobody owns is not a control, whatever the match rate.
The outcome
Seven answers turn a matching exercise into a control, on the engine every DataTwin product runs on.
The reconciliation
Part 1
Reconciliation projects rarely fail at matching. They fail earlier, because one side is a PDF, the other is an export nobody can schedule, and the identifier that should join them was truncated by a system in between.
Whatever shape it arrives in
Direct connections, scheduled extracts, portal downloads, statements and scanned documents all land in the same pipeline.
Normalised
Dates, currencies, entity codes and identifiers brought to one form so two sides can be compared without a manual clean-up first.
At the right grain
Two sides compared at the level the question needs. Comparing a line-level source to a header-level one is why reconciliations never close.
Part 2
One receipt settles seven invoices. One bank credit covers three gateway batches. One invoice spans two purchase orders. Any tool can match a reference to a reference; the work is in everything that is not that.
One to many, many to many
Split settlements, batch payments and part-deliveries resolved into the set of records they actually cover.
Tolerance
Rounding, bank charges, exchange differences and agreed variances treated as tolerances rather than exceptions, with the rule visible.
Fuzzy, where it has to be
Where identifiers differ across systems, matching uses names, amounts and dates together, and records why each match was made.
Part 3
A reconciliation that ends with a number and a pile of unmatched items has moved the work rather than done it. Each difference needs a reason, an owner and an age, or it will be the same difference next month.
A reason on every line
Differences classified into timing, error, omission, dispute and unidentified, so the list can be worked by cause instead of read top to bottom.
Aged
Every open difference carries its age, so a two-day item and a two-year item are never presented as the same problem.
Owned
Each break is assigned, worked and closed with a note, so the reconciliation is a live control rather than a monthly report.
Part 4
Sampling exists because testing everything by hand is impossible. Once every transaction has already been tested and the evidence is attached to it, the argument for a sample is weaker, and the conversation with your auditor gets shorter.
Full population
Testing everything reports a rate rather than a handful of findings, which is a different and more useful conversation with a board.
Evidence attached
The document that supports a match is held against the match, so testing is a read rather than a document request.
Continuous, not periodic
Reconciliations and control checks run on a schedule rather than at period end, so a failure is found in the week it happens.
In practice
This is not a fixed list of supported reconciliations. It is the set we see most often. A new one is a new configuration of the seven questions above, not a new product.
If you can describe the two sides, the grain and what counts as a difference, it can be configured. That is the whole argument for one engine rather than a tool per reconciliation: the eleventh one costs what the first one cost, and no less, but it does not wait for a release.
Prevent
Prevent is not a second build. The reconciliations that found your history are the reconciliations that run every night. That is where a one-off clean-up starts compounding.
The two sides, the grain, the key and the tolerance agreed once, per reconciliation.
Nightly or intraday, so a break is days old rather than a month old.
Every difference given a reason and an owner as it appears.
Age and value drive escalation, rather than somebody remembering at close.
Preparer and reviewer recorded against the period, with the evidence attached.
What changes
Not a longer list of features. A different distribution of who does what, and when a difference is found.
How reconciliation runs today
At period end, on the days there is least time for it
How it runs on DataTwin
On a schedule, so a break is found in the week it happens
How reconciliation runs today
Two, because that is what the tool does
How it runs on DataTwin
As many as the question needs, at the grain it needs
How reconciliation runs today
Left unmatched, or forced through so the total agrees
How it runs on DataTwin
Many-to-many resolved, with tolerance and fuzzy matching recorded
How reconciliation runs today
A pile that gets carried forward
How it runs on DataTwin
Classified by reason, aged, owned and escalated
How reconciliation runs today
Found again each time somebody asks
How it runs on DataTwin
Attached to the match when the match was made
How reconciliation runs today
A new spreadsheet, and a person who now maintains it
How it runs on DataTwin
A new configuration of the same seven questions
How reconciliation runs today
A sample, tested after the event
How it runs on DataTwin
Full population, tested as it happens
Start here
Everything above is prevention; it stops the next month breaking. It does nothing about the differences already sitting in your ledgers, some of them for years. So we start there, read-only, before there is anything to sign.
2min
This is how long it takes to understand how much can be recovered.
Send us the two sides of whichever reconciliation worries you most. We test the full transaction population, not a sample, and come back with what is recoverable and what is merely unexplained, split by heading. Before any contract.
Receipts never applied, credits never taken, claims never raised, balances owed and never chased.
Duplicate and over-payments, charges above the agreed rate, deductions never netted.
Control accounts that stopped agreeing, one-sided intercompany, accruals never reversed.
Why the first three keep happening: recs nobody owns, breaks nobody ages, sign-off nobody records.
The same engine reconciles for manufacturing, distribution, retail, logistics, pharma, financial services and multi-entity groups. If you can describe the two sides, it can be configured.