Template

Janitorial Job Costing Template:Production-Rate Hours, Loaded Cleaner Rate, Supplies per Square Foot, Overhead Share and a Filled Honolulu Office Account

Janitorial job costing template: production-rate hours, a loaded cleaner rate from Honolulu wages, supplies per square foot, overhead and a filled account.

Updated 12 min read

Download .xlsxExcel spreadsheet · 24 KB · Free, no sign-up

A janitorial job costing template sets one cleaning account's monthly cost against its contract price: cleaner hours from production rates at a loaded labor rate, supervisor inspection time, supplies per square foot, equipment, a share of overhead and the margin left. The sample costs a five-night office account in Honolulu, Hawaii, budget against October 2026 actuals.

FieldRanger, the cleaning app built inside HubSpot, files this costing layout with its free field service templates. The page offers the tabs and formulas as a free .xlsx download with no sign-up. A one-off job, such as a repaint, is costed once at closeout on the job costing spreadsheet. A janitorial account never closes, so this template costs it by the month and compares each month with the budget the bid was built on.

Janitorial job costing template tabs and columns

The workbook has four tabs. Rates holds the production rates and their sources, Labor builds the loaded rate per productive hour, Account turns areas into monthly hours, and Month sets budget against actual.

Janitorial job costing template, Account tab columns and formulas (row 5 shown)
ColumnHeaderContentsFormula
AAreaCarpet, hard floor, restrooms, whole buildingTyped
BTaskOne task from the contract specificationTyped
CQuantitySquare feet, or fixtures for restroomsTyped from the walkthrough
DUnit1,000 sq ft or fixtureTyped
EMinutes per unitFrom the Rates tab=VLOOKUP(B5,Rates!$A:$C,3,FALSE)
FMinutes per visitQuantity in units times minutes per unit=IF(D5="fixture",C5*E5,C5/1000*E5)
GVisits per month5 nights a week is 5 × 52 ÷ 12; weekly is 52 ÷ 12=IF(H5="N",5*52/12,IF(H5="W",52/12,IF(H5="M",1,0)))
HFrequencyN nightly, W weekly, M monthlyTyped
IHours per monthMinutes per visit times visits, over 60=ROUND(F5*G5/60,2)
JRate sourceISSA table, published article, or the company's own timingTyped
Janitorial job costing template, Month tab rows (budget in column B, actual in column C)
RowLineFormula in column BColumn C
5Cleaner hours=SUM(Account!I:I)Hours from the clock record
6Cleaner labor=B5*Labor!$B$14=C5*Labor!$B$14
7Supervisor hoursInspection hours plannedHours logged
8Supervisor labor=B7*Labor!$C$14=C7*Labor!$C$14
9Supplies=Rates!$B$20*Account!$C$2Receipts and stock issued
10EquipmentMonthly charge for machines on this accountSame
11Direct cost=SUM(B6,B8,B9,B10)=SUM(C6,C8,C9,C10)
12Overhead=(B6+B8)*Labor!$B$18=(C6+C8)*Labor!$B$18
13Total cost=B11+B12=C11+C12
14Contract priceThe monthly priceSame
15Gross profit and margin=B14-B11, and =B15/B14=C14-C11, and =C15/C14
16Net profit and margin=B14-B13, and =B16/B14=C14-C13, and =C16/C14

Column G carries the cost period. Five nights a week is 21.67 nights in an average month. A calendar month holds 20 to 23 weekdays, and the contract price does not move with it. The budget column uses the average; the actual column uses the month as worked.

Production rates and their sources

A production rate converts a quantity into minutes. The Rates tab keeps the rate, its unit and its source on the same row, so a rate the company has timed itself never passes for a published one.

Rates tab, production rates used in the sample account
TaskRateSource
Vacuum carpet, backpack vacuum with 12-inch carpet tool8.25 min per 1,000 sq ft (7,273 sq ft an hour)The Official ISSA 540 Cleaning Times, ISSA 2009, as reproduced by WAXIE
Automatic scrubber, 17-inch walk-behind10.14 min per 1,000 sq ft (5,917 sq ft an hour)The Official ISSA 540 Cleaning Times, as above
Restroom fixtures: toilets, urinals, sinks3 min per fixtureBen Walker, Facility Cleaning Decisions, August 15, 2014
Trash, recycling, dusting and spot cleaning, whole building6.0 min per 1,000 sq ftCompany's own timing (sample)
Damp mop hard floor, flat mop12.0 min per 1,000 sq ftCompany's own timing (sample)

