Stripe AI: Ask Your Payments Data Questions
Yes, you can ask Stripe questions in plain English. The useful part is which records the answer is built from, because gross, net and payouts are three different numbers.
Yes, you can ask Stripe questions in plain English and get a number back, such as net volume by month, fees last quarter, or which customers churned. The answer is only as good as the records it is built from, and Stripe has several kinds: charges, refunds, fees, payouts, subscriptions and invoices. Most wrong answers come from mixing them up, not from the AI.
Three totals that get called revenue
Stripe records money at several points, and each total answers a different question.
- Gross volume is successful charges before refunds, disputes and fees.
- Net volume is gross volume less refunds, disputes and all Stripe fees. This is the figure the Dashboard reports as net volume from sales.
- Payouts are what was sent to your bank. They lag the sales and include timing differences, so they are a cash question, not a sales question.
If someone asks what we made in March, they could mean any of the three. Before you ask an AI, or a colleague, name the one you want. That one habit removes most of the disagreements.
How to answer these by hand first
In the Stripe Dashboard, the Balance report lists balance transactions with gross, fee and net columns. Export it for a month, filter by type, and sum each column. Charges and refunds, disputes and payouts all appear in that one list, which is why it is the right base for money questions. For subscriptions, the Billing section shows MRR, and the subscriptions list shows who is active.
The by-hand method breaks down at two points. Comparing months means exporting and re-summing each time, and any question that crosses objects, such as which customers have overdue invoices and what their MRR is, means combining several exports. That is the part worth handing to a tool.
Questions worth asking
- What was net volume by month this year?
- How much did we pay in Stripe fees last quarter?
- How many payments failed this month, and why? (the failure code is on each payment)
- How has MRR changed month by month?
- Which customers churned last month, and how much MRR did we lose?
- Which products bring in the most MRR?
- Which customers have overdue invoices?
Notice that each one names an object, a measure and a period. A question that leaves out any of the three leaves the tool guessing.
How Quiriz reads Stripe
The Stripe connector is in beta. It brings in seven datasets: [Stripe] Payments, [Stripe] Balance transactions, [Stripe] Subscriptions, [Stripe] Invoices, [Stripe] MRR by month, [Stripe] Subscription snapshots and [Stripe] Customers. The balance transactions dataset is shaped like Stripe's Balance report, with gross, fee and net signed the way Stripe signs them, so Net volume matches what the Dashboard shows.
Defined metrics sit on top of those datasets: Gross volume, Refunded amount, Dispute losses, Processing fees, Net volume, Payouts, Payment success rate, MRR, ARR, New MRR, Expansion MRR, Contraction MRR, Churned MRR and Reactivation MRR, among others. Because they are defined once in Company Context, net volume means the same thing whoever asks and on whichever surface, and the answer shows the work so you can see which dataset and filters produced it.
The connector is read-only, refreshes daily and is included in paid plans. For the monthly layout these questions fit into, see Stripe reporting: MRR, refunds and fees in plain English.
A worked example: one question, three readings
Suppose the question is what did we make in September? A careful answer asks which total is meant, then gives each. In this illustrative example, gross volume is 52,000, net volume is 47,800 after refunds, disputes and fees, and payouts to the bank are 44,300 because a few days of sales had not yet paid out. All three are correct. The first is what customers paid, the second is what the sales were worth to you after Stripe's costs, and the third is cash that arrived.
A tool that returns only one of them without saying which is making the choice for you. A tool that names the metric, shows the dataset and filters behind it, and lets you ask for the others is doing the job. When you evaluate any AI on payments data, run exactly this test: ask the same question twice with slightly different wording and see whether the definition stays put.
Limits you should know
- One account per connection. A Stripe App token reads only the account that installed it.
- A payment cap. Charges are read first and set the window. If an account has more payments than the cap, the datasets show a note saying they start later than a full history.
- Currency. Payments, balance transactions, invoices and MRR rows carry an
is_home_currencyflag. The defined metrics filter to the account currency, and you should never add currencies together. - Test mode. If the newest balance transaction is a test record, the dataset carries a notice that these are test records, not live payments.
- MRR is Stripe Billing's rule, not yours. Trials, metered items and tax are not counted, and a plan switch shows as one churn and one new. If your finance team defines MRR differently, define that in Company Context rather than assuming the two agree.
How to check any AI answer about money
Pick one month, ask for net volume, and compare it with the Dashboard's figure for the same month in the same time zone. If it matches, the definition is right and you can trust the repeat questions. If it does not, the answer should show the filters it used, and the gap is usually a definition or a window, which you can fix once. The same discipline appears in why your team gets different numbers.
Ask Stripe a question and see the work
Connect Stripe, ask for net volume by month or MRR movement in plain English, and compare it with your Dashboard. Free to start.
Try Quiriz free →