US BAI2 Bank Parser
Import BAI2 cash-management statement files (US & Canada) into Odoo bank statements
BAI2 (the BAI Cash Management Balance Reporting Specification, Version 2) is the dominant corporate statement format delivered by US and Canadian banks — Citibank, Bank of America, JPMorgan, Wells Fargo, RBC, TD and most treasury/cash-management portals. This module parses a BAI2 file end-to-end and turns every account block into an Odoo bank statement, ready for reconciliation. Everything runs locally: bring your own file exported from your bank.
Complete record support
File Header (01), Group Header (02), Account Identifier (03), Transaction Detail (16), and Account / Group / File Trailers (49 / 98 / 99). Continuation (88) records are folded into the record they continue, so long transaction descriptions arrive intact.
Multi-account splitting
A single BAI2 file often carries several account blocks. Each one is split into its own bank statement and routed to the matching Odoo bank journal by account number, including zero-padded / fully-qualified DDA numbers.
Real BAI2 type codes
Ships with a curated, editable table of BAI status / credit / debit type codes (Lockbox, ACH, Wire, Check Paid, Book Transfer and more). Credit / debit sign is derived per code with correct BAI range arithmetic; add bank-specific codes or override a sign from the UI.
Accurate amounts & integrity
Minor-unit amount handling with a configurable currency exponent, BAI2 YYMMDD / HHMM date-time parsing, opening / closing ledger balances seeded onto the statement, trailer control-total and count integrity checks, and a duplicate-statement guard for safe re-imports.
How it works
- Set each bank journal's BAI2 Account Number (or rely on the journal's bank account number).
- Open Accounting → BAI2 Import → Import BAI2 Statement and upload your file.
- Review the import summary; statements are created per account and ready to reconcile.
Privacy: parsing is entirely local to your Odoo instance. No statement data is transmitted to any external service.
Compatible with Odoo 18 and 19.
Screenshots
Import Bai2 Statement
Bai2 Import Wizard Form File
Bai2 Type Codes
Bai2 Type Code Reference Tab
Update date: 2026-07-02