Skip to main content

How to Allocate a Payment Across Multiple Customers’ Invoices

Learn how to split one payment across invoices from different customers in Kolleno.

Kolleno Support avatar
Written by Kolleno Support
Updated yesterday

Sometimes a single bank payment covers invoices belonging to more than one customer. Kolleno allows you to allocate such payments across multiple customers’ invoices while keeping transactions correctly reconciled in your ERP (e.g., NetSuite).

For a step-by-step demonstration, watch our short video guide:


Step 1 – Select the Payment

  1. Navigate to Bank Transactions.

  2. Locate and select the received payment (e.g., $216.50).


Step 2 – Find the Invoices

  1. Search for the first customer (e.g., Karimon Dudley).

  2. Select the correct invoice (e.g., Invoice #53).

  3. Search for the second customer (e.g., Denise Batemanger).

  4. Select the correct invoice (e.g., Invoice #52).


Step 3 – Verify Invoice Selection

  1. Check that both invoices are listed in Selected Transactions.

  2. Confirm that the amounts match the total payment received (e.g., $216.50).

  3. Scroll down to perform a Balance Check:

    • Total transactions = total invoices = payment amount to apply.


Step 4 – Match the Payment

  1. Click Match.

  2. Review the breakdown preview:

    • A payment for $108 will be created for Karimon Dudley.

    • A payment for $108 will be created for Denise Batemanger.

    • Each will be applied to their respective invoices.


Step 5 – Review and Reconcile

  1. Go to Review and Reconcile.

  2. Select the transaction and push it to NetSuite.

  3. Refresh after a short delay to confirm updates.


Step 6 – Verify in ERP

  1. Open each customer’s invoice in NetSuite.

  2. Confirm that both invoices are reduced to zero and show Paid in Full.

  3. Review each invoice history:

    • The correct payment amount was applied to each customer’s account.


Did this answer your question?