How to Allocate a Slight Overpayment and Round Off in a Single Customer Payment Entry?

Requirement

I have a customer invoice in NetSuite with an amount of 3,475.50, but the customer paid 3,476.00. I want to apply 3,475.50 to the invoice and allocate the extra 0.50 as a rounding adjustment, all within a single Customer Payment entry.

However, I do not see any option for Write-off or Discount on the Customer Payment page. I am logged in as Administrator, so permissions shouldn’t be an issue.

What is the best way to handle this scenario in a single transaction? Do I need to enable any specific settings in Accounting Preferences, or is there another recommended approach?

Solution

Here’s how you can record the Customer Payment:

  1. Transactions > Customers > Accept Customer Payments
  2. Select the Customer
  3. In Apply tab, set the following:
  4. In Payment Amount, add the original payment 3,476.00
  5. In Invoices subtab, select the Invoice to be applied. Payment will be the original Invoice amount which is 3,475.50
  6. Save the record

Notice that Summary tab from the upper right corner of record shows Unapplied amount of .50. This Unapplied amount can be applied to another Invoice but if you wanted to write-off the amount, you can create a manual journal entry and use your preferred account where to write off the balance.

Leave a comment

Your email address will not be published. Required fields are marked *