Connectors

/

Stripe

/

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

Line up Stripe and Business Central customer lists

For finance and operations teams who want Stripe customers compared with Dynamics 365 Business Central customers by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Stripe customers with Dynamics 365 Business Central
Compare our Stripe customers with Business Central customers and show me who is missing on each side.
Of 212 Stripe customers, 188 match a Business Central customer. - Recorded differently: 9, including Contoso with a different email - Stripe only: 15 customers, including Fabrikam - Business Central only: 31 customers - Duplicates: 2 emails used by more than one Stripe customer Want the Stripe-only customers listed so you can create them?
Stripe
Sample figures. Your results come from your own account.
stripe-get-customer

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 customer lists that drift apart

Customers created in Stripe and in Dynamics 365 Business Central drift apart: some exist in one system only, some are spelled differently and some share an email with a duplicate. Comparing two long lists by hand is tedious and easy to get wrong.

Without PopdockAI

  • Export customers from both systems
  • Match them by email and name in a spreadsheet
  • Spot spelling differences by eye
  • Miss duplicates that share an email

With PopdockAI

  • Customers are matched by email, then exact name
  • Name-only matches are marked weaker, and partial names never match
  • Four tables show matched, different and one-sided customers
  • Duplicates are flagged, 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:** Compare the customers in Stripe with the customers in Business Central company `{company}` (default: the default company), limited to names containing `{name-contains}` (default: all customers), and report which exist on only one side and which disagree.

**Step 1: Read Stripe customers**

Call `stripe-get-customer` with `name.contains` set to `{name-contains}` when it is given. Keep `customer-id`, `name`, `email`, `currency`, `balance` and `delinquent` for each.

**Step 2: Read Business Central customers**

Call `business-central-get-customer` with `company` set to `{company}` and `name.contains` set to `{name-contains}` when given. Keep `customer-number`, `name`, `email`, `balance-due` and `blocked`.

**Step 3: Match**

Match on email first, comparing case-insensitively and ignoring surrounding spaces. For a record with no email match, try an exact name match, ignoring case and punctuation. Mark name-only matches as weaker in the report. Never match on a partial name.

**Step 4: Report**

Four sections, each a table:

1. Matched: Stripe customer-id, Business Central customer-number, name, email.
2. Recorded differently: matched pairs whose names differ, or matched on name but with different emails. Show both values side by side.
3. In Stripe only: customer-id, name, email, delinquent.
4. In Business Central only: customer-number, name, email, balance-due.

End with a count for each section.

**Rules & Guidelines:**

* `stripe-get-customer` is on the stripe server; `business-central-get-customer` is on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-customer` or `business-central-update-customer`. To create a missing customer, point the user to the create-bc-customer-from-stripe prompt.
* If either read hits its record limit, say that the comparison is partial and suggest narrowing `{name-contains}`.

**Validation:**

* If either side returns no customers, report that side as empty and list everything from the other side as unmatched. Do not guess matches.
* A customer with no email on either side can only be name-matched; say so in its row.
* If one email matches several records on the same side, list them all under Recorded differently, flagged as duplicates.

Who it's for

One answer, three teams that use it

Master data analysts

Clean up customer records

Customers recorded differently and duplicates are listed, ready to tidy.

Compare Stripe customers with Business Central and show who is recorded differently.

Accounts receivable

Find customers missing from the ERP

Stripe-only customers are listed, so billing has an ERP account behind it.

Which Stripe customers do not exist in Business Central?

Controllers

Keep billing and the ERP aligned

A regular check keeps the two customer lists in step before errors reach invoices.

Reconcile Stripe and Business Central customers whose names start with Contoso.

How it works

What PopdockAI does when you ask

You can narrow by name, and your AI assistant lines up Stripe and Business Central customers. It only reads and says when a side is empty or hits its record limit.

01

Ask

You optionally narrow by customer name.

Your AI tool

02

Read

It reads customers from Stripe and Business Central.

stripe-get-customer

03

Match

It matches by email, then exact name, marking name-only matches as weaker.

No items found.

04

Report

You get four groups with duplicates flagged, and nothing is 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-customer

Returns customer records (name, email, balance, delinquency, address) 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

Customer lists that agree, gaps in plain view

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