Feature
Bank Statement Reconciliation
Upload a statement, see what's paid, and spot what's missing. Reconciliation shouldn't be a spreadsheet project.
- → Upload CSV, Excel, or PDF — Clerko parses the header and transaction rows even when the export isn't clean.
- → See paid vs unpaid at a glance — match outgoing payments to invoices and get a clear reconciled / unreconciled picture.
- → You confirm every match — Clerko suggests likely matches and flags gaps. Final decisions stay with you.
4 transactions · January 2026
From statement export to reconciled period
Start with a statement export. End with a clean view of what's reconciled and what needs follow‑up.
Upload a statement
Import CSV, Excel, or PDF statements for the period you're closing. No reformatting required.
Parse header + transactions
Clerko extracts statement metadata and a flat list of transactions—dates, amounts, directions, descriptions.
Enrich where possible
When the description allows it, Clerko adds a short label and counterparty name to make transaction lists readable.
Match payments to invoices
Clerko identifies likely matches and flags what's missing. You confirm what's reconciled—not the other way around.
What gets extracted
Clerko extracts a usable statement header and transaction rows. If something is missing or unclear, it stays empty instead of being guessed.
When a payment is matched, Clerko can store an optional link to the invoice and keep structured reconciliation logs for transparency.
- Bank + account name, account label
- Account identifiers account/IBAN when present
- Period start + end
- Balances opening + closing
- Currency statement currency
- Dates booking + value date
- Direction debit / credit
- Amount amount + currency
- Description description + reference
- Optional enrichment counterparty + short label
Reconciliation FAQ
What file formats do you support?
CSV, Excel, and PDF bank statements.
What if my statement descriptions are messy?
Clerko extracts core fields first. Enrichment (short label / counterparty) is added when the description allows it.
How does matching work?
Clerko suggests likely matches (based on amounts, timing, and text cues) and helps you review what's reconciled.
What stays manual?
Final decisions on ambiguous matches—especially when amounts are split or descriptions are generic.
Does reconciliation use credits?
Yes—creating a bank statement record uses credits. Invoice processing also uses credits.
Want to reconcile your next statement in minutes?
Sign up and upload a statement export for the period you're closing. You'll see transactions and a clear match status.