Using AI to build a simple invoice chasing sequence that goes out automatically when a client is overdue without you having to ask

Most small business owners have unpaid invoices sitting right now that they haven't chased because writing that email feels uncomfortable. This post walks you through how to automatically follow up on unpaid invoices using AI — building a four-email escalation sequence you write once and reuse every time a payment goes overdue. The sequence works because it mirrors the psychological pressure of a real collections process: tone escalates gradually, and every email removes friction by including payment details directly.

According to a 2023 Xero report{:target="_blank"}, small businesses wait an average of 30 days beyond payment terms to get paid, and one in five invoices is paid late. That's not a client problem. That's a systems problem.

What You Need Before You Start

ChatGPT{:target="_blank"} or Claude{:target="_blank"}: AI tools you'll use to draft the email sequence. ChatGPT's free tier works. Claude's free tier works. You don't need a paid plan to complete this setup.

Google Sheets{:target="_blank"} or Airtable{:target="_blank"}: Your overdue invoice tracker. Google Sheets is free. Airtable's free tier currently supports up to 1,000 records per base — enough for most small businesses.

Gmail or Outlook: You'll use the built-in scheduling feature in either to queue emails in advance. No automation software required.

Time required: 45 minutes to 1.5 hours for initial setup; under 10 minutes per new overdue invoice after that.

Skill level: No coding required. Basic comfort copying and pasting between apps is enough.

---

Build an Automated Invoice Chasing Email Sequence with AI

The sequence covers four contact points: Day 1 after due (friendly nudge), Day 7 (polite follow-up), Day 14 (firm reminder), Day 21–30 (final notice with consequences). You generate all four in one AI session, then save them as reusable templates.

1. Open ChatGPT or Claude in your browser.

2. Paste the following prompt into the chat. Fill in the placeholder details before sending.

Write a four-email invoice follow-up sequence for a small business owner. Each email should escalate in tone. Use these details across all four:

