Convert a CODA file to Excel and CSV
Beta This tool is in beta. It is tested on sample files, and details may still change. Review the result before relying on it.
Open a Belgian CODA bank statement file and download it as Excel or CSV for free. Klarbon reads each record, checks the balances, previews first.
In short
Turn a bank statement file or a PDF statement into Excel, CSV, CAMT.053, MT940 or OFX. Klarbon reads a PDF statement into a draft; check the result before you use it. CSV and Excel free from bank files, otherwise 1 credit (€1.99).
Klarbon opens a Belgian CODA bank statement file and converts it into Excel (XLSX) or CSV, free on the site. It reads the 128-character records by position, joins the movement records that belong together and checks the old balance plus the movements against the new balance. The trailer's own totals must agree as well. Reading is in beta. A PDF statement dropped here is read too.
Compare what Klarbon reads from a PDF with the original before you download.
How do I convert a CODA file to Excel?
- Get the .cod file. Belgian banks deliver CODA for business accounts, often straight to the accountant or the accounting software; ask your accountant or your bank if you do not have it.
- Drop it on the box above and confirm the century of the first date.
- Check the preview: account, period, old and new balance, and the movements.
- Download Excel or CSV. A file with several statements gives one file per statement.
Which records does a CODA file hold?
| Record | What it carries |
|---|---|
| 0 | header: creation date, bank, BIC |
| 1 | old balance: account (Belgian number or IBAN), currency, statement number, holder |
| 21 | a movement: amount and sign, value date, transaction code, start of the communication, entry date |
| 22 | more communication, the customer reference |
| 23 | the counterparty's account and name, the rest of the communication |
| 8 | new balance |
| 9 | trailer: number of records, total debits, total credits |
What does Klarbon make of a movement?
The amount with its sign becomes the amount. The entry date in record 21 becomes the booking date, and the value date is written when the bank filled it (a value of 000000 leaves it empty). The communication from records 21, 22 and 23 is joined into one description, in that order. The customer reference from record 22 is the reference, or the bank reference from record 21 when there is none. Record 23 gives the counterparty's name and, when it is an IBAN, the counterparty IBAN.
Klarbon then adds up the debits and credits and compares them with the trailer, and compares the old balance plus the movements with the new balance. A file where either disagrees is not written.
What does Klarbon not read yet?
CODA 2.6 has more than ordinary bookings. A file with information records (type 3), free messages (type 4) or globalised bookings with their details is refused whole rather than read in part. Klarbon accepts two departures it has seen in bank files, because they leave every amount clear: header fields that should hold zeros left blank, and a trailer that counts records 0 and 9 as well.
What does it cost?
Opening a CODA file is free up to 10 files a day without an account and 30 with one, and Excel and CSV from it are free. Writing it as CAMT.053 or MT940 for software that does not read CODA costs one credit per started 500 transactions. A PDF statement read here costs one credit per started 10 pages for any download, Excel and CSV included.
Related
Frequently asked questions
What is a CODA file?
The coded statement of account that Belgian banks deliver to businesses and their accountants, defined by Febelfin. It is plain text in fixed 128-character records, usually one statement per account and banking day, often with the extension .cod.
Why does Klarbon ask me to confirm a date?
CODA writes dates as day, month and two-digit year, so nothing in the file says 19 or 20. Klarbon shows the first date both ways and you choose once.
My CODA file has an old Belgian account number, not an IBAN. Does that work?
Yes. A 12-digit Belgian account number holds the same digits as its IBAN, so Klarbon works the IBAN out and marks it as derived in the preview. Check it against your bank before importing anything that relies on it.
Can Klarbon write CODA as well?
Yes, from a statement with an IBAN, at one credit per started 500 transactions. Free text is written in plain ASCII and cut to the CODA field lengths, and Klarbon lists every text it had to shorten. Excel and CSV from a CODA file are free.
Sources
Related
- Open any e-invoice. Check it. Convert it.
- Klarbon help centre
- What is CODA?
- Bank statement tools
- Supported bank statement files
- Why do my statement balances not match?
- Convert CAMT.053 to Excel and CSV
- Convert MT940 to Excel and CSV
- Convert CAMT.053 to MT940, or MT940 to CAMT.053
- Convert OFX to CSV and Excel
- Simple pricing for invoices and bank statements
- What happens to my files?
- E-invoice tools
- Belgium’s e-invoicing requirement since January 2026
- Understanding Bank CSV export
- Understanding Excel workbook (XLSX)
- Convert a CAMT.053, MT940 or OFX bank statement to Excel
- Convert a CAMT.053, MT940 or OFX bank statement to CSV
Also as an API: Bank statement API