/
/
Reconcile a GP customer balance with Stripe in one request
For accounts receivable teams who compare Dynamics GP balances with Stripe invoices and want their AI assistant to do the comparison.
On this page
Connector
Connect PowerGP Online, pick your AI tool and paste the prompt.
The problem
GP balances and Stripe invoices disagree and nobody knows why
When a customer pays through Stripe, the amount owed in Dynamics GP and the Stripe invoices should agree. Checking means totalling both by hand, so differences are missed or blamed on the wrong cause.
Without PopdockAI
- Find the customer in GP and total open receivables
- Find the same customer in Stripe
- Total invoices and charges by hand
- Guess at the cause of the difference
With PopdockAI
- The customer found in both systems, with a stop if several match
- GP receivables and Stripe invoices and charges totalled
- The difference with likely causes such as unapplied payments
- Currencies kept apart, and nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For customer `{customer-name}` (optionally GP company `{company}`), reconcile the amount GP says is owed against Stripe invoices and charges, looking back `{lookback-days}` days (default 90).
**Step 1: Find the customer in GP**
Call `powergp-online-get-customers` with `customer-name.contains` set to the name. If more than one customer matches, list `customer-number` and `customer-name` for each and stop. Keep `customer-number`, `customer-name` and `balance-due`.
**Step 2: Open items in GP**
Call `powergp-online-get-receivablestransactions` with that `customer-number`. Total `unapplied-amount` and `document-amount` by `document-type`, and note any with `days-past-due` above 0.
**Step 3: Find the customer in Stripe**
GP has no email on the customer, so match by name. Call `stripe-get-customer` with `name.contains` set to the GP `customer-name`. If several match, list `customer-id`, `name` and `email` and stop. If none match, report the customer as present in GP and absent from Stripe, and skip to Step 6.
**Step 4: Stripe invoices**
Call `stripe-get-invoice` with that `customer-id` and `created-date.from` set to the lookback start. Total `total`, `amount-paid` and `amount-remaining` by `status`.
**Step 5: Stripe charges**
Call `stripe-get-charge` with the same `customer-id`. Total `amount` and `amount-refunded` for succeeded charges.
**Step 6: Report**
A table with GP balance-due, GP open receivables, Stripe amount-remaining and Stripe amount paid, then the difference between GP and Stripe and likely causes (payments not yet applied in GP, invoices not in GP, refunds).
**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 returns nothing, say which and report only the other side.
* If currencies differ between the systems, do not net the figures; show them separately.Who it's for
One answer, three teams that use it
Accounts receivable
Reconcile a customer without the spreadsheet
GP balance, Stripe amount remaining and paid, and the difference in one table.
Reconcile Fabrikam's GP balance with their Stripe invoices for the last 60 days.
Billing managers
Explain a balance before the customer calls
Likely causes such as refunds or payments not yet applied are named for each gap.
Why does Northwind's balance in Dynamics GP not match what Stripe shows as unpaid?
Controllers
Check key accounts before month end
Confirm GP and Stripe agree for a large customer before you close the period.
Does Contoso's open receivables in our US company agree with Stripe this month?
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant reads PowerGP Online and Stripe. It stops if a name matches several customers and writes to neither system.
01
Ask
You name the customer and, if needed, the company and look back period.
02
Find
It finds the customer in PowerGP Online and in Stripe, and stops if several match.
03
Total
It totals GP receivables and Stripe invoices and charges.
04
Report
You get the difference and the likely causes.
What PopdockAI provides
The tools behind the answer
Ready made tools for PowerGP Online and one secure connection to your AI tool. No code, no exports.
powergp-online-get-customers
powergp-online-get-receivablestransactions
stripe-get-customer
stripe-get-invoice
stripe-get-charge
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
The gap and its likely cause, before it becomes a dispute
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)
