Bank Statement Import
Import bank statements from multiple file formats and auto-reconcile
Bank Statement Import module enables importing bank statements from common file formats (CSV, OFX, QIF, CAMT), automatically reconciling with invoices and efficiently managing bank transactions.
System supports multiple file formats, automatically detects duplicates, suggests smart reconciliation and creates detailed cash flow reports.
Key Features
Key points
• Multi-format Support: CSV, OFX, QIF, CAMT.053
• Auto-reconciliation: Automatically reconcile with invoices
• Duplicate Detection: Detect duplicate transactions
• Smart Matching: Intelligent reconciliation suggestions
• Batch Import: Import multiple files at once
• Transaction Management: Detailed transaction management
Import Process
Steps
1. Download statement: Download statement from bank
2. Import file: Upload file to Odoo
3. Review transactions: View and check transactions
4. Auto-reconcile: System automatically reconciles
5. Manual matching: Manual reconciliation if needed
6. Confirm statement: Confirm and post
File Formats
Format Comparison
| Format | Origin | Advantages |
|---|---|---|
| CSV | Universal | Flexible, easy to edit |
| OFX | US banks | US standard, detailed |
| QIF | Quicken | Simple, legacy |
| CAMT.053 | EU banks | EU standard, ISO 20022 |
Real-World Scenarios
Key points
• Daily import: Import statements daily for cash flow updates
• Monthly reconciliation: Import end-of-month statements for overall reconciliation
• Multiple banks: Manage multiple bank accounts
Best Practices
Key points
• Choose format appropriate for your bank
• Import frequently for easier reconciliation
• Check for duplicates before confirming
• Use reconciliation rules for automation
• Backup import files for future reference
Troubleshooting
Common Issues
| Issue | Cause | Solution |
|---|---|---|
| Import failed | Wrong format | Check file format and encoding |
| Duplicate transactions | Already imported | Skip or delete duplicates |
| Cannot reconcile | Missing information | Manual reconciliation |
FAQ
Key points
• Which format is best? Depends on bank: CAMT for EU, OFX for US, CSV for flexibility.
• Can import multiple files? Yes, upload multiple files at once.
• How to handle duplicates? System auto-detects and suggests skip.
• Import frequency? Recommended daily or weekly.