Relay
Pricing
Get started
Pricing
Get started
Free tools

Free job profitability worksheet: estimated vs actual costs

Free from Relay, no signup. Defaults and sources checked November 14, 2026.

Compare the revenue and costs you expected with what the job actually took. Keep multiple jobs on this device, include return visits and review the causes of a change in profit. Blank costs remain unrecorded; they are never silently counted as zero.

Loading saved jobs…

Review saved jobs (1)

All jobs in your open collection on this device, including current edits.

Includes 0 of 1 jobs with complete actual revenue and costs. 1 incomplete job is excluded from totals.

No jobs have complete actual records yet. Finish a job below before interpreting totals.

Finish incomplete jobs

  • Untitled job 1

    Record Revenue, Initial visit labor, Materials and 4 more inputs.

Job costs and revenue

Revenue

USD, before sales tax

Use revenue after discounts or refunds. An unpaid invoice is not the same as zero revenue.

Labor and visits

Initial visit

Estimated

Actual

Use separate rows for different burdened rates. For an unplanned return visit, record estimated hours as 0 and enter its actual labor. Include paid travel hours once.

Other job costs

Enter 0 where no cost applies. A blank means unrecorded. Include all visits in these amounts once.

Cost, USDEstimatedActual
Materials
Subcontractors
Vehicle and travel
Other direct costs
Allocated overhead
Record zero for remaining cost amounts

Use only after confirming there are no other costs in that column. These actions fill blank amounts above with 0; labor, revenue and recorded values are kept.

Job result

ResultEstimatedActual
Total entered costIncompleteIncomplete
Job profitIncompleteIncomplete
MarginIncompleteIncomplete

Estimated figures are incomplete. Known cost subtotal: $0.00. Record Revenue, Initial visit labor, Materials, Subcontractors, Vehicle and travel, Other direct costs, Allocated overhead. Profit and ratios are withheld for this column.

Actual figures are incomplete. Known cost subtotal: $0.00. Record Revenue, Initial visit labor, Materials, Subcontractors, Vehicle and travel, Other direct costs, Allocated overhead. Profit and ratios are withheld for this column.

Contribution, markup and calculation scope

Actual contribution before entered overhead: Incomplete. Actual markup on all entered costs: Incomplete.

Job profit includes only recorded costs and the overhead allocation you entered. It is not your company’s net profit. A zero denominator leaves margin or markup undefined.

The PDF includes private labor rates and all recorded assumptions. Incomplete jobs export with missing-cost warnings.

Backup and restore

Download a backup or restore one here. Keep portable copies of work you need.

Price a future job · Prepare a separate customer estimate

Compare the same scope on both sides

Start with the original estimated revenue, person-hours, burdened labor rates and cost allowances. Record actual revenue and costs for the whole job, including return visits. Use revenue before sales tax and after discounts or refunds. This worksheet compares job economics; an unpaid invoice is not zero revenue, and the result is not cash collected.

Record a zero only when you know no cost applies. If a worker's hours or rate are missing, the labor row remains incomplete. A known-cost subtotal can help you finish the records, but it is not the full cost and does not establish profit.

How profit, margin and variance are calculated

  • Labor cost for each row = person-hours × burdened hourly cost, rounded to cents once per row.
  • Direct job cost = labor + materials + subcontractors + vehicle/travel + other direct costs.
  • Contribution before allocated overhead = revenue − direct job cost.
  • Job profit after entered overhead = revenue − direct job cost − allocated overhead.
  • Margin = job profit ÷ revenue. Markup = job profit ÷ all entered job costs. A zero denominator leaves its ratio undefined.
  • Profit change = actual revenue minus estimated revenue, less actual costs minus estimated costs.

The University of Maine Cooperative Extension's pricing guide explains why markup on cost and margin on selling price have different denominators. This worksheet applies those definitions to the costs you enter. It does not establish company net profit, tax treatment or an accounting policy.

A return visit changes a profitable job

In the fictional worked example, estimated revenue is $1,200 and entered costs are $580, leaving $620. Actual revenue is $1,180 and entered costs are $780, leaving $400. Profit falls $220: revenue is $20 lower and costs are $200 higher.

The extra $200 consists of $120 labor, $40 materials, $10 vehicle costs and $30 allocated overhead. Five actual person-hours include four for the initial visit and one for the return. Return-visit parts and vehicle costs are already in their categories; adding a second lump-sum callback cost would count them twice.

Save, back up and share the right document

Your job collection saves in this browser when storage is available. It is not uploaded or synchronized with Relay jobs, estimates or other devices. Anyone using the same browser profile can access saved worksheets. Use Backup and restore to download a portable copy; restoring asks before replacing the current collection.

Open Review saved jobs to review every job in the current collection on this device. Only jobs with valid actual revenue and every actual cost recorded enter the totals; unfinished estimates do not exclude those actuals. Combined margin is total included job profit divided by total included revenue, rather than an average of job margins. Zero total revenue leaves it undefined. Incomplete jobs stay visible with a direct route to their first missing or invalid actual input. The internal CSV lists included figures and explicit exclusions.

The exported PDF is an internal cost worksheet and includes private burdened rates, costs and notes. Keep it for your own review. Use the estimate builder for a separate customer-facing proposal. Neither this worksheet nor its links change an accepted or sent estimate.

Use the variance to improve the next job

Compare the largest changes with their records. More person-hours may reflect scope, travel or an extra visit. Materials can change through quantities, unit prices or parts needed on a return. Apply the same overhead-allocation method to both sides before comparing them.

Use the labor rate calculator to review labor burden and the flat-rate calculator to price a future scope. The job-costing software guide provides a completed-job test for evaluating a live system.

For the next planning period, use the technician capacity and callback calculator. It keeps a crew time budget separate from a defined historical callback cohort; it does not infer callback rates from this worksheet's visit labels.

Questions

What is the difference between a blank cost and zero?

A blank means the cost has not been recorded. Zero means you have confirmed no cost applies. An incomplete column shows only its known-cost subtotal; profit and ratios are withheld until revenue and all cost inputs are recorded and valid.

How do I include a callback or another technician?

Add a separate labor row for the extra visit or worker. Enter person-hours and that worker's burdened hourly cost. Put return-visit parts and vehicle costs into their existing categories once, without also adding a lump-sum callback total.

Is the exported PDF suitable for my customer?

It is an internal cost worksheet with private labor rates and cost assumptions. Use a separate customer estimate or service report after reviewing its scope. No estimate, invoice, payment or live job is changed by this worksheet.

Can I use it without an account?

Yes. You can enter multiple jobs, compare costs, download an internal PDF and back up or restore your collection without signing up. Storage is local to this browser and is not cloud synchronization.

Does job profit mean company net profit?

No. It is revenue less the job costs and overhead allocation you entered. Company expenses, financing, taxes and other costs outside this worksheet still affect company net profit. Zero revenue or zero entered cost leaves the corresponding percentage ratio undefined.

Evaluate job-costing software with a worked job
Book a demo

All free tools

Product

  • All features
  • AI Front Office
  • Business Phone
  • Website
  • Booking
  • Pipelines
  • Scheduling & dispatch
  • Mobile App
  • Pricebook
  • Inventory
  • Time tracking & timesheets
  • Estimates & proposals
  • Invoicing & payments
  • Customer management
  • Maintenance plans
  • Review requests
  • Customer campaigns
  • Reports & profitability

Compare

  • Relay vs Housecall Pro
  • Relay vs Jobber
  • Relay vs ServiceTitan
  • Relay vs Workiz
  • Relay vs FieldPulse

Industries

  • HVAC
  • Plumbing
  • Electrical
  • Garage door
  • Appliance repair

Legal

  • Privacy
  • Terms
  • SMS Policy
  • Account Deletion

Company

  • About
  • Guides
  • Free tools
  • Help center
  • Contact
  • Support
© 2026 Relay Ops, Inc.