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.
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.
| Column | Header | Contents | Formula |
|---|---|---|---|
| A | Area | Carpet, hard floor, restrooms, whole building | Typed |
| B | Task | One task from the contract specification | Typed |
| C | Quantity | Square feet, or fixtures for restrooms | Typed from the walkthrough |
| D | Unit | 1,000 sq ft or fixture | Typed |
| E | Minutes per unit | From the Rates tab | =VLOOKUP(B5,Rates!$A:$C,3,FALSE) |
| F | Minutes per visit | Quantity in units times minutes per unit | =IF(D5="fixture",C5*E5,C5/1000*E5) |
| G | Visits per month | 5 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))) |
| H | Frequency | N nightly, W weekly, M monthly | Typed |
| I | Hours per month | Minutes per visit times visits, over 60 | =ROUND(F5*G5/60,2) |
| J | Rate source | ISSA table, published article, or the company's own timing | Typed |
| Row | Line | Formula in column B | Column C |
|---|---|---|---|
| 5 | Cleaner hours | =SUM(Account!I:I) | Hours from the clock record |
| 6 | Cleaner labor | =B5*Labor!$B$14 | =C5*Labor!$B$14 |
| 7 | Supervisor hours | Inspection hours planned | Hours logged |
| 8 | Supervisor labor | =B7*Labor!$C$14 | =C7*Labor!$C$14 |
| 9 | Supplies | =Rates!$B$20*Account!$C$2 | Receipts and stock issued |
| 10 | Equipment | Monthly charge for machines on this account | Same |
| 11 | Direct cost | =SUM(B6,B8,B9,B10) | =SUM(C6,C8,C9,C10) |
| 12 | Overhead | =(B6+B8)*Labor!$B$18 | =(C6+C8)*Labor!$B$18 |
| 13 | Total cost | =B11+B12 | =C11+C12 |
| 14 | Contract price | The monthly price | Same |
| 15 | Gross profit and margin | =B14-B11, and =B15/B14 | =C14-C11, and =C15/C14 |
| 16 | Net 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.
| Task | Rate | Source |
|---|---|---|
| Vacuum carpet, backpack vacuum with 12-inch carpet tool | 8.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-behind | 10.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, sinks | 3 min per fixture | Ben Walker, Facility Cleaning Decisions, August 15, 2014 |
| Trash, recycling, dusting and spot cleaning, whole building | 6.0 min per 1,000 sq ft | Company's own timing (sample) |
| Damp mop hard floor, flat mop | 12.0 min per 1,000 sq ft | Company'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.
| Row | Item | Source or formula | Cleaner (B) | Supervisor (C) |
|---|---|---|---|---|
| 3 | Wage | OEWS mean hourly wage, Honolulu MSA, May 2025 | $18.93 | $28.70 |
| 4 | Social Security and Medicare | =ROUND(B3*7.65%,2) | $1.45 | $2.20 |
| 5 | Federal unemployment | =ROUND(7000*0.6%/B12,2) | $0.02 | $0.02 |
| 6 | Hawaii unemployment | =ROUND(MIN(B3*B12,64500)*2.4%/B12,2), new-employer rate | $0.45 | $0.69 |
| 7 | Prepaid 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 |
| 8 | Workers' compensation | =ROUND(B3*4.10/100,2), sample $4.10 per $100 of payroll | $0.78 | $1.18 |
| 9 | Cost per paid hour | =SUM(B3:B8) | $25.10 | $36.11 |
| 12 | Paid hours a year | Sample | 2,080 | 2,080 |
| 13 | Productive hours a year | Sample: paid hours less 80 of holiday and vacation and 104 of travel between buildings and training | 1,896 | 1,896 |
| 14 | Loaded rate per productive hour | =ROUND(B9*B12/B13,2) | $27.54 | $39.61 |
| 16 | Annual overhead | Sample: office, general liability, software, vehicles for supervisors, owner's salary | $214,000 | |
| 17 | Annual direct labor | Sample: all cleaner and supervisor labor charged to accounts | $1,150,000 | |
| 18 | Overhead 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.
| Item | Basis | Monthly cost |
|---|---|---|
| Floor cleaner concentrate, mopping | 13.75 gal a night × 21.67 nights × 1 oz × $0.22 | $65.54 |
| Floor cleaner concentrate, scrubbing | 7.33 gal a scrub × 4.33 scrubs × 1 oz × $0.22 | $6.99 |
| Disinfectant and glass cleaner | Sample purchases | $58.00 |
| Can liners | Sample purchases | $96.00 |
| Pads, microfiber and vacuum filters | Sample 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.
| Area | Task | Quantity | Minutes per unit | Minutes per visit | Frequency | Hours per month |
|---|---|---|---|---|---|---|
| Whole building | Trash, recycling, dusting, spot cleaning | 24,000 sq ft | 6.0 | 144.00 | N | 52.00 |
| Carpet | Vacuum, backpack, 12-inch tool | 16,000 sq ft | 8.25 | 132.00 | N | 47.67 |
| Restrooms | Clean and disinfect fixtures | 24 fixtures | 3.0 | 72.00 | N | 26.00 |
| Hard floor | Damp mop | 5,500 sq ft | 12.0 | 66.00 | N | 23.83 |
| Hard floor | Automatic scrub, 17-inch | 5,500 sq ft | 10.14 | 55.77 | W | 4.03 |
| Total | 414.00 nightly, 55.77 weekly | 153.53 |
| Line | Budget | October 2026 actual | Variance |
|---|---|---|---|
| Cleaner hours | 153.53 | 163.50 | 9.97 |
| Cleaner labor at $27.54 | $4,228.22 | $4,502.79 | $274.57 |
| Supervisor hours | 8.67 | 10.00 | 1.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
- 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.
- Fill the Account tab, with a source on every rate and the company's own timings labeled as such.
- 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.
- Set the budget column from the average month, and enter the contract price.
- At month end, enter the clock hours, supervisor hours and supplies issued to the account in the actual column.
- 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.
- 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.
- 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