Tracking & Monitoring
3 min

Import a CSV bank statement

Upload a CSV file to track transactions from non-integrated banks.

When to use CSV import

If your bank is not yet integrated (other than Qonto and Wise), you can import a statement exported from your banking portal.

Prepare your file

The file must be in CSV format (comma or semicolon separator) and contain at least:

  • A Date column (DD/MM/YYYY or YYYY-MM-DD format)
  • A Description column
  • An Amount column (positive for income, negative for expenses)

Import steps

  1. Open Pilotage → Import
  2. Click "Choose a file" and select your CSV
  3. Check the preview of the first 5 rows
  4. Map each column to the right field (date, description, amount)
  5. Select the currency (EUR by default)
  6. Click "Import"

Automatic categorization

The AI automatically categorizes each transaction (Salaries, Marketing, SaaS, etc.). You can correct the category after import from the "Real data" tab.

Tips

  • Import in monthly batches for easier reconciliation
  • Avoid duplicates: import detects identical transactions (same date + amount + description)
  • Back up your original CSV before importing

Related articles

Discover the Pilotage dashboard

Connect Qonto and Wise

Understand Actual vs Forecast variances