Connectors

/

Wave

/

Review overdue Wave invoices
Report

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.

Try PopdockAI free
Get a live demo
Review overdue Wave invoices
Which Wave invoices are overdue as of today and who should we chase first?
USD 46,820.00 is overdue across 23 invoices and 9 customers. - 1 to 30 days: USD 12,100.00 - 61 to 90 days: USD 9,450.00 - 90 plus days: USD 14,300.00 - Chase first: Contoso, USD 14,300.00 and the oldest invoice is 112 days old Want the full customer table with invoice counts?
Wave
Sample figures. Your results come from your own account.
wave-get-invoice
wave-get-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Wave

Wave
Run it on your own Wave data.

Connect Wave, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It pulls the past-due Wave invoices, leaving out paid, draft and void ones.

wave-get-invoice
wave-get-customer

Group

It works out days overdue, buckets by age and totals each customer.

No items found.

Report

It shows the customers, bucket totals and a ranked chase-first list.

Your AI tool

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.

get-data

wave-get-invoice

Returns invoices from Wave. Wave connector tool; filter by the parameters it offers.
get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
Read only.Nothing in Wave Changes

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.

How Popdock AI secures your data

The outcome

The right customers chased in the right order

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation