Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesConstruction & EngineeringEstimates & BidsJob Cost Tracker

SpreadsheetEstimates & BidsFree

Job Cost Tracker

Budget, committed and actual cost by cost code, with a forecast at completion and the variance to budget.

Shown with sample data

Colour

Job Cost Tracker

Budget, committed and actual cost by cost code, with a forecast at completion and the variance to budget.

Budget
$621,000
Forecast at completion
$617,356
Projected over (−) or under budget
$3,644
Codes over budget
2
Budget by category
  • Subcontractors$373,000
  • Materials$90,000
  • Labour$82,000
  • Overheads$48,000
  • Equipment$28,000
Share of budget by category
  • Subcontractors$373,00060%
  • Materials$90,00014%
  • Labour$82,00013%
  • Overheads$48,0008%
  • Equipment$28,0005%

How to use it

  1. 1Set up cost codes to match your estimate.
  2. 2Update committed costs when orders and subcontracts are placed.
  3. 3Enter actual cost and an honest percent complete each month.
  4. 4Investigate every code flagged Over budget.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Know whether a job is making money while you can still do something about it. For each cost code enter the budget, what is committed in orders and subcontracts, actual cost to date and percent complete; the sheet forecasts final cost, shows the variance and flags codes heading over budget.

Who it’s for

  • Monthly cost reports
  • Spotting overruns early
  • Feeding real costs back into future estimates

What’s included

  • Job costs sheet: One row per cost code.
  • Summary by Category sheet: Budget and Actual to date and the number of entries for each category, calculated from the Job costs sheet.

How to use it

  1. 1Set up cost codes to match your estimate.
  2. 2Update committed costs when orders and subcontracts are placed.
  3. 3Enter actual cost and an honest percent complete each month.
  4. 4Investigate every code flagged Over budget.
Related searchesjob costingconstruction budget vs actualcost to completejob cost reportconstruction cost tracking

Details

Format
Spreadsheet
Category
Estimates & Bids
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetEstimates & BidsFree

Job Cost Tracker

Budget, committed and actual cost by cost code, with a forecast at completion and the variance to budget.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Estimates & Bids
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More estimates & bids templates

View all
Construction Cost Estimate3 sheets

Direct cost

$66,665

Bid price

$86,091

Margin in bid

14%

ABCD
1TradeItemQtyUnit
2Site prepExcavation & grading1lump sum
3ConcreteSlab foundation 4"1,200sq ft
4FramingWall framing1,850sq ft
5RoofingAsphalt shingles1,400sq ft
Estimate
SpreadsheetEstimates & Bids

Construction Cost Estimate

Itemised estimate by trade with quantities, unit rates, markup and contingency.

10 min setupPreview
Bid Comparison Sheet2 sheets

Packages

4

Awarded

1

Best bids vs budget

$1,800

ABCD
1PackageBidderBase bidExclusions to add
2ElectricalBright Spark Ltd$48,500$0.00
3ElectricalVolt Masters$44,200$3,800
4ElectricalBudget Electric$39,900$2,500
5PlumbingFlowRight$36,400$0.00
Bids
SpreadsheetEstimates & Bids

Bid Comparison Sheet

Level subcontractor bids by adding back exclusions and alternates, check insurance, licence and references, rank qualified bidders, and compare the best bid with your budget for each package.

10 min setupPreview
Material Takeoff Sheet4 sheets

Materials total

$24,319

Still to order

$5,291

Lines to order

4

ABCD
1AreaMaterialDrawing refMeasured qty
2FoundationReady-mix concrete 4000 psiS-10115
3FoundationRebar #4 (20 ft)S-102140
4FoundationVapour barrier 10 milS-1011,800
5Walls2x6 studs 8 ftA-201420
Takeoff
SpreadsheetEstimates & Bids

Material Takeoff Sheet

Quantities from drawings with waste factors, order quantities rounded up, material costs with tax and delivery, order status, and totals by area and supplier.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