Free template · Australian and New Zealand wording

Certificate of currency register template

An Excel register for the certificates of currency your contractors and trades send you: who is insured, by whom, for how much and until when. Free to download, with no email address asked.

Excel workbook (.xlsx). Free to download, with no sign-up or email address.

What’s in the register

One row per policy. The example rows in the file are fictional.
ColumnWhat it holds
nameThe contractor’s legal name
abnIts ABN (Australia) or NZBN (New Zealand), if you keep it
countryAU or NZ
categoryContractors, Facilities or Services
siteThe site or building the work is at
contact_nameWho sends you the certificate
emailTheir email address
phoneTheir mobile, as +61 or +64 and the number
documentPublic liability, workers compensation, professional indemnity…
insurerThe insurer named on the certificate
policy_numberThe policy number
sum_insuredThe limit of liability or sum insured
expiry_dateThe 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.