The monthly valuation
Work done to date line by line, materials on site, Excel progress, and what each month starts from.
Each interim valuation values all the work done to date, not only this month's: every line is the total done since the start, and the certificate takes off what was certified before. A slip one month is therefore put right the next month by itself. The certificate opens on its own screen: the work on the left, the certificate on the right, worked out again each time you type, down to To be paid in figures and in words.
Prepare the valuation
- 1Press Next valuation on the contract's workspace or on the dashboard (or New in Contracts › Payment Certificates, which asks for the contract). A draft that is still open is reopened instead of making a second one.
- 2The new valuation is numbered IPC No. 1, IPC No. 2 and so on, and dated today (or the date of the last valuation if that is later). Change the Valuation date on the right if needed: the period runs from the day after the previous certificate's period (from possession of site for IPC No. 1) up to the valuation date.
- 3Under To date, type each line's quantity done to date, or the % complete for a sum. Enter goes to the next line. Last month's figures are already filled in, so only the lines that moved need typing. Find a line and Only lines with work shorten a long BoQ.
- 4Under Materials on site, press Add materials for materials delivered but not yet built in: a description, the value and the % allowed.
- 5Check the certificate on the right, then press Submit (or Submit & Certify when you may certify it yourself). See Submitting, certifying and freezing.
What is on the valuation
A valuation is loaded with every priced line of the Contract BoQ (items, preliminaries, dayworks, provisional and PC sums, contingencies and % additions) and every addition line of every approved VO, in BoQ order, grouped by bill and then by VO. For each line:
| Column | What it is |
|---|---|
| Contract | The contract quantity: the BoQ quantity less what approved VOs omit. For a sum, the contract amount less what is omitted. |
| Rate | The contract rate (or the VO rate for a VO line). |
| Previous | The value to date on the previous certificate. |
| To date | What you type: the quantity to date (value = quantity × rate) or the % complete (value = contract amount × %). The value is shown under it. |
| This period | Value to date less previous: what this certificate adds for the line. |
| Done | Value to date as a % of the contract amount, as a bar. |
- Provisional sums, PC sums, contingencies and % additions are always valued by % complete. Other lines are valued by quantity; in Details › Work Done the hidden Method column switches a line to % complete (or back), keeping its value.
- A line valued above its contract quantity or amount turns red with above the contract under its bar. Check it: extra work normally needs a VO.
- A provisional sum omitted in full has nothing left to value and is not loaded.
- Progress cannot be negative. A line can be lowered below last month, and its This period is then negative: the certificate takes the over-valuation back.
- A VO approved while the valuation is a draft is added to it at once, and the contract terms are copied again.
Materials on site
Allowed = value × % allowed. The % allowed is proposed from the contract (Materials on site: % allowed, 100 by default). In Details › Materials on Site a row can also be picked from the price list, which fills the description and unit and works the value out as quantity × price. Every interim valuation starts with the previous certificate's materials copied over: remove what has been built in and change what is left. The Final Certificate has no materials on site.
Excel progress
On a large BoQ (on plans with Excel progress), open Details and press Excel Progress: Download the Sheet gives every line with what is done to date now. Type the total done to date in the last column (a quantity, or a % for sums), then choose the file and press Read the Sheet. HodariQ says how many lines were updated or unchanged, which cells were not numbers, which rows are not lines of this valuation, which lines kept their measurement sheet quantity, and which lines are now above the contract.
Tip
What the screen does not show (the contract terms used, the claimed figures, the liquidated damages waiver, the retention release, the history) is under Details.
Good to know
Only one certificate of a contract can be open at a time: a valuation that is not certified yet must be finished before the next one, or before an advance payment certificate, can be made.
Something unclear? Ask us on WhatsApp: we answer the same day.