/
/
Rank overdue Wave invoices by who to chase first
For finance teams who ask their AI assistant which Wave customers to chase first and why.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Big overdue balances get lost in a long list
Chasing late payers means exporting invoices, sorting them by hand and guessing who matters most. Days overdue and customer totals are built in a spreadsheet, and big balances get missed.
Without PopdockAI
- Export unpaid invoices from Wave
- Work out days overdue in a sheet
- Total each customer by eye
- Guess who to chase first
With PopdockAI
- Past-due invoices are read for any as-of date
- Age buckets and customer totals are calculated
- Top customers get email and overall overdue
- A ranked list is given, nothing is sent
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find the invoices in Wave that are past due as of `{as-of-date}` (default: today) and recommend who to chase first. Company: `{company}`.
**Step 1: Pull the open invoices**
If the user has access to more than one Wave company and `{company}` is empty, ask which company to use before reading anything. Call `wave-get-invoice` with `due-date.to` set to the as-of date and `amount-due.min` set to `{min-amount}` (default 0.01). Use `max-records` 500. Ignore rows whose status is Paid, Draft or Void.
**Step 2: Age and group**
* Compute days overdue for each row as as-of date minus `due-date`.
* Bucket into 1-30, 31-60, 61-90 and 90+ days.
* Group by customer name and total the amount due per customer.
**Step 3: Add customer context**
For the five customers with the largest overdue totals, call `wave-get-customer` filtered by `name` and note their email and overall `overdue-amount`.
**Step 4: Report**
A table of customers (overdue total, oldest invoice age, invoice count), then the bucket totals, then a ranked "chase first" list with one line of reasoning each. Finish with the grand total overdue.
**Rules & Guidelines:**
* Do not call any write tool (every `wave-add-*`, `wave-update-*`, `wave-delete-*`, `wave-archive-*`, `wave-send-*`, `wave-approve-*`, `wave-mark-*`, `wave-clone-*`, `wave-convert-*`, `wave-reset-*` and `wave-generate-*` tool). This prompt only reads.
* Do not email or contact anyone. Only recommend.
* Show amounts in the invoice currency; never add different currencies together, report each separately.
**Validation:**
* If no invoices are overdue, say so and stop.
* If a read returns the maximum records, say the list may be truncated and suggest narrowing the date range.Who it's for
One answer, three teams that use it
Accounts receivable
Start the day with a chase list
Get a ranked list of who to contact first, with the reason beside each name.
Give me the overdue Wave invoices ranked by who to chase first.
Credit controllers
See aging at a glance
Review bucket totals from 1 to 30 up to 90 plus days for the whole ledger.
What does our Wave overdue aging look like as of 31 October?
Business owners
Check what is owed to you
Get the grand total overdue and the top customers without opening a report.
How much are customers overdue to us in Wave, and who owes the most?
How it works
What PopdockAI does when you ask
You pick an as-of date and your AI assistant reads Wave. It recommends and never emails or contacts anyone.
Ask
You give an as-of date and optionally a minimum amount.
Read
It pulls the past-due Wave invoices, leaving out paid, draft and void ones.
Group
It works out days overdue, buckets by age and totals each customer.
Report
It shows the customers, bucket totals and a ranked chase-first list.
What PopdockAI provides
The tools behind the answer
Ready made tools for Wave and one secure connection to your AI tool. No code, no exports.
wave-get-invoice
wave-get-customer
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
The right customers chased in the right order
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
