QIF Bank Import
Import QIF statements from Quicken and convert accounting data
QIF Bank Import module supports importing QIF (Quicken Interchange Format) statements - simple text-based format from Quicken and personal finance software.
System parses QIF text format, maps categories to Odoo accounts and converts historical data from personal to business accounting.
Key Features
Key points
• QIF Format: Parse text-based QIF format
• Quicken Compatible: Import from Quicken exports
• Category Mapping: Map QIF categories to accounts
• Split Transactions: Support split transactions
• Historical Data: Convert historical data
QIF Import Process
Steps
1. Export QIF: Export from Quicken or other software
2. Import file: Upload QIF text file
3. Parse format: Read QIF structure
4. Map categories: Map categories to accounts
5. Import transactions: Import transactions
6. Reconcile: Reconcile if needed
QIF Structure
QIF fields
| Code | Field | Example |
|---|---|---|
| D | Date | 01/15/2026 |
| T | Amount | -50.00 |
| P | Payee | Grocery Store |
| M | Memo | Weekly shopping |
| L | Category | Food:Groceries |
Real-World Scenarios
Key points
• Migration: Move from Quicken to Odoo
• Personal to business: Convert personal to business accounting
• Legacy data: Import historical data from QIF
Best Practices
Key points
• Map categories before importing
• Test with few transactions first
• Check date format (MM/DD/YYYY)
• Handle split transactions carefully
Troubleshooting
Common Issues
| Issue | Cause | Solution |
|---|---|---|
| Parse error | Wrong QIF format | Check file encoding (ASCII/UTF-8) |
| Category not found | Category not mapped | Create mapping for categories |
| Split transaction error | Wrong split format | Check S lines in QIF |
FAQ
Key points
• What is QIF? Quicken Interchange Format - text-based legacy format.
• Which Quicken versions? Most versions, QIF is universal format.
• Can import split transactions? Yes, but need correct category mapping.
• QIF vs OFX? QIF simpler but less information than OFX.