When customers make one payment covering several invoices, you can use Remittance Advice to match and reconcile these transactions efficiently in Kolleno.
This process ensures accuracy and keeps your ERP system (e.g., NetSuite) up to date without manual adjustments.
For a step-by-step demonstration, watch our short video guide:
Step 1 – Upload a Remittance File
Navigate to the Remittances section.
Upload your remittance file in CSV, Excel, or PDF format.
Once uploaded, you can view the invoices identified by your ERP system within Kolleno.
Step 2 – Select the Payment Transaction
Go to Bank Transactions.
Select the transaction that represents the customer payment.
Click Select Remittance.
Step 3 – Match the Payment to Invoices
Choose the uploaded remittance file that matches the payment amount.
If adjustments are needed, you can make them manually.
Review the list of invoices linked to this payment.
Step 4 – Review and Reconcile
Click Match to confirm the link between payment and invoices.
Go to Review and Reconcile.
Select the reconciled transaction and push it to your ERP (e.g., NetSuite).
Step 5 – Verify in ERP
Refresh your ERP system to confirm the reconciliation.
You should now see:
Each invoice balance reduced by payment remitted amount.
A payment record created against each invoice.