HVAC Company Business BrokerBook a call
Menu
HedgeStone Business Advisors
Download

Maintenance agreement audit workbook

Count members from the opening roster through the closing roster, then test renewal behavior on the contracts that actually came due. This workbook separates those two questions and records the cost of visits already promised. You can see what the incoming operator must deliver before treating membership cash as earnings.

Which accounts belong in the opening count?

Define your unit before you run the export. A customer with two addresses, three systems and one family plan could appear once or several times depending on how your dispatch software records agreements.

Choose the unit that matches the contract and use it in every column. Save an opening snapshot, identify the cohort and pull a closing snapshot on the same basis. A report run today might display current status for an account that was active during the review period. If the system supports history, preserve it.

Classify complimentary maintenance bundled with new installations separately from paying subscribers. A visit can create real labor obligations even when the customer never chose to purchase a recurring plan. Mixing the two makes it harder to tell why members stay.

How do you explain a roster that will not reconcile?

Compare the reported ending count with opening active agreements plus additions minus losses. A difference tells you to look for a missing event or a definition that changed.

Test transfers between locations, upgrades, downgrades, reactivations and duplicate account merges. If one plan moved from the bronze tier to the gold tier, show the movement on both sides before calling it churn. If the underlying customer canceled and returned months later, explain the gap.

For the renewal test, identify contracts eligible to renew during this period. Someone who joined yesterday on an annual contract normally has no renewal decision in this month’s cohort. Keep new enrollments out of the denominator, and check that successful renewals represent actual collection or a clearly defined contractual event.

Who pays for prepaid visits after the sale?

Estimate the outstanding service effort separately from the amount recorded as deferred revenue. An accounting liability and the operating cost of performing a tune-up answer different questions.

Count visits by plan tier and territory. Include the labor, travel and consumables you expect to use when preparing your direct cost assumption. If the seller collected a full year up front and the buyer performs two visits after close, each party needs to know how the purchase agreement handles that obligation.

If you’re selling, show the route density and completion history behind your estimate. If you’re buying, open the dispatch calendar and confirm that crews have room to deliver the promised visits before peak demand. Leave purchase-price treatment to the negotiated closing schedule and your advisors.

How do you set up your working copy?

Decide what makes an agreement active in your business, then record that definition beside the working file.

  1. Freeze the opening and closing counts and retain both exports with their original filters.
  2. Classify adds, cancellations, expirations and tier changes. Reconcile before calculating a renewal percentage.
  3. Test earned fees and service costs against the ledger, then estimate the burden of the visits still owed.

What will you find in the file?

These are the values and calculated fields you will see in the editable cohort register.

Maintenance agreement audit workbook preview
Worksheet fieldHow to use it
Plan / cohortIdentify a tier, acquisition group, territory or start month.
Opening activeCount the active agreements on the opening date.
NewAdd contracts first activated during the review period.
Lost / expiredCount agreements removed under your written definition.
Closing reportedEnter the closing count from the original system export.
Count varianceCompare the reported ending total with the calculated roll-forward.
Eligible to renewCount contracts facing a renewal decision in the period.
Actually renewedInclude only renewed agreements inside the eligible cohort.
Renewal rateDivide successful renewals by the contracts eligible to renew.
Earned feesRecord recognized fees attributable to this period.
Direct service costEnter direct service cost for the same earned revenue.
Program gross profitSubtract the direct cost from earned fees.
Visits still owedCount unperformed visits promised under existing agreements.
Cost per future visitEstimate labor, consumables and travel per remaining visit.
Future service costMultiply the visits outstanding by the estimated direct cost.

How do you build a cohort that another person can reproduce?

Choose one billing plan and a period with a clear start and end. Define whether you are counting agreements, households, locations or covered systems. If a household pays for two systems on a single agreement, entering two accounts may artificially enlarge the roster or distort the service obligation. Record the unit in the cohort label and apply it consistently from opening count to closing count.

Export active agreements at the start of the period, new enrollments, cancellations and ending status. Retain the dated snapshots or the transaction history needed to rebuild them. Some systems show current status on all historical reports. If so, confirm how changes after the cutoff affect the export before assuming you have an accurate historic count. Distinguish a genuine reactivation from a corrected duplicate or a household moved to another plan.

Group separately when economics differ. Monthly-billed residential plans, annual prepayments and commercial agreements with several sites can have different collection behavior and visit cost. If the owner acquired another shop’s book during the year, identify those accounts. A jump from a portfolio purchase should not appear as organic sales or stronger renewal performance.

What does the count variance tell you to investigate?

Use the opening active count, new agreements and lost agreements to derive an expected ending population. Compare the expectation with the closing reported count. A variance flags a continuity problem. It does not identify the cause. Trace the individual IDs behind the difference before adding an adjustment to force the table to reconcile.

