Free Excel template

Free construction cost report template for monthly cost control

Monthly cost control for contractors in one sheet: budget, commitments and actuals by cost code, a forecast final cost for each, and the project margin that follows, with the movement since last month.

Sheets Cost report · How to use

Get the cost report template

Enter your email and the download starts straight away.

Excel (.xlsx); also opens in Google Sheets and Numbers. We’ll email you the link, and we may get in touch about Palydin. See our privacy policy.

01What's inside

Built the way the work is done.

  • Cost report

    Forecast revenue, cost, variance and margin at the top, and 150 cost code lines.

  • How to use

    How to update the report each month and keep the forecast honest.

  • Current budget = original budget + approved budget changes, so the original stays visible.
  • Cost to date includes accruals, and committed-but-unspent cost is shown beside the cost to complete.
  • A cost to complete below what's already committed is flagged: the most common way a forecast goes wrong.
  • Forecast final cost, variance to budget and % of budget spent for every cost code.
  • Movement in forecast final cost since the last report, with rises highlighted.
  • Forecast margin and margin % against contract sum plus approved variations.

02How to use it

From blank to done in four steps.

  1. 1

    Set revenue and budgets

    Enter the contract sum and approved variations, then each cost code's original budget.

  2. 2

    Update costs monthly

    Committed cost, actual cost to date and accruals for each code.

  3. 3

    Forecast to complete

    Estimate each code's cost to complete, bottom-up, and check it against what's committed.

  4. 4

    Report the movement

    Copy last month's forecast final cost across, then explain the movements and the margin.

03Questions

Good to know.

When the spreadsheet stops scaling.

Palydin runs cost reporting on versioned forecasts: actuals from your accounting system, accruals per version, approved forecasts frozen, and risk-adjusted P50 and P90 outcomes.