How to resolve overdue, disputed, and short-paid invoices
Every distributor has a few invoices that stay unpaid long after the goods were delivered. This guide shows how to deal with three kinds of trouble: bills that are simply late, bills the customer disputes, and bills paid short. The aim is to turn each one into a case with an owner and a date, so collection does not depend on who remembers to phone.
Why this matters
A hardware distributor in Coimbatore with ₹60 lakh of monthly sales can easily have ₹8 lakh stuck in small disputes: a carton that arrived damaged, a rate the customer remembers differently, a deduction taken without a note. Each amount looks too small to chase, but together they decide whether the owner can pay suppliers on time. Old invoices also get harder to collect, because the customer forgets the delivery and the driver has changed.
Before you start
- A list of all open invoices with invoice number, date, due date, amount and customer name.
- The customer ledger showing the agreed credit terms for each customer.
- A promise log: one line per commitment a customer makes, with the date, the amount and who they spoke to.
- Bank statement access, so receipts can be matched to invoices by reference.
- One named person who chases, and one person with authority to approve a credit note or a discount.
Step by step
- The accounts receivable clerk raises the invoice only from approved work: a signed delivery challan or a confirmed order. The invoice states the order number, quantity and rate, so that a later dispute can be checked against the same papers.
- The sales manager records the payment terms and the expected method (bank transfer, cheque, cash) in the customer ledger when the customer is set up, and again whenever terms change. A short note such as "30 days, transfer only, 2 per cent deduction not allowed" saves arguments later.
- The owner or the sales manager sends the bill with the payment details and keeps the payment advice the customer returns. If the customer asks for a copy, the same invoice is resent, never a rewritten one.
- The accounts receivable clerk reviews overdue invoices every week. For each one, the clerk phones, records what the customer said in the promise log, and sets a date to check again. A dispute gets its own line with a reason (damage, rate, quantity, quality) and a name against it.
- For a dispute, the sales manager gathers the delivery proof and the order, decides whether the claim is right, and either issues a credit note for the agreed amount or confirms the full amount is due. The customer is told the decision in writing the same day.
- For a short payment, the clerk compares the bank receipt with the invoice, finds the difference and asks the customer for the reason. The shortfall stays open as its own line until it is explained and either collected, written off by the owner, or covered by a credit note.
- The sales manager matches each receipt to its invoice using the bank reference and closes the invoice only when the balance is zero. Any receipt that cannot be matched goes on a short list reviewed every Friday.
Where the customer deducts tax at source from the payment, the shortfall is often that deduction. Treat it as a separate line, ask for the deduction certificate, and do not call the invoice closed until the paperwork matches. Check the current rule on the official portal or with your CA before acting.
Who does what
| Role | What they do | Record they own |
|---|---|---|
| Accounts receivable clerk | Raises invoices, chases overdue bills, logs promises, spots short payments | Invoice and promise log |
| Sales manager | Sets terms, settles disputes, matches receipts and closes | Customer ledger and bank reference |
| Owner | Sends or approves bills to large customers, approves write-offs and credit notes | Payment advice and write-off approval |
Common mistakes
- Chasing by memory instead of a promise log, so nobody can say how many times a customer has promised and failed.
- Letting a dispute sit inside the overdue list with no reason written, which makes the whole customer look like a bad payer.
- Closing an invoice because "most of it came", leaving a small balance that is never collected.
- Issuing a credit note verbally or by message without a number, so the ledger and the customer disagree for months.
- Skipping the bank reference, which leaves receipts parked as unmatched and invoices looking overdue when they have been paid.
How to tell it is working
- Days overdue. For every open invoice, subtract the due date from today. Take the average and also note the single oldest. Both should fall month on month, and nothing should cross the limit you set, for example 60 days, without the owner having seen it.
- Unmatched receipts. Count the bank credits at month end that are not linked to an invoice. The number should be close to zero, and any item should be older than a week only if the customer has been asked to confirm it.
- Broken promises. Divide the promises whose date has passed without payment by all the promises that fell due in the month. If a quarter or more are broken, the follow-up is too soft or the terms are unrealistic for that customer.
Questions people ask
Who owns invoice to cash?
The sales manager owns the customer relationship and the final close, and the accounts receivable clerk owns the daily chasing. The owner steps in for large amounts and write-offs. One name should be against every open invoice.
What is the minimum record for invoice to cash?
Keep the invoice, the customer ledger with agreed terms, a promise log and the bank reference for each receipt. With these four you can answer who owes what, since when, what they promised and what has actually arrived.
When should a case stop?
A case stops when the balance is zero, when a credit note has been issued and agreed, or when the owner signs a write-off with a reason. Do not stop a case just because the customer has gone quiet. Record the last contact and move it to a longer review cycle instead.
Can a spreadsheet support this stream?
Yes, if it has one row per invoice, a separate sheet for promises, and one person who updates it daily. It breaks down when several people edit it without a rule about who changes what, or when the dispute reasons are typed differently each time.
What should the owner review?
Once a week, the owner should look at the oldest invoices, the disputes older than 15 days, the broken promises and the unmatched receipts. The owner decides on write-offs and on stopping supply to customers who keep breaking promises.