When you need it
Use when a payment application, certificate and bank receipt do not align clearly. Maintain it across payment periods to distinguish assessment differences, contractual deductions and genuinely unallocated or missing cash.
XLSX /
AI tools and documents for engineering and project management.
Payment Application and Certificate Reconciliation
Reconcile applied, assessed, certified and received amounts against actual contract and payment records.
How to use this templateThis Excel template contains prepared working sheets and completion notes on a separate sheet. Enter your project data and review the completed workbook before use.
This editable workbook helps you organise project information. Check any included formulas, assumptions and results before use; it does not replace professional review.
The form prepares a separate brief; it does not fill the Word or Excel file.
Read product descriptions in your language. The Word and Excel template files are in English.
Only selected pages are shown. This is not the complete template. The full editable Word or Excel file is supplied with purchase.
Learning
How to use this template
What it helps you decide
The reconciliation explains how applied values become certified amounts and receipts. It supports focused follow-up while avoiding the false conclusion that every application difference represents certified overdue debt.
How to complete it
- Identify Application / period and a consistent currency, tax and cut-off basis. Separate current-period movements from cumulative Applied value and Certified value.
- Record Difference reason from actual certificate explanations. Reconcile Retention / recovery and other adjustments against verified contractual records without assuming every deduction is agreed.
- Match Receipt reference to bank evidence and payment allocation. Describe Outstanding reconciliation and Follow-up, keeping disputed valuation distinct from certified amounts awaiting payment.
Who prepares and reviews it
The commercial administrator prepares it with quantity surveyors and finance staff. A reviewer checks period and cumulative values; contractual payment decisions and legal interpretations remain with the relevant authorized representatives and advisers.
A mistake to avoid
Subtracting a single receipt from cumulative applications mixes incompatible periods and can exaggerate the amount described as unpaid or overdue under the contract.
Illustrative example
Illustrative example: a contractor receives less cash than the latest application's gross value. The worksheet identifies a certified deduction, advance recovery and a receipt partly allocated to an earlier period. Finance and commercial staff then determine which difference needs clarification and which relates to an unresolved valuation.
Document contents
- Document control and decision owner
- Evidence, scope and applicability
- Period and cumulative basis
- Certification differences
- Cash and adjustment reconciliation
- Administration follow-up
- Open points, competent review and decision
Required inputs
- Project / asset identity, assessment date, scope and authorized decision owner
- Verified source documents with exact revision and record locators
- Payment applications and supporting measurements
- Certificates and assessment explanations
- Bank receipt records
- Contract retention, advance and tax provisions
Practical tools.
Professional judgment.
Confirm the adopted edition, local amendments, National Annex where relevant, and contract requirements.
Prepare project brief