Job Costing Spreadsheet Template: Track Estimate vs Actual on Every Job

What is a job costing spreadsheet (and a job cost report)?

A job costing spreadsheet records what one job was supposed to cost and what it did cost, in the same rows, so the gap is visible. A job cost report is the same sheet summarised after the job closes: estimate, actual, variance and the margin you really kept.

Most free templates in the search results are built for construction project budgets or manufacturing standard costs. A small service business needs something narrower: the quote you sent, the hours your crew clocked, the receipts, and one number at the bottom — profit left at the price you already agreed. That is what this page builds. I'm not a contractor; I build the pricing math, and every number below shows its working so you can check it.

If you have not priced the job yet, start with how to price a job; job costing is the loop that checks whether that price held up.

What does a job cost sheet look like?

A job cost sheet has one row per cost code and four money columns: estimated, actual, variance in dollars, variance in percent. Labour is costed at the loaded rate, not the wage, and overhead is charged per crew-hour.

The labour and overhead lines move together because both are driven by crew-hours. That is the single most useful thing a job cost sheet tells you: when hours slip, you lose twice. Try your own estimate below — the calculator returns the break-even and the price, which become the Estimated column.

Worked example: estimate vs actual on one job

Here is the estimate. Two workers, 16 hours each, a $25 wage with 30% burden, $900 of materials, and $24,000 of yearly overhead spread over 2 people × 220 billable days × 8 hours. Every input is an assumption — replace it with your own.

The job was sold at $3,320.28. Then the job ran long: 19.5 hours each instead of 16, and materials came to $1,040. Here is the same math on the actuals:

The price was already agreed, so the profit is what is left after the actual cost: $3,320.28 − $2,573.41 = $746.87. The quote planned $1,162.10 of profit; $415.23 of it went to the overrun. Real margin: $746.87 ÷ $3,320.28 = 22.5%, not 35%.

How to make a job cost sheet in Excel or Google Sheets

Build it in seven steps: set your rates once, list cost codes, enter the estimate, log actuals as the job runs, compute variance, compute real margin, then carry the actual production rate into the next quote.

1. Rates tab. Wage, burden %, yearly overhead, people in the field, billable days, target margin. Every job reads from here.
2. Cost codes. Labour, material groups, rentals, subs, disposal, overhead. Keep the same codes on every job so you can compare jobs.
3. Estimate column. Paste the numbers from your quote. Freeze them — never edit the estimate after the job starts.
4. Actual column. Timesheet crew-hours and receipt totals, entered daily or at close.
5. Variance. Dollar and percent per line, with a flag above your trigger.
6. Real margin. (Quoted price − actual cost) ÷ quoted price.
7. Feedback. Actual crew-hours ÷ units of work = your measured production rate for the next bid.

That sequence also answers the common question “what are the 7 steps of job costing?” — different textbooks group them differently, but every version ends at the same place: compare, then correct the next estimate.

The mistake that hides overruns: costing labour at the wage

If your sheet costs labour at the wage, every job looks more profitable than it was. The loaded rate adds the costs of employing someone: the employer share of Social Security (6.2%) and Medicare (1.45%) per the IRS, plus workers' comp, liability insurance and paid time off.

The example uses 30% burden as an assumption, so a $25 wage becomes $32.50. On 39 actual crew-hours that is the difference between $975 at the wage and $1,267.50 loaded — $292.50 of real cost a wage-based sheet never shows. Work out your own burden with the labor burden calculator.

The second hidden mistake is overhead as a percentage of cost. Overhead is a yearly bill divided by the hours you can actually sell — here $6.82 per crew-hour. Charge it per hour and a long-running job correctly carries more overhead, which is exactly what happened in the example ($218.18 planned, $265.91 actual). The overhead and profit calculator walks through the division.

How to track budget vs actual in Excel

Put estimate and actual in adjacent columns, subtract, divide by the estimate, and add conditional formatting so a line over your trigger turns red. That is the whole budget-vs-actual method; everything else is layout.

Two rules keep the comparison honest. First, lock the estimate column once the job is sold (Excel: Review → Protect Sheet leaving only the Actual column editable; Google Sheets: Data → Protect sheets and ranges). Second, compare against the quoted price, not a re-calculated price — the customer is paying what you quoted, so the overrun comes out of profit.

For a job cost report across many jobs, add one summary row per job to a log tab: job name, quoted price, estimated cost, actual cost, real margin. Sort by real margin and the job types that lose money float to the top.

Feed the actuals back into the next quote

The point of job costing is the next estimate. Divide actual crew-hours by the units of work (rooms, square feet, linear feet, fixtures) to get your measured production rate, and quote the next similar job on that rate instead of the one you guessed.

Re-pricing the example job on its actual 39 crew-hours and $1,040 of materials gives $3,959.09, against the $3,320.28 that was sent. If the next job of this type is quoted at the old price, the same overrun repeats. If you win fewer jobs at the corrected price, that is information too: either the work is priced right and those customers were buying a loss, or your crew's production needs attention.

Pricing trade-specific work? The contractor estimate template guide covers the quoting side that produces the Estimated column.

Free job costing template vs a paid or custom build

A free template is enough if you will maintain the formulas yourself; pay for a build when you want the rates, cost codes and quote sheet wired together and tested.

The done-for-you custom job-pricing calculator is built around your real materials, labour tasks, equipment and subs, shows total cost → price → profit in dollars and margin %, and includes a job log and dashboard for win-rate, revenue and average margin. It is built from scratch around how you price, so ask for actual-cost columns when you fill in the form.

What to put in your job costing template

Keep it to the fields you will actually fill in after a tired day on site. A short sheet that gets used beats a detailed one that does not.

• Header: job name, customer, quote date, quoted price (locked).
• Rates block: wage, burden %, overhead a year, people in the field, billable days, target margin.
• Cost lines: cost code, description, estimated, actual, variance $, variance %.
• Hours: estimated vs actual crew-hours — the line that drives two others.
• Result: actual cost, profit at the quoted price, real margin %.
• Feedback: units of work and measured production rate.

Want to run the numbers before building anything? The free job pricing calculator gives the estimate side in your browser.

Step-by-step: Job Costing Spreadsheet Template: Track Estimate vs Actual on Every Job

1. Set your rates once. Enter wage, burden %, yearly overhead, people in the field, billable days and target margin on a rates tab every job reads from.
2. Lock the estimate. Copy the quoted cost lines and price into the Estimated column and protect it once the job is sold.
3. Log actuals. Enter timesheet crew-hours and receipt totals per cost code as the job runs or at close.
4. Compute variance. Variance $ = actual − estimate; variance % = variance ÷ estimate. Flag lines above your trigger.
5. Compute real margin. Real margin = (quoted price − actual total cost) ÷ quoted price.
6. Update your production rate. Divide actual crew-hours by units of work and use that rate on the next similar quote.

Related guides