Connectors

/

Stripe

/

Match Stripe payouts to Dynamics GP deposits
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Match Stripe payouts to Dynamics GP deposits
Match Stripe payouts from 1 to 30 September to deposits in the OPERATING checkbook in Dynamics GP.
17 of 19 Stripe payouts match a Dynamics GP record in the OPERATING checkbook. - Matched: 15 deposits and 2 bank transactions by amount and date - Possible: 2,880.40 matches on amount but was recorded 5 days later - Unmatched: 4,105.92 that arrived 26 September has no GP record Want the details for the unmatched payout so it can be recorded?
Stripe
Sample figures. Your results come from your own account.
stripe-get-payout
microsoft-dynamics-gp-get-gl-bank-deposit
microsoft-dynamics-gp-get-gl-bank-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

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.

Prompt
**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.

Your AI tool

02

Read

It reads paid Stripe payouts that arrived in the range.

stripe-get-payout

03

Match

It looks in GP deposits, then bank transactions, within three days.

microsoft-dynamics-gp-get-gl-bank-deposit
microsoft-dynamics-gp-get-gl-bank-transaction

04

Report

You get matched, possible and unmatched payouts, with currency issues noted.

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

microsoft-dynamics-gp-get-gl-bank-deposit

Returns bank deposit records from Dynamics GP General Ledger bank reconciliation, including checkbook, deposit date and amount. Filter by deposit number, currency ID, checkbook ID, deposit amount, deposit date, description and type, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-gl-bank-transaction

Returns bank transactions from Dynamics GP General Ledger (Bank Reconciliation), including checkbook, transaction type, dates, amounts and reconciliation status. Filter by CM transaction type, checkbook ID, CM transaction number, reconciled, transaction date, paid to received from, voided and description, and pick the company and the maximum number of records.
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 payout tied to a deposit or listed to record

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