CSV Import: 6 Canadian Banks Supported

CSV is a first-class citizen in CondoAide. Upload the file exported from your bank and the system automatically detects the format, encoding, and columns — no manual configuration needed.

Supported Banks

• Desjardins AccèsD — Retrait/Dépôt split columns, semicolon separator, Windows-1252 encoding
• TD EasyWeb — Withdrawals/Deposits, MM/DD/YYYY dates
• BMO Online — Signed single amount, compact YYYYMMDD dates
• Banque Nationale — Débit/Crédit columns, metadata row automatically skipped
• RBC Royal Bank — Description 1/CAD$, signed amounts
• Scotiabank — Date/Description/Amount, signed format

CSVs from other Canadian banks (CIBC, Tangerine, Laurentian) also work thanks to automatic generic column detection.

What CondoAide Handles Automatically

• Encoding — UTF-8, Windows-1252, Latin-1 auto-detected
• Separators — comma, semicolon, tab
• Date formats — YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY, YYYYMMDD
• Amounts — French format (1 326,50), English format (1,326.50), negative sign or parentheses
• Metadata rows — account headers (Banque Nationale, etc.) are skipped automatically

How It Works

1. Go to Finances → Transactions → Import CSV
2. Drag your file or click to select it
3. CondoAide detects the bank and shows a transaction preview
4. Review and confirm the import

Same workflow for imports in Payments, Reserve Fund, and Self-Insurance.