Skip to main content

How to Match One Payment to Multiple Invoices Using Remittance

Learn how to apply a single payment to multiple invoices using remittance advice for faster reconciliation.

Kolleno Support avatar
Written by Kolleno Support
Updated yesterday

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

  1. Navigate to the Remittances section.

  2. Upload your remittance file in CSV, Excel, or PDF format.

  3. Once uploaded, you can view the invoices identified by your ERP system within Kolleno.


Step 2 – Select the Payment Transaction

  1. Go to Bank Transactions.

  2. Select the transaction that represents the customer payment.

  3. Click Select Remittance.


Step 3 – Match the Payment to Invoices

  1. Choose the uploaded remittance file that matches the payment amount.

    • If adjustments are needed, you can make them manually.

  2. Review the list of invoices linked to this payment.


Step 4 – Review and Reconcile

  1. Click Match to confirm the link between payment and invoices.

  2. Go to Review and Reconcile.

  3. Select the reconciled transaction and push it to your ERP (e.g., NetSuite).


Step 5 – Verify in ERP

  1. Refresh your ERP system to confirm the reconciliation.

  2. You should now see:

    • Each invoice balance reduced by payment remitted amount.

    • A payment record created against each invoice.

Did this answer your question?