/
/
Find Shopify refunds the Wave books still miss
For finance teams who ask their AI assistant whether Shopify refunds have been reflected in Wave.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Store refunds are forgotten in the books
When a refund is issued in the store it is easy to forget in the accounting system. Revenue stays overstated until someone spots the invoice still showing as paid.
Without PopdockAI
- Export refunds from Shopify
- Find each order's invoice in Wave
- Compare payments with the refunded amount
- Spot what was never adjusted
With PopdockAI
- Refunds are read with their amounts worked out
- Each order is matched to its Wave invoice
- Totals and payments are compared net of refund
- Gaps are totalled, nothing is edited or credited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Shopify refunds created from `{from-date}` to `{to-date}` (default: the last 30 days), check whether Wave still shows the invoice as fully paid. Company: `{company}`.
**Step 1: Read the refunds**
Call `shopify-get-refund` with `created-at.from` and `created-at.to` set to the range and `max-records` 200. Keep `refund-id`, `order-id`, `order-name`, `customer-email`, `total-adjustments` and `created-at`. Where a refund has no total, call `shopify-get-refund-line` with `order-refund-id` and sum `subtotal` and `total-tax`.
**Step 2: Find the invoice in Wave**
If you have access to more than one Wave company and `{company}` is empty, ask which company to use before reading anything. For each refund call `wave-get-invoice` with `po-number` set to `order-name`. If nothing matches, record "no Wave invoice".
**Step 3: Check the payments**
For each matched invoice call `wave-get-invoice-payment` with `invoice-invoice-number`. Compare the invoice `total` and `amount-paid` with the order amount net of the refund.
**Step 4: Report**
A table: order name, refund date, refund amount, Wave invoice number, Wave total, Wave amount paid, and a status: books reflect refund, books still show full payment, no Wave invoice, or unclear. Sort "still show full payment" first and total that group.
**Rules & Guidelines:**
* Tools named `wave-*` are on the wave-ai server; tools named `shopify-*` are on the shopify server. Both servers must be connected.
* Do not call any write tool on either server: on Wave 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, and on Shopify every `shopify-add-*` and `shopify-update-*` tool. This prompt only reads.
* Do not delete or edit Wave payments, create credits or change anything in Shopify. Only report what needs correcting.
**Validation:**
* If there are no refunds in the range, say so and stop.
* If currencies differ between the refund and the invoice, report both and flag the row as unclear.Who it's for
One answer, three teams that use it
Accounts receivable
Find invoices that need a credit
List the invoices still showing full payment after a store refund.
Which Shopify refunds from this month are not yet reflected in Wave?
Controllers
Check revenue before close
See the total of refunds the books have missed so revenue is not overstated.
Total the Shopify refunds from October that Wave still shows as fully paid.
Ecommerce managers
Confirm refunds reached finance
Check that refunds issued by the support team are visible in the accounts.
Did the Shopify refunds we issued last week show up in Wave?
How it works
What PopdockAI does when you ask
You give the period and your AI assistant reads Shopify and Wave. It reports what needs correcting and never edits a payment, issues a credit or changes the store.
Ask
You give the date range and the Wave business.
Read
It reads the Shopify refunds, adding up refund lines where needed.
Check
It finds each order's Wave invoice and compares total and amount paid with the net amount.
Report
It gives a status per refund and totals the ones still showing full payment.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
shopify-get-refund
shopify-get-refund-line
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
Refunds reflected in the books, not overlooked
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)
