Connectors

/

PowerGP Online

/

Reconcile a PowerGP Online customer balance with Stripe
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile a PowerGP Online customer balance with Stripe
Reconcile what Contoso Ltd owes in Dynamics GP against their Stripe invoices and charges for the last 90 days.
GP and Stripe differ by 1,250.00 USD for Contoso Ltd over the last 90 days. - GP balance due: 4,800.00 USD - GP open receivables: 4,800.00 USD, one item 12 days past due - Stripe amount remaining: 3,550.00 USD - Likely cause: a payment taken in Stripe not yet applied in GP Want the individual invoices behind the difference?
PowerGP Online
Sample figures. Your results come from your own account.
powergp-online-get-customers
powergp-online-get-receivablestransactions
stripe-get-customer
stripe-get-invoice
stripe-get-charge

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

PowerGP Online

PowerGP Online
Run it on your own PowerGP Online data.

Connect PowerGP Online, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

02

Find

It finds the customer in PowerGP Online and in Stripe, and stops if several match.

powergp-online-get-customers
stripe-get-customer

03

Total

It totals GP receivables and Stripe invoices and charges.

powergp-online-get-receivablestransactions
stripe-get-invoice
stripe-get-charge

04

Report

You get the difference and the likely causes.

Your AI tool

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.

get-data

powergp-online-get-customers

Returns customers from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

powergp-online-get-receivablestransactions

Returns receivables transactions from the PowerGP Online connector (Microsoft Dynamics GP). Read-only; can be filtered by company and the record fields it offers.
get-data

stripe-get-customer

Returns customer records (name, email, balance, delinquency, address) from Stripe.
get-data

stripe-get-invoice

Returns invoices (number, customer, status, dates, totals, amount remaining) from Stripe.
get-data

stripe-get-charge

Returns charges (amount, status, refunds, customer, card used) from Stripe.
Read only.Nothing in PowerGP Online 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

The gap and its likely cause, before it becomes a dispute

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