Sales Cloud Template for MAKO SCORE

Small business valuation and exit readiness SaaS platforms manage high volumes of Main Street business signups, 14-day free trial conversions, accounting data integrations, and 19-question readiness assessments. When subscription tiers, QuickBooks and Xero connections, Plaid bank verifications, and 3-year tax return uploads live across separate portals and manual spreadsheets, teams lose visibility into mid-onboarding drop-offs and quarterly valuation cycles. This customized Salesforce configuration unifies the entire Mako Score subscription lifecycle - tracking organic and advisor-referred leads, managing monthly and annual subscriptions, monitoring 0-to-1,000 Mako Score updates, and automating retention across business owners, CPAs, and exit planners.
✨ Get this free template installed in Salesforce in one day.
Book a free one-hour onboarding session to get started.
◄ Back to Leads List
L
Lead

Marcus Vance

New Signup
Trial Active
Financials Synced
Quiz Completed
Converted to Paid
Details
Notes
Files

Primary Lead & Trial Information

Full NameMarcus Vance✎
CompanyGulf Coast HVAC Services✎
TitleOwner & President✎
Phone(813) 555-0142✎
Lead StatusTrial Active✎
Lead OwnerKelly Schmidt✎
Lead SourceMeta Lead Form✎
Subscription Plan Interest14-Day Free Trial ($0)✎
Dashboard TypeBusiness Owner Dashboard✎
Referring Advisor AccountSuncoast CPA Advisory Group✎

Business Profile & Onboarding Readiness

Annual Revenue Band$2.5M - $5M✎
Employee Count Tier16 - 30 Employees✎
NAICS Industry Sector238220 - Plumbing & HVAC Contractors✎
Real Estate FootprintThird-Party Commercial Lease✎
Accounting SoftwareQuickBooks Online✎
Onboarding Step ReachedStep 4: Tax Returns Uploaded✎
19-Question Quiz Status15 of 19 Answered✎
Tax Return Upload Status3 Years Uploaded (2023-2025)✎
Plaid Identity & Bank CheckPlaid Identity & OFAC Cleared✎
Owner Exit Horizon1 - 3 Years (Succession Prep)✎
QuickBooks Sync Completed & 3-Year Tax Returns Ingested
Marcus connected QuickBooks Online and uploaded 2023, 2024, and 2025 Form 1120-S returns. OCR parsing matched gross receipts to P&L within 1.2%. He has 4 questions left on the 19-question Mako Readiness quiz regarding commercial lease renewal terms.
Created by Kelly Schmidt • October 12, 2026
14-Day Free Trial Conversion Outreach
Trial expires in 4 days. Automated email journey sent reminding him to finish questions 16-19 so his preliminary Mako Score (estimated 745) unlocks and he can convert to the $29.99/month subscription to download the buyer/lender-ready PDF.
Created by Gerard Perillo • October 10, 2026
Referred via Suncoast CPA Advisory Group
Lead captured through Meta co-branded campaign targeting Southwest Florida HVAC and trades owners with $2M-$5M annual revenue preparing for baby boomer retirement over the next 24 months.
Created by Kelly Schmidt • October 4, 2026
◄ Back to Accounts List
Account

Gulfstream Commercial HVAC LLC

Details
Contacts
Opportunities
Mako Scores
Financial Syncs
Valuation Reports
Notes
Files

Subscriber Account Overview

Account NameGulfstream Commercial HVAC LLC✎
Account TypeMain Street Business Subscriber✎
Subscription StatusActive Paid ($29.99/mo - 3 Seats)✎
NAICS Classification238220 - Plumbing & HVAC Contractors✎
Account OwnerKelly Schmidt✎
Primary Business ContactRobert Hendrickson✎
Annual Verified Revenue$4,850,000✎
Active Mako Score RecordMS-2026-0884 (Score: 782)✎

Valuation & Operational Footprint