• Business name: [YOUR BUSINESS NAME]
• Client name: [CLIENT FIRST NAME]
• Invoice number: [INVOICE #]
• Invoice amount: [AMOUNT]
• Original due date: [DUE DATE]
• Payment method: [e.g., bank transfer, PayPal link, cheque]

Email 1 — Day 1 after due date: Friendly and brief. Assume the oversight is accidental. Mention the invoice number and amount. Include payment instructions.

Email 2 — Day 7: Polite but clearer. Reference that you sent a previous reminder. Restate payment details. Keep it professional.

Email 3 — Day 14: Firm. No warmth added for its own sake. State clearly that the invoice is now 14 days overdue. Mention you need this resolved promptly. Include full payment details again.

Email 4 — Day 21–30: Final notice. Professional and direct. State that if payment is not received within 7 days, you will pursue further action (credit agency referral, late payment interest, or legal steps — pick one to include). Do not threaten. State it as a factual next step.

Format each email with a subject line, body, and sign-off. Do not use exclamation marks. Do not use filler language. Keep each email under 150 words.

3. Review the output. You should see four distinct emails with clearly escalating tone and consistent invoice details throughout.

4. Copy each email into a Google Doc or Word file. Label them Email 1 through Email 4. Leave the client-specific fields as placeholders — e.g., [CLIENT NAME], [INVOICE AMOUNT] — so you can fill them in per client later.

This is your master template set. You build it once. Every future overdue invoice takes under 10 minutes to process.

5. Re-prompt if any email misses the tone. A targeted instruction works better than regenerating everything.

Rewrite Email 3 to be firmer. It should read as if the sender is running a business, not apologising for asking to be paid. Keep it under 150 words.

You should see a revised version that removes hedging language.

---

Set Up Your Overdue Invoice Tracker

A simple spreadsheet is your manual CRM. You don't need accounting software to run this process.

6. Open Google Sheets and create a new spreadsheet.

7. Set up the following column headers in Row 1:

Client Name | Invoice # | Amount | Due Date | Days Overdue | Email 1 Sent | Email 2 Sent | Email 3 Sent | Email 4 Sent | Status | Notes

8. Add each overdue invoice as a row. Fill in the client name, invoice number, amount, and due date.

9. Use a formula in the Days Overdue column to calculate automatically.

=TODAY()-[due date cell] — for example: =TODAY()-D2

You should see the number of days since the due date update automatically each time you open the sheet.

10. Mark each email column with the date sent once you schedule it. Change the Status column to "Paid" when payment arrives.

This tracker tells you at a glance which clients need action and where each one sits in the sequence. It takes about five minutes to update per week.

---

Schedule All Four Payment Reminder Emails at Once in Gmail or Outlook

This is where the sequence becomes close to automatic. When a new invoice goes overdue, you fill in your templates and schedule all four emails the same day.

11. Open Gmail or Outlook and start composing Email 1.

12. Paste your Email 1 template and replace all placeholder fields with the specific client's details.

13. Schedule the send instead of sending immediately.

In Gmail: click the dropdown arrow next to the Send button, select "Schedule send," and choose or type the send date and time. You should see the email move to your Scheduled folder.

In Outlook: go to the Options tab in the compose window, select "Delay Delivery," and set the date and time under "Do not deliver before."

14. Repeat this for Emails 2, 3, and 4 — scheduling them at Day 7, Day 14, and Day 21 from the original due date.

15. Mark your tracker with today's date in each "Sent" column. You should see all four entries filled in for that client row.

If the client pays before Email 3 goes out, go to your Scheduled folder and delete the remaining queued emails. This takes 30 seconds.

---

When Something Goes Wrong

The AI output uses hedging language like "I hope this finds you well" or "I just wanted to follow up." The prompt didn't specify tone constraints clearly enough. Add this line to your prompt: "Do not use filler phrases. Do not apologise for following up. Write as someone who expects to be paid on agreed terms."

Gmail shows "Schedule send" but the email sends immediately. This usually happens if the scheduled time has already passed. Set the send time at least 10 minutes in the future, or use a specific future date.

A client says they never received Email 1 or Email 2. Check your Scheduled folder in Gmail or the Outbox in Outlook. If the email is still sitting there, a connectivity issue may have interrupted the send. Resend manually and note the date in your tracker.

---

What to Do Next

Build your tracker and run the AI prompt session this week. Get the four templates saved and ready before the next invoice goes overdue — not after.

If you want to extend this process to client onboarding and recurring communication, read how to use AI to build a client onboarding sequence.

---

FAQ

How do I automatically follow up on unpaid invoices without chasing clients manually? Build a four-email escalation sequence using AI (ChatGPT or Claude), save the templates, and schedule all four sends in Gmail or Outlook the day an invoice goes overdue. The emails go out automatically from that point — you only need to cancel them if the client pays early.

Can I set up an invoice chasing email sequence without accounting software? Yes. The method in this post uses AI to write the emails, a Google Sheet to track overdue invoices, and the built-in scheduling feature in Gmail or Outlook to send them. No accounting software, automation platform, or paid tools are required.

What should a late payment reminder email sequence include? At minimum: a friendly first nudge the day after the due date, a polite follow-up at Day 7, a firm reminder at Day 14, and a final notice at Day 21–30 that states what happens next if payment isn't received. Each email should include the invoice number, amount, due date, and payment instructions — every time.

Will a firm overdue invoice email damage my relationship with a long-term client? Tone calibration matters here. When you run the AI prompt, add a line like: "This is a long-term client. Email 3 should be firm but preserve the relationship — acknowledge the history before stating the overdue amount." The FSB research{:target="_blank"} is consistent on this: the problem is systemic, not personal, and clients generally respond to professional persistence without lasting damage.

What if a client ignores all four emails? Email 4 references a next step — late payment interest, credit agency referral, or formal demand. Follow through on whichever you stated. In the UK, the Late Payment of Commercial Debts Act entitles you to charge 8% above base rate on overdue B2B invoices. In the US, statutory protections vary: the Prompt Payment Act covers federal contracts, but for private B2B work, your contract terms govern what interest or penalties apply. State the step factually in Email 4, then act on it within the stated timeframe if there's no response.

Do I need a paid AI plan to write a four-email invoice reminder sequence? No. Both ChatGPT{:target="_blank"}'s free tier and Claude's free tier handle this prompt without issue. The sequence is generated in a single session — you're not running repeated queries or working with large documents.

Can I use this method if I already use QuickBooks or FreshBooks? Yes. The email templates you generate work independently of your accounting software. You're using the AI to write the emails and your email client to send them. If your accounting software has built-in reminders, you can still use this sequence for clients where you want more control over tone and escalation timing.