/
/
Get a Wave customer account summary in one reply
For finance teams who want a customer's invoices, payments and estimates summarised before a call or credit decision.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Account reviews mean clicking through tabs
Before a call or credit decision you open a customer in Wave and read invoices, payments and estimates one tab at a time. Totals and payment habits are worked out by hand and differ between reviewers.
Without PopdockAI
- Find the customer in Wave
- Read invoices, then payments, then estimates
- Total billed, paid and due yourself
- Judge payment habits from memory
With PopdockAI
- The customer is found and unclear matches stop for your choice
- Invoices, payments and estimates are read together
- Totals and unpaid items come back in one summary
- A short payer assessment closes it and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Produce an account summary for the Wave customer `{customer-name}` covering the last `{lookback-days}` days (default 365). Company: `{company}`.
**Step 1: Find the customer**
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-customer` with `name` equal to the given name. If nothing matches, retry with `name.contains`. If more than one customer matches, list them with email and city and stop to ask which one.
**Step 2: Read their documents**
* `wave-get-invoice` filtered by `customer-name` and `invoice-date.from` for the lookback window.
* `wave-get-invoice-payment` filtered by `invoice-customer-name` and `payment-date.from`.
* `wave-get-estimate` filtered by `customer-name` and `estimate-date.from`.
**Step 3: Report**
* Header: name, email, `outstanding-amount`, `overdue-amount`.
* Invoices: count, total billed, total paid, total due, list of any unpaid with due dates.
* Payments: count, total received, average days from invoice date to payment where you can match them by invoice number.
* Estimates: open, accepted and declined counts.
* A two-sentence health assessment (good payer, slowing, at risk).
**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.
* Share only what the question needs; do not print full contact details beyond the email.
**Validation:**
* If the customer has no activity in the window, say so and report only the header.Who it's for
One answer, three teams that use it
Credit controllers
Decide on credit with a clear payer view
See billed, paid and due totals and a short assessment before you extend or hold credit.
Summarise Northwind Traders in Wave for the last 12 months and tell me if they are a good payer.
Account managers
Prepare for a customer meeting
Know what a customer has been billed, what is unpaid and which estimates are open before you meet.
Give me a Wave account summary for Fabrikam Holdings over the last 6 months, including open estimates.
Bookkeepers
Answer a customer's balance question
Pull invoices, payments and unpaid items together to answer a question without opening each tab.
What has Adventure Works been invoiced and paid in Wave this year, and what is still unpaid?
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant reads their Wave records. It only reads, and shares only the email as contact data.
Ask
You name the customer and optionally the period and Wave company.
Find
It finds the customer and stops to ask if several customers match.
Read
It reads the customer's invoices, payments and estimates for the period.
Report
It summarises the totals, unpaid invoices and estimates, with a short payer assessment.
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-customer
wave-get-invoice
wave-get-invoice-payment
wave-get-estimate
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
A clear picture of a customer before you act
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)
