Connectors

/

Wave

/

Reconcile Wave invoice payments
Report

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.

Try PopdockAI free
Get a live demo
Reconcile Wave invoice payments
Check Wave invoices dated 1 July to 30 September against their payments and list any that do not add up.
5 of 148 invoices do not reconcile to their payments. - Paid but amount due still over zero: INV-2031 Contoso, 120.00 due - Payments exceeding total: INV-2044 Fabrikam, 75.00 over - Payment tied to no invoice in range: 1 - Unexplained difference: USD 310.00 Want the full mismatch table with the suspected cause for each?
Wave
Sample figures. Your results come from your own account.
wave-get-invoice
wave-get-invoice-payment

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

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.

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

Your AI tool

Read

It reads the invoices and the invoice payments.

wave-get-invoice
wave-get-invoice-payment

Match

It sums payments by invoice number and compares them with amount paid, amount due and total.

No items found.

Report

It lists each mismatch with a suspected cause, counts per type and the unexplained total.

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-invoice-payment

Returns invoice payments 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

Every payment mismatch found before close

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