Jobs
JOB-2026-0007
Cashflow Forecast — Inverness Data Centre

Cashflow Forecast — Inverness Data Centre

Cost Value Reconciliation Back to job

Forecast cash in

£45,062

Receipts & receivables over the window

Forecast cash out

£28,305

Costs payable on terms

Projected closing balance

£16,910

From £153 opening

Lowest projected balance

-£5,765

Funding low point — Jun 26

Retention

5% withheld per valuation, capped at 3% of the contract sum. Released in two halves at practical completion and end of defects.

Total held

£1,538

Outstanding £1,538 · released £0

First moiety

£769

Awaiting practical completion date

Second moiety

£769

Awaiting practical completion date

Monthly cashflow

Cash in (payments received and outstanding notified sums, then forecast valuations) versus cash out (costs paid on terms), with the running cash position. Past months are actuals; future months are forecast.

Month	Cash in	Cash out	Net	Cumulative
Jun 26	£2,466	£8,384	-£5,919	-£5,765
Jul 26	£10,569	£5,677	£4,892	-£873
Aug 26	£17,127	£3,427	£13,700	£12,827
Sep 26 forecast	£6,354	£3,860	£2,494	£15,321
Oct 26 forecast	£6,354	£3,478	£2,876	£18,197
Nov 26 forecast	£2,191	£3,478	-£1,287	£16,910
Dec 26 forecast	—	—	£0	£16,910
Jan 27 forecast	—	—	£0	£16,910
Feb 27 forecast	—	—	£0	£16,910
Mar 27 forecast	—	—	£0	£16,910
Apr 27 forecast	—	—	£0	£16,910
May 27 forecast	—	—	£0	£16,910

Figure	How it's calculated
Contract Sum	The awarded value
Approved Variations	Σ agreed variation amounts, with the % drift = (projected − contract) ÷ contract
Variations Outstanding	Σ claimed amounts of open variations/claims (not yet agreed), with a count
Projected Final Account	Contract sum + agreed variations
Certified to Date	Σ certified on payment applications, vs the total applied for

Tab	What's there
Details	Contract terms, project overview
Commercial Register	All contractual events — variations, instructions, claims
Variations	Detailed variation management with valuation breakdown
Payment Applications	Interim valuations and certification tracking
Cost Ledger	Actual and committed costs
Documents	Drawings and files, with the take-off tool

Status	Meaning	Counts as
Committed	Ordered, not yet invoiced	Future spend
Accrued	Work done, not yet invoiced	Cost to date
Invoiced	Invoice received	Cost to date
Paid	Settled	Cost to date

Layer	What it is	Example
Section	A heading that groups items	"Roofing", "Preliminaries"
Item	A measured line: quantity × unit rate	"Slate roofing — 250 m²"
Build-up	The cost lines that make an item's rate	Labour + Slates + Battens

Tool	Measures	How
Linear / polyline	Length (m, lm)	Sum of segment lengths × scale
Polygon area	Area (m²)	Shoelace formula × scale²
Rectangle	Area (m²)	width × height × scale²
Ellipse	Area (m²)	π × r₁ × r₂ × scale²
Count	Number (nr)	1 per pin placed

Field	Purpose
Reference	Your variation number, e.g. `VO-001`
Instructed by	Who originated the change
Title / scope	What the change is
Contract clause	The clause it's claimed under
Claimed vs agreed amount	What you've asked for vs what's been agreed
Programme impact	Extension of time claimed and agreed, in days
Notified / response / resolved dates	The timeline

Notice type	NEC4	JCT / SBCC	Standard
Early Warning (EWN)	7 days	—	7 days
Compensation Event (CE)	21 days	—	—
Variation (VAR) / Instruction (AI)	—	14 days	14 days
Extension of time (EOT)	21 days	14 days	14 days

Colour	Meaning
🟢 On track	More than 3 days to respond
🟠 Due soon	3 days or fewer remaining
🔴 Overdue	Past the response deadline
⚪ Resolved	Agreed, rejected or closed

Field	Meaning
Applied amount	The gross value you're claiming this period
Certified amount	What the payer certifies as due
Retention	Deducted automatically per the job's terms (override if needed)
Paid amount / paid date	Recorded on settlement