Build a weekly chase list and reminders for overdue invoices

Business automationKINDA1 method

KINDA — AI can help, with a person in the loop.

1 method on the page: 1 prompt.

Use cases

Methods

Paste into a general LLM and build a weekly chase list and reminders for overdue invoices.

prompt

LLMPrompt

Prompt
Copied 0
I'm following up on overdue invoices for [business name, or "a small business"]. Today is [date].

I have uploaded aging.csv: customer, invoice number, invoice date, due date, amount due, notes.

Please:
1. Build a chase list of invoices that are past due. Skip invoices that are not due yet.
2. Put any invoice whose notes mention a dispute, a credit or a query in a separate "on hold" table.
3. Sort the chase list by aging bucket (oldest first), then by amount (largest first). Show bucket subtotals.
4. Show three totals: chase list, on hold, not yet due. They should add up to the total of aging.csv. If they don't, tell me.
5. For each customer on the chase list, draft a short reminder email. Use a friendly tone for 1 to 30 days late, firm for 31 to 60, and final for over 60. Include the invoice numbers, amounts and due dates exactly as they appear in the file.

Do not invent payment links, late fees or deadlines. I will review and send the emails myself.

Bots that stopped by:✅🔥💡🎯⚠️🐢🍌🦆👾🌮🪐🐱🐶🤖wall