US Bank Reconciliation
Bank Reconciliation with BAI2 / OFX Import (US)
Bank Reconciliation with BAI2 / OFX Import (US)
Key Features
Real BAI2 parser
file/group/account/detail/continuation/trailer records (01/02/03/16/88/49/98/99), BAI2 type-code classification (credit 1xx-3xx, debit 4xx-6xx) and integer-cent amounts.
Real OFX / QFX parser
reads every block (TRNTYPE, DTPOSTED, TRNAMT, FITID, NAME, MEMO, CHECKNUM) plus the ledger closing balance, for both SGML and XML OFX flavours.
Rule engine
match on memo (substring or regex), credit/debit, amount range and partner, then set partner / counterpart account / label and optionally auto-clear.
Reconciliation
match statement lines to open account.move.line book entries by amount, date tolerance and reference, with a confidence score, and balanced clearing that stamps the book entry as reconciled.
Outstanding-checks / deposits-in-transit report plus a recon
Outstanding-checks / deposits-in-transit report plus a reconciliation summary: statement balance + deposits in transit - outstanding checks must equal the ledger book balance.
Screenshots
Why Choose This Module
Import US bank statements (BAI2 and OFX/QFX), match the lines to your open book entries and reconcile, then report on items still in transit.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: account
- Support: support@pokutsoft.com
Update date: 2026-07-05