Real Estate OccupancyOwner-Occupied Commercial Facility✎
Accounting IntegrationQuickBooks Online + 3-Yr Tax Returns✎
IBISWorld Benchmark TierTop 15% Regional EBITDA Margin✎
Quarterly Refresh CadenceAutomated 90-Day Pull Active✎
Allocated Seat Utilization3 of 3 Seats Active (Owner, CFO, CPA)✎
Headquarters City & StateTampa, FL✎
Q4 90-Day Automated Refresh Raised Mako Score by 34 Points
Gulfstream Commercial HVAC improved their score from 748 to 782 following Q3 QuickBooks synchronization. Recurring commercial maintenance contracts increased from 38% to 49% of total revenue, boosting the SDE multiple against IBISWorld NAICS 238220 benchmarks.
Created by Gerard Perillo • October 03, 2026
All 3 Subscription Seats Active
Robert Hendrickson (Owner), Diane Hendrickson (Co-Owner), and Arthur Pendelton (CPA at Suncoast CPA Advisory) are actively logging into the Business Owner and Advisor views to review Seller Discretionary Earnings add-backs.
Created by Kelly Schmidt • September 18, 2026
Tax-Return vs QuickBooks Valuation Variance Reconciled
Both the QuickBooks-only report ($6.68M) and the 3-Year Tax Return verified report ($6.92M) have been generated. Depreciation and owner vehicle add-backs on the 1120-S accounted for the positive $240K valuation delta.
Created by Kelly Schmidt • August 12, 2026
◄ Back to Contacts List
C
Contact

Robert Hendrickson

Details
Notes
Files

Contact & Portal Seat Assignment

Full NameRobert Hendrickson✎
TitleFounder & Majority Owner✎
Stakeholder PersonaMain Street Business Owner✎
Contact OwnerKelly Schmidt✎
Phone(813) 555-0199✎
Mako Seat AllocationSeat 1 - Primary Admin & Billing✎

Verification & Nurturing Preferences

Plaid KYC Identity StatusVerified Owner & Watchlist Clear✎
Dashboard Access LevelBusiness Owner Full Financial View✎
Report Download ActivityDownloaded Both Tax & QB PDFs✎
Communication CadenceQuarterly Score Digest + Monthly Tips✎
Succession Planning StageOptimizing SDE for 24-Month Exit✎
Latest Viewed Mako ScoreMS-2026-0884 (782 / 1000)✎
Downloaded Lender-Ready PDF & Booked Score Review
Robert downloaded VR-2026-9012 immediately after the automated 90-day refresh email triggered. He clicked the embedded calendar link in the post-download nurture email to review how reducing customer concentration can push his Mako Score over 800.
Created by Kelly Schmidt • October 03, 2026
Invited External CPA to Seat 3
Robert used his 3rd included seat to invite Arthur Pendelton CPA so Arthur can directly upload the 2026 quarterly tax estimates and verify owner add-backs inside the portal.
Created by Gerard Perillo • August 10, 2026
Plaid Identity & Watchlist Authentication Completed
Completed mandatory KYC and US banking identity verification during initial onboarding. Zero flags returned.
Created by Kelly Schmidt • July 12, 2026
◄ Back to Opportunities List
O
Opportunity

Gulfstream HVAC - Annual Plan Upgrade & CPA Bundle

Discovery
Proposal
Negotiation
Closed
Details
Line Items
Notes
Files

Subscription Opportunity Information

Opportunity NameGulfstream HVAC - Annual Plan Upgrade & CPA Bundle✎
Primary Subscriber ContactRobert Hendrickson✎
Opportunity TypeMonthly to Annual Plan Upgrade✎
StageProposal✎
Subscription Plan PackageAnnual Multi-Entity + CPA Advisory Pack✎
Opportunity OwnerKelly Schmidt✎
Amount$1,499.00✎
Close DateNovember 15, 2026✎
Lead Acquisition ChannelCPA Partner Co-Marketing✎
Baseline Mako Score LinkMS-2026-0884 (Score: 782)✎

Financials, Onboarding & Retention Metrics

