Uploading a Bank Statement

Manually import bank transactions by uploading a statement file.

What this does

Uploading a bank statement imports transactions from a CSV, OFX, or QIF file into your bank feed for categorisation and matching.

When to use it

Upload statements if you don't use Open Banking, or when you need to import historical transactions.

Step by step

  1. Download a statement from your bank's online portal (CSV, OFX, or QIF format)
  2. Go to Banking in the Accounting menu
  3. Select the bank account
  4. Click Upload Statement
  5. Choose the file from your computer
  6. Map the columns if prompted (date, description, amount)
  7. Click Import
  8. Transactions appear in the bank feed ready for review

Tips

  • CSV files must include at least date, description, and amount columns
  • Duplicate transactions are detected and skipped automatically
  • Import one statement at a time to keep things organised
  • You can import statements going back as far as needed