Commerzbank Statement to Excel Converter

A Commerzbank Kontoauszug gives the account holder, IBAN, statement number and period, and the old balance, then the bookings: booking date, value date, the transaction type — SEPA-Überweisung, SEPA-Lastschrift, Kartenzahlung, Entgelt — with counterparty, IBAN and Verwendungszweck, and the amount. The new balance closes it.

FlowParse writes one row per booking with both dates, the full text and a signed amount in EUR. The statement number and period travel with every row, so a booking in the converted sheet can always be found on the right Auszug.

German Steuerberater work mostly in DATEV; freelancers and small companies commonly use Lexware, lexoffice or sevDesk. FlowParse exports a CSV with dates, text and signed amount, a DATEV-ready layout, and an Excel file for review first.

Because the full Verwendungszweck and Mandatsreferenz are kept, each booking can be matched to its invoice after import — the same as with a live bank feed, but for the periods the feed no longer covers.

A Kontoauszug from the Postfach carries real text and converts exactly. An old paper statement can be scanned and converted through OCR; scan it flat, one statement per file, so the proof can run from old to new balance.

If you have both a CSV export and the statements for the same months, convert the statements: they are the document of record and carry the balances that make the proof possible.

German formats: 1.234,56 is text in an English-locale spreadsheet, and 03.04. is the 3rd of April, not March 4th. FlowParse writes real numbers and unambiguous dates. Multi-line bookings: a SEPA-Lastschrift with Gläubiger-ID, Mandatsreferenz and Verwendungszweck takes several lines and becomes several rows when pasted. FlowParse keeps one booking per row.

And mixing sources: a CSV for the last year and typed rows from PDFs for the years before rarely line up. Converting all of them from the statements gives one consistent column layout.

A Steuerberater's client faces a tax audit covering three years. The auditor asks for all bank movements of the business account. The client's CSV export reaches back only twelve months; the earlier statements are in the Postfach as PDFs. The figures here are an illustration, not a real client's.

All three years of statements are uploaded and come back as one workbook in date order. Each statement is proved against its balances, and the chain from first to last has no break, so the Steuerberater can confirm completeness before handing it over. The DATEV import of the earlier years lines up with the booked figures, and the two bookings the auditor asks about are found in under a minute.

Use statements, not overviews, for anything official — Commerzbank itself says the two are not the same. Check the chain: each new balance equal to the next old balance. Check that every statement is marked reconciled before using totals.

And keep the PDFs: the converted file is a working copy, the Kontoauszug is the document of record — for a business, for ten years.

Kontoauszüge for current, business and savings accounts convert and are proved against their balances. Credit card statements convert as purchases and settlement against the previous and new balance. A PDF export of Umsätze converts as a list, but without the statement's balances there is less to prove.

Account settlements, securities statements and tax certificates summarise rather than list movements. Keep them; convert the Kontoauszüge.

Commerzbank's export lets you tick individual Umsätze and export only those — practical for sending an accountant three payments, risky as evidence. A selection is by definition incomplete, and once it is a CSV nothing shows what was left out.

A Kontoauszug works the other way round. It contains every booking between two printed balances, and FlowParse proves that the converted rows add up to exactly those balances. If you need to show someone a few bookings, filter the converted statement — the reconciled whole stays behind it, and anyone who doubts the selection can be shown the full, proved statement it came from.

For anyone receiving Commerzbank data from a third party — a landlord, a lender, an auditor — that is the question to ask: is this a selection from the Umsätze, or the statements themselves? Ask for the statements, convert them, and the proof answers the completeness question for you.

When statements are missing from the Postfach — deleted, never downloaded, or from before you used Online Banking — Commerzbank's help says you can reorder them by placing an order in Online Banking. Decide first which months you actually need: the chain check in Smart Merge will tell you exactly where the gaps are once you upload what you already have.

Upload the statements you hold, look at the breaks the merge reports, and reorder only those periods. When the reordered statements arrive, add them to the same batch; the chain closes, and the year is complete and proved.

The same approach works for a closed account or an estate: list what you hold, let the chain show what is missing, and request only the missing statements. It saves fees, time, and a second round of questions from whoever asked for the documents in the first place — a Finanzamt, a court, an heir or a buyer's due-diligence team.