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

# Final account preparation worksheet

Assemble the proposed final account and separate agreed changes, disputed items, retention and payments.

by [Jack Butler-Kettle](<https://www.quantsurv.com/about#jack-butler-kettle>) · About 2 min readShare

## How to use it

Reconcile the closing value with the change register before recording payments. Label proposals and agreements distinctly.

### Final account preparation worksheet

Reconcile the closing value with the change register before recording payments. Label proposals and agreements distinctly.

[Download blank Excel workbook](<https://www.quantsurv.com/downloads/library/final-account-preparation-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

#### Final account preparation worksheet

Scroll across if needed to read the whole record. A dash means no value has been entered.

Final account preparation worksheet: completed fictional example
| Account | Original sum (£) | Agreed changes (£) | Unagreed claim (£) | Proposed gross (£) | Retention held (£) | Payments received (£) | Proposed balance (£) |
| --- | --- | --- | --- | --- | --- | --- | --- |
| WH-042 closing proposal | £200,000.00 | £18,000.00 | £3,000.00 | £221,000.00 | £10,900.00 | £190,000.00 | £20,100.00 |

£221,000 is the proposed gross account, including £3,000 still disputed. £20,100 is the proposed balance excluding retention and VAT; it is not an agreed final payment.

## Understanding your results

£221,000 is the proposed gross account, including £3,000 still disputed. £20,100 is the proposed balance excluding retention and VAT; it is not an agreed final payment.

## 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/final-account>) 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>)