hayat help
Help › Hayat Projects

IPCs, retention and subcontractors

hayaterp.com ↗

Bill the client and pay subcontractors in Hayat Projects — the mobilisation advance certificate, interim and final payment certificates (IPC / running bills) worked out from measured quantities, with retention, advance recovery, sales tax and income tax withheld; certifying into a Sales invoice; client receipts; retention release; variation orders with approval; subcontract work orders, measured subcontractor bills with retention and deductions, posting to Purchasing and releasing their retention.

The Billing (IPC) tab of a project holds every certificate raised on the client; Variations and Subcontracts hold the changes to the contract and the work given out. Certificates, receipts and subcontractor bills need proj.bill; variation orders and subcontract work orders need proj.manage.

Certificate When Amount
Advance Start of the contract Mobilisation advance % × revised contract value, less any advance already billed
Interim (running bill) Each month or stage Work measured since the last certificate, less deductions
Final End of the contract Like an interim, and recovers all advance still outstanding
Retention release After completion Retention held from the client

Advance certificate

Billing (IPC) → Advance certificate: the date, the amount (the default is worked out for you), the client's certificate no. and notes. It is saved as a draft; Certify & invoice makes it a Sales invoice. The advance is then recovered bit by bit from each interim certificate.

Interim and final IPCs

  1. Make sure the site has measured progress up to the period end.
  2. Billing (IPC) → + IPC, choose Interim or Final, the period, the client certificate no. and, if this one differs, the retention %.
  3. Hayat makes a draft from the BOQ: per item the quantity to date, the previous certified quantity and this certificate's quantity, at the BOQ rate.
  4. Check the lines and the deductions. If the site measures more before you certify, click Recalculate.
  5. Certify & invoice and confirm. The IPC gets its number and a Sales invoice is posted.

Only one draft can be open per project at a time; Cancel removes a draft.

How the net is worked out

Line Formula Example
Gross work done to date Σ quantity to date × rate 45,000,000
Less previous certificates Σ gross of certified IPCs 35,000,000
This certificate (gross) The difference (must be more than 0) 10,000,000
+ Sales tax This × tax % (10 %) 1,000,000
− Retention This × retention % (5 %) 500,000
− Advance recovery This × recovery % (10 %), at most the advance still outstanding — 100 % on a Final 1,000,000
− Income tax withheld (This + tax) × withholding % (4 %) 440,000
Net payable 9,060,000

Certifying posts one Sales invoice to the client for the gross and the tax (due in 30 days), and at the same time settles the retention, the advance recovery and the tax withheld against that invoice. So the client's balance in Sales is exactly the net payable — what they really owe. A certificate whose net is 0 is Paid at once.

After the first certified interim or final IPC the BOQ is locked.

Client receipts

On the IPC, Receive payment: the amount, the tax withheld by client (if they deducted more at source), the method, reference and date, then Save receipt. It is a Sales receipt against the IPC's invoice. Payments taken directly in Sales against that invoice count as received too. The IPC shows received and balance; the IPC register lists them all.

Print gives the certificate with its lines and deductions for the client's signature.

Retention release

When the project is Completed (or Closed), Billing (IPC) → Retention release: the amount (all retention held by default), date and the client's certificate no. Certify it like any IPC: the retention moves from Retention receivable back into the client's normal receivable, ready to be collected. If Retention release needs completion is off in the settings, you can release before completion.

Variation orders

A variation order (VO) changes the contract after the BOQ is locked.

  1. Variations → + Variation: title, reason and the client's reference.
  2. Add lines of three kinds: New item (WBS node, code, description, unit, quantity and rate), Rate change (a BOQ item and its new rate) or Qty change (a BOQ item and its new quantity). The change in value of each line shows as you type.
  3. Save draft, then Submit for approval.

The outcome shows at once: approved (when no approval rule applies, or when the approver accepts it in the Approvals inbox), pending approval, or rejected. An approved VO adds the new items to the BOQ, changes the rates and quantities, and adds its amount to the project's variations — the revised value = contract value + variations. A draft or rejected VO can be edited and submitted again, or deleted.

Subcontractors

A subcontract work order gives part of the BOQ to a subcontractor — a Purchasing supplier — at agreed rates.

  1. Subcontracts → + Work order (or from the project's Subcontracts tab).
  2. Choose the subcontractor, a title, the dates and the retention % (the project's by default).
  3. Add lines, each linked to a BOQ item if you like: description, unit, quantity and rate.
  4. Save (Draft), then make it Active.

Statuses: Draft → Active → Completed, or Cancelled (an active work order only while nothing is billed). A completed one can be made active again. The open quantity of active work orders counts as committed cost.

Measured bills. Each time the subcontractor claims, + Measured bill: the date, the subcontractor invoice no., the quantity to date per line (this bill = to date − already billed) and any deductions with a note (materials you supplied, penalties). Save draft bill, check it, then Post bill:

Posted Accounts
Gross of this bill A Purchasing bill: Dr Contract costs – subcontract / Cr Accounts payable
Retention A supplier credit note: the retention moves to Retention payable (subcontractors)
Deductions A supplier credit note that reduces the subcontract cost

The subcontractor's balance in Purchasing is then the net you owe, paid there like any supplier. A draft bill can be deleted; Print gives the bill for signature.

Release retention on the work order (all retention held by default) makes a payable charge in Purchasing so you can pay it.