/
/
Tie every Stripe payout to a Dynamics GP deposit
For accountants who want each Stripe payout matched to a Dynamics GP bank deposit or transaction by asking their AI assistant.
On this page
Connector
Connect Stripe, pick your AI tool and paste the prompt.
The problem
Payouts that share an amount get matched wrong
Stripe pays out in lump sums after fees, so each bank deposit in Dynamics GP has to be matched to a payout by amount and date. When several payouts share an amount or a deposit was recorded late, matching by hand gets confusing and some payouts are never recorded.
Without PopdockAI
- List Stripe payouts by arrival date
- Search GP deposits and bank transactions
- Untangle payouts that share an amount
- Miss payouts that were never recorded
With PopdockAI
- Paid payouts in the range are read from Stripe
- Each is found in GP deposits, then transactions, within three days
- Each payout matches at most one record, ties by nearest date
- Possible and unmatched payouts are listed, 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.
**Objective:** Match every paid Stripe payout that arrived from `{start-date}` to `{end-date}` to a deposit or bank transaction in Dynamics GP checkbook `{checkbook-id}` (if empty, search every checkbook), and list the payouts that are not in GP.
**Step 1: Read the payouts**
Call `stripe-get-payout` with `status` = `paid`, `arrival-date.from` = `{start-date}` and `arrival-date.to` = the day after `{end-date}`. Drop any payout arriving after `{end-date}`. Keep `payout-id`, `amount`, `currency`, `arrival-date`, `description` and `balance-transaction-id`. A payout `amount` is what reached the bank, after Stripe fees.
**Step 2: Look for each payout in GP deposits**
For each payout, call `dynamics-gp-get-gl-bank-deposit` with `deposit-amount.min` and `deposit-amount.max` both equal to the payout `amount`, `deposit-date.from` and `deposit-date.to` set to the arrival date plus or minus 3 days, and `checkbook-id` = `{checkbook-id}` when it is given.
**Step 3: Then in GP bank transactions**
If no deposit matches, call `dynamics-gp-get-gl-bank-transaction` with `checkbook-amount.min` and `checkbook-amount.max` both equal to the payout `amount`, the same date window as `transaction-date.from` / `transaction-date.to`, `voided` = false, and the same `checkbook-id`. Also try `description.contains` with the `payout-id`, since some teams paste it into the description.
**Step 4: Report**
A summary first: payouts read, total paid out, matched to a deposit, matched to a bank transaction, unmatched. Then a table with Payout ID, arrival date, amount, GP record type (deposit or bank transaction), GP number (`deposit-number` or `cm-transaction-number`), GP date, checkbook, reconciled status. Put the unmatched payouts last with their amounts and dates so someone can record them. Also list any GP record that matched more than one payout.
**Rules & Guidelines:**
* `stripe-get-payout` is on the stripe server. `dynamics-gp-get-gl-bank-deposit` and `dynamics-gp-get-gl-bank-transaction` are on the dynamics-gp server.
* This prompt is read-only. Do not call `dynamics-gp-gl-bank-deposit-add`, `dynamics-gp-gl-bank-transaction-add` or any other dynamics-gp tool whose name does not start with dynamics-gp-get-.
* Match each payout to at most one GP record, and each GP record to at most one payout. When two payouts share an amount, pair them by nearest date.
**Validation:**
* If Stripe returns no paid payouts in the range, say so and stop.
* If a payout matches only on amount and the date gap is more than 3 days, do not count it. List it as a possible match instead.
* If the payout currency is not the checkbook's currency, report it rather than comparing amounts.Who it's for
One answer, three teams that use it
Cash accountants
Tie payouts to deposits fast
Matches come with the record they tied to, so the bank reconciliation is mostly done.
Match Stripe payouts from 1 to 31 October to deposits in the OPERATING checkbook.
Controllers
Find unrecorded payouts before close
Unmatched payouts are listed for recording, so cash is complete.
Which Stripe payouts this month are not recorded in Dynamics GP?
Bookkeepers
Untangle same-amount payouts
Ties are paired by nearest date, and amount-only matches outside the window are flagged as possible.
Several Stripe payouts last week had the same amount. Match them to GP deposits.
How it works
What PopdockAI does when you ask
You give a date range and optionally a checkbook, and your AI assistant ties each Stripe payout to a Dynamics GP record. It only reads and notes currency differences.
01
Ask
You give a date range, and optionally a checkbook.
02
Read
It reads paid Stripe payouts that arrived in the range.
03
Match
It looks in GP deposits, then bank transactions, within three days.
04
Report
You get matched, possible and unmatched payouts, with currency issues noted.
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.
stripe-get-payout
microsoft-dynamics-gp-get-gl-bank-deposit
microsoft-dynamics-gp-get-gl-bank-transaction
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.
The outcome
Every payout tied to a deposit or listed to record
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.

.webp)
