Business analytics dashboard on laptop screen showing data visualizations

HOW-TO GUIDE

The ServiceTitan Due Diligence Shortcut: Five Reports That Replace $15,000 in Consulting Fees

9 min read Due Diligence Operations ServiceTitan

Five report exports from the seller’s own field service platform answer the most expensive due diligence questions in twenty-five minutes. Here’s exactly which reports to pull and what to look for in each one.

You’re about to write a $15,000 check to a due diligence consultant. He’s going to spend six weeks interviewing the seller, reviewing financials, and building a slide deck. Half of what he delivers will come from data the seller’s own field service platform already has — organized, timestamped, and exportable in about five minutes per report.

I’m not knocking consultants. I used one when I bought my second shop. But I wish someone had told me that the most expensive line items on his invoice were things I could have pulled myself from ServiceTitan before I ever signed the LOI.

Five reports. Five exports. Twenty-five minutes total. They won’t replace your CPA or your attorney. But they’ll tell you whether this deal is worth the next $15,000 — or whether you should walk before you spend it.


Why Most Buyers Miss This

Every buyer asks for tax returns, P&Ls, and a balance sheet. That’s table stakes. Your SBA lender requires them, your CPA reviews them, and the broker has them ready in a tidy PDF before your first call.

What almost nobody asks for is the operational platform data.

Over 70% of HVAC companies above $1M in revenue run ServiceTitan. Since the company went public as TTAN with 21% year-over-year revenue growth, that number keeps climbing. The platform records every dispatched call, every invoice, every tech’s close rate, every marketing dollar tied to a booked job.

Tax returns tell you what happened last year. ServiceTitan tells you why it happened — and whether it’ll keep happening after the seller hands you the keys. If you’re building out your full due diligence checklist, these five reports belong at the top.


Report #1: Revenue by Employee

What it shows: Each technician’s total revenue generated over a trailing 12-month period.

Where to find it: Reports > Performance > Revenue by Employee. Export to CSV.

What you’re looking for: Key-person concentration.

If one technician generates 35% or more of total service revenue, you don’t have a business — you have a person. That person has relationships with your best customers, knows every unit in their building, and has a decade of institutional knowledge in their head. If they leave six months after you close, a third of your revenue walks out with them.

Here’s what healthy looks like in a five-tech shop doing $2.5M:

Technician Revenue Share
Tech A$620K24.8%
Tech B$550K22.0%
Tech C$510K20.4%
Tech D$480K19.2%
Tech E$340K13.6%

That bottom tech might be a newer hire still building a book. Fine. But if Tech A is doing $1.1M and everybody else is below $400K, your entire deal thesis depends on one person’s two-week notice.

Revenue per tech is one number, but you also want to see close rates, average ticket, and callback frequency by individual. ServiceTitan has all of it.

HVAC operations management screen showing technician scheduling and dispatch

Red flag: The seller can’t or won’t produce this report. That tells you either the data isn’t clean (they’re not using the platform properly) or they know what it shows.


Report #2: Membership Summary by Tier

What it shows: Maintenance agreement counts broken down by plan tier, with average revenue per agreement.

Where to find it: Reports > Memberships > Membership Summary. Export to CSV.

What you’re looking for: The real composition of the maintenance book.

Every broker listing says something like “400 active service agreements averaging $300/year.” Sounds great. $120K in recurring revenue. Predictable. Bankable.

But “400 at $300 average” can mean two completely different businesses:

Scenario A:

  • 200 PM-Only plans at $179/year = $35,800
  • 200 Comfort Club plans at $429/year = $85,800
  • Total: $121,600 — balanced book, good upsell path

Scenario B:

  • 350 PM-Only plans at $199/year = $69,650
  • 50 Comfort Club plans at $599/year = $29,950
  • Total: $99,600 — and 87% of your members are on the cheapest tier

Scenario A is a business with a healthy upgrade pipeline. Scenario B is a business that sells tune-ups and hasn’t figured out how to move customers into higher-value relationships.

