Connectors

/

Stripe

/

Reconcile Stripe charges to Wave payments
Report
Cross-Connector

Find Stripe charges missing from Wave

For finance teams who want their AI assistant to match Stripe charges to Wave payments and list the gaps.

Try PopdockAI free
Get a live demo
Reconcile Stripe charges to Wave payments
Reconcile Stripe charges to Wave payments from 2026-10-01 to 2026-10-31 for Northwind Books.
Stripe and Wave agree on 118 of 124 charges for October. - Matched pairs: 118 - Stripe charges with no Wave payment: 4, USD 2,310.00 - Wave payments with no Stripe charge: 2, USD 640.00 - Currencies: 1 EUR charge, reported separately Want the full table of the 4 unrecorded charges?
Stripe
Sample figures. Your results come from your own account.
stripe-get-charge
wave-get-invoice-payment

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Stripe

Stripe
Run it on your own Stripe data.

Connect Stripe, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Two exports and a tick-off every month

Matching Stripe to Wave means exporting charges and payments and ticking them off by hand. Minor-unit amounts and refunds make the figures differ, and unrecorded receipts slip through.

Without PopdockAI

  • Export succeeded charges from Stripe
  • Export invoice payments from Wave
  • Convert amounts and subtract refunds by hand
  • Tick off matches and hunt for the rest

With PopdockAI

  • Both sides are read for the same dates
  • Matches use amount, date and customer name
  • Refunds are taken off to give a net amount
  • Gaps are totalled per currency, nothing is written

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 successful Stripe charges against Wave invoice payments from `{from-date}` to `{to-date}` (YYYY-MM-DD). Company: `{company}`.

**Step 1: Read Stripe (stripe server)**

Call `stripe-get-charge` with `status` succeeded, `created.from` and `created.to` set to the dates, `max-records` 500. Keep `charge-id`, `amount`, `amount-refunded`, `customer-email`, `customer-name`, `invoice-id`, `currency` and `created`.

**Step 2: Read Wave (wave-ai server)**

If you have more than one Wave company and `{company}` is empty, ask which to use before reading. Call `wave-get-invoice-payment` with `payment-date.from` and `payment-date.to` set to the same dates and `max-records` 500. Keep `amount`, `payment-date`, `invoice-invoice-number`, `invoice-customer-name`, `payment-provider` and `confirmation-code`.

**Step 3: Match**

Match a charge to a payment when the amounts are equal (Stripe amounts may be in minor units, so check against the currency and convert), the dates are within 3 days and the customer name matches case-insensitively. Also try `confirmation-code` against the charge id. Treat net amount as `amount` minus `amount-refunded`.

**Step 4: Report**

Three tables: matched pairs, Stripe charges with no Wave payment (the likely unrecorded receipts), and Wave payments from Stripe-like methods with no Stripe charge. End with counts and total value per currency of each gap.

**Rules & Guidelines:**

* Wave tools come from the wave-ai server and Stripe tools from the stripe server; both must be connected. Stripe has no write tools here, so nothing can change in Stripe.
* Do not call any Wave 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.
* Never add different currencies together.

**Validation:**

* If either side returns nothing, say so and report the other side as entirely unmatched.
* If a read returns the maximum records, warn that the result may be truncated.

Who it's for

One answer, three teams that use it

Accounts receivable

Spot receipts missing from the books

List Stripe charges that never became a Wave payment, ready to record.

Which successful Stripe charges from October have no matching payment in Wave?

Controllers

Check the month before close

See counts and value per currency for each gap so the cash side can be signed off.

Reconcile Stripe to Wave for last month and give me the totals of anything unmatched by currency.

Bookkeepers

Find payments with no Stripe source

Spot Wave payments from Stripe-like methods that have no Stripe charge behind them.

Show me Wave payments from Stripe this quarter that I cannot find in Stripe for Fabrikam Studio.

How it works

What PopdockAI does when you ask

You give the dates and your AI assistant reads Stripe and Wave. It only reads, and it never adds currencies together.

Ask

You give the dates and the Wave business.

Your AI tool

Read

It reads succeeded Stripe charges and Wave invoice payments for the period.

stripe-get-charge
wave-get-invoice-payment

Match

It pairs them on amount, date within 3 days and customer, net of refunds.

No items found.

Report

It shows matched pairs and the gaps on each side, with value per currency.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Stripe and one secure connection to your AI tool. No code, no exports.

get-data

stripe-get-charge

Returns charges (amount, status, refunds, customer, card used) from Stripe.
get-data

wave-get-invoice-payment

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

Unrecorded Stripe receipts found in one pass

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