/
/
Tie each Stripe payout to its NetSuite payments and fees
For finance teams who ask their AI assistant what is inside a Stripe payout and whether NetSuite has the payments, deposit and fees.
On this page
Connector
Connect Stripe, pick your AI tool and paste the prompt.
The problem
One payout, bundled charges, refunds and fees
A Stripe payout lands in the bank as one amount, but it bundles charges, refunds and fees. Tying it back to customer payments and deposits in NetSuite means breaking it apart by hand, and a gap or an unposted fee is easy to miss.
Without PopdockAI
- Open the payout and its balance transactions
- Total charges, refunds and fees by hand
- Search NetSuite for payments and a deposit
- Miss the fees that still need posting
With PopdockAI
- The payout is broken into charges, refunds, fees and net
- Net is checked against the payout amount
- NetSuite payments and a matching deposit are looked for
- The fee total and any gap are reported, 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:** Trace Stripe payout `{payout-id}` to the NetSuite books, and report fees and unrecorded items. Look for NetSuite entries within `{window-days}` days of the arrival date (default 7).
**Step 1: The payout**
Call `stripe-get-payout` (stripe server) with `payout-id` set to `{payout-id}`. Note `amount`, `arrival-date`, `status`, `balance-transaction-id`. If it is not found, stop.
**Step 2: What it contains**
Call `stripe-get-balance-transaction` (stripe server) for the balance transactions in the payout window and group them by `type` and `reporting-category`: charges, refunds, fees, adjustments. Sum `amount`, `fee` and `net`, and check that the net equals the payout amount.
**Step 3: The books**
Call `netsuite-get-customerpayment` (netsuite server) with `date.from` and `date.to` around the payout, and `netsuite-get-customerdeposit` (netsuite server) over the same dates. Look for entries whose totals match the charges or the payout net.
**Step 4: Report**
State payout amount, gross charges, refunds, fees and net, then which charges have a NetSuite payment, which do not, and whether a deposit matches the payout net. List the fee total, since NetSuite may need it posted as an expense.
**Rules & Guidelines:**
* `netsuite-*` tools are on the netsuite MCP server and `stripe-*` tools are on the stripe MCP server. Both servers must be connected.
* This prompt is read-only. Call only the `netsuite-get-*` and `stripe-get-*` tools named above. Never create, update, refund, void or delete anything in either system.
* Pass only filters the tool actually has. Never guess an id.
**Validation:**
* If net does not equal the payout amount, report the gap instead of forcing a match.
* If NetSuite shows nothing in the window, widen it once and say so.Who it's for
One answer, three teams that use it
Cash accountants
Tie a payout to the books
See which charges have a NetSuite payment and whether a deposit matches.
Trace Stripe payout po_1R2aBc to NetSuite and tell me if the deposit is recorded.
General ledger accountants
Post the fees
The fee total for the payout comes ready to post as an expense.
What were the Stripe fees in payout po_1R7xYz, and are they in NetSuite?
Controllers
Find payout gaps
When net does not equal the payout, the gap is reported plainly for investigation.
Does Stripe payout po_1QzT9k add up, and which charges have no NetSuite payment?
How it works
What PopdockAI does when you ask
You give a payout ID, and your AI assistant breaks it apart and checks NetSuite for the payments and deposit. It only reads and reports a gap rather than forcing a match.
01
Ask
You give the payout ID and, optionally, a search window in days.
02
Break down
It reads the payout and groups its charges, refunds, fees and net, checking net against the payout amount.
03
Check books
It looks for matching NetSuite customer payments and a matching deposit.
04
Report
You get what has a payment, what does not, whether a deposit matches and the fee total.
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
stripe-get-balance-transaction
netsuite-get-customerpayment
netsuite-get-customerdeposit
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
Each payout tied to its payments and fees
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)
