With the export file, Kolleno does not post payments to your ERP. You approve the matches in Kolleno, download them as an Excel file and import the file into Business Central yourself.
The export file works with Business Central only. To switch it on, contact Kolleno Support (support@kolleno.com).
Use one reconciliation method at a time. When the export file is on, Kolleno does not post matches to Business Central. If Kolleno also posted the matches, each payment could be posted two times.
How it works
Match bank payments to invoices in the Match tab, as usual. See How to Match a Single Payment to a Single Invoice.
Approve the matches in Review & reconcile.
Download the approved matches in Reconciliation history.
Import the file into Business Central.
Kolleno reads the payments back from Business Central and marks the matches Reconciled.
1. Approve your matches
Open Reconciliation, then the bank account.
Go to the Review & reconcile tab.
Select the matches that are correct.
Click Approve.
Then click Approve again to confirm.
The approved matches move to Reconciliation history with the status Confirmed.
2. Download the file
Go to the Reconciliation history tab. To learn more about this tab, see Reconciliation History Overview.
Click Export. Kolleno downloads an Excel file (.xlsx).
The tab opens with two filters: Confirmed matches that are not yet exported. So each file has only the new approved matches.
To download matches again, remove the Match datetime exported filter and click Export. The file has the matches of this bank account only, up to 5,000 matches.
3. What is in the file
The file has one row for each invoice that a payment pays.
The payment_reference column holds the Kolleno ID of the match. Kolleno uses it to find the match when the payment comes back from Business Central.
Need different columns? Contact Kolleno Support (support@kolleno.com) to set the columns, their order and their names for your company. A column can also show a field from your bank data or from your customer data. The payment_reference column always stays in the file.
4. Import the file into Business Central
Import each row as a customer payment in Business Central.
Put the payment_reference value into the Business Central field that you agreed with the support team, for example Your Reference.
Post the payments.
Do not change the payment_reference value. If it is missing or changed, Kolleno cannot find the match, and the match stays Confirmed.
5. Kolleno marks the matches as reconciled
Kolleno syncs the payments from Business Central. When it finds a payment with the match ID, it marks the match Reconciled.
If a match stays Confirmed after the sync, check the Error column, or contact Kolleno Support (support@kolleno.com).






