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
Set revenue and budgets
Enter the contract sum and approved variations, then each cost code's original budget.
- 2
Update costs monthly
Committed cost, actual cost to date and accruals for each code.
- 3
Forecast to complete
Estimate each code's cost to complete, bottom-up, and check it against what's committed.
- 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.
More free templates
- Progress claim templateA month-end progress claim: schedule of values, cumulative % complete, variations, retention, GST and the total payable, with the Security of Payment endorsement for your state.Get the template
- Payment schedule templateThe assessor's reply to a payment claim: claimed against scheduled amount line by line, a reason wherever they differ, retention, GST and the scheduled amount.Get the template
- Variation register templateEvery variation on the contract in one log: status, claimed and approved values, time impact and the adjusted contract sum.Get the template
- Risk register templateA 5×5 risk and opportunity register: likelihood and consequence scoring, bands, expected value, owners, treatments and a live heat map.Get the template
- EOT and delay notice registerDelay notices and extension of time claims per separable portion: notice dates, days claimed, days granted and each portion's adjusted completion date.Get the template
- Retention tracker templateRetention held claim by claim against the cap, releases at practical completion and the end of the defects liability period, and the balance still held.Get the template