Bank connections

Where the transactions on the Bank page come from. Interface in Dutch, like the rest of finance.

Bank accounts

Register your accounts by IBAN and name, and map each to a ledger account (grootboek). The mapping is what lets a transaction be booked rather than just listed.

Two ways to get transactions

Automatisch koppelen (open banking) links an account through GoCardless and pulls transactions automatically. Choose your bank and complete the authorisation with them. This needs the instance to be configured with GoCardless API credentials — the page names the settings (KANCIL_GOCARDLESS_SECRET_ID / KEY) so you can tell "not configured" from "not working".

Afschrift importeren — import a statement — takes a file:

• CAMT.053, the ISO 20022 bank statement format, which every European bank can export. Prefer it: it carries structured counterparty and reference data.
• CSV, for when CAMT is not available. Fields vary by bank, so expect to do more classification by hand.

Which to use

Open banking is less work per month and keeps the Bank worklist current without you remembering to do anything. Its costs are a third-party dependency and an authorisation that expires and needs renewing.

Statement import has no dependencies and no expiry, at the price of a monthly download-and-upload. For a small business closing its books once a month, that is a perfectly reasonable trade.

Both land in the same worklist, and you can mix them — open banking on the account with the volume, imports for the one that rarely moves.

Duplicates

Importing the same statement twice is the obvious hazard. Import a period once, and if you are unsure whether a file has already been loaded, check the existing transactions for that date range before importing rather than after.