HubSpot deals vs Stripe invoices
“show every closed won hubspot deal with its matching stripe invoice by amount, and add Status that says "Agrees" when it matches, else a short reason to check”
show every closed won HubSpot deals deal with its matching Stripe invoices invoice by amount, and add Status that says "Agrees" when it matches, else a short reason to check
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileHubSpot dealsCSV export · 16 rows
- FileStripe invoicesCSV export · 17 rows
- StepKeep closed won dealsStep 1
- StepAdd company keyStep 2
- JoinJoin matching invoice14 of 15 paired
- StepAdd statusStep 4
- ResultDeal invoice matches16 rows · 1 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out, and the join paired 14 of 15 rows.
- Download HubSpot deals sample (16 rows)HubSpot: Sales > Deals > Export view as CSV
- Download Stripe invoices sample (17 rows)Stripe: Billing > Invoices > Export
What you get back
The result of that run, the rows to look at first.
| Deal ID | Deal name | Deal amount | Close date | Associated company | Deal owner | Invoice id | Invoice number | Invoice customer name | Invoice status | Invoice amount due | Invoice amount paid | Invoice currency | Invoice created | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| d_1015 | Juniper Health Audit | 4,300 | 2026-10-26 | Juniper Health | Owen Hart | · | · | · | · | · | · | · | · | No matching invoice |
| d_1001 | Acme Atlas Annual Plan | 4,800 | 2026-10-21 | Acme Atlas LLC | Mina Patel | in_9011 | INV-9011 | Acme Atlas LLC | paid | 4,800 | 4,800 | usd | 2026-10-21 | Agrees |
| d_1002 | Bluebird Launch Retainer | 2,750 | 2026-10-18 | Bluebird Studio Inc | Jonas Reed | in_9012 | INV-9012 | Bluebird Studio Inc | paid | 2,750 | 2,750 | usd | 2026-10-18 | Agrees |
| d_1003 | Cedar Peak Expansion | 9,200 | 2026-10-14 | Cedar Peak Wellness | Elena Torres | in_9013 | INV-9013 | Cedar Peak Wellness | paid | 9,200 | 9,200 | usd | 2026-10-14 | Agrees |
| d_1004 | Northstar Support Bundle | 1,500 | 2026-10-09 | Northstar Fabrication | Priya Shah | in_9014 | INV-9014 | Northstar Fabrication | paid | 1,500 | 1,500 | usd | 2026-10-09 | Agrees |
| d_1005 | LumenWorks Q4 Services | 6,400 | 2026-10-07 | LumenWorks Co | Owen Hart | in_9015 | INV-9015 | LumenWorks Co | open | 6,400 | 0 | usd | 2026-10-07 | Agrees |
| d_1006 | Harborview Onboarding | 1,800 | 2026-10-02 | Harborview Dental Group | Mina Patel | in_9016 | INV-9016 | Harborview Dental Group | paid | 1,800 | 1,800 | usd | 2026-10-02 | Agrees |
| d_1007 | SummitLine Renewal | 3,300 | 2026-09-29 | SummitLine Logistics | Jonas Reed | in_9017 | INV-9017 | SummitLine Logistics | paid | 3,300 | 3,300 | usd | 2026-09-29 | Agrees |
| d_1008 | Evergreen Partners Sprint | 5,100 | 2026-09-24 | Evergreen Partners | Elena Torres | in_9018 | INV-9018 | Evergreen Partners | paid | 5,100 | 5,100 | usd | 2026-09-24 | Agrees |
| d_1009 | Riverton Analytics Setup | 2,250 | 2026-09-19 | Riverton Analytics | Priya Shah | in_9019 | INV-9019 | Riverton Analytics | paid | 2,250 | 2,250 | usd | 2026-09-19 | Agrees |
| d_1010 | Mosaic Retail Growth | 3,900 | 2026-09-16 | Mosaic Retail Group | Owen Hart | in_9020 | INV-9020 | Mosaic Retail Group | paid | 3,900 | 3,900 | usd | 2026-09-16 | Agrees |
| d_1011 | Pinecone Advisory Package | 7,200 | 2026-09-12 | Pinecone Advisory | Mina Patel | in_9021 | INV-9021 | Pinecone Advisory | paid | 7,200 | 7,200 | usd | 2026-09-12 | Agrees |
How do you reconcile HubSpot deals with Stripe invoices?
Export your closed won deals from HubSpot and your invoices from Stripe. Mammoth keeps the closed won deals, adds a company key, matches the invoice by amount, and adds a Status column. When the amount matches, the status says Agrees. When it does not, you get a short reason to check.
How it works
How to use the Deal invoice matches workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Deal invoice matches: questions
Which export should you use from HubSpot and Stripe?
What happens to rows that do not find a match?
How do you change the matching rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Measure how fast the pipeline turns into revenue, and where people drop out of your funnel.
- Pipeline velocityExport HubSpot deals and review pipeline velocity by month using your chosen rule for open deals, win rate, deal size and cycle days.See the workflow Built by the agent
- Sales cycle lengthMeasure sales cycle length from your HubSpot deals export by rep and source, using closed-won deals from the last 6 months.See the workflow Built by the agent
- Sales pipeline reportBuild a weekly sales pipeline report from Salesforce exports, grouped by rep and stage, with stage changes and past-due deals.See the workflow Built by the agent
- Lead scoringScore HubSpot contacts by company size, job title, and pages viewed from your points table, then list the leads that match.See the workflow Built by the agent
- Win rate by rep and sourceCalculate win rate from a Salesforce opportunities export by rep and lead source for the last two quarters.See the workflow Built by the agent
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template