HodariQ
Ctrl K
Back to siteBook a demo

Getting started

  • How HodariQ works
  • Set up your firm
  • Country, currency and dates
  • Users and roles
  • Approvals
  • Sending documents: e-mail and WhatsApp
  • The change log
  • Plans and limits
  • Features and switches
  • What must come first

Contracts

  • Create a contract
  • Commercial terms
  • Key dates and contract states
  • The contract workspace
  • Programme of works
  • Parties
  • Completion and closing
  • Consultant or contractor firm

Bills of Quantities

  • Build a BoQ
  • Lines, sums and totals
  • Units
  • Measurement sheets
  • Import from Excel
  • How the import reads a file
  • Paste and copy
  • Rates and build-ups
  • Price list, regions and the Price Book
  • Print the BoQ
  • Export to Excel
  • Tender, lock and revise
  • Compare revisions

Take-off

  • Start a take-off
  • The screen, keyboard and tablet
  • The scale
  • Lengths, areas and counts
  • Rooms: one click or every room
  • Roofs and wall centre lines
  • Doors, windows and symbols
  • Assemblies
  • Heights from sections
  • Zones
  • Send to the BoQ
  • Print the take-off
  • Check a take-off
  • Revised drawings
  • Revision to a variation order
  • Queries to the architect
  • Quick Measure

Tenders

  • Tender analysis
  • Tenderers and their rates
  • Checks and ranking
  • Award and the tender report

Variations

  • Variation orders
  • Pricing VO lines
  • Approving a variation order
  • VO from revised quantities
  • The VO document and the register
  • Extensions of time

Valuations and certificates

  • The monthly valuation
  • How the certificate is worked out
  • Retention and its release
  • Advance payment and its recovery
  • Liquidated damages
  • Measurement sheets
  • Submitting, certifying and freezing
  • Claimed and certified
  • Printing certificates

Money

  • Invoices and payments
  • Withholding tax and VAT
  • Who owes what
  • Financial statement
  • Cost control
  • Budget line by line
  • Recording costs
  • LPOs (purchase orders)
  • Suppliers and their prices
  • Schedule of materials
  • Subcontracts
  • Subcontractor certificates
  • Cost plans

Site Portal

  • Add your site team
  • On site: the phone pages
  • The daily report from the phone
  • Chats and photos
  • Notifications on the phone
  • Material requests at the office
  • Who approves, and the settings
  • Daily reports at the office
  • Work done, item by item
  • Who sees what

Inbox and Work

  • How the Inbox works
  • Connect the mailbox
  • How e-mails are sorted, summarised and dated
  • Which contract an e-mail is about
  • Check and approve e-mails
  • My work: reply, notes and Done
  • Alerts, the morning e-mail and the contract

Bids and the NeST scout

  • How bids work
  • Bid or no bid, and the documents
  • Results, the win rate and the contract
  • The NeST scout
  • Bid alerts

Team

  • Team: who has how much work

Registers and alerts

  • Bonds, insurance and documents
  • Alerts
  • The dashboard and the financial statement
  • The contractor portal
Ctrl K
Docs/Valuations and certificates

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.LineHow it is worked out
1Measured work to dateSum of the Contract BoQ lines valued to date.
2Approved variations to dateSum of the approved VO addition lines valued to date (omissions already lowered the BoQ lines).
3Materials on site (allowed)Sum of value × % allowed.
4Gross valuation to date1 + 2 + 3.
5Less retentionRetention % × gross (or × 1 + 2 when retention is not taken on materials), never above the retention limit, less any retention released. See Retention.
6Less advance recoveryRecovery % × gross, or equal shares over a number of certificates, never above the advance paid. See Advance payment.
7Less liquidated damagesDays late × the rate, never above the limit, less any waived. Only when there are damages. See Liquidated damages.
8Net valuation to date4 - 5 - 6 - 7.
9Less previous certificatesThe net valuation to date of the previous interim certificate (line 8 of it). The advance payment certificate is not in it.
10Amount due this certificate (excl. VAT)8 - 9.
11Add VATVAT % × the tax base. A contract without VAT prints VAT: exempt.
12Less withholding taxWHT % × the tax base. Printed only when the contract has withholding tax.
13Total amount payable10 + 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.

ExampleIPC No. 1 (31/03/2026)
Measured work to date: substructure 100 m3 complete100,000,000
Materials on site (allowed): reinforcement 2,857,143 at 100%2,857,143
Gross valuation to date102,857,143
Less retention 10% (below the limit of 42,500,000)(10,285,714)
Less advance recovery 20% of gross(20,571,429)
Net valuation to date72,000,000
Less previous certificates0
Amount due this certificate (excl. VAT)72,000,000
Add VAT 18%12,960,000
Total amount payable84,960,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%.

ExampleIPC No. 2 (30/04/2026)
Measured work to date: 100,000,000 + 15% of 750,000,000212,500,000
Approved variations to date (VO-001)8,000,000
Materials on site (allowed): 20,000,000 at 75%15,000,000
Gross valuation to date235,500,000
Less retention 10% (below the limit of 42,500,000)(23,550,000)
Less advance recovery 20% of gross(47,100,000)
Net valuation to date164,850,000
Less previous certificates (IPC No. 1)(72,000,000)
Amount due this certificate (excl. VAT)92,850,000
Add VAT 18%16,713,000
Total amount payable109,563,000

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.

← PreviousThe monthly valuationNext →Retention and its release

Something unclear? Ask us on WhatsApp: we answer the same day.

On this page

  • The calculation, line by line
  • Worked example
  • Rounding
  • Edge cases