/
/
Check that Chargebee payments were applied in GP
For finance teams who want recent Chargebee payments matched to PowerGP Online receipts by asking their AI assistant.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Unapplied payments surface when a customer disputes
Payments taken in Chargebee have to be applied to the customer account in GP, and checking each one means looking the customer up in both systems and scanning applied receipts. Slow checks mean unapplied payments are found late.
Without PopdockAI
- List successful Chargebee payments for the period
- Find each customer in PowerGP Online by name
- Scan applied receipts for a matching amount
- Find the gap when the customer disputes
With PopdockAI
- Successful Chargebee payments are read for your window
- Each customer is found in PowerGP Online
- Receipts are matched on amount within 7 days or reference
- Unapplied totals are 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 whether Chargebee payments received in the last {lookback-days} days (default 30) have been applied in PowerGP, optionally for one {customer} only.
**Step 1: Chargebee payments**
Call `chargebee-get-transaction` (chargebee) with `status` set to success, `type` set to payment, `date.from` set to the lookback start, and `customer-id` if the customer was resolved with `chargebee-get-customer` (`company.contains`). Record `id`, `customer-id`, `amount`, `date`, `reference-number`.
**Step 2: Resolve each customer**
For each distinct `customer-id` call `chargebee-get-customer` with `id` to get `company`. Then call `powergp-online-get-customers` (powergp-online-ai) with `customer-name.contains` set to that company. If none match, list the payments as customer not found in PowerGP.
**Step 3: Look for the receipt**
Call `powergp-online-get-receivablesapply` with `customer-number` and `applied-date.from` set to the lookback start. A Chargebee payment counts as applied when an applied amount equals `amount` and the date is within 7 days, or `reference-number` appears in an applied document number.
**Step 4: Report**
Table with Chargebee transaction id, customer, amount, date, and status Applied or Not found in PowerGP. End with counts and the total of unapplied amounts.
**Rules & Guidelines:**
* Tools prefixed powergp-online- belong to the powergp-online-ai server; tools prefixed chargebee- belong to the chargebee server. Both servers must be connected.
* Read-only: call only the get tools named above. Never create, change or delete anything in either system.
* Never print card or bank details; report ids, names and amounts only.
**Validation:**
* If Chargebee has no payments in the window, say so and stop.
* Amounts in different currencies are listed as not comparable.Who it's for
One answer, three teams that use it
Cash application clerks
Find payments still to apply
Every payment marked Not found in PowerGP is a receipt to apply before statements go out.
Which Chargebee payments from the last 14 days are not applied in PowerGP Online?
AR managers
Know the unapplied total
Counts and the total of unapplied amounts show how far behind cash application is.
What is the total of Chargebee payments this month with no applied receipt in PowerGP?
Finance controllers
Check one customer before close
Limit the check to one customer to clear a dispute or a balance query quickly.
Check that every Chargebee payment from Contoso in the last 60 days was applied in PowerGP Online.
How it works
What PopdockAI does when you ask
You give a look-back window and your AI assistant checks each Chargebee payment against applied receipts in PowerGP Online. Different currencies are shown as not comparable.
01
Ask
You give a look back window and, optionally, one customer.
02
Read
It lists successful Chargebee payments in that window.
03
Match
It finds each customer in PowerGP Online and looks for an applied receipt.
04
Report
You get Applied or Not found per payment, with counts and the unapplied total.
What PopdockAI provides
The tools behind the answer
Ready made tools for Chargebee and one secure connection to your AI tool. No code, no exports.
chargebee-get-transaction
chargebee-get-customer
powergp-online-get-customers
powergp-online-get-receivablesapply
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
Unapplied payments listed and totalled
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)
