A weekly email lists unpaid invoices grouped by how overdue they are, with the biggest balances first and a one-line note on each, so the owner knows exactly who to call before the weekend.
Tools that do this: QuickBooks, Xero or FreshBooks (or a Google Sheet), n8n, Zapier or Make, Gmail, an AI model (Claude or ChatGPT)
You prepare a weekly unpaid-invoice snapshot for a small business owner. Use only the rows below and calculate carefully. Business: [business name] Today's date: 2026 Open invoices (customer | invoice number | amount | due date | last contact date | notes): [paste rows] Output: 1. A table with four buckets: not yet due, 1-30 days overdue, 31-60 days overdue, over 60 days overdue. Show the invoice count and dollar total for each. 2. For every invoice more than 30 days overdue, one line: customer, invoice number, amount, days overdue, days since last contact, and a suggested next step in under 12 words (for example 'Owner phone call'). 3. Sort lines largest amount first. If there are no overdue invoices, output only: 'Nothing overdue this week.' Do not draft messages to customers, do not suggest late fees or legal action, and do not guess reasons for non-payment.