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.
FinanceCollectionsbeginnerWho 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.
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
- Copy the prompt above.
- Replace every [bracket] with your own details (or fill in the blanks on AgentPlaybook Real Estate, which remembers your answers for the next prompt).
- 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
- List them as drafts for me to review; don't send anything.
Check yourself
- Check every figure, price and total against your own records before anything is sent, posted or booked. A person approves refunds, discounts, payments and price changes.
- Remove names, contact details, account numbers and other personal data the task doesn't need before you paste, and check your AI tool's data and training settings.
- Read and edit the draft before it reaches a customer or goes public. If you later automate this prompt, start with "draft and notify me", not "send automatically".
- Check names, dates, numbers and any claim against your own source material before you use the answer. AI can misread or invent details.
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.
Want to make this prompt even better? Grade it with the free prompt grader or build your own with the AI prompt generator.
32 copy-paste agent prompts (PDF) plus 5 new prompts every week.
Get it free