Connectors

/

Stripe

/

Reconcile Stripe invoices with Dynamics 365 Business Central
Report
Cross-Connector

Find Stripe invoices paid in one system but open in Business Central

For finance teams who want Stripe invoices checked against posted invoices in Dynamics 365 Business Central by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Stripe invoices with Dynamics 365 Business Central
Reconcile Stripe invoices from the last 30 days with posted sales invoices in Business Central.
96 of 104 Stripe invoices from the last 30 days match a posted invoice in Business Central. - Status mismatch: INV-1042 paid in Stripe but open in Business Central - Amount difference: INV-1047, 1,250.00 against 1,200.00 - Matched by amount: 3 invoices found without the Stripe number - Stripe only: 5 invoices, including one for Fabrikam Want the Stripe-only invoices listed?
Stripe
Sample figures. Your results come from your own account.
stripe-get-invoice

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

Paid in Stripe, still open in Business Central

Stripe invoices should each have a posted invoice in Dynamics 365 Business Central with the same amount and status. When they disagree, collections chase paid customers or cash goes unapplied, and matching is slow when invoices lack the Stripe number.

Without PopdockAI

  • Export paid and open Stripe invoices
  • Search Business Central by Stripe number
  • Fall back to customer and amount by hand
  • Chase customers who already paid

With PopdockAI

  • Paid and open Stripe invoices are read for the range
  • Each is found by Stripe number, then customer and exact amount
  • Status mismatches and amount differences above one cent are flagged
  • Totals come per currency, and nothing is changed

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 the Stripe invoices created from `{from-date}` to `{to-date}` (default: the 30 days ending today) against posted sales invoices in Business Central company `{company}` (default: the default company).

**Step 1: Read Stripe invoices**

Call `stripe-get-invoice` with `created-date.from` and `created-date.to`, once with `status` set to paid and once with `status` set to open. Ignore draft, void and uncollectible invoices. Keep `invoice-id`, `number`, `customer-email`, `customer-name`, `total`, `amount-remaining`, `currency`, `created-date` and `status`.

**Step 2: Find each one in Business Central**

For each Stripe invoice, call `business-central-get-posted-sales-invoice` with `external-document-number` set to the Stripe `number`.

If nothing comes back, fall back: call `business-central-get-customer` with `email` set to the Stripe `customer-email` (cache the result per email), then call `business-central-get-posted-sales-invoice` with that `sell-to-customer-number` and a `posting-date` window 5 days either side of the Stripe `created-date`. Accept a candidate only if its `total-amount-including-tax` equals the Stripe `total`. Mark a fallback match as "matched by amount".

If still nothing, record the invoice as in Stripe only and continue.

**Step 3: Compare matched pairs**

* Amount: Stripe `total` against Business Central `total-amount-including-tax`. A difference of 0.01 or less is rounding; ignore it.
* Payment status: Stripe paid but Business Central `remaining-amount` above zero, or Stripe open but Business Central `remaining-amount` zero.
* Currency: Stripe currency is lower case (usd); Business Central leaves `currency-code` empty for the local currency. Treat empty as matching the local currency and only flag a clear difference.

**Step 4: Report**

Tables for: Matched and agreeing (count only, unless the user asks), Amount differences, Payment status mismatches (the most important for collections and cash application), In Stripe only, and Matched by amount (so the user can add the Stripe number as the external document number). Finish with totals per section in each currency.

**Rules & Guidelines:**

* `stripe-get-invoice` is on the stripe server; `business-central-get-posted-sales-invoice` and `business-central-get-customer` are on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-sales-invoice`, `business-central-update-sales-invoice` or any other create or update tool. For invoices in Stripe only, point the user to the create-bc-invoice-from-stripe prompt.

**Validation:**

* If Stripe returns no invoices in the range, say so and stop.
* If a Stripe invoice has no `number` or no `customer-email`, list it under In Stripe only with the reason.
* If a read hits its record limit, say the reconciliation is partial and suggest a shorter date range.

Who it's for

One answer, three teams that use it

Collections specialists

Stop chasing paid invoices

Invoices paid in Stripe but open in Business Central are flagged before you call.

Which Stripe invoices paid in October are still open in Business Central?

Accounts receivable

Apply the cash that is waiting

Status mismatches show where cash has arrived but has not been applied.

Reconcile Stripe invoices from the last 14 days with posted sales invoices in Business Central.

Controllers

Find invoices only in Stripe

Stripe-only invoices are listed, so revenue is not missing from the ERP.

List Stripe invoices from last quarter with no posted invoice in Business Central.

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant matches Stripe invoices to posted invoices in Business Central. It only reads and warns when a read is partial.

01

Ask

You give a date range.

Your AI tool

02

Read

It reads paid and open Stripe invoices.

stripe-get-invoice

03

Match

It finds each posted invoice by Stripe number, then by customer and exact amount.

No items found.

04

Report

You get mismatches and per-currency totals, with nothing changed.

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

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
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

Status mismatches found before the wrong call

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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