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
  • 🔗 GitHub Repository (Onfuse)
  • 🧠 Onfuse Swiss Accounting Overview
• ✅ 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

1. Go to Bank Statement Import List
2. Click New
3. Select the Bank Account you want to reconcile
4. Save the document
5. Check the Enable camt box
6. Attach the camt.054 XML file (usually provided by your bank)
7. Click Convert XML to CSV
8. 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:

1. Navigate to Bank Transaction List
2. 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
3. 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