Apply an unapplied NetSuite customer payment to the right invoice

Start with the existing NetSuite customer payment and its remittance. Identify the intended open invoice and apply the supported amount before treating the balance as overdue.
Upload a case

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.

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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.