What’s in the register
| Column | What it holds |
|---|---|
name | The contractor’s legal name |
abn | Its ABN (Australia) or NZBN (New Zealand), if you keep it |
country | AU or NZ |
category | Contractors, Facilities or Services |
site | The site or building the work is at |
contact_name | Who sends you the certificate |
email | Their email address |
phone | Their mobile, as +61 or +64 and the number |
document | Public liability, workers compensation, professional indemnity… |
insurer | The insurer named on the certificate |
policy_number | The policy number |
sum_insured | The limit of liability or sum insured |
expiry_date | The date the period of insurance ends |
A certificate of currency register is a list of every insurance certificate your contractors have given you, one row per policy, with the date each one ends. It answers two questions quickly: who is covered today, and whose cover ends next.
What should each row record?
One row per policy, not per contractor: a plumber with public liability and workers compensation takes two rows. Record the contractor’s legal name as it appears on the certificate, the insurer, the policy number, the limit of liability or sum insured, and the date the period of insurance ends. Each column has a short name you can sort and filter by in Excel or Google Sheets, and the example rows show the format; replace them with your own.
Which certificates do principals usually ask trades for?
- Public liability, usually with a minimum limit set in your contract.
- Workers compensation, where the contractor employs workers and the law where the work is done requires it.
- Professional indemnity, for trades that design or advise.
- Motor vehicle insurance, for contractors who drive on your sites.
How do I keep the dates current?
Sort by expiry_date and look at the next 30 days every week. Ask for the renewal before the date, not after: a certificate only shows cover on the day it was issued, so the day the period of insurance ends is the day you need a new one. When the new certificate arrives, update the row and keep the old certificate on file, so you can show what was in force on a past date.
Can I check the dates without a calendar?
Yes. Vendarity’s free expiry check reads this register in your browser, with no upload and no sign-up, and lists what has expired, what expires today and what expires in the next 14, 30, 60 or 90 days. The supplier columns are named as Vendarity’s supplier import names them, so if you sign up you can keep the list and add your contractors without matching columns.
General information, not legal or insurance advice: your contracts and the rules where the work is done decide which certificates you need.