Payment collection tracker with days outstanding.
One row per open invoice: the reference, the dates, the value, what has been received, the balance, how many days it is past due, the status, and the next action. Then an ageing summary in five bands, so the invoice that has been outstanding for a hundred days is visible instead of averaged away. Copy it as CSV and use it on your next review.
The template, filled with an example
The example carries six invoices for three fictional clients, with an as-on date of 4 October 2026. Days outstanding is calculated from the dates shown, so you can check it rather than trust it.
Illustrative example only. Every client name, invoice number, amount, and date on this page is invented. The ageing bands are a suggested structure, not a standard, and where your follow-up differs — a 15-day cycle rather than 30, a different part-payment policy — the bands are yours to change.
Open invoices
| Invoice ref | Client | Invoice date | Due date | Value (INR) | Received (INR) | Balance (INR) | Ageing | Status | Next action |
|---|---|---|---|---|---|---|---|---|---|
| INV-2026-0187 | Sample Client Enterprises | 2026-10-04 | 2026-11-03 | 29,736.00 | 0.00 | 29,736.00 | Not yet due, 30 days to go | Open, not yet due | Send the invoice with bank and UPI details |
| INV-2026-0181 | Sample Client Private Limited | 2026-09-20 | 2026-09-28 | 1,18,000.00 | 60,000.00 | 58,000.00 | 6 days overdue | Part paid | Call the finance contact; agree a date for the balance |
| INV-2026-0172 | Sample Client Private Limited | 2026-08-18 | 2026-09-02 | 86,500.00 | 0.00 | 86,500.00 | 32 days overdue | Unpaid | Second reminder, then call the named approver |
| INV-2026-0159 | Sample Retailer Trading Co | 2026-06-24 | 2026-07-09 | 3,40,000.00 | 2,00,000.00 | 1,40,000.00 | 87 days overdue | Part paid, part payment unallocated | Reconcile the part payment against the ledger first |
| INV-2026-0150 | Sample Retailer Trading Co | 2026-06-11 | 2026-06-26 | 45,000.00 | 0.00 | 45,000.00 | 100 days overdue | Disputed | Get the dispute reason in writing before chasing payment |
| INV-2026-0146 | Sample Client Enterprises | 2026-05-28 | 2026-06-30 | 67,000.00 | 67,000.00 | 0.00 | 96 days overdue | Paid in full on 18-07-2026 | None — file the receipt against the invoice |
| Total | 6 invoices | — | — | 6,86,236.00 | 3,27,000.00 | 3,59,236.00 | — | — | — |
6 invoices are worth 6,86,236.00, of which 3,27,000.00 has been received. The balance outstanding is 3,59,236.00 — and one of those invoices is paid in full, so it is on the list for reference rather than for chasing.
Ageing of the outstanding balance
| Band | Outstanding (INR) |
|---|---|
| Not yet due | 29,736.00 |
| 1 to 30 days overdue | 58,000.00 |
| 31 to 60 days overdue | 86,500.00 |
| 61 to 90 days overdue | 1,40,000.00 |
| More than 90 days overdue | 45,000.00 |
| Total outstanding | 3,59,236.00 |
The bands exclude the invoice that has been paid in full, so the ageing total equals the balance on the tracker. That equality is worth checking every time — if it does not hold, one of the two is being edited without the other.
Review
- Reviewed on
- 04-10-2026
- Reviewed by
- Sample Accounts Owner (example)
- Overdue invoices on this list
- 4 of 6
- Oldest overdue invoice
- INV-2026-0150, 100 days overdue, disputed
- Action agreed this week
- Two calls, one written dispute response, one reconciliation
- Next review
- Weekly, same day each week
Payment collection tracker (CSV — illustrative example data) As on,2026-10-04 Invoice ref,Client,Invoice date,Due date,Invoice value (INR),Received (INR),Balance (INR),Days outstanding,Status,Next action INV-2026-0187,Sample Client Enterprises,2026-10-04,2026-11-03,"29,736.00",0.00,"29,736.00","Not yet due, 30 days to go","Open, not yet due",Send the invoice with bank and UPI details INV-2026-0181,Sample Client Private Limited,2026-09-20,2026-09-28,"1,18,000.00","60,000.00","58,000.00",6 days overdue,Part paid,Call the finance contact; agree a date for the balance INV-2026-0172,Sample Client Private Limited,2026-08-18,2026-09-02,"86,500.00",0.00,"86,500.00",32 days overdue,Unpaid,"Second reminder, then call the named approver" INV-2026-0159,Sample Retailer Trading Co,2026-06-24,2026-07-09,"3,40,000.00","2,00,000.00","1,40,000.00",87 days overdue,"Part paid, part payment unallocated",Reconcile the part payment against the ledger first INV-2026-0150,Sample Retailer Trading Co,2026-06-11,2026-06-26,"45,000.00",0.00,"45,000.00",100 days overdue,Disputed,Get the dispute reason in writing before chasing payment INV-2026-0146,Sample Client Enterprises,2026-05-28,2026-06-30,"67,000.00","67,000.00",0.00,96 days overdue,Paid in full on 18-07-2026,None — file the receipt against the invoice Total,6 invoices,—,—,"6,86,236.00","3,27,000.00","3,59,236.00",—,—,— Ageing band,Outstanding (INR) Not yet due,29736.00 1 to 30 days overdue,58000.00 31 to 60 days overdue,86500.00 61 to 90 days overdue,140000.00 More than 90 days overdue,45000.00 Total outstanding,359236.00
The next-action column is the one that turns this from a report into a work list. Every overdue row in the example has one, because a tracker that only records status records a condition rather than a decision.
How to fill it in
Four steps, and the order matters more than the effort.
Copy it and add a column for the review date
The tracker is only useful if it has a date on it. A list without an as-on date cannot be compared with last week's list, and a comparison is most of the value.
Add every open invoice, including the ones you expect to be paid
Part-paid and disputed invoices belong on the list from the start. Excluding the awkward ones makes the outstanding figure attractive rather than true.
Work out the balance, not the invoice value
Balance is invoice value minus everything received against it. Chasing the invoice value for an invoice that has been part paid is a good way to lose the relationship over money you already have.
Give every overdue row a next action and an owner
A status of “unpaid” is a condition, not a plan. “Call the finance contact on Tuesday and agree a date for the balance” is a plan, and it can be checked at the next review.
When to use this, and when to stop
A tracker is the first thing a business automates and one of the last things it should automate badly, because the numbers it depends on have to be right first.
When this template is the right tool
- You have a manageable number of open invoices and currently track them in a spreadsheet that is a week out of date.
- You want one place to see what is due, what is overdue, and what to do about each row.
- You are still learning which clients pay late and by how much, and the pattern is not obvious to you yet.
- You need a list you can take into a review and walk through in fifteen minutes.
When you have outgrown it
- The tracker is rebuilt from scratch each month rather than updated, so nothing is ever compared with anything.
- Payments arrive without a reference and cannot be matched to an invoice without manual work.
- Nobody can produce an outstanding figure for a single client without exporting from two systems.
- Chasing is a person remembering, and the oldest invoice is the one most likely to be forgotten.
The same process in NoxOrigin
A payment is recorded against the invoice it settles, and a promise to pay can be recorded with it, carrying a date the follow-up can point at. Receivables then stay visible per client and by age, so “who owes us and since when” is a queue rather than a monthly reckoning — and quoted, billed, collected, and outstanding remain four separate numbers rather than one figure that always looks acceptable.
- Reports & Economics in NoxOriginQuoted, billed, collected, and outstanding value by client and project, with a path from any number back to the records behind it.
- Receivables ageing calculatorBucket open invoices into bands and see the totals, the share, and what is outstanding in total.
- Quote to cash for small businessWhere the invoice came from, the payment recorded against it, and the promise to pay that carries a date.
- Client profitabilityQuoted, billed, collected, and outstanding read as four separate states per client.
- GST invoice templateThe document at the start of this chain, and the due date is set on it.
- Day-end closing sheetFor a counter that also takes payment on the day, rather than on invoice terms.
Payment collection tracker questions
What is the difference between days outstanding and days overdue?
Days outstanding is how long the invoice has existed. Days overdue is how far past the due date it is, which is the number that should drive your follow-up. The example shows both, because a young invoice and a 100-day-old one sitting next to each other in the same total is exactly how an old receivable gets lost inside a healthy-looking number.
How many ageing bands should I use?
As few as still change your behaviour. The example uses five — not yet due, 1 to 30, 31 to 60, 61 to 90, and more than 90 — because each band maps to a different action. If two bands always get the same treatment, merge them; a band nobody acts on is decoration.
What do I do about a part payment?
Record it against the invoice and record the remaining balance as the outstanding figure, not the original value. The example flags one part payment as unallocated, because money that arrived without a reference is a different problem from money that was short — and treating them the same is how a balance gets chased after it has already been paid.
Should a disputed invoice sit in the ageing bands?
Yes, but labelled as disputed, exactly as the example does. Hiding it makes the outstanding total wrong; leaving it unlabelled makes the ageing wrong. A dispute is a status on the invoice, not a reason for it to leave the list.
Stop rebuilding the outstanding list every month.
If payments cannot be matched to invoices without manual work, that matching is the thing worth fixing first.