OFX Bank Import
Import OFX statements from US banks and credit cards
OFX Bank Import module supports importing OFX (Open Financial Exchange) format statements - US and international standard, with complete bank and credit card transaction information.
System automatically parses OFX 1.x (SGML) and OFX 2.x (XML), extracts transaction details and reconciles with invoices.
Key Features
Key points
• OFX 1.x/2.x: Support both SGML and XML
• Bank Accounts: Checking/savings accounts
• Credit Cards: Credit and debit cards
• Transaction Details: Payee, memo, check number
• Auto-reconcile: Automatically reconcile with invoices
OFX Import Process
Steps
1. Download OFX: Download from bank (OFX/QFX file)
2. Import file: Upload to Odoo
3. Parse format: Auto-detect OFX 1.x/2.x
4. Extract data: Extract transactions
5. Match accounts: Match with bank journal
6. Reconcile: Reconcile with invoices
OFX Transaction Types
Transaction types
| Type | Description | Examples |
|---|---|---|
| DEBIT | Withdrawal | ATM withdrawal, purchase |
| CREDIT | Deposit | Deposit, refund |
| CHECK | Check | Check payment |
| XFER | Transfer | Transfer between accounts |
Real-World Scenarios
Key points
• US accounts: Import from Chase, Bank of America, Wells Fargo
• Credit cards: Reconcile credit card expenses
• International: Some international banks support OFX
Best Practices
Key points
• Download OFX instead of QFX if available
• Check OFX version (1.x SGML or 2.x XML)
• Map bank accounts to journals first
• Use transaction ID to avoid duplicates
Troubleshooting
Common Issues
| Issue | Cause | Solution |
|---|---|---|
| Parse error | Invalid OFX format | Re-download from bank |
| Account not found | Account number mismatch | Check account mapping |
| Missing transactions | Wrong date range | Download correct date range |
FAQ
Key points
• OFX vs QIF? OFX is newer, more detailed, QIF is legacy format.
• OFX 1.x vs 2.x? 1.x uses SGML, 2.x uses XML, both supported.
• Which banks support? Most US banks and some international.
• Can import credit cards? Yes, OFX supports both bank and credit card.