A ready to use Excel valuation for building interim payment applications or supporting an NEC4 clause 50 assessment, with retention, VAT and certification status calculated automatically. Built by quantity surveyors.
A pay application or valuation is the document that sets out the value of work done to date, so the contractor is paid the right amount at the right time. Under JCT it is the contractor's interim valuation or application for payment, certified by the quantity surveyor or architect/contract administrator. Under NEC4 there is no contractor "application" by default: the Project Manager assesses the amount due under clause 50, drawing on the same evidence this template organises.
Under NEC4, a contractor only submits its own application for payment where the secondary option Y(UK)2 has been incorporated into the contract. Without it, the clause 50 assessment is Project Manager led, not contractor led, though most contractors still prepare a valuation like this one to support that assessment.Most valuations fail in the same two places: the percentage complete on each line is someone's estimate rather than something evidenced, and the retention and VAT arithmetic is redone by hand every month with a fresh chance of error. This template fixes the arithmetic and gives every line an evidence reference to point at.
| Field | Why it matters |
|---|---|
| Contract sum, approved variations, previous certified | The three numbers that set the ceiling and the starting point for this month's application |
| Retention % and VAT % | Applied automatically to the gross figure so the net amount due is never hand calculated |
| Contract value, % complete, value to date | Per line item, so the total application is built from measured progress, not a single lump figure |
| Previously certified, current application | The sheet works out the current application as value to date minus what has already been certified |
| Evidence ref and certification status | Points at the diary entries or progress photos behind each line, and tracks where each item sits in the certification cycle |
[SCREENSHOT: Pay Application tab showing the application summary panel with retention and VAT calculated, and the line item grid with % complete driving value to date] Each line carries the same evidence and status fields shown here, and the Dashboard tab totals the application automatically as lines are updated.
The Excel file with automatic retention, VAT and current application calculations, plus a worked example tab.
Download the template (.xlsx) Free download. No email needed. Yours to use and share with your team.The contract sum is £2.4m with £85,000 of approved variations already agreed and £650,000 previously certified. Groundworks is 95% complete against a £650,000 contract value, giving a value to date of £617,500. With £550,000 already certified on that line, the current application for groundworks alone is £67,500. Across all three line items the gross current application comes to £153,955. At 3% retention and 20% VAT, the sheet works out a net amount due without anyone touching a calculator.
Envelope is only 25% complete but carries the largest contract value, so it is the line most worth checking against the site diary before the application goes out. That is the line an assessor will query first.
A valuation is only as strong as the evidence behind each percentage complete. If the 95% on groundworks cannot be backed up by a diary entry or a progress photo from the same week, that line gets queried, and the whole application slips.
Gather's AI QS reviews your records against the NEC4 clauses and surfaces the events your team has not notified yet, before the eight week clock bars them.
See how the AI QS catches missed CEs A 30 minute call. No commitment. Bring one of your live contracts.FAQ
It can support one, but NEC4 does not have a standard contractor "payment application" by default. The Project Manager assesses the amount due under clause 50. A contractor only submits its own application where the Y(UK)2 secondary option is incorporated. Either way, this valuation gives the Project Manager the same evidence to assess against.
Under JCT the contractor submits an interim valuation or application for payment, which the quantity surveyor or architect/contract administrator certifies. Under NEC4 the Project Manager carries out the assessment under clause 50, using the contractor's records as evidence rather than a formal application in most cases.
Yes. Enter the retention and VAT percentages once in the application summary panel and the sheet calculates the retention deduction, net before VAT, VAT amount and amount due from the gross current application automatically.
Yes, that is how it is designed to be used. Track variations or compensation events separately, then bring the agreed value across into the contract value or approved variations figure on this sheet once it is agreed.
Gather reads your site diaries as they come in and flags the CEs before the time bar does.
Book a demo