Payment cycle worked worksheet
Practise a complete payment cycle with a cumulative valuation, retention, prior assessment and receipt reconciliation.
by Jack Butler-Kettle · About 2 min readShare
How to use it
Complete the working sheet using your own cycle. Separate the current amount applied for from the assessed amount and the cash received.
Payment cycle worked worksheet
Complete the working sheet using your own cycle. Separate the current amount applied for from the assessed amount and the cash received.
Free blank template for your own project. The completed example is shown below. No email address required.
View the completed example
Completed fictional example
Westhaven refurbishment · 14 October 2026 · Version 1.0
Payment cycle worked worksheet
Scroll across if needed to read the whole record. A dash means no value has been entered.
| Cycle | Gross cumulative (£) | Retention (£) | Previous assessed (£) | Current application (£) | Current assessed (£) | Cash received (£) | Assessed balance (£) |
|---|---|---|---|---|---|---|---|
| October | £120,000.00 | £6,000.00 | £90,000.00 | £24,000.00 | £22,000.00 | £20,000.00 | £2,000.00 |
Example amounts exclude VAT. The £24,000 application, £22,000 assessment and £20,000 receipt are different stages; the assessment difference remains unresolved.
Understanding your results
Example amounts exclude VAT. The £24,000 application, £22,000 assessment and £20,000 receipt are different stages; the assessment difference remains unresolved.
How it works
The workbook provides blank working records. Grey cells calculate from the entered inputs; yellow cells are for your information. The completed example stays on this page.
Read the related guidance for the context and checks behind this template.
If you need help preparing or reviewing the project records, our quantity surveying services explain the tasks available under a separate appointment. Agree the deliverable, responsibilities and required specialist input before work starts.