88% Renewal rate, up from 76% before automated retention
Project Map It, a B2B SaaS platform serving home improvement contractors, was running its commercial operation on Excel. Subscription pricing across four tiers was recomputed manually each month. Sales commissions were reconciled by hand with no privacy controls. Renewals had no pipeline. Worst of all, the internal revenue report disagreed with Stripe by approximately $61,000, and nobody could explain it. INSIDEA spent the first three weeks not building, but auditing, diagnosing the root causes inside HubSpot, Stripe, and the spreadsheets that had been bolted onto both. We then designed and shipped a seven-step calculated property chain that runs all four pricing tiers automatically, a separate renewal pipeline with 90-day forward visibility, per-rep commission dashboards with system-enforced privacy, a custom HubSpot-powered customer portal, and partner attribution dashboards for SRS, ABC Supply, and CertainTeed. Eight months later, the dashboard agrees with the bank.
Numbers That Tell the Story
- Industry
- B2B SaaS
- Location
- Arnold, Maryland, USA
- Service
- HubSpot Sales, Service & Operations Hub + Custom Portal
- Timeline
- October 2024 - Ongoing (Monthly Retainer)
Replace Excel-driven revenue operations with a HubSpot-native system that the leadership team could trust without going back to Stripe.
A SaaS Business Running on Spreadsheets
Project Map: It had built a successful product. Their map-based portfolio tool was helping contractors close more in-home appointments, and the customer base was growing across single-location roofers, multi-location service companies, and large national accounts. But the commercial infrastructure underneath the product had not kept pace with that growth.
Subscription revenue was reconciled by hand each month. Pricing across four plan tiers was being recomputed manually in a spreadsheet. Sales commissions had no privacy controls, every rep could see what every other rep was being paid, which was creating real internal tension. Renewals had no pipeline at all. Churn was not measured, and on more than one occasion, churned customer records had been deleted entirely, taking the historical data with them.
The single largest piece of friction was the revenue reconciliation gap. The internal report showed roughly $132,000 in subscription revenue for the period. Stripe showed roughly $71,000. The $61,000 difference was not a rounding error, it was a structural disagreement between two systems that should have been telling the same story, and nobody could explain it.
Every leadership decision the company was making was based on a baseline nobody fully trusted.
Excel as the Calculation Layer
Every commercial number on every deal, plan amount, partner discount, rep commission, was being entered manually or recomputed in Excel each month. There were zero calculated properties on the deal record. Across deals, commissions, onboarding, and renewals, we counted fourteen distinct manual processes.
Stripe-to-HubSpot Data Drift
Yearly subscriptions were not being correctly accounted for in the monthly internal report. Stripe's billing event categorization wasn't cleanly mapped to HubSpot's deal model. Discount codes from partner programs were arriving as Stripe metadata that HubSpot wasn't reading. Together: a $61K gap nobody could explain.
Manual Commissions Without Privacy
Four sales reps, each with a different commission rate, all reconciled by hand each month. No system-level privacy meant every rep could see every other rep's compensation. The math was inconsistent across deals, and disputes were running 5–6 per quarter.
Onboarding via Email Thread
New customers were being onboarded through ad-hoc email threads. Stalled onboarding was invisible until somebody noticed weeks later. Distribution partner channels (SRS, ABC Supply, CertainTeed) drove significant volume but were tracked only in spreadsheets, with no way to optimise the relationships.
A HubSpot-Native Revenue Engine, Built in Sprints
INSIDEA approached the engagement as an architecture problem first and a configuration problem second. We spent the first three weeks not changing a single HubSpot setting – instead, auditing 438 company records, 12 months of plan data, the Stripe integration, and every manual process the team was running.
The diagnosis was that Project Map It did not have a HubSpot problem. They had four people each carrying a piece of the truth in their heads, and a CRM that didn’t know what any of them knew. The Excel files were a symptom, not the cause. We then ran the engagement in sprints, not a single big-bang implementation, because the business could not pause its commercial operations while we rebuilt them. Every sprint produced a deliverable that Stephen could test and sign off on. No sprint was marked as done until the outcome was visible to him in HubSpot and confirmed in writing.
Seven-Step Calculated Property Chain
Plan Amount → Discount Logic → CT Payout % → PMI Amount → CTP → Commission Rate → Rep Commission. The chain runs every time a deal is created or updated. No human ever touches any of these values. The conditional logic at steps 2, 3, and 6 handles the location-count and seniority-level corporate plan formula natively in HubSpot Operations Hub, no Zapier transforms, no external scripts.
Separate Renewal Pipeline With 90-Day Trigger
When a deal's close date comes within 90 days and the deal stage is still Active, a new deal is automatically created in the renewal pipeline, the customer is enrolled in a retention sequence, the deal is assigned to an Account Manager, and a renewal review task is created. The trigger is conditional, it does not fire on already-churned companies.
Per-Rep Commission Dashboards With System-Level Privacy
Each rep sees only their own numbers. Admins and leadership see all four. The privacy is enforced by HubSpot ownership filtering rules, not by trust or by emailed PDFs. Month-end reconciliation that used to take hours is now automated. Disputes have dropped from 5–6 per quarter to 1–2.
Custom HubSpot-Powered Customer Portal
The one piece of the engagement that's genuinely custom-built rather than configured. Six components: HubSpot-authenticated login, dynamically rendered CSM card, live onboarding notes from HubSpot Activity, document area, support ticket form, and a HubSpot CMS-managed resource library. The portal reads directly from HubSpot in real time, no synchronised cache, no stale data.
Partner Attribution Dashboards
SRS Distribution, ABC Supply, and CertainTeed each have a dedicated dashboard. When a form is submitted with a partner attribution field populated, the resulting deal carries a partner source property, is enrolled in the partner pipeline, and is counted on that partner's dashboard. 90%+ of partner-driven deals are now tracked end-to-end.
Six Workflows Replacing Fourteen Manual Processes
Churn tagging with auto-date capture and Slack notification. Renewal trigger with conditional firing. Onboarding follow-up with day-1, day-7, day-14 escalation. Commission date capture. Partner referral attribution. Event lead nurture (5-touch sequence over 21 days, reusable for any trade show). Stalled onboarding now surfaces automatically, nobody is chasing it manually.
A Revenue Engine the Founder Can Trust
It walked into this engagement with HubSpot as a contact database. They walked out with HubSpot as the system of record for the entire commercial operation. The dashboard agrees with the bank. Commissions reconcile themselves. Renewals are visible 90 days out. None of those statements was true in October. The retainer has been extended twice, and INSIDEA continues to operate as the embedded RevOps team rather than as an external implementation partner.
- Reconciliation gap
- $61K → <$2K
- Renewal rate
- 76% → 88%
- Onboarding completion (21 days)
- 42% → 68%
- Monthly reconciliation hours
- 28–32 → 6–8
- Commission disputes per quarter
- 5–6 → 1–2
- Partner-driven deals tracked
- 90%+
- Commission calculations automated
- 100%
Built for B2B SaaS Companies Outgrowing Their Spreadsheets
It is not a unique case. The shape of the work and the failure modes that necessitated it recur across the broader software industry. SaaS pricing evolves faster than the infrastructure tracking it. New tiers get added. Partner discounts are negotiated. New commission structures roll out. Each of these gets bolted onto Excel because HubSpot was never set up to handle them. If you're running a B2B SaaS business and the patterns from this case study sound familiar - Stripe-to-HubSpot data drift, commission reconciliation as a month-end fire drill, partner channels with no attribution, onboarding via email, the architectural moves we made for Project Map It will transfer to your business. The pricing math, partner names, and commission rates will be different. The shape of the work will not.
- B2B SaaS companies with multi-tier subscription pricing
- Stripe-billed software businesses with HubSpot reconciliation gaps
- Software companies with 4+ sales reps on manual commissions
- Vertical SaaS players with active distribution partners
- Subscription businesses with no formal renewal motion
- Founders making decisions on numbers nobody fully trusts
Answers to the questions teams ask before they start
What does a HubSpot rebuild for a B2B SaaS company actually involve?
It starts with a full audit of the current HubSpot configuration, the Stripe (or other billing) integration, and every manual process the commercial team is running. From there it includes data model redesign, calculated property architecture, workflow deployment, dashboard build, integration stabilization, and ongoing optimization. For Project Map It specifically, it also included a custom HubSpot-powered customer portal. The work is delivered in sprints over 8+ months on a monthly retainer, not as a one-time implementation.
How long does it take to close a Stripe-to-HubSpot reconciliation gap?
The diagnosis itself takes 1–2 weeks of audit work. Closing the gap typically requires fixing three to five distinct issues, yearly subscription accounting, billing event categorization mapping, discount code metadata pass-through, integration deduplication, and product line item architecture. For Project Map It, the $61K gap was diagnosed in three weeks and fully closed inside the first six weeks of building. By month three, variance was under $2,000.
Can HubSpot really handle complex commission calculations natively?
Yes, but it requires deliberate architecture. A single calculated property in HubSpot can’t always handle a multi-variable formula by itself, so you have to build chained intermediary properties. Project Map It’s seven-step calculated property chain handles four pricing tiers, multiple partner discounts, and four rep-specific commission rates entirely inside HubSpot Operations Hub. No Zapier transforms, no external scripts. 100% of commission calculations are now system-generated.
How do you enforce commission privacy at the system level?
Through HubSpot’s ownership-based filtering combined with team and permissions configuration. Each rep’s dashboard is filtered to show only deals they own. Admins and leadership see all reps. The privacy is enforced by HubSpot configuration rules, not by emailed PDFs, not by trust, not by separate spreadsheets.
Why is the customer portal a custom build rather than HubSpot's out-of-the-box service portal?
Project Map It needed real-time CSM card rendering, an embedded video welcome message, a HubSpot CMS-managed resource library, and a documents area that surfaced any file attached at the contact level. The portal also had to read directly from HubSpot rather than from a synchronised cache. This level of customisation sat just outside the boundaries of HubSpot’s standard service portal, which is why we built it custom against the HubSpot APIs.
How long would a similar engagement take for another SaaS company?
Typical scope is 3–9 months for the foundational rebuild, with continuous optimisation as a monthly retainer afterward. Project Map It was 3 weeks of audit, 4 weeks of architecture design, 6 weeks of implementation, 4–5 weeks of portal and renewal pipeline buildout, then ongoing optimisation. The retainer model continues because the system keeps evolving as the business grows.
More from B2B SaaS.
Picked by industry and service line match. Three closest stories.
Ready to be the next case study?
30 minutes with a senior consultant. We map your specifics, share what we'd ship, deliver a written one-pager.
How INSIDEA works
