Commercial Cleaning Estimate Template in Excel: Cost and Margin Example

A cleaning estimate should explain more than a price. A commercial client needs to know what will be cleaned, how often, which supplies are included, and what happens when the scope changes. The cleaning company needs a separate view of labor, consumables, travel, equipment, and overhead so it does not confuse a busy schedule with a profitable contract.

This guide builds a commercial cleaning estimate in Excel using a fully fictional office contract. It includes a transparent cost model, formulas, a margin check, and a client-facing quote outline. The figures are illustrative assumptions, not US market averages, recommended wages, or guaranteed production rates.

Start with a site walkthrough, not a square-foot price

Measure the cleanable area, not merely the building's advertised size. Record the number and condition of restrooms, occupied workstations, floor types, trash points, security restrictions, and access hours. Note whether the client provides paper goods, liners, soap, and equipment. Ask about one-time initial cleaning and periodic tasks such as carpet extraction or high dusting.

Two 4,800-square-foot offices can require different labor hours. A quiet open-plan office is not the same as a multi-room clinic. Do not promise specialized healthcare, food-service, or hazardous-material procedures based on a generic office estimate.

For chemical and worker-safety considerations, consult OSHA's cleaning-industry hazards and solutions guidance. The estimate should allow time and resources for applicable safe-work procedures, not treat safety as a removable discount.

Fictional example: Maple Harbor Office Services

Maple Harbor Office Services is an invented US cleaning company. It is preparing a recurring evening-cleaning quote for an invented client, Willow Desk Co. The contract would cover 4,800 cleanable square feet, three visits each week, with 13 scheduled visits in the sample month. Thirteen is a fictional calendar count for this worked example; do not assume every month has exactly 13 visits.

The team expects two cleaners to work 3.5 hours each per visit. That is 7 paid labor-hours per visit. The company uses an assumed $27 loaded cost per labor-hour, including its own estimated employment-related costs. This is not a wage recommendation or a substitute for checking applicable pay and payroll rules.

Here is its assumed per-visit cost:

• Labor: 2 cleaners × 3.5 hours × $27 = $189.
• Cleaning consumables: $18.
• Travel and parking: $15.
• Equipment usage and maintenance allowance: $8.
• Direct cost per visit: $230.

The company also assigns $650 of monthly overhead to this contract for the sample month. At 13 visits, that is $50 per visit. Overhead allocation is a management assumption: the business must avoid charging the same fixed expense twice when comparing contracts or calculating company-wide profit.

Estimated fully allocated cost per visit = $230 + $50 = $280.

Calculate a price from a target margin

Maple Harbor sets a fictional 25% target margin after the allocated costs in this example, before income taxes and any omitted costs. This is not an industry benchmark.

The pricing equation is:

`Minimum price = Fully allocated cost / (1 - target margin)`

For this contract: `$280 / (1 - 0.25) = $373.33` per visit, rounded to cents. Maple Harbor rounds its customer quote up to $375 per visit rather than down.

The resulting illustrative totals are:

• Monthly service price: 13 × $375 = $4,875.
• Monthly direct cost: 13 × $230 = $2,990.
• Allocated monthly overhead: $650.
• Total modeled monthly cost: $3,640.
• Amount remaining after modeled costs: $1,235.
• Modeled margin: $1,235 / $4,875 = 25.3%.

This remaining amount is not net profit. It excludes any unmodeled expenses, financing costs, income taxes, and unexpected rework. The US Small Business Administration's break-even guidance distinguishes fixed costs, variable costs, and contribution margin. Use those concepts consistently when assessing an entire business, rather than treating one estimate as a complete financial forecast.

Margin and markup are not the same

A 25% margin means the amount left after the modeled costs is 25% of the selling price. A 25% markup would instead add 25% to the cost. On a $280 cost, a 25% markup produces only `$280 × 1.25 = $350`; its margin is `($350 - $280) / $350 = 20%`.

That is why the quote uses `cost / (1 - margin)` rather than `cost × (1 + margin)`. Label the target explicitly in your workbook so a future employee does not switch formulas accidentally.

Set up the Excel estimate calculator

Create a worksheet named `Estimate`. Put the following inputs in row 2:

• `A2` cleanable square feet: `4800`; `B2` scheduled monthly visits: `13`.
• `C2` cleaners per visit: `2`; `D2` hours per cleaner: `3.5`.
• `E2` loaded labor cost per hour: `27`.
• `F2` consumables per visit: `18`; `G2` travel per visit: `15`; `H2` equipment allowance per visit: `8`.
• `I2` monthly allocated overhead: `650`; `J2` target margin: `25%`.

Then use these Excel formulas:

