When you have sent an invoice and heard nothing, keep a follow-up log: one row per contact, with the date, the channel, who replied, what they said and the date they promised. The log turns a stretch of ignored messages into a clear record, and it shows you the moment a promised date slips for the second time.
What columns should the log have?
- Invoice number and client, so the log can be filtered by invoice.
- Date of contact.
- Channel: email, chat message or phone call.
- Who replied, or none.
- What they said, in your own words, briefly.
- Promised date, if any.
- Next follow-up date.
One line per contact is enough. If a call was made, write the name of the person and the time. A call with no note is a call you will not remember in a fortnight.
What does one invoice's log look like?
Hypothetical invoice INV-212 for ₹35,000, sent on 3 October:
| Date | Channel | Replied | What they said | Promised date |
|---|---|---|---|---|
| 10 Oct | No one | No reply | None | |
| 14 Oct | Chat | Accounts | Will pay this week | 20 Oct |
| 21 Oct | Call | Accounts | Approval still pending | 28 Oct |
| 29 Oct | Chat | No one | No reply | None |
Read the log from the top. Two promised dates, 20 October and 28 October, have passed. The first slip was a surprise. The second tells you the problem is not the date but an approval that nobody is pushing.
After any phone call, send a two-line message that repeats what was agreed: the invoice number, the amount and the date they gave you. It costs a minute, and it turns a spoken promise into something you can quote.
Keep your messages short and polite and keep the log factual. Words such as promised and confirmed are better than words such as ignored or avoiding.
Count the slips as you go. One missed date is an accident. Two is a pattern, and three means the invoice is no longer waiting for payment but for a decision. At that point, write to the person who commissioned the work and quote your log: the invoice, the three dates given and what happened each time. Keep the tone as even as the log itself, and offer a concrete way to settle it, such as paying by UPI or NEFT today.
What do I do when the promised date slips again?
- Reply on the same day, quoting the promised date back to them.
- Ask who owns the approval and whether it can be sent to that person directly.
- Ask for one named date and one named person, in writing.
- Move to your reminder schedule if you have one, and mark the log accordingly.
- If the amount is large, think about asking the person who commissioned the work to step in.
Which formulas help?
To count promised dates that have passed with the invoice still unpaid, with promised dates in F, the invoice's paid date in H and the data in rows 2 to 200:
=COUNTIFS($F$2:$F$200,"<"&TODAY(),$H$2:$H$200,"")
To set the next follow-up one day after a promise, in G2 use =F2+1. Both work in Excel and Google Sheets.
How do I keep the log from becoming a chore?
- Add a row immediately after each contact, not at the end of the week.
- Keep one file for all invoices rather than a new page per client.
- Paste the exact promised date from the reply.
- Review the log every Monday and clear what has been paid.
When a payment finally arrives, the credit date in your bank statement closes the loop. SpendixAI can import that statement, and the date can then be written against the invoice in your log.
Before you send the next message
- Read the last three lines of the log.
- Quote the promised date and amount.
- Ask for one date.
- Write down what you sent.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


