/
/
Match Stripe payouts to GP deposits without false mismatches
For finance teams who reconcile Stripe payouts to a Dynamics GP checkbook and want the matching done by their AI assistant.
On this page
Connector
Connect Stripe, pick your AI tool and paste the prompt.
The problem
Fee differences hide real deposit gaps
Reconciling Stripe payouts to the bank means scrolling the GP checkbook for deposits that look like them. Payouts are net of fees, so amounts rarely match exactly, and genuine deposits get flagged as mismatches while real gaps are missed.
Without PopdockAI
- List Stripe payouts by arrival date
- Scroll the GP checkbook for similar deposits
- Decide which differences are just fees
- Miss the payouts that were never recorded
With PopdockAI
- The checkbook is confirmed with its balance and last reconciled date
- Payouts pair with deposits of the same amount within five days
- Near matches within five percent are set aside as likely fees
- The net unrecorded amount is shown, 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:** Check that Stripe payouts arriving between `{date-from}` and `{date-to}` were recorded as deposits in GP checkbook `{checkbook-id}`.
**Step 1: Stripe payouts**
Call `stripe-get-payout` with `arrival-date.from` and `arrival-date.to`. Keep `payout-id`, `amount`, `currency`, `arrival-date` and `status`; ignore failed payouts but list them.
**Step 2: GP bank side**
Call `powergp-online-get-bankbalances` with `checkbook-id` to confirm the checkbook exists and show its `current-balance` and `last-reconciled-thru-date`. If it does not exist, stop. Then call `powergp-online-get-cashtransactions` with `checkbook-id`, `transaction-date.from` and `transaction-date.to` widened by 5 days each side. Keep rows with a `debit` greater than 0 (deposits).
**Step 3: Match**
Pair each payout with a deposit of the same amount within 5 days of `arrival-date`. A payout equals the net of charges, so a deposit may differ by fees; list near matches within 5 percent separately.
**Step 4: Report**
Matched, payouts with no deposit, deposits with no payout, and the net unrecorded amount.
**Rules & Guidelines:**
* Tools prefixed powergp-online- belong to the powergp-online-ai server (Dynamics GP). Tools prefixed stripe- belong to the stripe server. Both servers must be connected.
* Read-only. Call only get tools. Never create, change or delete anything on either side.
* Pass `company` on every GP call when the user names one; otherwise state which company the GP data came from.
* Stripe amounts and GP amounts may use different currencies; compare only like currencies and flag the rest.
**Validation:**
* If either side is empty for the range, say so and report the other side only.
* If the payout currency differs from the checkbook currency (`currency-id`), do not compare amounts.Who it's for
One answer, three teams that use it
Cash accountants
Reconcile without false mismatches
Fee near matches are separated, so the real gaps are the only ones left.
Did all Stripe payouts from 1 to 31 October get recorded as deposits in checkbook OPERATING?
Controllers
Know the unrecorded total
The net unrecorded amount tells you how much cash is missing from the books.
What is the net amount of Stripe payouts not recorded in PowerGP Online this month?
Bookkeepers
See the checkbook status first
The balance and last reconciled date are shown before matching, so you know where you stand.
Show the balance of checkbook FIRSTBANK and match last week's Stripe payouts to it.
How it works
What PopdockAI does when you ask
You give a date range and a checkbook, and your AI assistant matches Stripe payouts to PowerGP Online deposits. It only reads and keeps currencies apart.
01
Ask
You give a date range and a checkbook.
02
Check
It confirms the checkbook exists in PowerGP Online and shows its balance.
03
Match
It pairs Stripe payouts with deposits and sets fee near matches aside.
04
Report
You get matched items, gaps on each side and the net unrecorded amount.
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
powergp-online-get-bankbalances
powergp-online-get-cashtransactions
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
Payouts reconciled with fees separated
Related use cases
More ways to put this data to work
Check Stripe refunds against PowerGP Online credits
Ask your AI to check a customer's Stripe refunds against GP credits. It pairs them by amount and date and lists the gaps on each side.
Learn More
Find Stripe customers missing from PowerGP Online
Ask your AI to check Stripe customers against PowerGP Online and it lists the matched, ambiguous and unmatched ones, labelling name matches as likely and changing nothing.
Learn More
Apply Stripe payments to Rillet invoices
Ask your AI to apply Stripe payments to Rillet invoices and it matches charges by invoice number, skips duplicates and overpayments, and records only what you confirm.
Learn More
Backfill Stripe invoices into Rillet
Ask your AI to backfill Stripe invoices into Rillet and it finds the ones missing, matches customers and products exactly, and records only the invoices you confirm.
Learn More
Book Stripe fees to Intacct
Ask your AI to book Stripe fees to Sage Intacct and it totals the month's fees, checks the accounts and for an existing entry, and creates the journal entry only after you approve.
Learn More
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.