The two machine rates come from WAXIE's sample cleaning times sheet, which quotes "The Official ISSA 540 Cleaning Times", created and compiled by John Walker, International Sanitary Supply Association, 2009 (WAXIE, Sample Cleaning Times, file dated February 13, 2013). The restroom rate is Ben Walker's: "A good baseline time to use is three minutes per fixture" (Facility Cleaning Decisions, Tips To Developing Restroom Cleaning Times, August 15, 2014). Neither source publishes a rate for general trash and dusting or for flat-mopping, so those rows carry the company's own timing and say so.

A published rate describes an average building. The October actuals below are the first test of these rates in this one, and the logged hours replace them at the first rebid.

Loaded labor rate for a Honolulu cleaner

The Labor tab turns a wage into the cost of one productive hour on an account. Each row is rounded to the cent, and the total adds the rounded rows.

Labor tab, loaded rate per productive hour (published wages, tax rates and rules; sample premium, workers' compensation and hours)
RowItemSource or formulaCleaner (B)Supervisor (C)
3WageOEWS mean hourly wage, Honolulu MSA, May 2025$18.93$28.70
4Social Security and Medicare=ROUND(B3*7.65%,2)$1.45$2.20
5Federal unemployment=ROUND(7000*0.6%/B12,2)$0.02$0.02
6Hawaii unemployment=ROUND(MIN(B3*B12,64500)*2.4%/B12,2), new-employer rate$0.45$0.69
7Prepaid health care, employer share=ROUND((650-MIN(650*50%,B3*B12/12*1.5%))/(B12/12),2), sample $650 monthly premium$3.47$3.32
8Workers' compensation=ROUND(B3*4.10/100,2), sample $4.10 per $100 of payroll$0.78$1.18
9Cost per paid hour=SUM(B3:B8)$25.10$36.11
12Paid hours a yearSample2,0802,080
13Productive hours a yearSample: paid hours less 80 of holiday and vacation and 104 of travel between buildings and training1,8961,896
14Loaded rate per productive hour=ROUND(B9*B12/B13,2)$27.54$39.61
16Annual overheadSample: office, general liability, software, vehicles for supervisors, owner's salary$214,000
17Annual direct laborSample: all cleaner and supervisor labor charged to accounts$1,150,000
18Overhead share of direct labor=ROUND(B16/B17,4)18.61%

The wages are means for the Honolulu metropolitan area from the Occupational Employment and Wage Statistics survey, which the Bureau of Labor Statistics runs with the state: $18.93 an hour for janitors and cleaners, except maids and housekeeping cleaners, and $28.70 for first-line supervisors of housekeeping and janitorial workers (Hawaii DBEDT, Occupational Employment and Wages 2025, Table 6, October 2026). The same table gives the cleaners' median as $17.67. Both clear Hawaii's minimum wage of $16.00 from January 1, 2026, which rises to $18.00 on January 1, 2028 (Hawaii DLIR, Minimum Wage, checked November 13, 2026).

The federal rows come from the IRS. Social Security is 6.2 percent on wages up to $184,500 in 2026, and Medicare 1.45 percent (IRS, Topic 751, updated November 9, 2026). Federal unemployment is 6.0 percent of the first $7,000, or 0.6 percent after the full state credit (IRS, Topic 759, updated November 9, 2026). Hawaii's unemployment row uses the 2026 taxable wage base of $64,500 and the 2.40 percent rate for new employers (Hawaii DLIR, Tax Rate Schedule, checked November 13, 2026). An established employer uses the rate on its own notice.

Row 7 is the Hawaii line a mainland template lacks. The Prepaid Health Care Act requires coverage for employees who "work at least twenty (20) hours per week and earn 86.67 times the current Hawaii minimum wage a month". Employers "must pay at least 50% of the premium cost", and the employee's share "cannot exceed the lesser of 50% of the premium cost or 1.5%" of monthly gross earnings (Hawaii DLIR, About Prepaid Health Care, checked November 13, 2026). At $18.93, 1.5 percent of monthly wages is $49.22, so the employer pays $600.78 of the sample $650 premium: $3.47 for every paid hour.

Supplies per square foot from coverage rates

Supplies are costed from use, then divided by the area to give a rate that can be compared across accounts. WAXIE's sheet gives solution coverage of 400 square feet per gallon for damp mopping and 750 for an automatic scrubber with solution dosing. At a sample dilution of 1 ounce per gallon and $0.22 an ounce, 5,500 square feet of hard floor takes 13.75 gallons of mop solution a night.

Supplies per month, budget (coverage from WAXIE; sample dilution and prices)
ItemBasisMonthly cost
Floor cleaner concentrate, mopping13.75 gal a night × 21.67 nights × 1 oz × $0.22$65.54
Floor cleaner concentrate, scrubbing7.33 gal a scrub × 4.33 scrubs × 1 oz × $0.22$6.99
Disinfectant and glass cleanerSample purchases$58.00
Can linersSample purchases$96.00
Pads, microfiber and vacuum filtersSample purchases$45.00
Total$271.53
Per square foot per month$271.53 ÷ 24,000 sq ft$0.0113

Paper towels, tissue and hand soap are not on the list: the contract has the client supply them. A bid that includes paper adds it here, and the per-square-foot figure then stops being comparable with accounts that do not.

Overhead as a share of direct labor

Overhead is charged to each account in proportion to its direct labor dollars: $214,000 of annual overhead over $1,150,000 of annual direct labor is 18.61 percent. The base follows what drives a cleaning company's overhead. Supervisors, payroll processing, hiring and the office all scale with the labor on an account, not with its supply spend.

Supplies and equipment stay out of the base so the same dollar is not charged twice. The supervisor's inspection hours are charged to the account directly and also carry overhead, because the supervisor's vehicle and telephone sit in the overhead pool.

Filled janitorial job costing sheet: five-night office account in Honolulu

The account is a 24,000-square-foot office building cleaned Monday to Friday nights: 16,000 square feet of carpet, 5,500 of hard floor and six restrooms with 24 fixtures. A cleaner works each night, and a supervisor inspects for 2 hours each Friday. The company, building, price and actual figures are samples; the wages, tax rates and rules are published figures.

Filled Account tab, monthly hours (ISSA and published rates; sample quantities and company timings)
AreaTaskQuantityMinutes per unitMinutes per visitFrequencyHours per month
Whole buildingTrash, recycling, dusting, spot cleaning24,000 sq ft6.0144.00N52.00
CarpetVacuum, backpack, 12-inch tool16,000 sq ft8.25132.00N47.67
RestroomsClean and disinfect fixtures24 fixtures3.072.00N26.00
Hard floorDamp mop5,500 sq ft12.066.00N23.83
Hard floorAutomatic scrub, 17-inch5,500 sq ft10.1455.77W4.03
Total414.00 nightly, 55.77 weekly153.53
Filled Month tab, average-month budget against October 2026 actuals (sample price and actuals)
LineBudgetOctober 2026 actualVariance
Cleaner hours153.53163.509.97
Cleaner labor at $27.54$4,228.22$4,502.79$274.57
Supervisor hours8.6710.001.33
Supervisor labor at $39.61$343.42$396.10$52.68
Supplies$271.53$305.62$34.09
Equipment$28.00$28.00
Direct cost$4,871.17$5,232.51$361.34
Overhead at 18.61% of labor$850.78$911.68$60.90
Total cost$5,721.95$6,144.19$422.24
Contract price$6,450.00$6,450.00
Gross profit and margin$1,578.83 · 24.5%$1,217.49 · 18.9%
Net profit and margin$728.05 · 11.3%$305.81 · 4.7%

The price works out to $0.269 per square foot per month. Equipment is the account's share of an automatic scrubber and two backpack vacuums, depreciated over their sample lives and spread across the accounts that use them.

October variance and the general excise tax line

October lost 6.6 points of net margin, and the sheet separates the calendar from the work. October 2026 had 22 weeknights and five Fridays, against the average month's 21.67 and 4.33. At the budget rates, that calendar alone called for 156.45 cleaner hours. The other 7.05 hours were work. The clock record places them in the week of October 19, when a tenant moved in and the cleaner hauled cardboard each night. The extra liners in the supplies line come from the same week.

The two sources of variance call for different responses. The calendar variance averages out across the year, because short months such as February carry fewer nights at the same price. The move-in hours do not: a contract that names tenant moves as extra work bills them, and one that does not absorbs them.

Hawaii's general excise tax sits outside the cost lines when it is passed on. Honolulu's rate is 4 percent plus a 0.5 percent county surcharge, effective through December 31, 2030. The maximum pass-on rate is 4.712 percent (Hawaii Department of Taxation, County Surcharge on General Excise and Use Tax, page updated January 9, 2024). Passed on, it adds $303.92 to the $6,450.00 invoice and the business owes 4.5 percent of $6,753.92, the same $303.92 within a cent. Absorbed into the price, it is a cost of $290.25 a month, and the budget's net margin falls from 11.3 percent to 6.8 percent.

Monthly costing procedure from walkthrough to rebid

  1. Measure the account at the walkthrough: carpet and hard floor by square feet, restrooms by fixture count, and the frequency of each task from the specification.
  2. Fill the Account tab, with a source on every rate and the company's own timings labeled as such.
  3. Update the Labor tab once a year: the wage paid, the tax rates on current notices, the health plan premium and the workers' compensation rate. Recompute the overhead share from the year's budget.
  4. Set the budget column from the average month, and enter the contract price.
  5. At month end, enter the clock hours, supervisor hours and supplies issued to the account in the actual column.
  6. Split the hours variance into calendar and work: rebudget the month at its own nights and Fridays, and attribute the remainder to the reasons on the clock record.
  7. Check that the actual cleaner hours equal the clock record for the month's jobs, and that rows 6 to 10 add to row 11 in both columns.
  8. At the contract anniversary, replace the published rates with the account's logged minutes per unit and reprice.

Cleaning business software and the actual-hours column

The budget column is built once; the actual column is rebuilt every month from the clock, the stock room and the receipts.

In FieldRanger, recurring job templates create the five weekly visits, and each night is its own job assigned to a cleaner. The assigned cleaner clocks in and out with time logged against each job, and geo-location time tracking records where each clock-in happened. Technicians check supplies out of a specific warehouse, and materials used are logged against each job for job costing. Revenue reports show job revenue and margin by customer or service type, custom reports come from a drag-and-drop report builder, and any report downloads as CSV or Excel; the job costing reports page describes them. A month's export of hours and materials by job pastes into the actual column instead of being retyped. Invoices and payments sync with QuickBooks. The cleaning estimate template builds the bid the budget column starts from, and the cleaning invoice template bills the month.

The Labor tab stays in the workbook, with the loaded labor rate, the overhead allocation and the general excise tax worked there, and payroll is not built in FieldRanger. One job can carry several cleaners when a building needs a team; the sample assigns one cleaner to each night.

Frequently asked questions

How do janitorial companies calculate job costs?

They convert each task's square feet or fixture count into minutes with a production rate, multiply by visits per month, and price the hours at a loaded labor rate. Supplies, equipment and a share of overhead are added, and the total is set against the monthly contract price to give gross and net margin.

What is a loaded labor rate for a cleaner?

The cost of one productive hour: the wage plus payroll taxes, unemployment taxes, health coverage and workers' compensation, spread across productive rather than paid hours. In the Honolulu sample, an $18.93 wage loads to $27.54.

How much should supplies cost per square foot for janitorial work?

It depends on the floor mix, dilution rates and whether the client supplies paper. The Honolulu sample, with client-supplied paper, budgets $271.53 a month for 24,000 square feet, or $0.0113 per square foot.

Is there a free janitorial job costing template in Excel?

Yes. The page offers a free .xlsx download with no sign-up: the Account columns on a Template sheet from row 5, the Month, Rates and Labor tabs, and a Sample sheet with the filled Honolulu account.

Do Hawaii cleaning companies have to provide health insurance?

Hawaii's Prepaid Health Care Act requires coverage for employees who work at least 20 hours a week and earn 86.67 times the minimum wage a month. The employer pays at least half the premium, and the employee's share is capped at the lesser of half the premium or 1.5 percent of monthly wages.

October at 4.7 percent net

The Honolulu account kept $305.81 of $6,450.00 in October: 2.92 cleaner hours went to a long calendar month and 7.05 to a tenant's moving week. The November sheet starts from the same budget, and the contract's next renewal is the place to name tenant moves as extra work. The bid and invoice that bracket this sheet use the cleaning forms in the free field service templates. Ten weeknights of clock records fit inside the 14 days of Start free trial, which asks for no card, and the plans are listed on pricing.

FieldRanger runs field service inside HubSpot

Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.

Book a demo