Customer Deductions and Short Pays: A Resolution Workflow

Separate the cash from the claim on every short payment, gather evidence by deduction reason, and record each outcome correctly in NetSuite, SAP, and Sage.

The bank shows $950 against a $1,000 invoice. The remittance says the $50 is for damaged goods. AR can apply the $950 in a minute. Nobody in AR can say whether the goods were actually damaged. If the $50 does not get an owner today, it will sit in aging until someone writes it off to close the month.

Unowned claims like this lose money without anyone ever deciding to give it away. This guide sets out a workflow that keeps the cash and the claim apart, gathers the right evidence for each kind of deduction, and records the outcome so you can tell recovery from write-off.

Apply the cash, then open the claim

A short payment is two events. The receipt is a cash application task. The withheld amount is a claim against an identified invoice. Handle them separately.

  1. Apply the amount the remittance supports to the invoice it names.
  2. Open a claim record for the difference with the customer’s reason, the invoice, the remittance, and the debit memo if there is one.
  3. Assign an owner who can actually check the facts (shipping, pricing, sales operations) and a response date.
  4. Keep the open balance visible in aging, tagged as disputed so collections does not chase it as ordinary late payment.

If you cannot identify which invoice the payment covers, that is a matching problem, not a deduction. Leave the receipt in the unapplied queue until someone confirms where it belongs. See the unapplied cash guide.

Gather evidence by deduction reason

Customer’s reasonWhat to checkWho can confirm
Short shipmentOrder, packing list, shipment record, proof of delivery, customer’s receiving countShipping or warehouse
Damaged goodsDelivery exception, inspection evidence, return authorization, credits already issuedCustomer service or quality
Price differenceBilled unit price, order, approved quote, contract or price amendment and its effective dateSales or pricing
Promotional allowance or rebateProgram terms, eligible products and dates, prior credits for the same salesSales operations or commercial finance
Freight chargeInvoice line, shipment reference, agreed freight termsLogistics or the account owner
No reason givenReceipt, invoice, amount withheldAR asks the customer for the claim detail

Before approving anything, look for an existing credit. Customers sometimes cite an allowance you already credited, or send the same debit memo twice. Record the debit memo number and check whether another receipt or credit already references it. A second copy of a claim should lead the reviewer to the first record, not create a second credit.

Manufacturers face a wider set of claim types (warranty chargebacks, OTIF penalties, billbacks). Those are covered in the manufacturing chargebacks guide.

Record one of four outcomes

“Closed” is not an outcome. Every claim should end in one of these states, and your reporting should keep them apart.

OutcomeWhat it meansTypical entry (illustrative)
RecoveredCustomer paid the withheld amount after the disputeDebit cash, credit receivables
CreditedClaim approved on the evidence; you issue a creditDebit a returns, allowances, or deductions account; credit receivables
Written offAuthorized decision to stop pursuing itDebit a deduction write-off or bad debt account; credit receivables
Still openHas an owner, evidence request, and next action dateNo entry yet

Which accounts you use is a chart-of-accounts and revenue policy question. Pricing and promotional credits often reduce revenue rather than hitting expense; confirm treatment with your controller or auditors.

Microsoft’s Dynamics 365 deduction workbench documents matching a deduction to a credit, splitting it, denying it, and writing it off as separate actions, because each has different accounting and collection effects. Microsoft’s deduction workbench guide. Check how your own system distinguishes them before you report a closure rate.

Worked example: a split claim (illustrative)

A retailer withholds $2,400 from a $20,000 payment and attaches a debit memo citing a promotional allowance and a shortage.

  • Sales operations confirms the promotion: $1,500 is supported by the program terms and has not been credited before.
  • Shipping finds proof of delivery for the full quantity on the line the retailer says was short: the $900 shortage is unsupported.
  • Check: $1,500 + $900 = $2,400.

