How to use AI to build a simple accounts receivable follow-up system that chases invoices without you making awkward calls

Unpaid invoices pile up because following up feels awkward, so you delay, and then the money gets harder to collect. This post walks you through building a repeatable AI invoice follow-up email system for your small business — one that sends professional payment reminders at every stage without you drafting a single email from scratch. The mechanism is simple: AI generates personalized, tone-calibrated emails from raw invoice data, and a spreadsheet tells you when to send them.

A U.S. Bank study{:target="_blank"} widely cited in SMB finance literature found that 82% of small business failures trace back to cash flow problems. Late invoices are a primary driver. This is a survival-level task.

What you need before you start

ChatGPT{:target="_blank"} (GPT-4o) or Claude{:target="_blank"} (Claude 3.7 Sonnet): Either works for this workflow. Both generate multi-step email sequences from plain-language input. Free tiers work with limitations; ChatGPT Plus and Claude Pro are $20/month each and remove those limits. Check current pricing on their sites before subscribing.

Google Sheets{:target="_blank"} or Excel: Your tracking infrastructure. Free with a Google account.

Time required: 1–2 hours to build the system; under 30 minutes per week to run it.

Skill level: No coding required. You need basic comfort with spreadsheets and copy-paste.

---

Why Invoice Follow-Up Falls Apart (And Why AI Changes That)

Most small business owners know they should follow up faster. The Atradius Payment Practices Barometer{:target="_blank"} shows that invoices over 60 days late have roughly a 50% chance of full collection. The window closes fast.

The problem is not knowledge. It is friction. Calling feels confrontational. Writing a firm email to someone you have a relationship with feels uncomfortable. So you wait. Then you wait more.

AI removes the drafting friction entirely. You paste in invoice details. It returns a ready-to-send email calibrated to the right tone for that stage of follow-up. You review, adjust if needed, and send. The relationship anxiety does not disappear, but the activation energy drops enough that you actually do it.

---

Set Up Your Invoice Tracking Spreadsheet

Your spreadsheet is the control center. It tells you who owes what and which follow-up stage they are at.

1. Open Google Sheets and create a new file named "AR Follow-Up Tracker."
2. Set the following column headers in row 1: Client Name, Invoice Number, Service Description, Invoice Amount, Invoice Date, Due Date, Days Overdue, Follow-Up Stage, Last Contact Date, Notes. You should see a clean 10-column header row.
3. Enter one row per outstanding invoice. Fill in every column. Days Overdue is a formula: =TODAY()-[Due Date cell]. You should see a live number that updates daily.
4. Add a dropdown to the Follow-Up Stage column. Use Data > Data Validation and enter these options: Friendly Reminder, 7-Day Follow-Up, 14-Day Notice, 30-Day Final, 45-Day Escalation. You should see a dropdown arrow in each cell of that column.

This spreadsheet does one job: it tells you which clients need contact today and which stage they are at. That is all it needs to do.

---

Build Your AI Invoice Follow-Up Email Prompt

The master prompt is what you paste into ChatGPT or Claude each week. It gives the AI everything it needs to generate a personalized, correctly-toned email for any client at any stage.

Paste this into ChatGPT or Claude:

You are writing a payment reminder email on behalf of [Your Business Name], a [your industry] business. Write a single email for the follow-up stage specified below.

• Client name: [Client First Name]
• Invoice number: [INV-XXXX]
• Service or product provided: [Brief description]
• Amount owed: $[Amount]
• Invoice due date: [Date]
• Days overdue: [Number]
• Follow-up stage: [Choose one: Friendly Reminder / 7-Day Follow-Up / 14-Day Notice / 30-Day Final / 45-Day Escalation]
• Client relationship: [New client / Long-term client / Occasional client]
• Late fee policy: [Include 1.5% monthly fee / Do not mention late fees]

Match the tone precisely to the stage: Friendly Reminder is warm and assumes oversight. 7-Day Follow-Up is polite but direct. 14-Day Notice is professional and firm. 30-Day Final is formal and references consequences. 45-Day Escalation is formal and states that the account will be referred to collections if unresolved within 7 days.

Include the invoice number and amount in every email. Use the client's first name. Do not use threats or hostile language at any stage. Output the subject line and email body only.

Run this prompt once per client who needs follow-up that week. The entire drafting process takes under two minutes per email.

---

The 5-Stage Escalation Sequence

Each stage has a specific timing, tone, and purpose. Use these as your guide when selecting the Follow-Up Stage in the prompt.

Stage	When to Send	Tone	Key Move
Friendly Reminder	Day 1 overdue	Warm, assumes oversight	Reference the invoice, ask if they need anything
7-Day Follow-Up	Day 7 overdue	Polite, slightly more direct	Confirm they received the invoice, ask for payment ETA
14-Day Notice	Day 14–21 overdue	Professional, firm	State the outstanding balance clearly, request payment by a specific date
30-Day Final	Day 30 overdue	Formal, references consequences	State late fee policy if applicable, set a hard deadline
45-Day Escalation	Day 45–60 overdue	Formal, collections warning	State the account will be referred if no payment in 7 days

