How to use Bank Statements Import

This guide walks through a full statement import, from one-time setup to reconciling transactions.

Step 1 — Configure a bank account (once)

1. Open Statements Import → Bank Accounts.
2. Click Add Bank Account.
3. Choose the NIZU payment method that represents this bank account.
4. Enter the account IBAN and, optionally, the bank name, currency and a default map template.
5. Save.

The IBAN lets the app confirm an uploaded file really belongs to this account, and every reconciled payment is booked under this payment method.

Step 2 — Build a map template (once per bank)

1. Open Statements Import → Map Templates → Build a template.
2. Give the template a name (e.g. "KBC CSV export").
3. Choose the format (CSV, TSV, XLSX), delimiter, encoding, date format, decimal separator, and whether the file has a header row.
4. Upload a sample statement and click Load Sample.
5. A preview of the first rows appears. For each NIZU field (date, amount, communication, counterparty…) pick the matching column from your file.
6. Save. You will reuse this template for every future statement from this bank.

Step 3 — Run an import

1. Open Statements Import → Imports → New Import.
2. Select the bank account; the app pre-selects that account's default template (change it if needed).
3. Upload the statement file and click Run Import.

The app parses the file, skips any lines already imported, and matches money-in transactions to open invoices. You land on the review screen.

Step 4 — Review and reconcile

The review screen lists every transaction with its status:

• Suggested — the engine found a likely invoice; it shows the invoice number and a confidence score.
• Unmatched — no confident match; you can match it manually.
• Reconciled — a payment has been created.

For each money-in line you can:

• Click the green check to reconcile using the suggested invoice.
• Click the search icon to match manually — search any open invoice by number or client name and confirm.
• Click ignore for internal transfers, fees or noise.
• Click reverse on a reconciled line to undo it (the created payment is removed and the invoice status refreshed).

Optional — auto-confirm high-confidence matches

In Statements Import → Settings you can set an auto-confirm threshold. Suggestions at or above that confidence are reconciled automatically during import. Leave it at 0 to always review by hand.

Optional — AI reconciliation

For incoming lines that stay Unmatched, an AI model can suggest the right invoice.

1. In Statements Import → Settings → AI reconciliation, tick Enable AI reconciliation, choose a provider (OpenAI, Anthropic Claude, Grok or DeepSeek), paste its API key and (optionally) a model, then click Test to verify the connection.
2. On the review screen, use the blue AI match unmatched button to let the AI attempt every unmatched incoming line at once, or the small AI suggest icon on a single row.
3. The AI only proposes an invoice from your open invoices — it never creates one — and its suggestions are marked AI (provider): …. Review and confirm them like any other suggestion.

Each AI suggestion is one API call to your chosen provider, so it uses your provider credits. The transaction details and a shortlist of candidate invoices are sent to that provider.