Billing FrequencyAnnual Upfront Auto-Renew✎
Seat Allocation Tier6 Seats (2 Operating Entities)✎
Accounting Feed Scope2 QuickBooks Orgs + 3-Yr 1120-S✎
Report Deliverable TierDual QB + Tax-Verified Lender PDFs✎
Conversion Trigger EventDownloaded Q4 Lender PDF & Booked Call✎
Payment Method StatusCorporate Card & Plaid ACH Verified✎
Renewal Notification Status60-Day Automated Drip Enrolled✎
Churn Risk AssessmentLow Risk - High Quarterly Engagement✎
Traditional Appraisal SavingsSaves $8,500/yr vs $2,500 Point-in-Time✎
Next 90-Day Pull DateJanuary 01, 2027✎
Linked Financial SyncFS-2026-4410 (QuickBooks + Tax)✎
Linked Valuation ReportVR-2026-9012 ($6.92M Report)✎
Upgrading from $29.99/mo Single Entity to Multi-Entity Annual Plan
Robert Hendrickson and his CPA Arthur Pendelton want to track both Gulfstream Commercial HVAC LLC and their separate service fleet LLC under annual billing, adding 3 more seats and dual 3-year tax return verifications.
Created by Kelly Schmidt • October 08, 2026
ROI Comparison vs Traditional $2,500 Point-in-Time Appraisals
Reviewed with Robert how traditional certified appraisals cost $2,500 each time and become outdated in 6 months. With Mako Score updating every 90 days across both entities, he saves over $8,500 annually while keeping lender-ready PDFs current.
Created by Gerard Perillo • October 05, 2026
Revenue-to-Cash Billing Alignment
Annual invoice configured for automated Stripe and Plaid ACH settlement upon signature, with 60-day automated renewal reminders scheduled for September 2027.
Created by Kelly Schmidt • October 11, 2026
◄ Back to Campaigns List
C
Campaign

Q4 Southwest Florida SMB Valuation Push

Details
Campaign Members
Notes
Files

Campaign Strategy & Audience Targeting

Campaign NameQ4 Southwest Florida SMB Valuation Push✎
Campaign ChannelMeta & LinkedIn Lead Forms + Email✎
Campaign StatusIn Progress - Active Automation✎
Target Audience SegmentBusiness Owners ($500K - $5M Revenue)✎
Campaign OwnerGerard Perillo✎
Geographic FocusSouthwest Florida & Tampa Bay✎
Journey Automation GoalConvert 14-Day Trial to $29.99/mo Paid✎
Featured Partner AccountSuncoast CPA Advisory Group✎

Funnel Conversion & Attribution Metrics

Onboarding Drop-Off StageTargets Step 3 (QuickBooks) & Step 5 (Quiz)✎
Transactional Trigger RuleSend Guide + Booking Link on PDF Download✎
Budgeted Ad & Media Spend$18,500.00✎
Conversion Rate Benchmark40.7% Trial-to-Paid Conversion✎
Attributed Subscription Revenue$64,980.00✎
Meta & LinkedIn Lead Forms Ingesting Directly into Salesforce
All ad clicks on Meta and LinkedIn for Southwest Florida business owners ($500K-$5M revenue) now route into Salesforce and trigger the immediate 14-day trial onboarding sequence.
Created by Gerard Perillo • October 01, 2026
Mid-Onboarding Drop-Off Reduced by 31%
Automated reminder emails triggered when a user connects QuickBooks but stalls before finishing the 19-question readiness quiz have lifted quiz completion rates from 52% to 83%.
Created by Kelly Schmidt • October 09, 2026
Post-Download Transactional Email Driving Advisor Calls
When a subscriber downloads their buyer/lender-ready PDF, Salesforce automatically sends the "How to Get the Most Out of Your Mako Score" guide with a direct booking link to speak with our valuation team.
Created by Kelly Schmidt • October 12, 2026
◄ Back to Mako Scores List
M
Mako Score

MS-2026-0884

Accounting Connected
19-Question Quiz Completed
Tax Returns Reconciled
Score Published (782)
Next 90-Day Refresh
Details
Notes
Files

Mako Score (0-1,000) & Valuation Summary