Businesses that send the Friendly Reminder within one day of the due date get paid an average of 7 days faster than those who wait a week. Send it the day the invoice goes overdue, not the day you remember to check.

A 3-touch sequence — Friendly Reminder, 7-Day Follow-Up, 14-Day Notice — resolves most late invoices. Phone calls are typically reserved for the 45–60 day range when email has not worked.

---

Personalize Without Starting From Scratch

The master prompt handles personalization through the variables you fill in. Two fields matter most for calibration.

Client relationship changes the language significantly. A long-term client who has always paid gets a warmer tone at early stages than a new client with no payment history. Tell the AI which it is, and it adjusts.

Payment history belongs in the Notes column of your spreadsheet. If a client has been slow before, add that context to the prompt: "This client was 30 days late on the previous invoice." Claude 3.7 Sonnet and GPT-4o both use that context to sharpen the email's firmness without you rewriting the whole prompt.

---

The Weekly Routine for Small Business Accounts Receivable Follow-Up

Run this workflow once per week. It takes under 30 minutes when your spreadsheet is current.

1. Open your AR Follow-Up Tracker. Sort by Days Overdue descending. You should see your most urgent accounts at the top.
2. Identify every client where the Days Overdue number has crossed a stage threshold since last week.
3. Update the Follow-Up Stage dropdown for each of those clients.
4. Open ChatGPT or Claude. Paste the master prompt with that client's details filled in.
5. Review the generated email. Check that the invoice number, amount, and due date are correct. Edit anything that does not match your voice.
6. Send the email from your own email client. Log the date in the Last Contact Date column.
7. Repeat for each client that needs follow-up this week.

That is the complete workflow. (Fifteen hours per month is the average small business owner's AR time, according to surveys by Xero{:target="_blank"} and FreshBooks. This system runs the same function in under two hours.)

---

When Something Goes Wrong

The AI uses the wrong invoice amount in the email. You pasted the prompt with an error in the Amount field. AI reproduces what you give it exactly. Fix the source data in your spreadsheet, then re-run the prompt with the corrected number. Always verify the dollar amount before sending.

The tone is too aggressive for a long-term client. You selected the wrong Follow-Up Stage, or you did not specify the client relationship in the prompt. Re-run the prompt with "Long-term client" in the relationship field and one stage earlier than the current overdue count.

The email sounds generic despite the variables. The service description field is too vague — "consulting" or "services" produces generic output. Replace it with a specific description: "brand strategy workshop delivered October 12" produces a more grounded email.

---

What to Do Next

Set up your AR Tracker spreadsheet today and enter every outstanding invoice. Once it is current, run the master prompt for any invoice that is already past due. Get those emails out before you set up anything else.

If you want to expand this system further, read about how to use AI to build a client onboarding workflow — the same prompt-based approach applies to the full client lifecycle.

---

FAQ

Can I use this workflow without a paid ChatGPT or Claude subscription? Yes. Both tools have free tiers that handle this prompt without issues for low-volume use — a few invoices per week. Free tiers have daily message limits and no guaranteed access to the latest models. If you are managing 10 or more invoices per week, a $20/month subscription removes those constraints. Check ChatGPT{:target="_blank"} and Claude{:target="_blank"} for current plan details.

How do I chase invoices without calling clients? Use the 5-stage email sequence in this post. Most late invoices — especially in the 1–21 day range — resolve through email alone. The AI-generated reminders are firm enough to prompt action without requiring a phone call. Phone contact is typically reserved for the 45–60 day stage when email has produced no response.

How do I write a payment reminder email for a small business without sounding aggressive? Match the tone to the stage. Early reminders (Friendly Reminder, 7-Day Follow-Up) assume the client simply overlooked the invoice. The prompt in this post calibrates the language automatically based on the stage and client relationship you specify. Avoid mentioning late fees or consequences until the 30-Day Final stage.

How do I handle a client who says they never received the invoice? Resend the original invoice as an attachment in your reply to the AI-generated reminder. Log it in the Notes column with the date. If they claim non-receipt again at the 14-day stage, add that context to the prompt — "Client claims not to have received original invoice; this is the second send" — so the AI calibrates the tone appropriately.

Should I mention late fees in early-stage emails? No. Late fees belong in the 30-Day Final stage and beyond. Mentioning them in a Friendly Reminder signals distrust of the client relationship before the situation warrants it. Use the "Do not mention late fees" option in the prompt for stages 1 through 3.

What if a client responds to the email asking for more time? That is a successful outcome — you now have communication. Reply directly, not through the AI sequence. Agree to a specific payment date in writing, note it in your spreadsheet, and pause the follow-up sequence until that date passes. If they miss the agreed date, resume at the 14-Day Notice stage regardless of where you left off.

Is this system enough, or do I need dedicated AR software? For most small businesses with under 20 active clients, this spreadsheet-plus-AI approach covers the full follow-up workflow. Dedicated AR tools like FreshBooks{:target="_blank"} add automated sending and payment portals, which reduces manual steps. If you are spending more than 2 hours per week on this workflow after setting it up, look at dedicated software. Until then, this works.