Connectors

/

Stripe

/

Reconcile Stripe refunds and credit notes with Dynamics 365 Business Central
Report
Cross-Connector

Account for every Stripe refund in Business Central

For accountants who want Stripe refunds and credit notes matched to posted credit memos in Dynamics 365 Business Central by their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Stripe refunds and credit notes with Dynamics 365 Business Central
Check that last month's Stripe refunds and credit notes are in Business Central as credit memos.
27 of 30 Stripe refunds and credit notes have a posted credit memo in Business Central. - Missing: 2, including a 640.00 refund for Contoso - Possibly reversed: 1 duplicate refund, likely handled by reversing the invoice - Pending: 1 refund still pending in Stripe - Matched by amount: 4 found by customer and exact amount Want the missing items listed with their Stripe references?
Stripe
Sample figures. Your results come from your own account.
stripe-get-credit-note
stripe-get-refund

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

Refunds counted twice or flagged when they are fine

Refunds and credit notes issued in Stripe need matching credit memos in Dynamics 365 Business Central. Because one refund can sit behind a credit note, it is easy to count the same event twice, and refunds handled by reversing the invoice look like errors when they are not.

Without PopdockAI

  • Export Stripe credit notes and refunds
  • Work out which refunds a credit note already covers
  • Search Business Central for each credit memo
  • Raise false alarms on reversed invoices

With PopdockAI

  • Refunds covered by a credit note are dropped, so nothing counts twice
  • Each is found by reference, then customer and exact amount
  • Pending and failed refunds are listed separately
  • Fraudulent or duplicate refunds are noted as possibly reversed, read-only

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Check that the Stripe credit notes and refunds created from `{from-date}` to `{to-date}` (default: the 30 days ending today) are recorded as posted sales credit memos in Business Central company `{company}` (default: the default company).

**Step 1: Read Stripe credit notes and refunds**

Call `stripe-get-credit-note` with `status` set to issued and `created.from` / `created.to` set to the range. Keep `credit-note-id`, `number`, `invoice-id`, `refund-id`, `customer-email`, `amount`, `currency` and `reason`.

Call `stripe-get-refund` with `created-date.from` / `created-date.to` set to the range. Keep `refund-id`, `charge-id`, `customer-email`, `amount`, `status` and `reason`. Drop any refund whose `refund-id` already appears on a credit note, so that one event is not counted twice.

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

For a credit note, call `business-central-get-posted-sales-credit-memo` with `external-document-number` set to the credit note `number`. For a standalone refund, use the `refund-id`.

If nothing comes back, fall back: call `business-central-get-customer` with `email` set to the Stripe `customer-email`, then `business-central-get-posted-sales-credit-memo` with that `sell-to-customer-number`, `posting-date` 5 days either side of the Stripe date, and `total-amount-including-tax.min` / `.max` both set to the Stripe amount. Mark a fallback match as "matched by amount".

**Step 3: Report**

1. Matched: Stripe number or refund-id, amount, Business Central credit-memo-number.
2. Matched by amount: the same, so the user can record the Stripe reference.
3. Not in Business Central: Stripe reference, customer, amount, reason, date.
4. Refunds that are not succeeded (pending or failed), listed separately and not treated as missing.

End with totals per section per currency.

**Rules & Guidelines:**

* `stripe-get-credit-note` and `stripe-get-refund` are on the stripe server; `business-central-get-posted-sales-credit-memo` and `business-central-get-customer` are on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-sales-credit-memo`, `business-central-create-sales-credit-memo-line` or `business-central-update-sales-credit-memo`.
* Refunds with reason fraudulent or duplicate may be handled in Business Central by reversing the invoice instead. Say so in their rows rather than calling them errors.

**Validation:**

* If Stripe returns nothing for the range, say so and stop.
* If the Stripe customer has no Business Central customer, say so in the row rather than failing the whole run.

Who it's for

One answer, three teams that use it

Accounts receivable

Find missing credit memos

Refunds with no credit memo are listed with amounts, ready to enter.

Check October's Stripe refunds and credit notes against credit memos in Business Central.

Controllers

Count each refund once

Refunds behind credit notes are counted once, so the totals you report are right.

What is the total of Stripe refunds last quarter with no Business Central credit memo, per currency?

Revenue accountants

Separate real gaps from reversals

Refunds that were likely handled by reversing the invoice are noted rather than flagged as errors.

Which Stripe refunds this month look missing from Business Central and which were probably reversed?

How it works

What PopdockAI does when you ask

You give a date range, and your AI assistant checks Stripe refunds and credit notes against Business Central credit memos. It only reads and totals per currency.

01

Ask

You give a date range.

Your AI tool

02

Read

It reads Stripe credit notes and refunds, dropping refunds a credit note already covers.

stripe-get-credit-note
stripe-get-refund

03

Match

It finds each credit memo by reference, then by customer and exact amount.

No items found.

04

Report

You get matched, missing and pending items with totals 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-credit-note

Returns credit notes (number, customer, invoice, reason, amount, status) from Stripe.
get-data

stripe-get-refund

Returns refunds (charge, customer, amount, reason, status) 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

Every refund accounted for, without false alarms

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