Home › Countries › Germany › 1822direkt › Statement to OFX
1822direkt is a bank based in Frankfurt, Germany. Its account statements are issued as PDFs through online and mobile banking. Upload the statement PDF below and download an OFX-formatted export of the statement's transactions — extracted, normalized and reconciled first.
This .ofx file carries the reconciled 1822direkt transactions in standard OFX structure — the format to choose when your software's import menu lists OFX, QFX or 'bank statement file' rather than CSV.
The main use is moving an account between finance applications without retyping. Statements from Germany banks print dates as day/month/year, often written day.month.year — 03.04.2026 means 3 April 2026 and amounts with points or spaces for thousands and a comma for decimals (1.234,56) — the converter's locale-aware reader handles that layout, and then the reconciliation check proves the result: the extracted transactions must add up to the balances printed on the statement itself, or the conversion is flagged.
Every 1822direkt conversion is audited by the document it came from. The extracted transactions are totalled against the printed opening and closing balances and checked row by row against the running balance column where one is printed. A conversion only reports as reconciled when both tests agree to the cent — and when they do, the figures have been proven against the bank's own document, not merely read from it.
A 1822direkt statement's layout decides how differences behave. In a chronological layout with a running balance, a single dropped row shifts every later balance, which makes it easy to spot. In a sectioned layout — deposits, then withdrawals, then fees — compare section totals first. Knowing which layout you hold tells you where to look before the marked rows even load.
In Germany, bookkeepers commonly work in DATEV, lexoffice and sevDesk; the Excel and CSV exports from this converter are the files those tools import, and the CSV export is laid out for direct import where the tool accepts it.
Ask clients for the issued PDFs rather than portal screenshots or spreadsheet exports. The PDF is the only version that carries the balances the check needs, and a folder of monthly PDFs plus their conversion results is an audit trail that assembles itself.
Import the OFX file into a copy or a test account first if your software allows it: OFX imports typically cannot be undone in bulk, and a thirty-second trial shows whether the date range and account mapping are right before the real ledger takes the file.
These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.
Tip: keep the downloaded PDFs in a folder named by account and month. A tidy folder makes batch conversion and later review almost mechanical.
Get the PDF from 1822direkt's statements area, upload it here, and download the converted an OFX-formatted export of the statement's transactions. The converter reads the transactions, standardizes the columns and verifies the totals against the statement before the file is ready.
Expect day/month/year, often written day.month.year — 03.04.2026 means 3 April 2026 dates and amounts with points or spaces for thousands and a comma for decimals (1.234,56) on a 1822direkt statement. The reader is locale-aware, so those conventions are handled rather than misread, and the output columns come out in the standard layout regardless.
Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.
Convert them separately and import only one version of the overlap. Banks occasionally reissue a corrected statement for a period; the later issue supersedes the earlier, and importing both would double the shared days.
Yes. Download each month as its own PDF and upload them together — batch mode converts them in one run and, in Excel, adds a combined sheet. Each statement is still reconciled separately, because balances are per statement.
Yes. Credit-card statements use a Previous Balance / New Balance layout, which the converter reads as well; purchases are positive and payments are negative, and the same totals check applies.
Date, Description, Amount, Debit, Credit and Balance — the same normalized columns for every bank, so a 1822direkt file and a file from any other bank in Germany can be imported and reviewed the same way.
The conversion is flagged, and the rows whose running balance disagrees with the statement are marked with the expected and printed figures. Nothing is silently adjusted — you see exactly where the statement and the extraction part company.
No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.
Convert the same 1822direkt statement PDF to Excel instead.
Convert the same 1822direkt statement PDF to CSV instead.
Back to the 1822direkt statement converter hub or the Germany bank directory. Other Germany banks: Deutsche Bank statement to OFX · Commerzbank statement to OFX · DZ Bank statement to OFX · ING Deutschland statement to OFX
Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.