/
/
Find Wave invoices that do not match their payments
For finance teams who ask their AI assistant to check each Wave invoice against its recorded payments.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Payment mismatches hide in the period totals
Matching Wave invoices to payments by hand at period end hides underpayments, overpayments and payments with no invoice. You add up payments per invoice and compare them to the amounts.
Without PopdockAI
- Export invoices and payments for the period
- Add up payments for each invoice number
- Compare with amount paid and amount due
- Chase down the differences one by one
With PopdockAI
- Invoices and payments are read for the range
- Payments are summed per invoice automatically
- Each mismatch is listed with a suspected cause
- Nothing is corrected, currencies stay separate
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Reconcile Wave invoices to recorded payments for invoices dated from `{from-date}` to `{to-date}`. Company: `{company}`.
**Step 1: Read both sides**
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 `invoice-date.from` and `invoice-date.to`. Call `wave-get-invoice-payment` with `payment-date.from` set to the from date and no upper bound.
**Step 2: Match by invoice number**
For each invoice, sum its payments by `invoice-invoice-number` and compare with `amount-paid` and `amount-due`.
* Paid status but `amount-due` above zero, or payments that do not add up to `amount-paid`.
* Invoices with payments exceeding `total`.
* Payments whose state is not completed, or that refer to no invoice in the range.
* Unpaid invoices with a payment recorded.
**Step 3: Report**
A mismatch table (invoice number, customer, total, amount paid, sum of payments, difference, suspected cause), then counts per issue type and the total unexplained difference.
**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.
* Report suspected causes as suspicions. Do not fix anything.
* Never combine currencies.
**Validation:**
* If everything reconciles, say so with the counts checked.
* If either read returns the maximum records, warn that results may be incomplete.Who it's for
One answer, three teams that use it
Accounts receivable
Find invoices that were paid wrongly
See overpaid, underpaid and part-paid invoices with the difference for each.
List Wave invoices from this quarter where payments do not match the amount paid.
Controllers
Sign off receivables with confidence
Get counts per issue type and the total unexplained difference for the period.
Reconcile Wave invoices to payments for October and give me counts per issue and the total difference.
Bookkeepers
Trace orphan payments
Find payments that refer to no invoice in the range or are not completed.
Are there any Wave payments from Q3 that do not belong to an invoice in that period?
How it works
What PopdockAI does when you ask
You give the date range and your AI assistant reads the invoices and payments. It reports causes as suspicions and never corrects a record.
Ask
You give the invoice date range and the Wave business.
Read
It reads the invoices and the invoice payments.
Match
It sums payments by invoice number and compares them with amount paid, amount due and total.
Report
It lists each mismatch with a suspected cause, counts per type and the unexplained total.
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-invoice-payment
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
Every payment mismatch found before close
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)
