US BAI2 File Writer turns the bank transactions you already hold in Odoo into a clean, fully balanced BAI2 cash-management file - the BAI Cash Management Balance Reporting Specification, Version 2 format that US corporate treasury workstations and ERP cash-positioning tools consume. Build the file in a few clicks, review every record, and download a ready-to-load .bai file. Everything runs inside your database: no external service, no per-file fee, your bank data never leaves Odoo.

Complete, well-formed record set

Every BAI2 record type is written in the correct order with the correct fields:

• Type 01 - File Header: sender/receiver id, creation date and time, file id, BAI version 2.
• Type 02 - Group Header: originator, ultimate receiver, group status, as-of date/time and currency.
• Type 03 - Account Identifier: account number, currency and repeating balance triplets (type code, amount, item count, funds type).
• Type 16 - Transaction Detail: type code, amount, funds type, bank and customer references, free text.
• Type 49 / 98 / 99 - Trailers: account, group and file trailers with control totals and record counts.

Correct control totals & counts

A BAI2 file is rejected on load if any trailer total or record count is wrong. This module re-derives them exactly the way a receiving workstation does:

• Signed control totals in integer cents - credits positive, debits negative - summed account → group → file.
• Record counts that include the trailer itself at each level (49 counts 03+16…+49, 98 counts 02…+98, 99 counts the whole file).
• Amounts in minor units (cents) with no decimal point and round-half-up cent handling to avoid float drift.
• Negative / overdraft balances written with a leading minus sign per the specification.

Build straight from bank transactions

• One-click wizard turns a date range of bank statement lines from one or many bank journals into a BAI2 file.
• Opening (010) and closing (015) ledger balances are computed from the prior balance plus the period net.
• Each statement line maps to a credit (108) or debit (409) transaction by the sign of its amount, carrying the reference and description.

Full BAI2 type-code library

• Curated status/balance codes (010 Opening Ledger, 015 Closing Ledger, 045 Closing Available, and more).
• Curated transaction codes across the credit (100-399) and debit (400-699) ranges - lockbox, ACH, wire, check paid, service charge, interest and others.
• Automatic credit/debit classification and human-readable descriptions from the published numbering scheme.

Feature overview

How it works

1. Set your BAI2 Sender, Receiver and Originator ids in Settings.
2. Create a BAI2 file manually, or run Build from Transactions over a journal and date range.
3. Review the accounts, balances and transactions, then Generate the file.
4. Inspect the live preview, confirm the control totals, and Download the .bai file to upload to your treasury system or bank portal.

Disclosure: this module only builds the BAI2 text file from your own Odoo data for you to load into your own treasury workstation or bank portal. It transmits nothing to any external service and makes no accreditation claim. Compatible with Odoo 18 and Odoo 19.

Screenshots

Build From Transactions

Bai2 Files

Settings