Issue a $1,500 credit and apply it to the invoice. Keep $900 open, and send the retailer the proof of delivery with a request for payment. The invoice should now show $900 due, tagged as a disputed balance with a response date. If the retailer later pays, record a $900 recovery; if your policy authorizes closing it, record a $900 write-off. Do not let the $900 disappear into the $1,500 credit.

How this works in NetSuite, Sage Intacct, SAP, and Sage 100

ERPBehaviour the sources documentWhat to watch
NetSuiteOpen credit memos can be applied on the Customer Payment page alongside payments; Auto Apply can target the oldest amounts due. Credit memos · Customer PaymentA credit meant for a specific invoice landing on the oldest one instead
Sage IntacctA debit memo adjustment increases the balance due; a credit memo adjustment decreases it. At the top level of a multi-entity, multi-currency company, an adjustment needs a base currency and location. AR adjustmentsAdjustments created in the wrong entity or currency
SAP S/4HANA CloudA partial payment leaves the original invoice and payment open; a residual item clears both and creates a new open item linked to the invoice. Dispute cases are available for both when Dispute Management is installed. SAPCollectors seeing different open items for the same $50 net balance
Sage 100In Cash Receipts Entry, Amount Posted reduces the invoice balance by the amount entered, and the default can be the full invoice balance when enough money remains on the receipt. Field referenceOn a check covering several invoices, the default paying one in full and leaving the short pay on the wrong invoice

In SAP, ask the controller which method (partial payment or residual item) applies to which scenario. In the $950 example, both leave a net $50, but a collector working from the residual item needs its link back to the original invoice, or a cleared invoice can make an unresolved deduction vanish from follow-up.

Run a weekly review from the claims register

The register should hold the original deduction, customer, reason code, invoice, owner, due date, and amount still open. Each week:

  • Group open claims by customer and reason. Repeated shortages go to shipping; recurring price claims go to sales; credits that were approved but never applied go to cash application.
  • Pick the largest repeatable cause your team can act on, and check whether it recurs on the next batch of invoices. A string of freight deductions from one customer is worth checking against the freight terms on their customer record before you blame the customer.
  • Review small deductions too. Policy may let AR clear amounts under a threshold without investigation, but a customer taking $40 on every invoice is a pattern worth a phone call.
  • Compare outcomes, not just backlog. A shrinking backlog can hide rising write-offs.

Track time to apply the cash separately from time to decide the claim. A fast posting says nothing about how long the customer waited for an answer.

What goes wrong

  • The default allocation hides the short pay. The ERP pays the first invoice in full and leaves the shortfall on the wrong one.
  • Duplicate credits. A claim is credited, then the customer deducts it again on the next payment.
  • Denied claims with no follow-up. The decision is made but collections never gets the evidence to request payment.
  • Write-off as the default closure. The month-end push clears old claims without anyone authorizing the decision.

Test before you automate

In a sandbox, run a check paying several invoices with one short pay, a payment with no usable reference, a debit memo that arrives twice, and a split claim like the example above. Tie the deposit to the receipts batch, then open customer aging and confirm the disputed amount sits on the intended invoice. Those two checks catch different errors. If you use SAP, run one short payment as a partial payment and one as a residual item and compare what the customer sees on a statement.

Deduction handling checklist

  • Cash applied to the invoice the remittance names; difference opened as a claim the same day.
  • Claim has reason, owner, evidence request, and response date.
  • Existing credits and earlier copies of the debit memo checked first.
  • Partial approvals split into credited and still-open amounts.
  • Outcome recorded as recovered, credited, written off, or open.
  • Write-offs approved by someone with authority, not cleared to close the batch.
  • Weekly review by customer and reason, with one root cause assigned.

Related: the collections aging review shows how disputed balances should appear on the call list, and the cash application guide covers the matching side.

See this workflow on your own ERP data

ProcIndex connects to NetSuite, Sage Intacct, and QuickBooks. Bring a recent batch and we'll walk through it with your team.

Book a Demo See how the AR agent handles this