Common investigation paths include accounts moved between plan codes, canceled contracts still marked active, complimentary agreements created on installation and a system migration that issued fresh customer identifiers. Compare the membership export with payment records, service visits and cancellation notes. Keep a small crosswalk for changed IDs in a restricted file. The public-facing sale materials need only the reconciled total and an explanation.

Once you understand the difference, correct the operating report or document the mapping. Retain the unadjusted source and the revised calculation. If the true count remains uncertain, state how much of the population you verified and identify the unresolved portion. A transparent exception is more credible to a buyer than a perfectly balanced roll-forward with an unexplained plug.

How should you handle eligible renewals and failed payments?

Define eligibility using the agreement’s renewal terms and the observation period. A recent enrollment may be active but not yet eligible for annual renewal. An account on automatic billing may show a renewed status while the card charge failed. Decide what counts as an actual paid renewal, the grace period you will allow and how you will handle refunds. Use one definition for every cohort you compare.

Match the eligible list to successful payments, follow-up collections, customer cancellations and uncollected failures. For annual plans with reminders and retries, keep the original due date visible. Counting every late-paying account in the collection month while leaving it in the earlier eligible pool can distort multiple months. Document whether you measure renewal within a defined window or as of the current date.

Investigate differences by salesperson, plan age, enrollment source, coverage package and service delivery where practical. A promotion may produce many first-year signups at a discount and fewer renewals at full price. A group that received timely preventive visits may behave differently from one waiting months for a technician. Make the comparison on observed data and avoid claiming causation from a single small group.

Which costs belong in program gross profit and future visit cost?

Identify the maintenance fees actually earned for the selected period and the direct cost of delivering the related service. Include relevant field labor, payroll burden, parts, consumables, travel and other direct costs under a consistently stated policy. Membership-only discounts may affect the margin on repairs or installations in a different account. Explain how those costs are treated instead of mixing all downstream revenue into plan dues.

Measure visits still owed at the cutoff. A customer with an annual plan may have received one of two visits, while another has yet to receive any. Use dispatch and service history to establish the count. Estimate cost per future visit from comparable completed work and explain whether it includes travel, parts or expected overtime. Timing matters when the next visit falls during peak capacity.

Provide the schedule to the person negotiating working capital. Deferred revenue on the balance sheet, remaining delivery cost and current cash collected are different measures. The buyer and seller must agree how each enters the deal. Do not subtract both a full prepaid balance and a second unsupported estimate for the same obligation without examining the purchase agreement and what the buyer actually assumes.

How can a buyer verify the workbook without exposing a customer list?

Offer a redacted sample showing a paid renewal, a failed renewal, a cancellation and a plan with visits outstanding. Use stable customer codes so the same plan can be followed through billing, dispatch and the cohort report. Have an authorized reviewer reconcile totals to the source system and accounting records. Protect names, addresses, payment details and access instructions.

Review the results with the service manager and bookkeeper together. The service manager can explain capacity, seasonal backlog and missed visits. The bookkeeper can distinguish collected cash, earned fees and deferred balances. An agreement program has more persuasive value when both can explain the same cohort and identify the work the buyer still owes after closing.

How would you apply this to your shop?

Illustrative composite — not a real client. A cohort opens with 240 members, adds 35, loses 18 and closes with 256 according to dispatch. The expected count is 240 + 35 − 18 = 257. The variance is 256 − 257 = −1, which calls for one specific account investigation.

Suppose only 80 contracts came up for renewal and 64 renewed. Your renewal rate is 64 ÷ 80 = 80%. Dividing 64 by 256 would mix this period’s eligible cohort with customers who did not face a renewal decision. A report showing the lower number could understate retention even if the bookkeeper entered every renewal correctly.

If the cohort still owes 40 visits at an estimated $55 direct cost, the forward service cost is $2,200. Keep that cost visible beside earned fees and direct labor when you discuss pricing. No automatic multiple premium belongs in the audit.

Where can you go next?

What else should you know?

Do canceled plans always count against renewal?

A midterm cancellation reduces the active roster. Its role in the renewal measure depends on your written cohort definition and whether the agreement was eligible for a renewal decision in that period. Track cancellations and renewals separately so you can explain exactly what happened to the underlying accounts.

Should I use invoice revenue or bank deposits?

Use earned fees for the same period as the direct service costs when calculating program gross profit. Use deposits separately to verify collection and investigate timing. An annual payment received today may finance work months from now, so bank receipts alone can overstate the current period’s operating contribution.

Can I treat the remaining visits as deferred revenue?

You can use them to estimate future service cost. Deferred revenue depends on contract terms, the record of amounts invoiced or collected and your accounting treatment. Ask your accountant to reconcile the earned and unearned balances separately before you discuss a working-capital adjustment or other settlement mechanism.

How does this show replacement opportunities?

The audit establishes an eligible, paying member population you can trace. To evaluate replacement conversion, match completed replacement invoices to those account identifiers over a consistent window. Separate opportunity creation, proposals and completed installations. The workbook’s gross profit field covers the program economics you actually enter.

Which sources informed this page?

Explore the operations hub