Beta:
This feature is currently in the beta phase. Further improvements are planned based on user feedback.
Overview of Topics
- Introduction
- Requirements
- Upload Bank Statement and Reconcile Invoices
- Frequently Asked Questions and Troubleshooting
Introduction
With the new Import Bank Statement feature, you can upload bank transactions directly into Alasco and reconcile them with approved invoices. Instead of recording payments individually or via the mass payment page manually, you can now import a bank statement in CAMT.053 format (XML) and automatically mark the corresponding invoices as paid.
This significantly simplifies payment reconciliation and reduces the manual effort involved in recording payments.
Requirements
To use this feature, the following requirements must be met:
You need the permission to edit invoices (since invoices will be marked as paid).
The invoices must be in the "Approved" status.
The bank statement must be in CAMT.053 format (XML). This is the global standard for exporting bank statements from banking software.
Note:
Currently, only the CAMT.053 format (XML) is supported. If you have difficulties exporting this format from your banking software, please contact our Support.
Upload Bank Statement and Reconcile Invoices
Follow these steps to import a bank statement and mark invoices as paid:
Navigate in the invoice list under the menu item "Costs" to the tab "Bank Transactions".
Click the button "Upload Bank Statement".
Select your CAMT.053 file (XML) from your local computer or drag & drop it into the upload window.
After uploading, the imported transactions will be displayed and automatically reconciled with approved invoices via the "Process Transactions" button.
Review the suggested matches and confirm them or unlink them again.
Click "Accept" to mark the selected invoices as paid.
Frequently Asked Questions and Troubleshooting
Which file formats are supported?
Currently, only the CAMT.053 format (XML) is supported. This format is the global standard for bank statements and is supported by most banking systems.
Can partial payments be recorded?
Partial payments are not yet supported in the current beta version. The transaction must match the approved invoice amount.
What happens with batch payments?
Batch payments are not supported in the current version. Each transaction is reconciled individually with an invoice.
Can payment data be adjusted before marking as paid?
In the current beta version, adjusting payment data before marking as paid is not possible. The data from the bank statement is taken directly. Payment data can be adjusted afterwards.
My bank statement is not accepted – what can I do?
Ensure your file is in CAMT.053 format (XML). If your banking software does not support this format, please contact our Support.