Last updated:
Quick answer
Paste your list of unpaid invoices and the AI sorts them by age, flags the risky ones, and tells you who to contact first this week.
At a glance
All outcome figures are estimates from cited sources, not independent verification by us.
- What it is allowed to do
- Read-only
Only reads, researches, or summarizes. It never drafts outbound content or changes anything.
- Time saved (estimate)
- Saves an estimated 1 hour per week.
- Difficulty
- Intermediate
- Tools needed
- ChatGPT
- Typical cost
- Free tiers of ChatGPT or Claude handle this. Accounting software like QuickBooks generates aging reports automatically if you outgrow the manual list.
Reviewed Oct 19, 2026
Basis (estimate): Your own estimate: manually sorting invoices and deciding who to chase vs getting a prioritized list to work through. Not measured.
What does this setup do?
Build a weekly unpaid-invoice review: who owes, how late, who to chase first
Who is it for?
An office manager or freelancer who sends invoices and discovers overdue ones by accident
How do you set it up?
Tools
- ChatGPT or Claude (free tier works)
- Your list of unpaid invoices: client, amount, invoice date, due date
Steps
- Export or list your unpaid invoices: client name, invoice number, amount, invoice date, due date.
- Paste the prompt below with your list.
- The AI sorts invoices into buckets: current, 1 to 30 days late, 31 to 60, 61 to 90, over 90.
- It flags the high-risk ones: big amounts, very late, or repeat late payers.
- You get a contact list for the week: who to email, who to call, in what order.
- Work the list. Update it when payments land.
- Repeat weekly. Ten minutes a week beats a quarterly panic.
Example output
Illustrative. Your results will differ.
- This month's spending sorted into 6 categories
- 3 subscriptions you forgot about, flagged for review
- You decide what to cut. Nothing moves on its own.
Where to paste this prompt
ChatGPT: ChatGPT → Project instructions, or ChatGPT Tasks for scheduled reminders (once a day on Free)
Copy-paste prompt
Adapt bracketed fields to your situation.
I need a weekly review of my unpaid invoices. Here is the list (client, invoice number, amount, invoice date, due date): [PASTE LIST]. Sort them into aging buckets: current, 1-30 days overdue, 31-60, 61-90, over 90. Flag the high-risk ones: large amounts, very overdue, or clients who are often late. Then give me this week's contact list in priority order, with a suggested action for each: email reminder, personal email, or phone call. Total each bucket.Newsletter
Get the free starter pack
Free starter pack with five beginner copy-paste prompts after you confirm, plus three sourced setups in your inbox each week. Unsubscribe anytime.
What usually goes wrong?
Where agents tend to stall on this job. More patterns in Where AI gets stuck.
- The list is out of date because nobody updates it when payments arrive. Garbage in, garbage out.
- Treating all overdue invoices the same. A $200 invoice 10 days late and a $5,000 invoice 80 days late need different actions.
- Never escalating. If the 90-day bucket keeps growing, your process needs teeth: late fees, paused work, or collections.
- Forgetting credit notes and partial payments. Net the amounts before sorting.
Which chat tools work with this prompt?
Paste the prompt into any of these assistants (free or paid tiers).
- ChatGPT
- Claude
Common questions
- What is an aging report?
- A list of unpaid invoices grouped by how long they have been outstanding, usually in 30-day buckets. It shows who owes you, how much, and how late, so you know who to chase first.
- How often should I review it?
- Weekly. Monthly is the minimum. The whole point is catching a 30-day problem before it becomes a 90-day problem.
- When do I write off a bad debt?
- Over 90 days with no response is the danger zone. Talk to your accountant about when to write it off and whether collections makes sense.
What tips make it smoother?
- Run the review weekly, not monthly. A 30-day-late invoice is a reminder; a 90-day one is a problem.
- Call the 61 to 90 day bucket. Emails stop working at that age.
- Watch for patterns: the same client always 45 days late is a terms problem, not a reminder problem.
- Keep payment terms short for chronic late payers, or require deposits.
Where do the claims come from?
Summaries use public sources linked below, not independent verification. How setups are picked.
- Read QuickBooks’s write-up (quickbooks.intuit.com)
QuickBooks: AR aging report explained: 30-day buckets, prioritizing follow-ups, forecasting cash flow.
- Read BIT Accounting’s write-up (bitaccounting.com)
BIT Accounting: AR tracking steps: invoice immediately, aging report, follow-up system by milestone, turnover ratio.
Related setups
- Track recurring software spend and idle charges
Scan renewal emails and receipts for SaaS and AI tools, flag overlaps, and draft refund or cancellation messages for charges you are not using.
- Audit your business subscriptions in one afternoon
Find every recurring software charge, flag waste and overlap, build a keep-or-cancel list
- Keep a mileage log without the notebook
Turn plain-words trip notes into an IRS-ready mileage log with dates and business purposes