From statement to entry
Bank reconciliation that closes at the line, not at the balance.
One statement line, one ledger entry, and the record that says why the two belong together. Tresora runs that match continuously across every account in the group, and where the two sides disagree it says what the difference is made of.
Closing balance
EUR 4,812,400.00
ES•• •••• •••• 4471 · Aug 14
- Opening balance
- EUR 4,582,640.00
- Credited
- EUR +631,940.00
- Debited
- EUR -402,180.00
- Matched to the ledger
- 92
- Waiting for a person
- 4
Lines on the statement96
Four agreements
What has to agree before a bank balance can be trusted?
Four things, in this order. Each one is checked on its own, because a balance that agrees while the lines underneath it do not is a coincidence you cannot repeat next month.
- 01The statement agrees with itself.
- Opening balance, plus what came in, minus what went out, is the closing balance — on every account, every day, with no day missing from the series. This is the link nobody checks by hand, and it decides whether anything after it was worth doing.
- 02Every statement line finds its ledger entry.
- The line, not the balance. One receipt can settle nine invoices and a whole payment run can leave as a single debit, so the match is many to many and it carries the records on both sides.
- 03The ledger balance agrees with the bank balance.
- And where it does not, the gap is a list of named items with a record behind each one, rather than a number somebody has to go away and explain.
- 04What a processor settled agrees with what the bank received.
- Card, wallet and marketplace money arrives net. Gross sales, minus the fee, minus what was charged back, is the credit on the statement — and until those three have names the credit reconciles against nothing.
A reconciliation is worth what its weakest link is worth. Three of the four is a balance that agrees for a reason nobody wrote down.
Both sides
What does it read from the bank, and what from your books?
Whatever each side already produces. No new file, no new field, and no report written for us.
From the bank
- MT940 and MT942 — end of day and intraday
- CAMT.053, CAMT.052 and CAMT.054 — ISO 20022
- BAI2, for North American accounts
- CSB43, for Spanish accounts
- And the fields underneath: value date, booking date, the counterparty reference and whatever free text your bank puts in its own detail lines
From your books
- Journal entries and general ledger lines
- Supplier and customer line items, open and cleared
- Clearing documents — what a bank movement actually settles
- Your own chart of accounts, exactly as it is
- SAP, Oracle, Business Central and whatever else the group runs
One ordinary day, across the group
- Statement lines read
- 1,284
- One business day, every entity.
- Accounts they came from
- 47
- Each one closed and footed on its own.
- Waiting for a person
- 33
- The only lines anyone has to open.
- What those lines are worth
- EUR 318,400.00
- In one queue, each with the reason it is there.
Reconciliation is not a job that starts when the month ends. Files land, lines are matched against what your books already hold, and by the time anyone looks the exceptions are a short queue rather than a search.
The difference, taken apart
The bank and the ledger disagree. Where exactly is the difference?
In four places, on this account, on this day. Each one carries the record that produced it, and two of them close on their own with tomorrow’s statement.
- Bank statement
- EUR 4,812,400.00
- General ledger
- EUR 4,796,150.00
- Difference
- EUR 16,250.00
What it is made of
| Receipts credited by the bank, not yet posted Clears itself | Clears itself | EUR +21,480.00 |
|---|---|---|
| Payments posted in the ledger, not yet debited Clears itself | Clears itself | EUR +7,140.00 |
| A card settlement received net, posted gross Needs an entry | Needs an entry | EUR -15,130.00 |
| One supplier payment posted twice Needs an entry | Needs an entry | EUR +2,760.00 |
Left unexplainedEUR 0.00
Two of those close themselves: tomorrow’s statement carries the receipts and the payments, and the difference shrinks with nobody doing anything. The other two are work — a fee and a chargeback to post, and a duplicate to reverse — and each one arrives with the records that prove it.
Who decides
The ledger side
Which side gets corrected — and who decides?
The statement is the outside record: it is what the bank did, and it is not ours to change. The ledger is the side a correction lands on, so a correction arrives as an entry with both documents attached to it.
- It runs every day, not at close.
- A difference found on the fourteenth is a five-minute conversation. The same difference found on the second of the following month is an investigation, and it is the reason close cycles run on heroics.
- It reads the ledger as documents, not as a balance.
- A bank movement settles a clearing document, which settles invoices, which sit against a customer or a supplier. Following that chain is what lets one receipt close nine open items instead of landing as an unexplained credit.
- It checks where a line was posted, not only that it was.
- An entry in the wrong account still balances, so a balance comparison will never find it. Tresora checks the account a line was posted to against what the movement behind it actually was, and raises the ones that disagree.
Nobody has to touch their books to make our figures agree with yours. The correction is one entry, and it is the same entry your own team would have written the moment they found the second document.
Same payment, two documents
- 1500042318 · KZ · Aug 12EUR 2,760.00Cleared by a bank line
- 1500042407 · KZ · Aug 13EUR 2,760.00Clears nothing
Why they are one payment
- Same supplier, same amount, same bank reference
- One debit on the statement, not two
- The second document leaves no open item behind it
Drafted for approval
Reverse document 1500042407Awaiting your approval
Card and marketplace money
Card settlements arrive net. How do they ever reconcile?
By reconstructing the deduction. A day of card sales reaches the bank as a single credit, and the provider’s own report says what came off it on the way.
Credited to the account
EUR 397,470.00
Aug 14 · ACQ SETTLE 20260814
- Card sales in the batch
- EUR 1,842
- Gross sales
- EUR 412,600.00
- Acquirer fee
- EUR -11,890.00
- Chargebacks and refunds
- EUR -3,240.00
Settled netEUR 397,470.00
The credit on the statement appears nowhere in the sales it came from, which is why a settlement can never be reconciled at the balance. Tresora reads the provider’s report, takes off what the provider took, and matches the result against the line the bank actually posted.
Every provider settles on its own calendar and takes its cut its own way. Acquirers, wallets and marketplaces all land in the same reconciliation, per provider and per settlement date, and a partial settlement stays open until the rest of it arrives.
The fee and the chargebacks are the same deduction the balance analysis named a section ago. One settlement, read from both ends, and the two readings agree.
What comes back
What do you get back, and who actually reads it?
A balance you can defend, the short list of what is not settled, and a trail behind every decision that got you there.
- A reconciled balance per account, per day.
- With the difference named where there is one. Not a status light and not a percentage — the items, and the records behind them.
- A queue, not a search.
- Only the lines that need a person, each carrying the reason it is there and the explanations the engine already ruled out.
- A trail your auditor can follow.
- Every match keeps the records that produced it and the explanations it rejected, with the score each one carried. A case reopens by itself when a later file changes the evidence.
- The same figure everywhere it appears.
- The reconciled balance is what the cash position, the cash flow statement and the intercompany screens read from. There is no second number for two teams to argue about.
Who reads it
Built on it
The questions we get
What treasury and accounting teams ask before they move.
- 01How is this different from the reconciliation our ERP already runs?
- An ERP reconciles against the balance it was given. Tresora reads the bank’s own file, matches at the statement line, and keeps the records on both sides — so when the two balances disagree the answer is a list of named items rather than an instruction to go and look.
- 02Which bank formats does it reconcile from?
- MT940, MT942, CAMT.053, CAMT.052, CAMT.054, BAI2 and CSB43, plus whatever a connector or a portal export produces. If one of your banks sends something that is not on that list, we add it, and we keep every column it carried.
- 03Can it reconcile card and marketplace settlements against the bank?
- Yes. Gross sales, the provider’s fee, chargebacks and refunds are reconstructed until the net equals the credit on the statement, per provider and per settlement date.
- 04Does it decide which differences matter?
- No. You set the threshold and the routing, and a difference either breaks the threshold you set or it does not. What Tresora decides is what a difference is made of, and it shows the working.
- 05What does an auditor get?
- A trail your auditor can follow: every matched pair with the records on both sides, the explanations that were rejected and why, who approved each correction, and an export of all of it.
Bring one account and one month.
A month of statements for a single account and the ledger extract that should agree with them. We will run the reconciliation on your own figures and show you the differences with their names on.
The lines that do not reconcile come with the records behind each one. Nothing is posted to your books that you have not approved.