Rabobank Statement to Excel Converter

The most useful thing on a Dutch statement for bookkeeping is the tegenrekening: the counterparty's IBAN identifies the supplier or customer far more reliably than a name typed differently each time. Copied from a PDF by hand, the IBAN, the name and the omschrijving end up in one blob of text that has to be split again before anything can be matched.

FlowParse keeps the counterparty's IBAN and name in the description in a consistent order, so a filter on an IBAN finds every payment to that supplier across a year of statements, and a bookkeeping program's matching rules can recognise them.

Dutch boekhouders mostly work in Exact Online, Twinfield, Moneybird, SnelStart or e-Boekhouden. For periods Rabobank's download covers, its own camt.053 is the direct route. For PDF statements, FlowParse produces a CSV with date, omschrijving and signed amount for the bank import, and an Excel file for checking first.

Companies reporting to a foreign parent can take the same statement to QuickBooks (as a .QBO bank-feed file), Xero, DATEV or Sage.

The cleanest input is the statement as Rabobank produces it in Rabo Online Bankieren — the overzicht betaalrekening or the zakelijk rekeningafschrift as a PDF. A downloaded PDF carries real text, so FlowParse reads every amount exactly as printed, with no OCR step in between. A scanned paper statement still works, but each scan is a chance for a digit to be misread.

Upload each statement as a whole file, so the beginsaldo on the first page and the eindsaldo on the last can prove everything in between. For several accounts or years, upload everything together: Smart Merge sorts by date, keeps accounts apart, and writes the source file on every row.

The tegenrekening, the name and the omschrijving are the first problem: copied by hand they become one long string, or split across rows, and the IBAN — the most reliable way to recognise a supplier — gets lost in the noise. FlowParse keeps them together in a consistent order in one cell per transaction.

Direction is the second. Bij and af are marked rather than printed with a minus sign, so a careless copy turns spending into income; FlowParse reads the marker. The third is mixing sources: a recent period from Rabobank's own CSV and an older one from PDF statements need to meet exactly. The balance check between consecutive statements in a merged workbook shows whether they do, and a missing month shows up as a break.

A family farm banks with Rabobank: a business account for the farm, a savings account, and a private account. The boekhouder needs the business account's full year and finds part of it only as PDF statements. These figures are an illustration, not a real customer's.

The farm uploads the PDFs to FlowParse. Each statement is proved against its beginsaldo and eindsaldo, and Smart Merge joins them into one sheet with every transaction, the transaction type, and the tegenrekening in the description. The boekhouder filters by the IBANs of the feed supplier, the dairy buyer and the contractor to check the year's big flows, then imports the CSV into the bookkeeping program as a bank file. Where Rabobank's own camt.053 covers the latest months, those are imported directly, and the two parts meet on the saldo.

Before you send converted Rabobank statements on, check four things. Coverage: every account and month, with each eindsaldo matching the next beginsaldo; Smart Merge flags any gap. Sources: if recent months come from Rabobank's own CSV or camt.053 and older months from PDFs, check that the two meet on the saldo of the first overlapping day.

The reconciled mark: each statement in the export should be proved against its own beginsaldo and eindsaldo. And keep the originals: the PDF from Rabobank is the document of record for a lender or an audit, the converted file is the one you sort, filter and import. Sending both saves a round of questions.

The overzicht betaalrekening and the zakelijk rekeningafschrift are the main ones: transactions between a beginsaldo and an eindsaldo, which FlowParse turns into rows and proves. Savings statements share that shape and convert the same way, and so does a creditcard overview, which becomes its own list of purchases with the payment that settles it.

Year overviews (jaaroverzichten) summarise balances and interest for the tax return rather than listing movements; they are a check on the year's statements, not a replacement for them. Keep them alongside the export. For a farm or business with loans at Rabobank, loan statements list interest and repayments; those convert too, as their own sheet, so the repayment booked on the business account can be matched to the loan statement line.

If a business moves its day-to-day banking from Rabobank to another Dutch bank, or opens a second account at ABN AMRO or ING, convert the last statements of one and the first of the other together. Smart Merge shows both balances side by side, so the transfer between the accounts is booked once, not twice.