In short
- A BAI2 file is a daily statement of your prefunding account in the industry-standard BAI2 format, so your accounting or treasury system can load it automatically.
- There are two kinds: the Daily BAI2 File we build for you, and your sponsor bank's own BAI2 statement.
- Both give you the bank side of your prefunding account reconciliation, next to your Daily Transfers and Cancellation reports.
What these files are
| Daily BAI2 File | Sponsor bank BAI2 statement | |
|---|---|---|
| Who makes it | PayMitto | Your sponsor bank |
| What it covers | Your prefunding account at Bancorp | Your prefunding account at the bank |
| Who gets it | Optional. Available to any client who needs it | Depends on the bank setting it up for your account |
- What both show: what actually posted to your prefunding account at the bank: your deposits, the debits for principal and transfer revenue, reversals credited back, and the opening and closing balances.
- Without a BAI2 file: you can read the same postings by logging in to your sponsor bank's online portal.
Naming format
-
Daily BAI2 File:
CustomerName_BAI2_MMDDYY.bai, with the same name prefix as your other daily files.MMDDYYis the day the file is sent, in Central Time, not the bank day it covers. Some older files are named for the bank day instead.
Delivery and timing
Daily BAI2 File
- One file per business day, sent by SFTP after your daily transfer files. There's no set time. It normally covers the previous bank day.
- Catching up: if a bank day wasn't sent, the next file carries it too. One file, with one section per bank day, oldest first, going back up to five bank days.
- Matching never holds your file: each day's file goes out as built, even when a day doesn't balance or doesn't match. PayMitto's Finance team follows up on any day that doesn't match.
Sponsor bank BAI2 statement
- Bancorp: creates its files Tuesday through Saturday and sends them between 7:00 and 8:00 AM ET (6:00 to 7:00 AM CT). Bancorp can't change this schedule. Drops have sometimes run late.
- No bank file on a Monday is normal, for both Bancorp and MVB.
- MVB: Tuesday to Saturday (same days as Bancorp).
- Who delivers it: for some clients, PayMitto picks up the bank's file and delivers it by SFTP; otherwise the bank delivers it.
Setup
- Daily BAI2 File: available to any client who needs it. Ask your PayMitto contact or the Integrations Team during setup.
-
Sponsor bank BAI2 statement: it depends on the bank setting it up for your account. Your account only appears in the file once the bank has turned it on.
- * MVB: each account needs its own signed form. MVB turns it on a day or two later.
What's in the file
BAI2 files follow the BAI Cash Management Balance Reporting Specifications, Version 2. A file is a set of nested envelopes. Each opens with a header and closes with a trailer that carries control totals, so your system can check nothing is missing.
| Record | Name | What it carries |
|---|---|---|
| 01 | File header | Sender and receiver IDs, creation date (YYMMDD) and time, file ID, version 2 |
| 02 | Group header | Receiver and originator, group status, as-of date, currency (USD), as-of-date modifier |
| 03 | Account identifier and summary | Your prefunding account number and currency, then type code and amount pairs for balances and summaries |
| 16 | Transaction detail | One per posting: type code, amount, funds type, bank reference number, and a text description |
| 88 | Continuation | Carries on the previous record when it runs past one line |
| 49 | Account trailer | Account control total and record count |
| 98 | Group trailer | Group control total, number of accounts, record count |
| 99 | File trailer | File control total, number of groups, record count |
Always in the file:
- Opening and closing ledger balances (type codes 010 and 015).
- Detail lines (record 16), each with a type code, an amount and a text description.
- Up to five line types per network batch per day: Principal Amount, Transfer Revenue, Fee Adjustment, Additional FX Charge, and FX Charge Return.
The Daily BAI2 File also has: incoming wires you send to fund the account, reversals credited back, and the day's debit and credit totals, with the same statement descriptions as your bank statement.
Reading the file:
- Amounts have no decimal point:
693means 6.93. The type code tells you whether it's a debit or a credit. - Dates are YYMMDD.
-
/ends a record. A line without/continues on the next 88 line, and text can split mid-word. - Blank optional fields are left empty between commas.
- Each bank chooses its own type codes, and they can change. The codes below are the ones that always appear; other codes may show up depending on the bank.
| Type code | Meaning |
|---|---|
| 010 | Opening ledger |
| 015 | Closing ledger |
| 690 | Total miscellaneous debits |
| 699 | Miscellaneous debit (principal and transfer revenue) |
What clients use it for
- The bank side of your prefunding account reconciliation, in a format your system loads without manual handling. Your Daily Transfers and Cancellation reports are the other side.
- How they tie: for each network batch on each day, Total debit amount minus Fee revenue share (summed from the Daily Transfers Report) equals Principal Amount plus Transfer Revenue (that batch's two lines in the BAI2 file). If you're not set up for revenue withholding, Fee revenue share is $0.00, so Total debit amount alone equals Principal Amount plus Transfer Revenue.
- The four batches: Mastercard, Visa Push to Card, Visa Account, and Visa Wallet.
- Not for your internal account: the Daily Consolidated Report covers your own general ledger, so it isn't the counterpart to a BAI2 file.