Client Dues & Ageing (Excel)
Every unpaid bill gets older every day. This workbook lists your bills with their credit period and the money received, works out how many days each one is overdue, and builds an ageing report per client in the usual buckets. A reminder message for each client is ready to copy into WhatsApp or email.
Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.
Preview
Real view of the file with its sample data (yellow cells are where you type).
| Client | Total due | Not due | 1-30 | 31-60 | 61-90 | 90+ |
| Gupta Enterprises | ₹ 59,500 | ₹ 0 | ₹ 23,500 | ₹ 0 | ₹ 36,000 | ₹ 0 |
| Delhi Office Supplies | ₹ 18,200 | ₹ 18,200 | ₹ 0 | ₹ 0 | ₹ 0 | ₹ 0 |
| Mehta & Sons | ₹ 4,800 | ₹ 0 | ₹ 0 | ₹ 0 | ₹ 4,800 | ₹ 0 |
What's inside
- Bills sheet: client, bill number, bill date, credit days, amount and amount received; balance, due date and days overdue calculate themselves
- Ageing sheet: one row per client with total due split into not yet due, 1-30, 31-60, 61-90 and over 90 days
- A polite reminder message per client with the amount in Indian number style
- "As on" date that you can change to see the position on any day
How to use it
- On the Clients sheet type your clients' names and phone numbers (replace the samples).
- On the Bills sheet enter each bill: pick the client, type the bill number, date, credit days (for example 30) and amount.
- When money comes in, type it in the Received column of that bill. Part payments are fine: add them up in the same cell, for example =20000+15000.
- Open the Ageing sheet. Each client's outstanding amount appears in the right age bucket. The "As on" date is today unless you type another date.
- Copy a client's reminder text and paste it into WhatsApp or an email.
Tips
- Sort the Ageing sheet by the 90+ column (Data › Sort) to see who to call first.
- A bill with nothing left to pay shows a balance of 0 and drops out of the ageing.
- Keep one file per financial year; carry unpaid bills forward by copying them to the new file.
Questions and answers
What is an ageing report?
It groups money owed to you by how long it has been due. Old dues are harder to recover, so they need attention first.
Days overdue are counted from which date?
From the due date, which is the bill date plus the credit days. A bill that is not yet due shows in the "Not due" column.
Can I use it for my suppliers too?
Yes. Make a copy, rename the Clients sheet to Suppliers and list the bills you have to pay.