Skip to content

Open Banking

  • Open Banking

  • Keep an eye on bank accounts

  • Read a bank account page

  • Search and filter a bank account's transactions

  • Sync an account with the bank and read the history

  • Connect a bank account

  • Reconnect a bank account when the bank consent expires

  • Understand why the bank balance doesn't match the transactions

  • Import a bank statement from a CSV or CAMT.053 file

  • Reconcile transactions with automatic suggestions

  • Manually matching a transaction to an invoice and undoing a reconciliation

  • Decide on movements held by the bank

  • Export movements for the accountant

  • Set up reconciliation rules

  • Recognize customers and suppliers from the bank text

All modules

Export movements for the accountant

Open Banking · 13 of 15 · 3 min read

From a bank account's page you can download the transactions for a period as a CSV or PDF file. The file is for handing transactions to whoever keeps the books outside the company, for example the transactions of a quarter for Main Current Account.

Before exporting

Exporting transactions is covered by a permission in the Open Banking module, not by the accounting one.

Before you start: to export you need read permission on bank connections, which the Open Banking User and Open Banking Manager groups have. The Open Banking module must be active for the organization.

Important: the external accountant's profile does not include Open Banking permissions. The accountant cannot export the transactions alone: you do the export and hand over the file.

You can export the transactions of any active bank account, whether connected to the bank or with statements imported by hand.

Exporting an account's transactions

The export buttons are on the account's page, in the Export bar next to the date fields, above the list of transactions. To read the rest of the page see Read a bank account page.

  1. Open Invoices › Banking and press Main Current Account. The account page opens.

The Main Current Account page with the Export bar above the transactions

  1. Set the period in the two date fields.
  2. Press CSV to download a spreadsheet, or PDF to download a document to print or send.

The period fields work like this:

  • First date field: the first date of the period to export.
  • Second date field: the last date of the period. It cannot be earlier than the first date.

Note: the two dates start filled in, from 1 January of the current year to today. If you clear both, the file contains all the transactions of the account.

To return to the list of accounts, press Back to accounts.

What the file contains

The CSV and the PDF have the same content, organized in three parts.

At the top of the file:

  • the document title;
  • the account, with its name and, in brackets, the journal code;
  • the period, with the start date and end date separated by an arrow.

One row for each transaction in the period, with eight columns:

  • the date of the transaction;
  • the description;
  • the reference;
  • the counterparty;
  • the bank statement the transaction is on;
  • the amount;
  • the matched document, for example the invoice the transaction is reconciled with;
  • the status, which states in full whether the transaction is matched or not. An unmatched transaction does not leave the cell empty.

At the bottom of the file:

  • the number of transactions exported;
  • how many of these are unmatched;
  • the total of the amounts for the period.

Tip: before exporting a period, reconcile the open transactions, so the file arrives with fewer unmatched rows. See Reconcile transactions with automatic suggestions and Manually matching a transaction to an invoice and undoing a reconciliation.

CSV and PDF formats

Choose the format based on what the recipient needs to do with the file.

  • CSV: for those who rework the data in a spreadsheet or another program. The file is encoded in UTF-8 so Excel correctly reads the € symbol and accented letters. Amounts are written with two decimals, with a dot as the decimal separator and no thousands separator.
  • PDF: for those who need to read or archive the transactions. The document is in A4 landscape, so the eight columns fit on the page.

The file name contains the account code and the period dates, for example bank-movements_BNK1_2026-01-01_2026-03-31.csv.

← Previous

Decide on movements held by the bank

Next →

Set up reconciliation rules

On this page

Book a demo

See it on your company, not on a slide deck.

In 30 minutes we map the software you use today.We show you how much work and how much margin Archimedes gives back.

Show me on my business →
No commitmentReply within one working day