Bank and reconciliation
Import bank statements, let reference numbers settle invoices, review the rest in suspense, and see how exchange rates are applied.
In Tosven a bank statement line is a ledger entry from the moment it is imported. Money that has not been matched yet is visible in the trial balance, on a suspense account, until a person decides what it is. This page covers importing statements, matching payments and the exchange rates used for foreign currency.
Bank accounts and suspense
You add a bank account before the first statement. Tosven checks the IBAN, links the bank account to its ledger account and to a suspense account, and requires the account currency to be the company's base currency.
Every imported line is posted between the bank account and the suspense account. The bank account in the ledger therefore mirrors the statement exactly, and the suspense balance equals the money still waiting for a decision. The two figures come from the same lines and cannot drift apart.
On the way
A live bank feed in place of imported files, and bank accounts held in a foreign currency, are not available yet.
Importing a statement
Tosven reads four file types. Live in the pilot
| Format | How it lands | Proof |
|---|---|---|
| camt.053 (XML) | Directly | Opening balance plus lines equals closing balance |
| Excel | After your preview | Balance or totals stated in the file |
| PDF with a text layer | After your preview | Balance or totals stated in the file |
| CSV | After your preview | Balance column if it chains, otherwise your confirmation |
Reading is rule based. There is no AI and no OCR on bank data, so the same file always reads the same way, and a scanned PDF is refused with advice on what to download from your bank instead.
Drop the file
A camt.053 statement lands at once. For other formats Tosven shows a preview: the account, the proof, and each row marked as new or already in the ledger.
Map columns if asked
A CSV or Excel layout that Tosven does not recognise goes to column mapping. You point out the date, amount, counterparty, reference and message columns.
Write to the ledger
You confirm the preview. A file with no balance and no totals needs you to confirm the row count and the net sum first.
A failed proof refuses the whole file. Half a statement never lands. The original file is stored unchanged next to its entries and can be downloaded again.
The same payment is never booked twice. Tosven recognises rows it already holds, so the same month imported as PDF and as Excel, or as camt.053 and as CSV, lands once in either order. A gap between two statements is flagged and shown. It does not block the new file.
Matching payments
Matching adds entries. It never rewrites the statement line.
- Automatic. A payment that carries a structured reference number with a valid check digit, pointing at exactly one open sales invoice, settles that invoice. A smaller amount settles it in part. A larger amount closes the invoice and leaves the excess visible in suspense.
- Proposed. A reference found in free text, or a match by amount, date and payer name, is only a proposal with a confidence. A person accepts or rejects it.
- Never. There is no tolerance and no silent write-off of small differences. A small remainder is proposed as an explicit write-off for a person to approve.
When the morning statement of 13.10.2026 holds 48.000,00 € from Nordlys AB with the right reference, INV-2026-0418 is settled as PAY-2026-0391 without anyone touching it. A line of 3.765,00 € without a reference waits in suspense, with Harju Tekniikka Oy proposed by amount and payer name.
On the way
A matching screen that lists each open incoming line with ranked candidates, and lets you pick an invoice by hand, is built and being released. Splitting one line across several invoices and matching outgoing lines come later.
The clearing report
The clearing report lists every line still in suspense in exactly one of three groups: done, in review, or open. It shows how long each amount has waited and flags gaps between statements on the same screen.
Money left in suspense at the end of a VAT period appears as a warning in the pre-checks of the return. See VAT and periods.
Exchange rates
Tosven fetches the euro reference rates of the European Central Bank by itself on each publication day. No rate is typed by hand. Live in the pilot
- One rate per document. A foreign currency invoice freezes one rate when it is posted. The rate date and the document date are both stored.
- Days without a rate. On a weekend or a holiday the latest published rate applies. If a publication day in between is missing from the feed, posting stops and names the missing day.
- Settlement. When the payment is matched, the realised exchange difference is booked in the same step. If the match is undone, the difference is reversed with it.
- Year end. Open foreign balances are revalued at the closing rate before the year can close.
Rates are kept today for SEK, DKK, TRY and USD against the euro.
Command shows how current the rates and statements are. A stale source is marked on the figure. See Command.
Next steps
- Invoices and payments: the reference number on a sales invoice and what settlement does to it.
- Ledger: why matching adds entries and never edits them.
- VAT and periods: suspense and the VAT return pre-checks.