Convert a BAI2 statement
Turn a BAI2 file into CSV or Excel, and check the control totals tie before you trust it.
BAI2 → CSV, XLSX
Loading this page.
Loading this page.
28 of 29 tools are open now.
Skip to toolsFree BAI2, MT940 and camt.053 converters — plus bank reconciliation and close checks.
Close still arrives as files. Convert one, tie two ledgers, or check the books — and see the hours a team could reclaim. 29 tools for the work that actually fills a close, 28 of them open now and the rest in build. No account, no card, no sales call.
Files, statements, reconciliation, subledgers, and the books. Open the BAI2 converter
Banks send fixed-width records and XML. Spreadsheets want rows. These four do that conversion and score the file while they are in there.
Turn a BAI2 file into CSV or Excel, and check the control totals tie before you trust it.
Read a SWIFT MT940 as rows you can sort, filter and sum, with the closing balance verified.
Flatten ISO 20022 camt.053 XML into one transaction per row, references intact.
Pull the transaction table out of a PDF statement and flag any page where the running balance breaks.
One bank file in and no second side to match it against: whether it is clean enough to reconcile with, what the bank charged you for it, and where the cash actually sits.
Judge whether a bank file is clean enough to reconcile with, in whichever format the bank sent it.
Group every charge on the statement by type, and estimate how much of it could be reclaimed.
Consolidate account balances by bank, entity and currency, and show what looks stranded or stale.
Every one of these takes the two files you are currently comparing by eye, matches them, and hands back the list of breaks with a reason against each.
Match the statement against your cash book and list what is outstanding on each side.
Match the statement against the GL cash account and explain every break, with the cost of clearing it.
Compare a supplier's statement with your ledger and find the invoices only one of you has.
Tie customer receipts to open invoices, and surface short payments, part payments and unapplied cash.
Tie supplier payments to open bills and catch the duplicate payment before the month closes.
Break a Stripe, Razorpay or PayPal payout back into orders, fees, refunds and chargebacks.
Pair balances between entities and show exactly what will not eliminate on consolidation.
Match GSTR-2B against your purchase register invoice by invoice, and total the credit at risk.
Compare what a customer says they owe with your AR ledger, and account for the difference.
Find the receipts sitting unapplied and show which open invoices each one probably settles.
Check every balance-sheet account against the schedule behind it, and list the accounts nothing supports.
Match purchase orders to goods receipts to invoices, and name every document the other two do not account for.
One AR or AP ledger and nothing to match it against: how overdue the balances really are, and where the same invoice or payment appears twice.
Bucket what customers owe by how overdue it is, and show where the collection risk sits.
Bucket what you owe by how overdue it is, and show which suppliers need attention first.
Compare an invoice register against itself and surface the same invoice entered more than once.
Compare a payment register against itself and surface the same money looking like it left twice.
The checks a controller runs before signing, and an auditor runs after. Point them at an export and read the answer.
Confirm the trial balance actually balances, then flag the accounts that moved without an explanation.
Age what is sitting in suspense, group it by likely cause, and show who posted it.
Find the round numbers, the weekend postings and the reversals worth questioning before an auditor does.
Age the accruals still open, and show which never reversed or reversed for the wrong amount.
Find the account that moved unlike itself: a dormant account waking up, an outsized posting, a material movement with no narrative.
Put this month's files through every check above in one pass and get a single close readiness report.