• `K2` direct cost per visit: `=C2D2E2+F2+G2+H2`
• `L2` overhead per visit: `=IF(B2>0,I2/B2,"")`
• `M2` fully allocated cost per visit: `=IF(L2="","",K2+L2)`
• `N2` minimum price: `=IF(OR(M2="",J2<0,J2>=1),"Check inputs",M2/(1-J2))`
• `O2` quote rounded up to the next $5: `=IF(ISNUMBER(N2),CEILING(N2,5),"")`
• `P2` monthly quoted revenue: `=IF(O2="","",O2*B2)`
• `Q2` modeled margin: `=IF(OR(O2="",O2<=0),"",(O2-M2)/O2)`

The sample should return $230, $50, $280, $373.33 before rounding, $375, $4,875, and 25.3%, respectively. Format money and percentages explicitly. Add validation for positive visit counts and nonnegative costs. For a reusable workbook, add a warning for missing fields, unrealistic hours, and any formula error before exporting a client quote.

These formulas model one recurring service package. If different areas have different frequencies, use separate rows per area or task and calculate their monthly costs before applying the margin target. Do not silently use one production rate for restrooms, open floors, and specialized cleaning.

Stress-test the estimate before sending it

Suppose the site walkthrough was optimistic and the crew actually needs 8 labor-hours, not 7, per visit. Labor cost increases by `$27`, from $189 to $216. Fully allocated cost rises from $280 to $307 per visit.

If the company keeps the $375 quote, modeled margin falls to `($375 - $307) / $375 = 18.1%`. This is a meaningful difference even though the extra time is only one labor-hour per visit. Record the actual hours from early visits and revisit the price if the contract allows it.

Also test changes in supply prices, travel time, frequency, and customer-requested tasks. Avoid changing the client's price without following the agreed quote or contract terms. A proposed scope change should be documented and approved before work proceeds.

Turn the internal calculation into a client-facing quote

Do not send the full internal labor-cost model unless you choose to disclose it. A client-facing estimate should identify the supplier and client, estimate number and date, site, service schedule, detailed included scope, exclusions, recurring price, separately priced add-ons, proposed start date, validity period, and payment terms.

For Willow Desk Co., the fictional quote could say: Evening office cleaning, three scheduled visits per week; $375 per completed visit; $4,875 for the illustrated 13-visit month, before any applicable sales tax. It should list the tasks agreed during the walkthrough and clarify that the monthly invoice changes if the actual number of scheduled visits differs.

Keep initial deep cleaning, carpet extraction, unusually soiled areas, emergency callouts, and customer-supplied versus contractor-supplied consumables explicit. A one-time service should not be quietly folded into a recurring price if it materially changes the cost.

Sales tax treatment varies by jurisdiction and service type. The IRS small-business FAQ directs businesses to their state revenue department for sales-tax questions. This article does not assume that cleaning services are taxable or exempt in any particular state.

Connect the estimate to operations and bookkeeping

After a client accepts a quote, retain the approved scope and estimate version. Compare planned hours with actual hours after the first several visits, record add-ons separately, and investigate repeated overruns. A low quoted price cannot be repaired by an impressive-looking dashboard if the underlying scope was underestimated.

Staff competency also affects delivery time and quality. VectoraWork's employee training matrix guide explains how to document skills and coverage. When payments begin arriving, the bank reconciliation example addresses a separate bookkeeping control; it does not replace the job-cost calculation used to prepare a bid.

An offline quote calculator can be convenient during walkthroughs, but browser-local data is not automatically a durable backup. Export a copy of the approved estimate and verify the file opens before relying on it. No downloadable Excel template or live calculator is promised by this article until those resources are actually published and tested.

Frequently asked questions

Should I quote by square foot or by labor-hour?

Either can be a presentation method, but estimate the actual tasks and likely labor first. A square-foot figure alone cannot capture access constraints, restrooms, frequency, or initial condition.

Does a 25% target margin guarantee 25% net profit?

No. The worked example covers only listed costs and one overhead allocation. Unexpected labor, omitted costs, taxes, and changes in scope can reduce the actual result.

Is $375 a standard price for a 4,800-square-foot office?

No. It is a fictional calculated quote based on invented hours, labor costs, visit count, and margin. It is not a market-rate claim.

Can I send the same estimate every month?

Only if the service count, scope, and contract terms support that. The example uses 13 visits in one illustrative month; another month may have a different count.

Practical takeaway

Build a cleaning quote from site-specific scope, estimated labor-hours, direct expenses, and a clearly defined overhead allocation. Then apply the margin formula, round transparently, and stress-test extra labor. In the fictional Maple Harbor example, $280 of modeled cost supports a $375 quote per visit and a 25.3% modeled margin across 13 visits. The most useful estimate is one that the client understands and the team can actually deliver.

Editorial disclosure: Maple Harbor Office Services, Willow Desk Co., all quantities, costs, and outcomes are fictional educational examples. This article is not tax, legal, wage, safety, or accounting advice.