AIONA Docs

Import a bank statement

Load a statement as CSV, OFX, QIF or PDF and let AIONA propose matches.

The Reconcile workspace with proposed matches, each carrying a written reason
The live product on a demonstration book.
  1. Open Reconcile and click Import.
  2. Choose the statement file. CSV, OFX, QIF and PDF statements are supported. For CSV, AIONA detects the date, description and amount columns itself; a single signed amount column or separate credit and debit columns both work.
  3. Give the bank account a name the first time (Main Bank Account is the default). AIONA links it to the Cash at Bank ledger account.
  4. After import, click Find matches. AIONA proposes a match for each statement line it can pair with a posted journal, and writes the reason on the line: exact amount, days apart, source type.
  5. Anything that looks wrong is put in Flagged rather than matched: a counterparty that does not fit the journal, money in matched to a bill, and so on. Nothing is reconciled until you accept it.

Duplicate lines are skipped on re-import, so importing the same statement twice does not double up transactions.

Other guides