The tier breakdown also tells you about churn risk. PM-only members cancel at 2–3x the rate of full-coverage members because they have less skin in the game. A book that’s 85% basic plans will shrink faster than one with strong mid-tier enrollment.

Red flag: No tier structure at all — just one flat plan. That’s not necessarily bad, but it means nobody’s optimized the membership program, and there’s margin sitting on the table.


Report #3: Marketing ROI by Source

What it shows: Cost per lead and cost per booked job by marketing channel — Google Ads, LSA, organic search, referral, direct mail, everything tagged in ServiceTitan.

Where to find it: Reports > Marketing > Marketing ROI. Export to CSV.

What you’re looking for: How fragile the lead pipeline is.

Revenue sourced from organic search and customer referrals is durable. It survives an ownership change. The website still ranks. Existing customers still tell their neighbors.

Revenue sourced from Google Ads spend is fragile. It requires ongoing budget, ongoing optimization, and — critically — it requires the seller’s institutional knowledge of what works. If the seller is personally managing a $6,000/month Google Ads account and that account drives 40% of new customer acquisition, you’re buying a business whose growth engine requires the departing owner to function.

Here’s the breakdown I’d want to see:

  • Organic/SEO: 25–35% of new customers
  • Referral: 20–30%
  • Google Ads/LSA: 20–30%
  • Direct mail/other: 10–15%

A business getting 60%+ of new leads from paid channels needs a marketing budget baked into your pro forma that the seller may not have been tracking as a true cost of acquisition.

This data matters when you’re evaluating the tech stack you’re inheriting. ServiceTitan’s marketing attribution only works if calls are tracked, sources are tagged, and the CSRs are booking jobs against the right campaigns. If the data is messy, that’s a signal about operational discipline too.

Red flag: No marketing source tracking at all. The seller runs ServiceTitan but never set up call tracking or campaign tags. You’re flying blind on CAC.


Report #4: Job Costing Variance

What it shows: The gap between estimated job cost and actual job cost on every completed job.

Where to find it: Reports > Jobs > Job Costing. Filter for completed jobs, trailing 12 months. Export to CSV.

What you’re looking for: Estimating discipline.

A well-run shop lands within ±5–8% variance on the majority of jobs. The estimator knows the labor hours, the material costs, and the common surprises. They price accordingly, and the jobs come in close to bid.

Here’s what the numbers mean:

  • ±5–8% average variance: Healthy. Normal job-to-job fluctuation.
  • Consistently >+15% (actual exceeds estimate): The shop is lowballing bids to win work. They’re buying revenue at the expense of margin. Your actual gross margins are lower than the P&L suggests because the underbidding is being absorbed.
  • Consistently <-10% (estimate exceeds actual): Could mean conservative estimating (fine) or scope creep absorption — techs are doing extra work on-site that never gets invoiced. Check against the callback rate.

This is one of the places where the SDE add-back conversation gets real. A seller who claims 55% gross margins but whose job costing shows consistent 15% overruns is telling two different stories. The ServiceTitan data is harder to manipulate than the P&L because it’s recorded at the job level by technicians who don’t know you’re looking at it.

Sort by job type. Install jobs should have tighter variance than service calls because installs are more predictable. If install variance is worse than service variance, the estimator — who is often the owner — has a pricing problem you’ll inherit.

Red flag: Fewer than 60% of jobs have costing data entered. The shop uses ServiceTitan for dispatch and invoicing but doesn’t track material costs or labor hours at the job level. The report exists but it’s useless.


Report #5: Customer Aging and Lifetime Value

What it shows: Every customer ranked by total spend, with aging buckets showing how recently they’ve been active.

Where to find it: Reports > Customers > Customer Aging. Sort by total revenue, export to CSV.

What you’re looking for: Concentration risk and relationship dependency.

Pull the top 20 customers by total spend. In a residential-heavy shop, no single customer should represent more than 2–3% of annual revenue. If you see a commercial account doing $180K/year in a $1.8M business, that’s 10% of revenue tied to one relationship — a relationship the seller probably manages personally.

