Connectors

/

Stripe

/

Match Stripe payouts to Dynamics 365 Business Central bank entries
Report
Cross-Connector

Match Stripe payouts to Business Central bank entries

For accountants who want every Stripe payout found on the bank account in Dynamics 365 Business Central by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Stripe payouts to Dynamics 365 Business Central bank entries
Match last month's Stripe payouts to G/L account 10200 in Business Central.
21 of 23 Stripe payouts are on G/L account 10200 in Business Central. - Not found: payout of 6,412.80 that arrived 18 September - Possible duplicate: 3,905.15 appears twice near 9 September - Failed payout: 1 on 22 September, not expected in the bank - Fees: 1,284.33 USD in Stripe fees for the period Want the full match list by date?
Stripe
Sample figures. Your results come from your own account.
stripe-get-payout
stripe-get-balance-transaction

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

Matching lump-sum payouts to bank entries every month

Stripe pays out in lump sums that arrive a few days after the sales, net of fees, so matching them to bank entries in Dynamics 365 Business Central is a monthly chore. Missing deposits, duplicate postings and unrecorded fees hide in the gap.

Without PopdockAI

  • Export paid Stripe payouts
  • Search the bank account for each amount
  • Allow a few days either side for arrival
  • Work out the fees to expense separately

With PopdockAI

  • Paid payouts are matched by exact amount a few days either side
  • Entries mentioning Stripe are preferred and none is used twice
  • Possible duplicates and failed payouts are listed
  • Fees per currency are totalled for expensing, 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 every Stripe payout that arrived from `{from-date}` to `{to-date}` (default: the 30 days ending today) is recorded on G/L account `{gl-account-number}` in Business Central company `{company}` (default: the default company), and summarise the Stripe fees for the same period.

**Step 1: Read Stripe payouts**

Call `stripe-get-payout` with `status` set to paid and `arrival-date.from` / `arrival-date.to` set to the range. Keep `payout-id`, `amount`, `currency`, `arrival-date`, `description` and `balance-transaction-id`. Also call it once with `status` set to failed for the same range, to report separately.

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

For each paid payout, call `business-central-get-general-ledger-entry` with `gl-account-number` set to `{gl-account-number}`, `posting-date.from` 2 days before and `posting-date.to` 3 days after the `arrival-date`, and `amount.min` and `amount.max` both set to the payout amount.

If one entry comes back, it matches. If several come back, prefer the one whose `description`, `document-number` or `external-document-number` contains the payout-id or the word Stripe, and list the others as possible duplicates. If none, record the payout as not found in Business Central and continue. Do not use an entry for more than one payout.

**Step 3: Fees for the period**

Call `stripe-get-balance-transaction` with `created.from` and `created.to` set to the range and sum `fee` per currency. Report the total as the amount of Stripe fees that should be expensed for the period. Do not try to match fees to individual entries.

**Step 4: Report**

1. Matched payouts: payout-id, arrival-date, amount, Business Central entry-number, posting-date, document-number.
2. Payouts not found in Business Central: payout-id, arrival-date, amount, description.
3. Possible duplicates or ambiguous matches.
4. Failed payouts in the period, with failure-message.
5. Stripe fees for the period per currency.

**Rules & Guidelines:**

* `stripe-get-payout` and `stripe-get-balance-transaction` are on the stripe server; `business-central-get-general-ledger-entry` is on the business-central server.
* This prompt is read-only. Do NOT call `business-central-create-journal-line`, `business-central-update-journal-line` or any other create or update tool.
* Stripe amounts are in major currency units, so they compare directly with Business Central amounts.

**Validation:**

* If `{gl-account-number}` returns no entries at all in the window, say that the account number may be wrong or not yet posted, and still list the payouts.
* If a payout is in a currency other than the bank account's, say that an exact amount match is not expected and list it under not found with that reason.

Who it's for

One answer, three teams that use it

Cash accountants

Reconcile Stripe deposits quickly

Matched, missing and duplicate deposits come back in one list for the bank reconciliation.

Match Stripe payouts from October to G/L account 10100 in Business Central.

Controllers

Find payouts that never landed

Payouts with no bank entry are listed, so you can chase them before close.

Which Stripe payouts last month have no matching bank entry in Business Central?

General ledger accountants

Expense the period's fees

The period's Stripe fees per currency come ready to post.

What were Stripe fees per currency for September, alongside the payout matches?

How it works

What PopdockAI does when you ask

You name the bank account and dates, and your AI assistant matches Stripe payouts to Business Central bank entries. It only reads and warns if the account looks wrong.

01

Ask

You name the bank account and a date range.

Your AI tool

02

Read

It reads paid Stripe payouts and the period's fees per currency.

stripe-get-payout
stripe-get-balance-transaction

03

Match

It finds each payout by exact amount a few days either side of arrival.

No items found.

04

Report

You get matches, missing payouts, possible duplicates and fees to expense.

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

Returns payouts to your bank (amount, arrival date, status, failure reason) from Stripe.
get-data

stripe-get-balance-transaction

Returns balance transactions (type, amount, fee, net, availability date) 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

Deposits reconciled, missing payouts and fees ready

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