Operations

Reconciliation without spreadsheets: closing the day in fifteen minutes

Provider registries are parsed automatically, discrepancies surface on the day of the transaction, and closing the day no longer depends on whether one accountant came in.

T+0

discrepancies visible the same day

700+

integrations with registry parsing

40+

currencies in one report

Why manual reconciliation breaks

Not because accountants count badly. Because there is more data than fits into a working day.

Registries arrive in different shapes

One provider emails a CSV, another drops a file on SFTP, a third only offers a dashboard export. Every format is its own, and every one of them changes without notice.

Discrepancies are found a week later

By then the transaction is closed, the money is paid out, and the provider replies that the claim window has expired. The cost of the error grows with every silent day.

The process rests on one person

The spreadsheet with the formulas lives on their laptop. While they are on holiday the day does not close — and that is not a hypothesis but a common cause of missed reporting.

How it works on the platform

The registry loads itself, matches automatically, and a person only looks at what did not reconcile.

Scheduled registry intake

The file is picked up from SFTP, from email or over the API, on the operator's schedule. Format parsing is configured once and survives the provider reordering its columns.

Matching on several keys

A transaction is looked up by identifier, amount, date and provider reference. If the keys do not line up, the row is not lost — it goes into review with the reason attached.

Only exceptions reach a human

Matched rows close with no one involved. Four cases remain: missing on our side, missing on the provider's side, amount mismatch, fee mismatch.

What changes for the finance team

Automated reconciliation does not replace the accountant — it changes what the accountant does. Instead of copying rows from a file into a spreadsheet, they work exceptions: why the provider withheld a fee above the contracted rate, why a refund went through twice, why a transaction exists on our side and not on theirs. That is work you cannot automate, and exactly where a person is irreplaceable.

The economics live in how fast you find things. A discrepancy found on the day of the transaction is discussed with the provider while it is fresh and is most often closed by their own correction. The same discrepancy found a month later becomes a claim, and a quarter later a write-off. The gap between those outcomes is what automated reconciliation is worth.

A separate benefit is a predictable period close. When reconciliation runs daily and leaves no tail, the monthly report is assembled from days that already balance rather than rebuilt from scratch. And the auditor gets a log rather than a spreadsheet: which file was loaded when, what was matched to what, who resolved each discrepancy and when.

How this is assembled in the operator dashboard

Two setup wizards. The operator goes through them alone — no development needed.

1. Connecting a registry to automated reconciliation

File source, intake schedule, format parsing, matching rules and how discrepancies are worked.

2. Recurring registry export to a recipient

The other direction: a scheduled report to a partner or to accounting, in an agreed format over a secure channel.

It is worth running the first pass on yesterday's registry: discrepancies show up immediately and the matching rules can be corrected before reconciliation goes on schedule.

Close the day without spreadsheets

Register and connect a registry to automated reconciliation yourself. Run the first pass on yesterday's data — the matching rules show up immediately.

Get started