Connectors

/

2Checkout

/

Reconcile 2Checkout orders with Wave payments
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile 2Checkout orders with Wave payments
Reconcile our 2Checkout orders from 2026-10-01 to 2026-10-31 with Wave payments and show what does not match.
86 orders were checked: 79 matched, 4 have no Wave payment and 3 have an amount mismatch. - Matched: 79 orders, 74 by reference and 5 by amount and name - No Wave payment: order 91233, Dana Whitfield, 149.00 USD - Mismatch: order 91258, 99.00 EUR, possible fee difference - Refunded orders: 3, listed separately - Ignored: 2 payments from another provider Want the full list for each currency?
2Checkout
Sample figures. Your results come from your own account.
2checkout-get-order
wave-get-invoice-payment

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

2Checkout

2Checkout
Run it on your own 2Checkout data.

Connect 2Checkout, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

Read

It reads the 2Checkout orders, leaving out test orders, and the Wave invoice payments for the period.

2checkout-get-order
wave-get-invoice-payment

Match

It pairs by reference number, or by amount, name and date, and labels each match.

No items found.

Report

You get matched, missing and mismatched items with totals per currency.

Your AI tool

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.

get-data

2checkout-get-order

Returns orders records from the 2Checkout connector (read-only). Accepts the filters defined on the tool, such as record identifiers, status and dates, and returns the matching rows.
get-data

wave-get-invoice-payment

Returns invoice payments from Wave. Wave connector tool; filter by the parameters it offers.
Read only.Nothing in 2Checkout 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

Month-end payment gaps found, currency by currency

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