/
/
Reconcile 2Checkout orders with Wave payments for the month
For finance teams who want month-end payment matching without spreadsheets, just by asking their AI assistant.
On this page
Connector
Connect 2Checkout, pick your AI tool and paste the prompt.
The problem
Month-end payment matching lives in spreadsheets
Matching 2Checkout orders to Wave payments by hand means lining up two exports. Missing or duplicate payments slip through, and test orders, refunds and mixed currencies blur the picture.
Without PopdockAI
- Export orders from 2Checkout
- Export payments from Wave
- Match references and amounts by eye
- Separate test orders, refunds and currencies by hand
With PopdockAI
- Orders and payments are read for your period
- Test orders are left out and refunds listed apart
- Matches use the reference, then amount, name and date
- Currencies are never added together
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Reconcile 2checkout orders (server 2checkout) against Wave invoice payments (server wave-ai) for the period `{from-date}` to `{to-date}` (YYYY-MM-DD), optionally restricted to currency `{currency}` (default: all). Report only; change nothing.
**Step 1: Read the 2checkout side**
Call `2checkout-get-order` (add `currency` when `{currency}` is not empty). Keep orders whose `order-date` falls inside the period and whose `test-order` is not true. Note `reference-number`, `billing-first-name`, `billing-last-name`, `gross-discounted-price`, `currency`, `status`, `order-date`.
**Step 2: Read the Wave side**
Call `wave-get-invoice-payment` with `payment-date.from` set to `{from-date}` and `payment-date.to` set to `{to-date}`. Keep `payment-date`, `amount`, `payment-method`, `payment-provider`, `payment-currency-code`, `invoice-customer-name`, `invoice-invoice-number`, `memo`, `confirmation-code`, `state`.
**Step 3: Match**
Match an order to a payment when the 2checkout `reference-number` appears in the Wave `memo` or `confirmation-code`; failing that, when the amount is equal, the currency is equal, the customer name equals billing first plus last name, and the dates are within 3 days. Mark each match as "reference" or "amount and name". Each payment can match one order only.
**Step 4: Report**
List four groups with counts and totals per currency: matched; 2checkout orders with no Wave payment; Wave payments with no 2checkout order (ignore payments whose `payment-provider` clearly is not 2checkout, but mention how many you ignored); amount mismatches. Order refunded or cancelled orders in their own list rather than as "missing".
**Rules & Guidelines:**
* `wave-get-invoice-payment` is on the wave-ai server; `2checkout-get-order` is on the 2checkout server.
* Read-only. Do not call `wave-add-invoice-payment`, `wave-update-invoice-payment`, `wave-delete-invoice-payment` or any other Wave action, and do not call `2checkout-order-refund`, `2checkout-order-cancel` or any other 2checkout action.
* Never add amounts in different currencies together.
**Validation:**
* If either side returns no rows for the period, say so and still list the other side as unmatched.
* If the 2checkout fee or tax treatment could explain a small difference, mark it "possible fee difference" and do not call it an error.
* Warn when a result may be truncated by `max-records`.Who it's for
One answer, three teams that use it
Accountants
Speed up the month-end match
Get matched, missing and mismatched items in one report instead of comparing exports.
Reconcile 2Checkout orders from last month with Wave payments and list the exceptions.
Accounts receivable
Find payments that never arrived
See which orders have no payment in Wave, so missing money is chased while it is fresh.
Which 2Checkout orders in EUR from October 2026 have no payment recorded in Wave?
Finance managers
Understand differences before close
See amount mismatches with the possible fee differences marked, so real errors stand out.
Show the amount mismatches between 2Checkout orders and Wave payments for Q3 2026 and mark likely fee differences.
How it works
What PopdockAI does when you ask
You give a period, and your AI assistant reads both systems and matches orders to payments. It only reports, and treats small differences that fees could explain as possible, not errors.
Ask
You give a date range and optionally a currency.
Read
It reads the 2Checkout orders, leaving out test orders, and the Wave invoice payments for the period.
Match
It pairs by reference number, or by amount, name and date, and labels each match.
Report
You get matched, missing and mismatched items with totals per currency.
What PopdockAI provides
The tools behind the answer
Ready made tools for 2Checkout and one secure connection to your AI tool. No code, no exports.
2checkout-get-order
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
Month-end payment gaps found, currency by currency
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)
