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

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

  1. 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.
  2. 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.
  3. 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.
  4. 4Under Materials on site, press Add materials for materials delivered but not yet built in: a description, the value and the % allowed.
  5. 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:

ColumnWhat it is
ContractThe contract quantity: the BoQ quantity less what approved VOs omit. For a sum, the contract amount less what is omitted.
RateThe contract rate (or the VO rate for a VO line).
PreviousThe value to date on the previous certificate.
To dateWhat you type: the quantity to date (value = quantity × rate) or the % complete (value = contract amount × %). The value is shown under it.
This periodValue to date less previous: what this certificate adds for the line.
DoneValue 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.

ExampleOne line, IPC No. 2
Superstructure, finishes and services: contract amount 750,000,000, 15% complete112,500,000
Previous (IPC No. 1)0
This period112,500,000

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.

← PreviousExtensions of timeNext →How the certificate is worked out

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

On this page

  • Prepare the valuation
  • What is on the valuation
  • Materials on site
  • Excel progress