CAMT.054 integration
โจ Features
- ๐ Automatic reconciliation of bank payments against invoices
- ๐ถ Threshold-based write-off handling: Small differences (e.g., rounding errors) are booked automatically into the company's write-off account, as defined in the Company settings
- ๐งพ Integrates directly with Swiss QR Bill references (QRR) for precise matching
- ๐ Creates fully linked Payment Entries for reconciled invoices
Prerequisites
Before using the camt.054 integration:
- โ Swiss Accounting Software Installed
- โ
Swiss QR Bill Setup Complete
- QR-IBAN is linked in your bank account
- QR references are generated on Sales Invoices, Payments with reference numbers will be automatically matched when importing camt.054 file
- The fields Assign Unreconciled Transactions To and Threshold Payment Difference are set
๐ฅ How to Import a Bank Statement
- Go to Bank Statement Import List
- Click New
- Select the Bank Account you want to reconcile
- Save the document
- Check the Enable camt box
- Attach the camt.054 XML file (usually provided by your bank)
- Click Convert XML to CSV
- Once parsed, click Start Import to begin reconciliation
๐ก Tip: Make sure the camt file includes references (<Strd><CdtrRefInf>) matching your QR invoice references.
๐ How to Check the Imported Transactions
After importing:
- Navigate to Bank Transaction List
- Here you'll see:
- All payments processed from the camt file
- Linked invoices that have been automatically marked as Paid
- Created Payment Entry documents per matched transaction
- Any unmatched or problematic entries will be left for manual review or routed to the user configured in QR Bill Settings.
๐ Troubleshooting
- Invoice not matched? Make sure the creditor reference in the invoice exactly matches the one in the XML file.
- Contact us for help at: ONFUSE Support