Job costing spreadsheet template for trades
A working Excel job costing sheet for a trade business with several jobs on the go. List your jobs with the price agreed, enter each cost against its job, and the sheet shows what every job has cost in materials, labour, subcontractors and hire, the profit left, and the margin. Free, no sign-up and no email address.
What is in it
| Sheet | One row per | What it does for you |
|---|---|---|
| Jobs | Job | Job name, customer and the price agreed. The cost under each of five headings, the total cost, the profit and the margin are worked out from the Costs sheet, with a total for all jobs and a line for any cost given to no job. |
| Costs | Cost | Date, the job chosen from your own list, supplier or person, invoice number, type, and either an amount or hours and an hourly rate. The cost is worked out on every row. |
How to use it
Type each job on the Jobs sheet with the price you agreed with the customer. Then, as invoices arrive and days are worked, add a row to the Costs sheet. The Job column is a dropdown of the names on the Jobs sheet, so a cost cannot be given to a job that does not exist. Choose the type, and enter the amount from the invoice.
For your own time or a day-rate worker with no invoice, leave the amount empty and enter hours and an hourly rate instead; the sheet multiplies them. If you type an amount, the amount is used and the hours are ignored.
What it tells you
Whether the job you priced at £1,500 made money, while there is still time to do something about it. Profit is the price agreed less every cost entered against the job. Margin is that profit as a share of the price. A job whose margin is falling week by week is one where materials or days are running over the quote.
If you are VAT registered, enter the price and the costs without VAT so the two are compared on the same footing. If you are not, enter what you actually pay, VAT included, because it is a real cost to you. Labour you do yourself is only a cost on this sheet if you give it a rate; leave it out and the profit shown is what the job paid you for your time.
One job in detail, or many at a glance
This template is for comparing jobs. For one larger project with a budget for each stage and every invoice line recorded, the construction cost template sets a budget against actual spending.
Filling it in without typing
The cost rows come from merchant and hire invoices, most of them PDFs in an inbox or photos on a phone. Invoices to Spreadsheets reads a folder of those into one checked table with the date, supplier, invoice number and amounts, and every line item, which you can export to Excel and paste in. The job stays yours to choose. Try one invoice free, without an account.
Is the job costing template free?
Yes. Download it, use it, change it. No account, no email address, no card.
How many jobs can it hold?
Forty jobs and five hundred cost rows as it comes. To add more, copy the last job row down, formulas included, and do the same on the Costs sheet.
How do I cost my own labour?
Add a row with the type Labour, leave the amount empty, and enter the hours and an hourly rate. The sheet multiplies them. Use a rate that reflects what your time costs the business.
What if one invoice covers two jobs?
Enter it as two rows with the same invoice number, each with its job and its share of the amount.
Does it work in Google Sheets or Numbers?
Yes. It is a standard .xlsx file using SUM and SUMIFS, with ordinary dropdowns. Set your locale to United Kingdom before importing so dates are read day first.
7 days · 50 documents · No card needed
All free tools and templates · Construction cost template · CIS subcontractor payment template