Financial statement
The whole money position of one contract on one page: contract sum, every certificate, paid and owed, in PDF or Excel.
The financial statement answers in one page what a meeting asks about a contract: what it is now worth, what has been certified, what was deducted, what has been paid and what is still owed. It is worked out as at today from the certified certificates only, so it always agrees with them.
Print or export it
- PDF: Statement on the contract's workspace, or Print › Financial Statement on the contract form.
- Excel: on the contract form, the Action menu (the gear) › Financial statement to Excel.
- From the Dashboard with one contract chosen: Financial statement (PDF) and Excel.
The PDF is A4 landscape with the firm's letterhead, titled Financial Statement as at the date; the Excel file is named Financial statement and the contract number, with the same figures in three parts: CONTRACT SUM, CERTIFICATES and POSITION.
What it shows
| Part | Content |
|---|---|
| Heading | Contract, Contract No., Employer, Contractor, Quantity Surveyor; Possession of site, Completion (contract), Completion (revised) with the days of extension, Practical completion (or N days late, or Not yet) |
| Contract sum | Original contract sum, each approved variation order with its amount, Revised contract sum, and Variations waiting for approval (not included) |
| Certificates | One row per certified certificate: Certificate, Date, Gross to date, Retention, Advance recovery, Liq. damages, Net to date, Amount due, VAT, Withholding, Payable, Paid, Still to pay; then a Total row |
| Position | The contract's standing today (below) |
The position
- Revised contract sum.
- Gross valuation certified to date, of which materials on site, and Work done to date with its % of the revised sum.
- Balance to complete, or Over-certified by when the work certified passes the revised sum.
- Retention held, Advance paid, Advance still to be recovered, Liquidated damages deducted.
- Certified for payment (incl. VAT, less withholding tax), Paid, Still to be paid, and Of which overdue.
Revised contract sum135,375,000
Gross valuation certified to date71,400,000
Work done to date (52.7% of the revised sum)71,400,000
Balance to complete63,975,000
Retention held6,493,750
Certified for payment (incl. VAT, less withholding tax)60,330,450
Paid35,000,000
Still to be paid25,330,450
Rules
- Only certified certificates are listed; drafts and submitted ones are left out. Without any, the table says No certified certificate yet.
- The advance payment certificate comes first. Its valuation columns (gross to net) are empty because it values no work; its amount due, VAT, withholding and payments are shown and added to the totals.
- The figures of each row are those frozen on the certificate when it was certified; paid and still to pay are today's.
- Anyone who can open the contract can print it; cost and profit are not on it (see Cost control).
Something unclear? Ask us on WhatsApp: we answer the same day.