Questions

Is there a free job costing spreadsheet worth using?

Yes, and most of them are a profit calculator rather than a job costing tool, which is a different thing wearing the same name.

Written by JD Davenport, who still sells for a living. Updated 4 November 2026.

A profit calculator takes numbers you already trust and subtracts them. That is arithmetic, and your phone can do it. Job costing is the work of getting numbers you can trust in the first place, and that is the part almost every free template leaves out.

What to check before you trust one

Does it hold one row per payment, or one row per category? A template with a single cell for material has already thrown away the only thing that would let you test it. A total is not evidence. If you cannot see the line items you cannot find the error.

Does it have anywhere to mark a cost you could not attach to a job? If not, those costs either get forced onto a job that did not cause them or silently dropped. Both make the output worse than no output, because it looks finished.

Does it distinguish a verified payment from an unverified one? Missing paperwork is not fraud. Plenty of subs invoice by text message. But a payment nobody checked has to look different from one somebody checked and passed, or every row carries the same confidence and none of it is earned.

Does it state a window and a basis? Revenue is not a number. Collected, date closed, 1 January to 31 July, is a number. A sheet that does not say which it is will produce arguments you cannot settle.

A free template that handles those four is worth more than a paid one that does not.

What is free on this site

There are browser tools on the free tools page that run the mechanical half of this. They work entirely in your browser. Nothing you put into them is uploaded anywhere, there is no login, and there is nothing to cancel.

They will not do the part that requires judgment, which is deciding what a cost belongs to. Nothing will. But they will take a list of payments and tell you which ones fail a test, which is the slow part done fast.

When a template stops being enough

Two signals, and neither is about how many jobs you run.

When you need to compare across jobs rather than within one. A per-job sheet answers what this job made. It cannot tell you that the same line has come up short on six of your last ten, which is the finding that actually changes how you price.

When somebody gets paid off the number. The moment a commission depends on a job's margin, job costing accuracy stops being a reporting question and becomes a payroll question. A sheet that is roughly right is fine for a gut check and not fine for a paycheck.

The honest version of the advice

Start free. Take your last ten finished jobs, one row per payment, and see how many rows you cannot attach to a job or produce a document for. That list is the real output and it costs you an afternoon.

If the list is short, a free template is all you need and you should stop reading. If the list is long, the problem was never the spreadsheet.

The free browser tools are on the free tools page. The twelve tests, the full register and the workbook are The Job Cost Standard, bought once, no monthly fee and no login. More answers on the questions page.