Score Record IDMS-2026-0884✎
Primary Business OwnerRobert Hendrickson✎
Composite Mako Score782 / 1,000 (Lender & Buyer Ready)✎
Score Rating Band750 - 849: Prime Transferable Business✎
Tax-Verified Valuation$6,920,000✎
Score Analyst OwnerGerard Perillo✎
QuickBooks-Only Valuation$6,680,000✎
Valuation MethodologyWeighted 3-Yr Tax SDE + IBISWorld Multiple✎
Applied SDE / EBITDA Multiple4.25x Verified SDE✎
Linked Financial SyncFS-2026-4410✎
Published Valuation ReportVR-2026-9012✎

19-Question Readiness Assessment & IBISWorld Benchmarks

19-Question Quiz Completion19 of 19 Questions Verified✎
Owner Dependency RatingLow Dependency - GM & Service Mgr in Place✎
Customer Concentration RiskLow Risk - No Client Over 6% of Revenue✎
Facility & Lease SecurityOwner-Occupied + 10-Yr Assignable Option✎
Recurring Revenue Ratio49% Annual Maintenance Agreements✎
IBISWorld Industry Percentile86th Percentile (NAICS 238220)✎
3-Year Tax vs Books Alignment98.8% Reconciled (2023, 2024, 2025)✎
Quarterly 90-Day Delta+34 Points (+7.3% Valuation Growth)✎
SBA 7(a) Financeability StatusPre-Qualified DSCR 1.85x (Lender Ready)✎
Score Improvement PriorityDocument SOPs for Commercial Estimators✎
19-Question Readiness Assessment Boosted Score by 22 Points
Completing all 19 readiness questions confirmed that Gulfstream Commercial HVAC has a full-time General Manager and documented dispatch SOPs, reducing the owner dependency discount and elevating the Mako Score to 782.
Created by Gerard Perillo • October 01, 2026
IBISWorld NAICS 238220 Benchmark Applied
Compared trailing 36-month gross margin (44.2%) and EBITDA margin (18.6%) against IBISWorld Florida HVAC benchmarks. Company ranks in the 86th percentile, supporting a 4.25x verified SDE multiple.
Created by Kelly Schmidt • October 01, 2026
Next Automated 90-Day Recalculation Set for January 1
System will automatically pull Q4 QuickBooks Online financials on January 1, 2027, recalculate the 0-1,000 Mako Score, and notify all 3 seat holders.
Created by Kelly Schmidt • October 02, 2026
◄ Back to Financial Syncs List
F
Financial Sync

FS-2026-4410

Plaid KYC Authenticated
QuickBooks OAuth Connected
3-Yr Tax Returns Ingested
P&L & Balance Sheet Mapped
90-Day Auto-Pull Active
Details
Notes
Files

Accounting API & Plaid Banking Connection

Financial Sync IDFS-2026-4410✎
Subscriber AccountGulfstream Commercial HVAC LLC✎
Authorized By ContactRobert Hendrickson✎
Accounting Software SourceQuickBooks Online Plus API✎
API OAuth Connection HealthActive & Auto-Refreshing Every 90 Days✎
Plaid Banking & KYC StatusBank Statements & Identity Verified✎
Sync Operations OwnerKelly Schmidt✎
Resulting Mako ScoreMS-2026-0884 (782 / 1000)✎
Resulting Valuation ReportVR-2026-9012 ($6.92M PDF)✎
Historical Ledger Depth36 Months Trailing P&L and Balance Sheet✎
Accounting Basis DetectedAccrual Basis (CPA Reconciled)✎
Last Successful Sync DateOctober 01, 2026✎

3-Year Tax Return OCR & Normalization Details

