Apply an unapplied NetSuite customer payment to the right invoice
Key facts
Match the receipt to the customer, currency, A/R account and, in OneWorld, the subsidiary. Review the invoice selection and any balance left after processing.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Find the recorded receipt and intended open invoice
Start with the original NetSuite transaction and bank reference. Compare the customer ID, amount and remittance with the invoice. Confirm the A/R account and, for a customer shared across subsidiaries in OneWorld, check the subsidiary against the invoice. Review currency before searching for an invoice. Oracle documents that with Multiple Currencies enabled, currency selection filters the invoices, credits and deposits available on the Apply subtab.
In Customers > Accounts Receivable > Accept Customer Payments, find the original transaction and select Edit. Review Auto Apply, then use the Apply subtab to select only the intended invoice and amount. Save the application on the existing payment. NetSuite can remember the preference from the prior payment entry, so check the selected invoices each time. If the correct invoice is absent, investigate the customer, subsidiary, A/R account and currency before changing the payment or invoice.
Worked example: apply $4,200 of $6,000
Suppose a $6,000 receipt is on file and remittance clearly identifies an open $4,200 invoice. Apply $4,200 to that invoice and leave the remaining $1,800 for reconciliation when the customer has not identified another invoice. Reopen the invoice and confirm the applied transaction and the amount due.
Check the original payment for the $1,800 unapplied balance and capture its reference. If the ledger already shows a separate customer deposit for this receipt, trace that record and reconcile its balance before closing the exception. The full bank receipt must reconcile once to the $4,200 allocated and $1,800 remaining.
Hold unresolved differences for cash application
Record the remittance, payment reference, linked invoice and remaining amount. If any key reference differs, queue it for cash application review and check the ledger before issuing a payment reminder.
Sources: Oracle’s NetSuite Customer Payment guide and its guidance on correcting payments to invoices.


.webp)