Credit period is the number of days a customer has to pay after your invoice date, and the due date is simply the invoice date plus that period. Net 30 on an invoice means payment is due within 30 days of the invoice date. Recording the due date as its own field is what lets you see, at a glance, who is overdue.
What do three clients on different terms look like?
Take three hypothetical clients with invoices of ₹20,000 each, checked on 15 November.
| Client | Invoice date | Terms | Due date | Status on 15 Nov |
|---|---|---|---|---|
| Client A | 10 Oct | Net 15 | 25 Oct | 21 days overdue |
| Client B | 12 Oct | Net 30 | 11 Nov | 4 days overdue |
| Client C | 20 Oct | Net 45 | 4 Dec | Not yet due, 19 days left |
The sums: 10 Oct plus 15 days is 25 Oct. 12 Oct plus 30 days is 11 Nov, because October has 31 days. 20 Oct plus 45 days is 4 Dec: 11 days to reach 31 Oct, 30 more through November, and 4 into December.
What is the difference between invoice date and due date?
The invoice date is the day you issue the invoice; the due date is the day payment is expected. A common mistake is to chase from the invoice date rather than the due date, which is early, or to forget that a late invoice pushes the due date back. Agree whether the days count from the invoice date or from delivery, and write it on the invoice.
What does the due-date column do for me?
- Put invoice date in column B and credit days in column C.
- In column D, calculate the due date with =B2+C2 and format the cell as a date.
- In column E, calculate days overdue with =IF(F2="Paid",0,MAX(0,TODAY()-D2)), where F holds Paid or Open.
- Filter column E for values above 0, and you have your overdue list.
- Sort by days overdue so the oldest comes first.
This works in both Excel and Google Sheets. The cell formatting for column D must be a date, not general, or you will see a number such as 46000 instead of a date.
What does Net 30 or 2/10 net 30 mean?
- Net 30: the full amount is due in 30 days.
- 2/10 net 30: a 2 percent discount if paid in 10 days, otherwise the full amount in 30.
- Due on receipt: payable straight away.
- End of month terms differ between businesses, so ask what is meant before relying on it.
How should I follow up on overdue invoices?
- A polite reminder on the due date or the day after.
- A second message a week later, quoting the invoice number and amount.
- A call at two to three weeks, to ask whether anything is blocking payment.
- A written note on what happens next, if the delay continues.
Rules on interest for late payment and on notices are a legal matter; ask a professional before relying on any of it.
How do I choose a credit period for a new client?
There is no standard answer, and it should reflect your own cash needs and the client's behaviour. Some practical starting points follow.
- Start new clients on shorter terms, such as 7 or 15 days, or ask for an advance.
- Offer longer terms such as 30 days to clients who have paid on time before.
- Match your terms to your own bills: if you pay suppliers in 15 days, you cannot comfortably wait 45 for customers.
- Write the agreed terms on the quote and on every invoice, not just in a chat message.
Keep the record clean
Mark an invoice Paid on the day money reaches the bank, and check it against your statement. If you receive part-payments, record each one and keep the balance visible. SpendixAI is aimed at tracking your own spending, so a receivables list like this belongs in your sheet or accounting software.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
