Free Excel Job Costing Template for Contractors
One sheet per job: agreed price, change orders, cash collected, recorded costs and what's left — the free template from our job costing guide.
- One entry table per job: date, vendor or client, category, description, type, amount, receipt
- Summary block: agreed price, cash collected, recorded costs, left to collect
- Change orders roll into the agreed price automatically
- Dropdowns for type and category, so entries stay consistent
- Opens on a worked example you can overwrite
- English and Spanish versions — the download matches this page's language
Not ready for an app? Start with our free Excel template.
A ready-made spreadsheet to track costs and income per project — with categories and the totals already set up.
How it works
One sheet per job. Enter the agreed price, then log every cost and every payment as it happens — date, vendor or client, category, description, type, amount, and whether you have the receipt. The summary block keeps the agreed price (contract plus change orders), cash collected, recorded costs, what's left to collect, and agreed price minus costs current as you type.
It opens on a worked example so you can see how the rows feed the summary, and the category column is ready for the twelve starter cost codes — build your own list with the cost code builder and paste the names in.
The spreadsheet does the arithmetic; the discipline is yours: every receipt logged the week it's paid, coded consistently, priced against what was really agreed. When that starts slipping across three jobs and four phones, that's the moment an app earns its keep.