Source: https://www.quantsurv.com/library/tools/payment-cycle-worked-worksheet
Content format: Markdown version of the public page.
Content reviewed: 2026-10-14

# Payment cycle worked worksheet

Practise a complete payment cycle with a cumulative valuation, retention, prior assessment and receipt reconciliation.

by [Jack Butler-Kettle](<https://www.quantsurv.com/about#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.

[Download blank Excel workbook](<https://www.quantsurv.com/downloads/library/payment-cycle-worked-worksheet.xlsx>)

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.

Payment cycle worked worksheet: completed fictional example
| 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](<https://www.quantsurv.com/library/courses/payment-cycle>) for the context and checks behind this template.

If you need help preparing or reviewing the project records, our [quantity surveying services](<https://www.quantsurv.com/quantity-surveying>) explain the tasks available under a separate appointment. Agree the deliverable, responsibilities and required specialist input before work starts.

[Browse the Library](<https://www.quantsurv.com/library>)