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
- Open Pilotage → Import
- Click "Choose a file" and select your CSV
- Check the preview of the first 5 rows
- Map each column to the right field (date, description, amount)
- Select the currency (EUR by default)
- 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