See who owes you money in one short email every Friday — AI Use Case | Ava Digital
← All AI use cases
AI Use Case · Operations

See who owes you money in one short email every Friday

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.

How it works

  1. Export or sync your open invoices to a Google Sheet (customer, invoice number, amount, due date, last contact date) from QuickBooks, Xero, FreshBooks or your job tool.
  2. Every Friday morning the automation reads the open invoices and works out days overdue.
  3. An AI step groups invoices into current, 1-30, 31-60 and 60+ days overdue, totals each group and writes one line per invoice over 30 days using only the sheet’s notes.
  4. The snapshot is emailed to the owner or bookkeeper with the invoice table attached.
  5. A person decides who to call or what to escalate and updates the last-contact date in the sheet.

The guardrail

The snapshot only reports; no reminder, late fee or collections message goes to a customer unless a person sends it.

Tools that do this: QuickBooks, Xero or FreshBooks (or a Google Sheet), n8n, Zapier or Make, Gmail, an AI model (Claude or ChatGPT)

Prompt to start with
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.
Get a free audit We’ll set this up for your business, end to end.