Federal Tax Form TypeForm 1120-S (S-Corporation)✎
Tax Return Years Ingested3 Full Years (2023, 2024, 2025)✎
Tax OCR Parsing Accuracy100% Line-Item Verified (Schedule K & M-1)✎
Owner Add-Back Normalization$385,000 Verified SDE Add-Backs✎
Trailing 12-Month Gross Revenue$4,850,000✎
Verified SDE / Adjusted EBITDA$1,628,235✎
Bank Statement vs P&L MatchPlaid Deposits Match Gross Receipts (99.4%)✎
Working Capital BenchmarkCurrent Ratio 2.4x (Above NAICS Median)✎
Azure & Plaid Security TierAES-256 Encrypted + Plaid Zero-Trust✎
Automated Sync ScheduleEvery 90 Days + On-Demand Tax Upload✎
QuickBooks Online & 3-Year 1120-S Reconciliation Complete
Ingested 36 months of QuickBooks Online general ledger data alongside 2023, 2024, and 2025 federal S-Corp returns. Officer compensation ($240K), depreciation ($98K), and non-recurring facility repairs ($47K) were verified as legitimate SDE add-backs.
Created by Kelly Schmidt • October 01, 2026
Plaid Commercial Bank Verification Matched Gross Receipts
Plaid read-only connection to Gulfstream Commercial HVAC's operating bank account confirmed $4.85M in trailing 12-month deposits, matching QuickBooks revenue within 0.6%.
Created by Gerard Perillo • September 29, 2026
Zero-Trust Azure Hosting & Watchlist Check Passed
All tax PDFs and accounting tokens are stored in the encrypted Mako Score Azure vault with Plaid identity and watchlist verification completed.
Created by Kelly Schmidt • August 05, 2026
◄ Back to Valuation Reports List
R
Valuation Report

VR-2026-9012

Financials & Tax Verified
IBISWorld Comps Applied
Lender-Ready PDF Generated
Downloaded & Nurture Sent
Advisor Consultation Completed
Details
Notes
Files

Valuation Report & Deliverable Overview

Report NumberVR-2026-9012✎
Downloaded By ContactRobert Hendrickson✎
Report ClassificationTax-Return Verified Lender/Buyer PDF✎
Concluded Enterprise Value$6,920,000✎
Valuation Range Band$6,550,000 - $7,280,000✎
Report Credential OwnerGerard Perillo✎
Source Mako ScoreMS-2026-0884 (Score: 782)✎
Source Financial SyncFS-2026-4410 (QuickBooks + 1120-S)✎
Intended Report Use CaseSBA Lender & Buyer Readiness Verification✎
Download & Portal StatusDownloaded by Owner & CPA (3 Times)✎
Report Generation DateOctober 02, 2026✎

SBA Lending Benchmarks & Post-Download Automation

SBA 7(a) Max Loan SupportSupports Up to $5.0M SBA 7(a) Financing✎
Debt Service Coverage (DSCR)1.85x DSCR at 10-Yr SBA Amortization✎
IBISWorld Data Set IncludedNAICS 238220 Southeast US 2026 Comps✎
Tax vs QuickBooks Delta Note+$240,000 Higher Value With Tax Add-Backs✎
Appraisal Standard AlignmentSBA SOP 50 10 8 & Main Street Comps✎
Post-Download Email TriggerSent Score Guide + Consultation Booking Link✎
Advisor Consultation StatusBooked Call via Email Link (Oct 20)✎
Authorized Seat ViewersAll 3 Seats (Owner, Co-Owner, CPA)✎
Report Expiration / RefreshValid 90 Days (Refreshes Jan 1, 2027)✎
Lender/Buyer-Ready PDF Downloaded & Automated Follow-Up Sent
Robert Hendrickson downloaded VR-2026-9012 on October 2. Salesforce immediately triggered the transactional follow-up email explaining how to interpret the $6.92M valuation, 782 Mako Score, and 1.85x SBA DSCR, resulting in a booked consultation for October 20.
Created by Kelly Schmidt • October 02, 2026
Comparison Against QuickBooks-Only Report (VR-2026-7741)
Because Gulfstream uploaded 3 years of Form 1120-S returns in addition to syncing QuickBooks, VR-2026-9012 includes verified tax add-backs and carries full lender-ready status, unlike the QuickBooks-only baseline report.
Created by Gerard Perillo • October 02, 2026
Shared with Suncoast CPA Advisory Group via Seat 3
Arthur Pendelton CPA accessed the report directly from his Advisor Dashboard seat to incorporate the $6.92M valuation into Robert's 24-month retirement and tax planning model.
Created by Kelly Schmidt • October 06, 2026