Bite Apps › SafeCAMT › BAI2 to Excel

BAI2 to Excel — convert BAI2 bank reports without uploading them

Open a BAI2 previous-day or intraday report, check its control totals and balances, and download every transaction with type code, references and text for Excel — all in your browser.

SafeCAMT reads BAI2, camt.053 and MT940 — free to use, nothing is uploaded.

Open SafeCAMT — free, in your browser

Open SafeCAMT with an example file Open SafeCAMT and drop your own file

How to convert a BAI2 file to Excel

Download the previous-day or intraday report as BAI2 from your bank's treasury portal.
Open SafeCAMT and drop the file. Continuation records (88) are joined, and every account (03 group) in the file is read.
Check the Checks and Balances tabs: SafeCAMT recalculates the account, group and file control totals (49, 98, 99) and record counts, and compares the ledger balances.
Download the transactions as CSV and open the file in Excel — one row per 16 detail record, with its type code, amount, bank and customer reference and text.

Free: every transaction on screen, the balance check, and a CSV download of the first 100 rows. Pro ($19 one-time, no subscription): all rows and Excel (.xlsx) with Transactions, Balances and Checks sheets.

Columns in the export

Column What it contains

Booking date / Value date when the bank booked the entry and when it is valued

Amount, Currency, Credit/Debit signed amount (debits negative) plus currency and C/D

Status booked, pending or information only

Counterparty, Counterparty IBAN/account, Counterparty BIC the other party of the payment

Remittance information, Structured reference free-text purpose and RF creditor reference

End-to-end ID, Bank reference, Entry/customer reference the references you reconcile against

Bank transaction code ISO domain-family-sub-family, e.g. PMNT-RCDT-ESCT (or the MT940 GVC / BAI2 type code)

Return reason, Additional information reason code of returned payments, extra bank text

File, Account, Statement where the row comes from when several files or accounts are open

Column	What it contains
`Booking date / Value date`	when the bank booked the entry and when it is valued
`Amount, Currency, Credit/Debit`	signed amount (debits negative) plus currency and C/D
`Status`	booked, pending or information only
`Counterparty, Counterparty IBAN/account, Counterparty BIC`	the other party of the payment
`Remittance information, Structured reference`	free-text purpose and RF creditor reference
`End-to-end ID, Bank reference, Entry/customer reference`	the references you reconcile against
`Bank transaction code`	ISO domain-family-sub-family, e.g. PMNT-RCDT-ESCT (or the MT940 GVC / BAI2 type code)
`Return reason, Additional information`	reason code of returned payments, extra bank text
`File, Account, Statement`	where the row comes from when several files or accounts are open

The type code column carries the BAI2 code (for example 165 preauthorized ACH credit or 475 check paid) — all 469 codes are listed on the BAI2 format reference. Need ISO 20022 instead? SafeCAMT converts BAI2 to camt.053 on the MT940 → camt.053 tab.

Why not an online converter?

A BAI2 file holds every account balance and payment of a company. SafeCAMT reads it in your browser — nothing is uploaded, and it also works offline.

FAQ

How do I open a BAI2 file in Excel?

Excel only sees comma-separated records with codes. Open the file in SafeCAMT, check the control totals, and download the transactions as CSV with one row per detail record.

Does it check the BAI2 control totals?

Yes. Account (49), group (98) and file (99) control totals and record counts are recalculated and compared with the file.

Are multiple accounts supported?

Yes. Every 03 account group in the file is read, and the account appears in its own column.

Is the BAI2 file uploaded?

No. Everything runs in your browser.

Last updated 2026-11-14. Something wrong or missing? Email support@biteapps.cc.