How to Import camt.053 XML into Accounting Software

General Steps (applies to all software)

Menu labels differ, but the core import logic is the same everywhere:

1. Open Banking or Finance module
2. Select Bank statement import or ISO 20022 / camt.053
3. Pick the target bank account
4. Upload the XML file
5. Verify opening and closing balances
6. Confirm import
7. Assign counterparty matching rules (if software didn't auto-match)

QuickBooks Online

1. Left menu: Banking
2. On your account tile click Upload transactions
3. Select camt.053 file
4. Map columns (QuickBooks usually auto-maps)
5. Review and confirm

Xero

1. Menu: Accounting → Bank accounts
2. Select account → Manage account → Import a Statement
3. Xero supports CSV and OFX natively; camt.053 via country-specific plugins or via CSV conversion

Sage (50, 200, X3, Intacct)

1. Menu: Cash Management → Bank Reconciliation → Import Statement
2. Format: ISO 20022 (camt.053)
3. Upload file and run import

SAP Business One

1. Menu: Banking → Bank Statement Processing → Bank Statement Import
2. Select ISO 20022 (camt.053) format
3. Upload XML file
4. Review mapping and run import

Oracle NetSuite

1. Menu: Transactions → Bank → Import Bank File
2. Choose ISO 20022 camt.053
3. Upload, review, submit

Microsoft Dynamics 365 Business Central (Navision)

1. Navigate to Bank Account Reconciliation
2. Choose Import Bank Transactions
3. Select XML file
4. Match against open entries and post

Rivile GAMA (Lithuania)

1. Menu: Bankas → Bankų išrašų importavimas
2. Format: camt.053
3. Select account and upload XML
4. Review transactions before import
5. Click Importuoti

Pragma, Centas, Finvalda (Lithuania)

All three follow the same pattern:

1. Finance/Banking module
2. XML / ISO 20022 import option
3. Upload file, verify balances, confirm

Common Errors and Solutions

Error: "Duplicate transaction"

Software found a transaction with the same NtryRef — probably already imported. Check previous imports or skip the duplicate.

Error: "Balance mismatch"

Opening XML balance should match closing balance of the previous period. If not — you're missing transactions between periods.

Error: "Invalid XML"

File likely corrupted by editing (e.g. opening in Word). Use the original untouched file from ProBankConvert.

Error: "Currency not supported"

Accounting software expects specific currency. Verify XML Ccy matches your account currency.

Post-Import Checklist

• ✅ Opening balance matches previous period's closing
• ✅ Closing balance matches internet banking
• ✅ Transaction count matches
• ✅ Top 5 largest amounts match internet banking
• ✅ Last transaction date correct