What does Lexware Office need from the CSV file?
According to the Lexware Office Help Center (Lexware, in German), checked on 21 November 2026:
| Requirement | Detail |
|---|---|
| Required columns | date (booking or value date), counterparty, payment reference and amount (or separate debit and credit columns) |
| No empty required fields | a transaction with an empty required field is not imported |
| Date range | transactions from 1 January 2014 only |
| File size | up to 5 megabytes per file; split larger files |
| Only missing transactions | there is no duplicate check, and duplicates can only be hidden, not deleted |
Lexware Office usually detects the separator, character encoding and text qualifier itself. A header row is counted and reported as not imported; Lexware says this is not an error.
How do I prepare the file with Klarbon?
- Drop the statement file on this page or on convert a bank statement to CSV: CAMT.053, MT940 or OFX from your online banking, or another supported file such as CODA. CSV is the output here, not the input.
- Check the preview: period, number of transactions and the balance check. A statement that does not add up cannot be downloaded. See the balance check.
- Choose Lexware Office as your accounting software. Klarbon then writes a CSV with a semicolon as separator, a decimal comma, dates as DD.MM.YYYY and one signed amount column, negative for debits, with German column headings such as Buchungsdatum, Auftraggeber / Empfänger, Verwendungszweck and Betrag. If a transaction has no counterparty or payment reference, or is dated before 2014, Klarbon tells you instead of writing a file Lexware Office would partly skip.
- Download the file, free, and remove any transactions that are already in Lexware Office.
Reading statement files is in beta. A PDF statement or scan can be dropped on the same tool too: you see every row before paying, the CSV 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 import the file into Lexware Office?
According to the Lexware Office Help Center:
- Go to Finanzen, then Konten. If the account cannot be connected, create an account without a connection first.
- On the account, open the three-dot menu and choose Umsätze importieren.
- Drop the CSV file into the window and click Weiter.
- Check the import settings, then map each column: Datum, Auftraggeber / Empfänger, Verwendungszweck and Betrag are required.
- Click Umsätze importieren. If some transactions were not imported, download them before you close the window, fix them and import that file again.
How do I test before importing everything?
Lexware suggests a first import with a small file containing one positive and one negative amount, so you can see straight away whether income and expenses are recognised correctly. After the import, compare the number of transactions, the dates, the signs and the sum of the imported amounts with the original statement. The CSV import does not update the account balance Lexware Office shows; for an account without a connection it shows no balance at all. Klarbon writes debits as negative amounts, so the switch for files with negative income must stay off. Klarbon has not tested an import into every Lexware Office plan, so this first small import is your check.
If your bank's connection already delivers the period, import only the missing transactions.
Does Klarbon work with Lexware Office?
No. Klarbon has no integration or partnership with Lexware. 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 does Lexware Office import for bank transactions?
A CSV file. PDF statements, spreadsheet files (XLS, XLSX) and CAMT files cannot be imported directly. Turn a CAMT.053, MT940 or OFX statement into a CSV with Lexware Office's columns, then import it under Finanzen, Konten, Umsätze importieren.
Is the Lexware CSV free on Klarbon?
Yes, from a CAMT.053, MT940, OFX or other supported statement file. The preview and the balance check are free too.
Which columns does Lexware Office require?
A date (booking or value date), a counterparty (Auftraggeber or Empfänger), a payment reference (Verwendungszweck) and an amount, or separate debit and credit columns. None of these may be empty, or Lexware Office skips the transaction.
Does Lexware Office check for duplicates on CSV import?
No. Lexware Office creates existing transactions a second time, and duplicates cannot be deleted afterwards, only hidden. Make sure the file contains only the transactions that are missing.
Is Klarbon a Lexware partner?
No. Klarbon has no integration or partnership with Lexware. It makes a CSV file; you import it.
Sources
Related
- Open any e-invoice. Check it. Convert it.
- Klarbon help centre
- Convert a CAMT.053, MT940 or OFX bank statement to Excel
- Convert a CAMT.053, MT940 or OFX bank statement to CSV
- Convert a bank statement PDF to CAMT.053
- Convert a bank statement PDF to MT940
- Why do my statement balances not match?
- Import bank statements into DATEV
- Import bank statements into sevdesk
- Import bank statements into Moneybird
- Import bank statements into e-Boekhouden.nl
- Import bank statements into Exact Online