Skip to content

Import bank statements into Exact Online

Exact Online imports bank statements by hand from a standard bank file, most often MT940. Turn CAMT.053, CODA or OFX into MT940 after a balance check.

No file to hand? Try a sample statement

For an Exact Online bank statement import by hand, you upload a file from your bank in a standard format; Exact's knowledge base names MT940 as the most common. If your bank now gives CAMT.053, or you have a CODA or OFX file, Klarbon turns it into MT940 after checking the balances. Import one short statement first and compare the result with the original.

On this page 10

What does Exact say about manual import?

According to Exact's knowledge base (Import bank statements), checked on 21 November 2026:

Point According to Exact
File a statement from your bank in a standard format; the most common is MT940
Right Import bank statements
Condition a bank account in Exact Online, and a bank that supports manual import
Bank link deactivate an active automatic link first; some banks require this on their website, up to 24 hours
Historical transactions import them by hand before you set up the bank link
Financial year set up to cover the imported statements

The article names no other file formats and does not say which subscriptions it covers. Klarbon has not tested which formats your company accepts.

Which file should I make with Klarbon?

You have Make Cost on the site
MT940 from your bank nothing: import it directly
CAMT.053 convert CAMT.053 to MT940 one credit per started 500 transactions
CODA or OFX MT940 one credit per started 500 transactions

The preview and the balance check are free. Reading statement files is in beta. Klarbon reads a PDF statement or scan too: you see every row before paying, a download from it costs one credit per started 10 pages, and what Klarbon reads from a PDF is a draft to compare with the original.

How do I prepare the file?

  1. Drop the statement file on this page, or use convert CAMT.053 to MT940.
  2. Check the preview: period, number of transactions and the balance check. A statement whose opening balance plus transactions does not give the closing balance cannot be downloaded. See the balance check.
  3. Choose MT940. Klarbon then asks for the statement number.
  4. Download the file.

How do I import it into Exact Online?

According to Exact's knowledge base:

  1. Go to Financial, Banking & Cash, Statements, Import.
  2. If more than one bank account is linked to your company, select the bank the statement is from.
  3. Browse for the file to upload. If you have bank journals with the same account number but different currencies, choose the right journal.
  4. Click Import.

Then allocate and match the statement lines under Financial, Banking & Cash, Statements, To be completed.

How do I avoid duplicate entries?

Do not import a period the bank link has already delivered, and never import the same period from both the bank's file and a converted one. Exact advises checking for double entries if you imported statements before the new financial year was created. Whether Exact Online accepts a converted file is not guaranteed; compare the number of transactions and the balance after the first import.

Does Klarbon work with Exact?

No. Klarbon has no integration or partnership with Exact. It makes a file; you import it. Klarbon creates no archive of the statement or its transactions. A PDF is read for your request only, and the reading may take place outside the EU. See what happens to my files.

Next

Frequently asked questions

Which file do I use for an Exact Online bank statement import?

A statement file from your bank in a standard format. Exact's knowledge base names MT940 as the most common. The article names no other format, so test one short statement first if you want to use another file.

My bank only gives CAMT.053 now. What do I do?

Turn the CAMT.053 file into MT940 with Klarbon, after the balance check, and import it under Financial, Banking & Cash, Statements, Import. Test one short statement first.

Why can I not import by hand?

According to Exact, you need the Import bank statements right and a bank account in Exact Online. If an automatic bank link is active, deactivate it first; some banks require that on their website, which can take up to 24 hours.

Can I import an Excel or CSV file as a bank statement?

Exact's article does not describe that. Use a bank statement file such as MT940.

Is Klarbon an Exact partner?

No. Klarbon has no integration or partnership with Exact. It makes a file; you import it.

Sources

Updated 21 November 2026

Klarbon, https://klarbon.app/exact-bank-statement-import