Jobs
JOB-2026-0011
Cashflow Forecast — Perth Community Campus

Cashflow Forecast — Perth Community Campus

Cost Value Reconciliation Back to job

Forecast cash in

£469,995

Receipts & receivables over the window

Forecast cash out

£218,411

Costs payable on terms

Projected closing balance

£51,028

From -£200,556 opening

Lowest projected balance

-£200,556

No dip projected

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

£14,642

Outstanding £14,642 · released £0

First moiety

£7,321

Awaiting practical completion date

Second moiety

£7,321

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	£136,481	£45,789	£90,692	-£109,864
Jul 26	—	£20,908	-£20,908	-£130,772
Aug 26	£211,499	£44,035	£167,464	£36,692
Sep 26 forecast	£73,209	£54,350	£18,858	£55,551
Oct 26 forecast	£48,806	£53,328	-£4,522	£51,028
Nov 26 forecast	—	—	£0	£51,028
Dec 26 forecast	—	—	£0	£51,028
Jan 27 forecast	—	—	£0	£51,028
Feb 27 forecast	—	—	£0	£51,028
Mar 27 forecast	—	—	£0	£51,028
Apr 27 forecast	—	—	£0	£51,028
May 27 forecast	—	—	£0	£51,028

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