ANS-1394 · ACCOUNTING & FINANCIAL CONFIGURATION

How to Write Off Customer Debt or Credit in NetSuite?

Learn the essential steps to accurately clear outstanding customer balances using a Journal Entry and a zero-dollar customer payment.

Short answer

To write off customer debt or credit in NetSuite, create a Journal Entry to adjust Accounts Receivable, then apply a zero-dollar Customer Payment. This links the Journal Entry to the relevant invoice or credit, effectively closing the outstanding balance and preventing perpetual aging of transactions.

Scenario

Organizations often encounter situations where customer debts or credits need to be written off due to various reasons, such as uncollectible receivables or small residual balances. Without proper write-off procedures, these transactions can perpetually age on customer records, leading to inaccurate financial reporting and aging reports.

Solution

To effectively write off customer debt or credit in NetSuite, follow these steps:

  1. Create a Journal Entry:

    • Generate a Journal Entry for the specific amount to be written off.
    • Depending on whether a credit or a debit is being written off, this will be a DR or CR to Accounts Receivable.
    • In the Name field, ensure the applicable Customer is entered. This linkage is mandatory for the process to function correctly.
    • For the offsetting account, select an appropriate account. Typically, this will be an Expense account.
  2. Create a Customer Payment:

    • Initiate a new Customer Payment record, ensuring the payment amount is 0$.
    • On the "Invoices" subtab, select the specific invoice intended for write-off.
    • On the "Credits" subtab, select the Journal Entry that was just created. (If writing off a customer credit, reverse these instructions: select the credit on the "Credits" subtab and the Journal Entry on the "Invoices" subtab).
  3. Save the Payment:

    • Save the Customer Payment record.

    Upon saving, the write-off Journal Entry and the transaction being written off will be tied together. The zero-dollar Payment record may disappear or remain, particularly if discounts are involved to track General Ledger (GL) impact. This process effectively closes both the Journal Entry and the transaction, preventing them from perpetually aging on the customer's account, which is crucial for accurate financial reporting.

Expert NetSuite Support

Need help with this NetSuite issue?

Accounting & Financial Configuration consulting and configuration support

Talk to a consultant