Overdue invoice follow-ups from your books: AI agent prompt

Pull overdue invoices from your accounting tool and draft a polite, escalating follow-up email for each one.

Curated by AgentPlaybook Real Estate · Worked example added Oct 24, 2026 · How we make and check prompts

FinanceCollectionsbeginner

Who this is for

Freelancers and small businesses with unpaid invoices in QuickBooks, Xero, Wave or similar.

Not for

Debts already with a collector or lawyer, or customers in a dispute.

What you need

An export of unpaid invoices: customer, invoice number, amount, due date, reminders already sent.

The prompt

Here's my list of unpaid invoices from my accounting software: [paste customer, invoice number, amount, due date, past reminders sent]. For each overdue invoice, draft a follow-up email in my voice: friendly if under 15 days late, firmer if 15-45 days, and a final notice with next steps after 45. Include the invoice number, amount, and a payment link placeholder. List them as drafts for me to review; don't send anything.
Open in ChatGPT Open in Claude Perplexity Download as agent skill (SKILL.md)

Worked example

A fictional business, so you can see what to paste in and what a good answer looks like. The example answer was written with AI help and its numbers and dates were checked; your AI's answer will be worded differently, so check it the same way.

Sample input (what you paste in)

Today is Oct 24, 2026.
- Lakeview Yoga, INV-1042, $480, due Oct 14, no reminders
- Cobalt Signs, INV-1031, $1,250, due Sep 30, 1 reminder
- Pine St Deli, INV-1009, $2,100, due Aug 29, 2 reminders

Example output (illustrative)

1) Lakeview Yoga, INV-1042, 10 days late (friendly)
Subject: Quick reminder: invoice INV-1042
Hi! Just a friendly nudge that invoice INV-1042 for $480 was due on October 14. You can pay here: [payment link]. If it's already on its way, thank you and please ignore this.

2) Cobalt Signs, INV-1031, 24 days late (firmer)
Subject: Invoice INV-1031 now 24 days overdue
Hello, invoice INV-1031 for $1,250 was due on September 30 and is now 24 days overdue. Please pay by October 31 using [payment link], or let me know today if there's an issue with the invoice.

3) Pine St Deli, INV-1009, 56 days late (final notice)
Subject: Final notice: invoice INV-1009
Hello, despite two earlier reminders, invoice INV-1009 for $2,100 (due August 29) remains unpaid. Please pay in full by November 7 via [payment link]. If we don't receive payment or hear from you by then, we'll pause further work and [your next step, e.g. late fees per our terms]. 

Drafts only; nothing has been sent.

Check before you use it: Check the days-late maths and only threaten steps your terms actually allow.

How to use it

  1. Copy the prompt above.
  2. Replace every [bracket] with your own details (or fill in the blanks on AgentPlaybook Real Estate, which remembers your answers for the next prompt).
  3. Paste it into Xero + Gemini, QuickBooks, Claude and review the answer before you use it.

Works with: Xero + Gemini, QuickBooks, Claude, ChatGPT, Gmail

Real-world example: xero.com/us/media-releases/xero-brings-real-time-financial-intelligenc

Featured in: Free AI agent prompts for small business (beginner-friendly) · ChatGPT prompts for business email, replies and follow-ups · ChatGPT prompts for bookkeeping, accounting firms and small-business finance

Before you use it: what to check

Already built into this prompt

Check yourself

Using an AI agent? Download this prompt as a SKILL.md agent skill with these checks built in, or get the .zip for Claude.ai. How to install skills.

Share:Post on XLinkedInFacebookRedditWhatsApp
</> Embed this prompt on your site

Paste this HTML into your blog or website. It's a plain card with no tracking scripts that links back to this prompt.

Want to make this prompt even better? Grade it with the free prompt grader or build your own with the AI prompt generator.

Get the free Solo Founder Stack pack

32 copy-paste agent prompts (PDF) plus 5 new prompts every week.

Get it free

More Finance prompts

Categorize transactionsBookkeeping · beginner · worked exampleInvoice reconciliationReconciliation · intermediateExpense policy checkerExpenses · beginnerCash-flow check-inCash flow · beginner · worked exampleReceipt photos to bookkeeping entriesReceipt capture · beginner · worked exampleReverse-charge VAT check on software invoicesVAT & tax checks · intermediate

See all Finance prompts →

Related prompts from other teams

Support ticket triageCustomer Support · beginner · worked exampleDraft replies from your FAQCustomer Support · beginner · worked exampleLead qualifierSales · beginnerAccount research briefSales · beginner