CSV Bank Import
Import statements from CSV with flexible column mapping for any bank
CSV Bank Import module enables importing bank statements from CSV files with customizable column mapping, supporting any bank format and Excel exports.
System supports multiple delimiters, date formats, encodings and allows saving mapping templates for reuse in future imports.
Key Features
Key points
• Universal CSV: Support any CSV format
• Column Mapping: Flexibly map columns to Odoo data
• Date Formats: Multiple date formats
• Delimiter Config: Comma, semicolon, tab, custom
• Mapping Templates: Save and reuse mappings
• Excel Compatible: Import directly from Excel exports
CSV Import Process
Steps
1. Export CSV: Export statement from bank as CSV
2. Upload file: Upload CSV to Odoo
3. Map columns: Map columns to Date, Amount, Description
4. Preview data: Preview mapped data
5. Import: Import to bank statement
6. Reconcile: Reconcile with invoices
Column Mapping
Columns to Map
| Field | Required | Format |
|---|---|---|
| Date | Yes | DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD |
| Amount | Yes | Debit/Credit or signed amount |
| Description | No | Text description |
| Reference | No | Transaction reference |
| Balance | No | Running balance |
Real-World Scenarios
Key points
• Vietnamese banks: Map CSV from local banks
• Excel exports: Import from exported Excel files
• Custom formats: Handle special bank formats
Best Practices
Key points
• Save mapping template for each bank
• Test with few rows before importing all
• Check date format before import
• Use preview to verify mapping
• Convert Excel to CSV UTF-8 if encoding errors
Troubleshooting
Common Issues
| Issue | Cause | Solution |
|---|---|---|
| Encoding error | File not UTF-8 | Convert to UTF-8 in Excel |
| Date parse error | Wrong date format | Select correct date format in mapping |
| Wrong amount | Wrong debit/credit mapping | Check which column is debit, credit |
FAQ
Key points
• Which delimiters supported? Comma, semicolon, tab and custom delimiter.
• Can import from Excel? Yes, save as CSV UTF-8 first.
• Where are mapping templates saved? In Odoo, reuse for future imports.
• Handle multiple date formats? Select appropriate format when mapping.