Excavation Job Costing Template
Download an excavation job costing template to compare estimated and actual labor, equipment, trenching, hauling, materials, shoring, dewatering, change orders, and project profit.
Track Excavation Costs From Estimate Through Financial Closeout
An excavation job costing template gives contractors a structured way to compare estimated, committed, actual, and forecast costs for labor, equipment, trenching, shoring, dewatering, imported materials, hauling, disposal, testing, restoration, and change work. It helps project teams identify overruns early and understand whether each excavation area, trench segment, structure, crew, or project phase is performing as planned.
This Excavation Job Costing Template is designed for excavation contractors, earthwork subcontractors, site-development companies, utility contractors, grading contractors, demolition contractors, estimators, project managers, operations managers, equipment managers, purchasing teams, accounting staff, and construction business owners.
What Is Excavation Job Costing?
Excavation job costing is the process of assigning estimated, committed, actual, and forecast costs to a specific project, work area, trench segment, structure, excavation type, crew, cost code, or phase. It shows how field production, labor hours, equipment utilization, trucking, material purchasing, shoring, dewatering, subcontractor charges, and change work compare with the original estimate and current budget.
A complete excavation job-cost record may include mobilization, utility coordination, potholing, clearing, demolition, topsoil stripping, mass excavation, footing excavation, utility trenching, structure excavation, trench support, groundwater control, bedding, backfill, imported fill, export, unsuitable soil, rock excavation, compaction, erosion control, testing, restoration, supervision, punch-list work, and closeout.
When to Use This Template
- After an excavation estimate becomes an active project budget
- During mass excavation, foundation work, trenching, backfill, and restoration
- When tracking labor productivity by excavation type, trench segment, structure, or crew
- When monitoring excavators, dozers, loaders, trenchers, compactors, pumps, cranes, and trucks
- When comparing imported fill, bedding, aggregate, geotextile, and flowable-fill costs with the estimate
- When tracking shoring, trench-box, slide-rail, sheet-pile, or hydraulic-support costs
- When monitoring dewatering equipment, fuel, discharge treatment, and standby
- When tracking pending and approved change orders
- Before progress billing, forecasting, or project review meetings
- At closeout to compare final cost with the original estimate
Who Should Use This Template?
This template is suitable for excavation contractors, earthwork companies, sitework subcontractors, utility contractors, grading contractors, demolition contractors, civil subcontractors, estimators, project managers, superintendents, operations managers, equipment managers, purchasing teams, accounting staff, and business owners.
It can be adapted for residential foundations, subdivisions, commercial sites, multifamily developments, industrial facilities, municipal work, roadway improvements, underground utilities, stormwater systems, renewable-energy sites, and public infrastructure.
What an Excavation Job Costing Template Should Include
| Job-Cost Section | Purpose |
|---|---|
| Project and Contract Details | Identifies the project, customer, contract value, estimate, revised budget, reporting period, excavation scope, and project status. |
| Cost Codes | Organizes costs by mobilization, utility coordination, excavation, trenching, shoring, dewatering, backfill, hauling, testing, and restoration. |
| Labor Costs | Tracks foremen, operators, laborers, grade checkers, utility installers, pipe layers, mechanics, regular time, overtime, standby, and rework. |
| Equipment Costs | Records excavators, dozers, loaders, skid steers, trenchers, hammers, compactors, pumps, cranes, vacuum excavators, service equipment, and fuel. |
| Excavation Production | Compares estimated and actual bank cubic yards, loose cubic yards, compacted fill, trench length, import, export, unsuitable soil, and rock. |
| Shoring and Dewatering | Tracks trench boxes, hydraulic shoring, slide rail, sheet piles, pumps, well points, bypass systems, filtration, power, fuel, and monitoring. |
| Materials | Records bedding, select fill, structural fill, aggregate, geotextile, geogrid, flowable fill, erosion-control products, and consumables. |
| Hauling and Disposal | Tracks truck hours, loads, payloads, haul routes, tipping fees, disposal charges, borrow costs, scale tickets, and rejected loads. |
| Subcontractors and Specialty Costs | Tracks surveying, testing, blasting, shoring engineering, dewatering, traffic control, environmental monitoring, and restoration work. |
| Change Orders | Separates potential, submitted, approved, rejected, billed, and collected change-order cost and revenue. |
| Revenue and Billing | Tracks original contract value, approved changes, progress billing, stored materials, retainage, collections, and remaining backlog. |
| Forecast and Profitability | Calculates estimated cost at completion, cost variance, projected gross profit, projected margin, overbilling, and underbilling. |
How to Use the Template
- Enter the project, customer, contract value, reporting period, excavation scope, and original estimate totals.
- Break the estimate into excavation-specific cost codes and budget categories.
- Enter labor hours, rates, burden, crews, work areas, trench segments, structures, and activities.
- Record equipment hours, fuel, rental, ownership allocation, maintenance, standby, and production.
- Add purchase orders, supplier invoices, trucking records, disposal tickets, subcontractor invoices, and credits.
- Track shoring, dewatering, imported materials, testing, restoration, and permit costs separately.
- Separate committed costs from posted actual costs.
- Track pending and approved change-order cost and revenue outside the original contract budget.
- Update installed quantities, percent complete, cost to complete, and estimated cost at completion regularly.
- Close the project only after all labor, equipment, invoices, credits, changes, retainage, restoration, and closeout costs are reconciled.
An excavation subcontractor budgets a commercial utility package with separate cost codes for potholing, trench excavation, trench boxes, groundwater pumping, bedding, imported backfill, compaction, export hauling, disposal, testing, pavement restoration, and supervision. The weekly cost report shows trench excavation on budget but dewatering and trucking trending over because groundwater inflow increased pump hours and a disposal site change added haul time. A pending change order is tracked separately so the project manager can see unrecovered cost exposure.
Best Practices for Excavation Job Costing
- Use the same cost codes in estimating, time tracking, equipment logs, purchasing, and job-cost reports.
- Track costs by work area, excavation type, trench segment, structure, crew, and phase when practical.
- Record labor, equipment, trucking, supplier, and subcontractor costs promptly.
- Separate productive labor, material handling, rework, standby, travel, maintenance, and overtime.
- Track production quantities with labor and equipment hours.
- Keep bank, loose, and compacted quantities separate.
- Reconcile supplier invoices with purchase orders, delivery tickets, truck tickets, and disposal receipts.
- Track open commitments separately from posted actual costs.
- Separate base-contract work from change-order work.
- Forecast remaining cost rather than relying only on cost to date.
Common Excavation Job Costing Mistakes
- Using different cost codes in the estimate and field records
- Posting labor or equipment without the correct work area, trench segment, or activity
- Ignoring open purchase-order and subcontract commitments
- Failing to track pending change-order cost exposure
- Combining productive time, standby, breakdowns, rework, and overtime
- Mixing bank, loose, and compacted quantities
- Leaving shoring, dewatering, testing, restoration, and closeout costs out of the budget
- Failing to reconcile trucking with tickets and disposal records
- Waiting until project closeout to review cost variances
- Closing the project before all invoices, credits, retainage, warranty, and restoration costs are recorded
Frequently Asked Questions
What costs should be included in excavation job costing?
Include labor, labor burden, equipment, fuel, shoring, dewatering, imported materials, trucking, disposal, subcontractors, testing, surveying, traffic control, supervision, restoration, warranty, and closeout costs.
What is the difference between estimated, committed, and actual cost?
Estimated cost is the project budget. Committed cost represents approved purchase orders and subcontract commitments. Actual cost is the amount posted from labor, equipment, invoices, trucking, and other completed transactions.
How should excavation productivity be measured?
Compare installed quantities with labor and equipment hours. Examples include bank cubic yards per excavator hour, linear feet of trench per crew day, compacted cubic yards per labor hour, and truckloads per truck hour.
How should shoring costs be tracked?
Separate engineering, mobilization, rental, installation, adjustment, inspection, standby, removal, repair, and subcontractor costs by trench segment or structure.
How should dewatering costs be handled?
Track pumps, well points, bypass systems, hoses, filtration, treatment, power, fuel, monitoring, permits, maintenance, standby, backup equipment, and operating duration separately.
How should hauling and disposal be tracked?
Track truck hours, loads, payload, route, origin, destination, tipping fees, disposal receipts, borrow charges, rejected loads, queue time, and route-related delays.
What is estimated cost at completion?
Estimated cost at completion is the projected final project cost based on actual cost to date, open commitments, remaining work, production performance, and known project risks.
When should an excavation job be financially closed?
Close it after all labor, equipment, supplier invoices, trucking, subcontractor charges, credits, change orders, retainage, restoration, warranty, and closeout costs are recorded and reconciled.
Protect Excavation Margins With Better Cost Visibility
A structured excavation job-cost report helps contractors compare estimated and actual performance, identify overruns early, forecast remaining cost, and improve future pricing.
SimplySub can help excavation subcontractors organize estimates, jobs, time records, equipment, purchase orders, change orders, invoices, daily logs, documents, tasks, and job-cost information within one workflow.