Now check the aging column. How many of those top 20 haven’t booked a job in 12+ months? A customer who spent $14,000 three years ago and hasn’t called since isn’t a $14,000 customer anymore. But their lifetime value is still inflating the average in every broker presentation you’ve seen.

Cross-reference against the membership report. Are the top customers also agreement members? Members stick. Non-member high-spenders are project customers — they called for a system replacement, spent big once, and may never need you again for 15 years.

This report also feeds your customer financing audit. If the top accounts are financing large installs through third-party lenders, you want to understand the approval rates and the dealer fees being absorbed on those transactions.

Red flag: Top 5 customers represent 25%+ of revenue. You’re buying a business that’s really a few big accounts wearing a trench coat.


How to Request These Without Spooking the Seller

Sellers get nervous when buyers start asking for granular data. It feels like an audit. It feels adversarial. And a spooked seller can kill a deal faster than bad financials.

Frame it around operations, not investigation.

Here’s the language that worked for me:

“I want to understand how the business runs day-to-day, not just the financials. Could I get a few standard reports from your field service platform? I’m looking at things like technician workload distribution and membership tier breakdowns — the stuff that helps me plan staffing and marketing for year one.”

That’s true. It’s also complete. You’re not hiding anything. But “I want to plan staffing” lands very differently than “I want to see if your top tech is doing all the work.”

Three tips:

  1. Ask after the LOI, not before. Pre-LOI, you’re a stranger asking for proprietary data. Post-LOI, you’re a serious buyer doing normal due diligence.
  2. Request exports, not login access. Asking for ServiceTitan credentials feels invasive. Asking for five CSV exports feels routine.
  3. Name the specific reports. Vague requests (“can I see your ServiceTitan data?”) make sellers nervous because they don’t know what you’ll find. Specific requests (“the Revenue by Employee report for the last 12 months”) feel professional and bounded.

Capital advisors like Lendesca who work with HVAC acquisitions can help you present this operational data alongside financial statements to strengthen your SBA application. Lenders increasingly want to see more than tax returns — they want to understand the business you’re actually buying.


What If the Seller Doesn’t Use ServiceTitan?

Not every shop runs ServiceTitan. Some are on FieldEdge, Housecall Pro, or Jobber. A few are still on paper tickets and QuickBooks.

The same five data points still matter. The reports are just named differently:

Data Point ServiceTitan FieldEdge Housecall Pro Jobber
Revenue by tech Revenue by Employee Technician Performance Team Performance Team Report
Membership tiers Membership Summary Agreement Analysis Plan Summary Client Manager
Marketing ROI Marketing ROI Lead Source Report Source Attribution Lead Source
Job costing Job Costing Work Order P&L Job Profitability Job Costing
Customer aging Customer Aging Customer History Customer Lifetime Client Revenue

If the seller is running a platform at all, these reports exist in some form. The column names change. The insights don’t.

If the seller is on paper — no platform, no CRM, no digital dispatch — that’s a data point too. It tells you the business has been run on institutional knowledge, not systems. That’s not automatically a dealbreaker, but it means your post-close technology investment is higher, your transition risk is greater, and your ability to verify any operational claim is limited to whatever you can piece together from tax returns and interviews.

It also means the ACCA and PHCC benchmarking data becomes more important, because you’ll be comparing the seller’s claims against industry averages instead of against their own tracked data.


The Bottom Line

Twenty-five minutes of exports. Zero consulting fees. And you’ll know more about the operational reality of this business than most buyers learn in six weeks of paid due diligence.

These five reports don’t replace professional advisors. You still need a CPA to verify the tax returns, an attorney to review the asset purchase agreement, and a lender to structure the financing. But they give you something no financial statement provides: a ground-truth view of how this business actually runs, who actually runs it, and whether the numbers the seller is quoting will survive the transition.

Pull these before your next LOI meeting. If the data confirms the listing, you’ll negotiate with confidence. If it doesn’t, you just saved yourself $15,000 and six months of your life.

That’s the best ROI in due diligence.