Bite Apps › SafeCAMT › camt.053 to QuickBooks / Xero

camt.053 to QuickBooks, Xero, FreeAgent and OFX

Convert a camt.053, MT940 or BAI2 bank statement into the import file your accounting software expects — QuickBooks Online, Xero or FreeAgent CSV, or OFX — without uploading it anywhere.

SafeCAMT also reconciles the statement balances before you import.

Open SafeCAMT — free, in your browser

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

How to import a camt.053 (or MT940, BAI2) statement into accounting software

Open SafeCAMT and drop the bank statement — camt.053, MT940 or BAI2.
Check that the balances reconcile, then on Transactions click Export for accounting….
Choose the layout and, if the file holds several accounts, the account. Pick the date format your software expects.
Download the file and upload it in your accounting software's bank import.

Free for the first 100 transactions of a statement; Pro ($19 one-time) exports all of them.

Layouts

Layout	Columns	Where to import
QuickBooks Online (CSV)	Date, Description, Amount (money out negative)	Transactions → Bank transactions → Upload from file
Xero (CSV)	Date, Amount, Payee, Description, Reference	Bank account → Import a statement (map the columns once)
FreeAgent (CSV)	date (dd/mm/yyyy), amount, description — no header	The bank account’s statement upload
OFX 1.02	Each transaction with a unique ID (FITID), ledger balance	Software with OFX import — e.g. Sage Accounting, Xero, most personal-finance apps

Layout

Columns

Where to import

QuickBooks Online (CSV)

Date, Description, Amount (money out negative)

Transactions → Bank transactions → Upload from file

Xero (CSV)

Date, Amount, Payee, Description, Reference

Bank account → Import a statement (map the columns once)

FreeAgent (CSV)

date (dd/mm/yyyy), amount, description — no header

The bank account’s statement upload

OFX 1.02

Each transaction with a unique ID (FITID), ledger balance

Software with OFX import — e.g. Sage Accounting, Xero, most personal-finance apps

Only booked transactions are exported; pending entries stay out. OFX transaction IDs come from the bank's reference where available, so importing the same statement twice does not create duplicates in software that de-duplicates by FITID. Test the first import with one statement before you switch your routine.

Why not an online converter?

Bank statements are confidential. SafeCAMT reads and converts them in your browser — nothing is uploaded and no account is needed. To just look at the data in Excel, see camt.053 to Excel or MT940 to Excel.

FAQ

Can QuickBooks Online import camt.053?

Not in every region. SafeCAMT converts camt.053 (and MT940 or BAI2) into the three-column CSV that QuickBooks Online accepts, or into OFX.

How do I import camt.053 into Xero?

Export the statement from SafeCAMT with the Xero layout (Date, Amount, Payee, Description, Reference) and upload it under Import a statement on the bank account; Xero asks once how to map the columns.

Is OFX supported?

Yes. SafeCAMT writes OFX 1.02 with unique transaction IDs and the ledger balance, which most accounting software can import.

Is my bank statement uploaded?

No. The conversion runs in your browser.

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