Connectors

/

Wave

/

Wave customer account summary
Report

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.

Try PopdockAI free
Get a live demo
Wave customer account summary
Give me an account summary for Contoso in Wave covering the last 12 months.
Contoso is a reliable payer with one invoice currently unpaid. - Header: Contoso, accounts@contoso.example, outstanding 640.00, overdue 0.00 - Invoices: 11 billed 9,800.00, paid 9,160.00, due 640.00 - Payments: 10 received, average 18 days from invoice date - Estimates: 2 open, 3 accepted, 1 declined Want the unpaid invoice with its due date?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
wave-get-invoice
wave-get-invoice-payment
wave-get-estimate

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

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.

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

Your AI tool

Find

It finds the customer and stops to ask if several customers match.

wave-get-customer
wave-get-invoice
wave-get-invoice-payment
wave-get-estimate

Read

It reads the customer's invoices, payments and estimates for the period.

No items found.

Report

It summarises the totals, unpaid invoices and estimates, with a short payer assessment.

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-customer

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

wave-get-invoice

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

wave-get-invoice-payment

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

wave-get-estimate

Returns estimates 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

A clear picture of a customer before you act

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