/
/
Catch Salesforce wins that never got billed in Stripe
For finance teams who want every closed won Salesforce deal checked for a matching Stripe customer and subscription, by asking their AI assistant.
On this page
Connector
Connect Salesforce, pick your AI tool and paste the prompt.
The problem
Won deals that never turn into billing
Opportunities marked closed won in Salesforce do not always become a Stripe customer or subscription, and the gap shows up only when revenue does not reconcile. Checking means listing wins, finding each deal's contacts and searching Stripe for every email.
Without PopdockAI
- List recent closed won deals
- Find the contacts on each deal
- Search Stripe for every email by hand
- Discover the gap at month end
With PopdockAI
- Closed won deals and their contact emails are collected
- Each email is checked for a Stripe customer and new subscription
- Unbilled deals are listed largest first
- Read only, with unverifiable contacts listed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find opportunities closed won since `{closed-since}` (default: the first day of the previous month), optionally owned by `{owner}`, where no contact on the deal or its account is billed in Stripe.
**Step 1: List closed-won deals in Salesforce**
Call `salesforce-get-opportunity` with `won` set to true and `close-date.from` set to `{closed-since}`. Add `owner.contains` set to `{owner}` when it is given.
**Step 2: Collect the emails for each deal**
Call `salesforce-get-opportunity-contact-role` with `opportunity-id` set to the deal's opportunity-id, then `salesforce-get-contact` with `contact-id` for each role to get the email. If the deal has no contact roles, call `salesforce-get-contact` with `account-id` set to the deal's account-id instead and note that the match is account-level.
**Step 3: Look each email up in Stripe**
Call `stripe-get-customer` with `email` set to each email. For each customer found, call `stripe-get-subscription` with `customer-id` and check for a subscription created on or after the close-date with status active or trialing.
**Step 4: Report**
Three groups. No Stripe customer: opportunity name, account, owner, amount, close-date, emails tried. Stripe customer but no new subscription: the same plus customer-id and its latest subscription status. Billed: a one-line count only. Sort each group by amount, largest first.
**Rules & Guidelines:**
* `salesforce-get-opportunity`, `salesforce-get-opportunity-contact-role` and `salesforce-get-contact` are on the salesforce server. `stripe-get-customer` and `stripe-get-subscription` are on the stripe server.
* The join is the contact email against the Stripe customer email, matched case-insensitively and trimmed. Do not count a match on company name alone; if a Stripe customer name looks like the account name but no email matches, report it as a possible match only.
* This is read-only. The stripe server cannot create customers. Do not call `salesforce-update-opportunity`, `salesforce-add-task`, `salesforce-update-contact` or any other salesforce add or update tool.
**Validation:**
* If no deals closed won in the window, say so and stop.
* A contact with no email cannot be checked; list it as unverifiable rather than unbilled.Who it's for
One answer, three teams that use it
Revenue accountants
Catch unbilled wins before month end
Find closed won deals with no Stripe customer or subscription while there is still time to fix them.
Which deals closed won in Salesforce this month have no new subscription in Stripe?
Billing specialists
Set up billing for every new customer
Get a list of wins that still need a Stripe customer, largest deals first.
List Salesforce wins since October 1 with no Stripe customer, biggest first.
Sales operations
Close the gap between sales and billing
Check a rep's or team's wins against billing so nothing sold is left unbilled.
Are any of Jordan Lee's closed won deals since August not billed in Stripe yet?
How it works
What PopdockAI does when you ask
You give a start date, and your AI assistant checks every recent win for billing in Stripe. Nothing is changed in either system.
01
Ask
You give a start date, and optionally an owner.
02
Read
It lists deals closed won since then and collects their contact emails.
03
Check
It looks up each email in Stripe for a customer and a new active subscription.
04
Report
You get unbilled deals and deals with no new subscription, largest first.
What PopdockAI provides
The tools behind the answer
Ready made tools for Salesforce and one secure connection to your AI tool. No code, no exports.
salesforce-get-opportunity
salesforce-get-opportunity-contact-role
salesforce-get-contact
stripe-get-customer
stripe-get-subscription
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
Everything sold gets billed
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)
