How the certificate is worked out
Every line of the certificate with its formula, and a full worked example to 109,563,000.
Every interim certificate is worked out the same way, in the same order, from the work valued and the contract terms copied onto the valuation. All the deductions are to date (cumulative); the amount due is the net valuation to date less what was certified before. That is why a correction on any line simply flows through the next certificate.
The calculation, line by line
| No. | Line | How it is worked out |
|---|---|---|
| 1 | Measured work to date | Sum of the Contract BoQ lines valued to date. |
| 2 | Approved variations to date | Sum of the approved VO addition lines valued to date (omissions already lowered the BoQ lines). |
| 3 | Materials on site (allowed) | Sum of value × % allowed. |
| 4 | Gross valuation to date | 1 + 2 + 3. |
| 5 | Less retention | Retention % × gross (or × 1 + 2 when retention is not taken on materials), never above the retention limit, less any retention released. See Retention. |
| 6 | Less advance recovery | Recovery % × gross, or equal shares over a number of certificates, never above the advance paid. See Advance payment. |
| 7 | Less liquidated damages | Days late × the rate, never above the limit, less any waived. Only when there are damages. See Liquidated damages. |
| 8 | Net valuation to date | 4 - 5 - 6 - 7. |
| 9 | Less previous certificates | The net valuation to date of the previous interim certificate (line 8 of it). The advance payment certificate is not in it. |
| 10 | Amount due this certificate (excl. VAT) | 8 - 9. |
| 11 | Add VAT | VAT % × the tax base. A contract without VAT prints VAT: exempt. |
| 12 | Less withholding tax | WHT % × the tax base. Printed only when the contract has withholding tax. |
| 13 | Total amount payable | 10 + 11 - 12, also in words. |
The tax base is the amount due (line 10). With the setting Taken after VAT and WHT (damages are not a lower price) on (Settings › Certificates and printing, on by default), this certificate's own liquidated damages are added back first, so VAT and withholding tax are worked out on the certificate before the damages are taken off; the VAT line then reads, for example, Add VAT 18% of 12,550,000 (before the liquidated damages).
Worked example
A TZS 850,000,000 contract: retention 10% with a limit of 5% of the contract sum (42,500,000), an advance of 10% (85,000,000, certified before IPC No. 1) recovered at 20% of each gross valuation, VAT 18%, no withholding tax. The Contract BoQ has two lines: substructure 100 m3 at 1,000,000 and superstructure, finishes and services as one item of 750,000,000.
Before IPC No. 2, VO-001 (additional works, 8,000,000) is approved. The superstructure is 15% complete, the VO work is done, and the materials on site are now worth 20,000,000, allowed at 75%.
In words: One Hundred and Nine Million, Five Hundred and Sixty-Three Thousand Shillings Only. This month the certificate added 112,500,000 of measured work and 8,000,000 of variations, held 13,264,286 more retention and recovered 26,528,571 more of the advance; 37,900,000 of the advance is still to be recovered. With a withholding tax of, say, 5% on the contract, the same certificate would deduct 4,642,500 and pay 104,920,500.
Rounding
Each line value, materials allowed, retention, advance recovery, VAT and WHT is rounded on its own to the currency's smallest unit; for Tanzania that is the whole shilling, and every printed figure is in whole shillings. Totals are sums of the rounded figures, so the certificate always adds up on paper.
Edge cases
- The amount due can be negative: for example when liquidated damages, or a line lowered after an over-valuation, take back more than the month's work adds. VAT and WHT follow its sign, and the certificate shows the amount owed back in brackets.
- An interim certificate whose amount due (excl. VAT) is below the contract's Minimum certificate amount cannot be certified; carry the work into the next month.
- Work valued (lines 1 and 2) above the revised contract sum needs a reason and a Senior QS / Manager to certify it (see Submitting, certifying and freezing).
- The advance is never recovered beyond what was paid, and retention never held beyond its limit.
Good to know
The advance payment certificate is separate: its money comes back through advance recovery, never through previous certificates.
Something unclear? Ask us on WhatsApp: we answer the same day.