Skip to main content

Project financials

Read a project's contract, budget, cost, progress, forecast and margin on one screen, with budget against actual by phase and the balance of work line by line.

Where
  1. Projects
  2. open a project
  3. Budget
Who
  • Company Admin
  • Project Manager
  • Accountant

Project financials sit on the Budget tab, below the budget itself. Nothing on this screen is typed in or stored: every figure is worked out when you open it, from the cost ledger, the certified RA bills and the contract BOQ. The same progress and forecast margin also appear in the strip at the top of every project tab.

๐Ÿ“ท Screenshot spot โ€” the Budget tab below the budget panel: the Contract / Budget cost / Actual cost / Forecast strip, and the Margin, Exposure and Revenue panels

Save as static/img/screenshots/finance-financials.png and replace this box with ![Project financials](/img/screenshots/finance-financials.png)

The headline figuresโ€‹

FigureWhat it is
ContractThe revised contract value โ€” the award plus approved variations.
Budget costThe revised budget, including the cost of approved variations.
Actual costCost the job has used, from the cost ledger. Underneath: how much of the job is certified.
ForecastWhat the job is now expected to cost in total. Underneath: the method used. It turns red when the forecast passes the contract value.

Progressโ€‹

Progress is measured by value, from what the client has certified:

certified quantity ร— rate, summed over the contract BOQ, รท contract quantity ร— rate, summed the same way.

Fifty finished lines worth โ‚น2,000 each are not half of a hundred-line BOQ whose other fifty lines are the โ‚น2 crore structure, so counting lines would mislead. Using the client's certified quantity, not a site estimate, means progress is a figure the client has already agreed to. It never shows more than 100%.

The forecast and its basisโ€‹

Two forecasts are worked out every time:

  • remaining at budget โ€” actual cost so far, plus the budget for the work still to do. It assumes today's overrun was a one-off.
  • current performance โ€” actual cost รท progress. It assumes the job keeps performing the way it has so far.

Below 10% certified progress the screen shows remaining at budget; from 10% on it shows current performance. Before anything is certified it shows not started, and the forecast is the full budget plus anything already spent.

Example: budget โ‚น4,00,00,000, actual cost โ‚น30,00,000, progress 6%. Remaining at budget gives โ‚น30,00,000 + 94% of the budget = โ‚น4,06,00,000. Current performance would give โ‚น30,00,000 รท 6% = โ‚น5,00,00,000. At 6% the screen shows โ‚น4,06,00,000, labelled remaining at budget.

Why the forecast always names its method

Actual รท progress means nothing early in a job: a โ‚น10,000 mobilisation overrun on a job 2% done forecasts a โ‚น5,00,000 overrun on the whole contract, and a report that says that once teaches people to ignore it. Actual plus remaining budget is the honest answer early but complacent late, because it assumes every overrun so far was the last. A forecast quoted without its method is a number somebody will take out of context.

The screen shows only the forecast the rule picks, with its method underneath. The other one is not displayed.

Margin, exposure and revenueโ€‹

Margin shows three figures that answer three different questions:

MarginWorked out asIt tells you
Budgetcontract โˆ’ budgetwhat you planned to make
Forecastcontract โˆ’ forecastwhat you now expect to make
Earnedrevenue recognised โˆ’ actual costwhat you have made so far

A healthy budget margin next to a negative forecast margin is a job in trouble that the budget alone would not show.

Exposure shows Committed (ordered, not yet consumed), Actual (consumed) and Total โ€” everything already spoken for.

Revenue shows Recognised โ€” the certified amount of every certified bill, recognised at certification and nowhere else โ€” and Progress.

Budget against actualโ€‹

  • Cost by head shows actual cost and each head's share. It has no budget column: the budget holds one cost rate per BOQ line, not a split into material, labour and the rest, so a budget per head would be invented.
  • Budget vs actual, by phase shows Budget, Actual and Variance for each phase. Variance is budget โˆ’ actual: positive is under budget, and over-budget phases show in red. Phases with neither a budget nor a cost are left out. Budget lines and costs that carry no phase are grouped together as "(no phase)".

Execution statusโ€‹

Execution status answers "how much of this job is left", line by line: Item, Description, Unit, Contract, Executed (last measured on a bill), Billed (last submitted), Certified, Balance and Balance value. Lines added by a variation carry a VO tag. The table shows the first 200 lines of the contract BOQ.

Who can see itโ€‹

The Company Admin, and Project Managers and Accountants on the project's team. A QS / Estimator does not see it โ€” the role prices the work, and the margin is kept separate. Site roles do not see the Budget tab at all. A team member ticked Sees financials whose role does not see cost gets the Contract and Budget cost figures in the project's header strip, but not this screen.

AI

Cost Overrun Watch reads the budget, the ledger and progress, works out the variance and forecast, and explains in plain English which cost lines are driving an overrun. It creates nothing.

  • Budget โ€” create or revise the budget these figures are measured against.
  • Cost ledger โ€” every entry behind the actual and committed figures.
  • RA bills โ€” certification drives both progress and recognised revenue.
  • Change orders โ€” approved variations move the contract and the budget.