Calculate Three KPIs from Home Cleaning Software Records

Utilization, rework rate, and contribution per crew hour can each be calculated from home cleaning software records. Each formula maps to the job, payroll, and financial information it needs, and the periods and job groups must stay consistent. Software screen names differ, so use the records' contents to find the right inputs.

The goal is to make each figure traceable to recorded work and costs, rather than rely on a dashboard number whose definition is unclear.

Map each metric to its source records

Before calculating, choose a reporting period and identify the jobs, employees, and service lines it covers. Use a matching scope throughout each formula: for example, do not pair job hours for one crew with payroll hours for a different group.

Report labels vary. Look for the fields and records that show these details rather than assuming every system uses the same menu name or report format. To compare systems, see what to check in home cleaning software.

If the system can export data, the job, employee, and date information should make it possible to connect the relevant records. If you cannot make that connection, mark the calculation incomplete instead of filling the gap with an assumption.

A job identifier can help connect job activity with its financial information; employee and date details help align work with payroll. Keep those identifiers consistent when information moves between systems. If payroll only provides totals for a pay period, calculate at a scope that those totals can support rather than presenting a more detailed crew comparison than the records allow.

The calculation chain is simple: identify the relevant work, select the source records for each input, apply one written definition, and preserve the resulting totals with the report. A result is easier to explain when you can trace it back to those inputs.

Calculate utilization from job and payroll hours

Utilization compares productive on-site hours with paid hours for the same employee group and period:

Utilization = productive on-site hours ÷ paid hours

The job records supply productive on-site hours; payroll records supply paid hours. Under the Fair Labor Standards Act recordkeeping rules, covered employers keep data on the hours worked and the wages earned for each non-exempt worker, though no particular form is required.

Decide what counts as productive on-site time and apply that definition consistently. Keep the employee group and dates aligned: hours from one crew cannot be compared with payroll hours for another group as if they described the same work. For pay-period detail, see pay rates and labor costs.

Count labor time, not just the elapsed time between a visit's arrival and departure. When several cleaners work on a visit, crew hours represent the labor time of those cleaners, while elapsed visit duration represents the time from the first start to the final finish. Those are different measures, so use labor hours when the formula calls for hours worked.

Calculate the period's result from the period totals. Averaging separate job or employee utilization ratios can give short and long jobs equal weight, even though they contribute different amounts of time. If a job time or payroll record is missing, flag the calculation as incomplete; treating unknown hours as zero changes the meaning of the result.

Utilization describes the relationship between productive on-site time and paid time. It does not explain why those totals differ, and the formula alone does not diagnose a scheduling, staffing, or pricing problem. Use it as a defined operating measure and investigate the underlying records before drawing conclusions.

Calculate rework rate from return hours

Rework rate measures return and touch-up hours as a share of total job hours:

Rework rate = return and touch-up hours ÷ total job hours

The job records must distinguish return and touch-up time from routine work. If the record only identifies a callback as a separate customer contact, but does not record its hours, it does not supply the numerator for this calculation. Do not substitute a callback count for return hours.

Choose a consistent date basis. You can group return hours by the date the return work was performed or by the original job they relate to; whichever basis you use, state it and use the same basis for the total job hours. Keep the numerator and denominator within the same reporting period, service scope, and crew group.

The way a return is coded matters. If return work is recorded as a new, unrelated job, the source records may not reveal that it belongs in the rework numerator. Record the relationship to the original work when the return is logged, then check that the hours are categorized consistently before calculating the ratio.

This is a labor-hours measure, not a count of complaints or a complete quality assessment. If the records do not separate return hours, report that the metric cannot be derived reliably from the available data. Do not change the definition between reporting periods without noting the change alongside the result.

Calculate contribution per crew hour

Contribution per crew hour compares revenue less specified costs with the crew hours consumed:

Contribution per crew hour = (revenue − supplies − burdened labor) ÷ crew hours consumed

Use job and financial records covering the same work. Total the revenue, supplies, and burdened labor for the selected jobs, subtract the costs from revenue, and divide by the crew hours for those jobs. The revenue and costs in the calculation should describe the work represented by the hours in the denominator.

Use a consistent accounting method to assign supplies and burdened labor. For labor, use the burdened labor cost recorded or allocated under that method; do not compare a result based on burdened labor with a later result based on wages alone without labeling the change.

If a cost cannot be assigned under the method your records use, note that limitation rather than inventing an allocation. For related formulas, see margins and break-even points.

Crew hours count each cleaner's labor time, not merely the elapsed span of a visit. As with the other metrics, calculate the result from the totals for the selected work rather than averaging individual job ratios. Keep the service scope and period visible, especially when comparing unlike work. For broader pricing decisions, see the pricing model it feeds.

Contribution per crew hour is not overall profit: it reflects the revenue and specified costs in the formula, divided by the labor hours consumed. Employee retention is a separate operating question; see the publication's employee retention analysis.

Make the calculation repeatable

Write down the reporting period, included jobs and employees, formula, and source records for each input. Keep the definitions with the reported result so the next calculation can use the same basis.

If a definition changes, for example which hours count as return work, record that change rather than treating the new figure as directly comparable to the old one.

Before relying on a result, trace its inputs back to their records:

Job and payroll exports can hold customer and employee details. The Federal Trade Commission's guide to protecting personal information starts with knowing what personal information you have in your files and on your computers.

The table summarizes the three formulas and their source records. A ratio with a missing or zero denominator cannot produce a meaningful result; flag it rather than reporting a fabricated figure.

A software-generated result is useful when its definition and source inputs are clear. If you cannot trace a figure to the records above, calculate it from the underlying records or label it unverified. For the wider monthly set, see KPIs owners track monthly.