Compliance & Certification Cost Tracker Spreadsheet
This spreadsheet adds up what holding your certificates actually costs, including the three parts that never arrive as an invoice.
Everybody knows what the certificates cost, because the renewal invoices arrive every year and somebody signs them off. Almost nobody knows what holding them costs, because getting ready, the days the work stopped and what the auditor found are nowhere on that invoice. This file writes all four down and then asks how much of the work each certificate has to win to be worth keeping.
What is in it
- Nine linked tabs, from Start Here through to a one-screen Overview.
- The Work — one row per thing you did: six things typed, the rest worked out on the row.
- By Certificate — what each one costs all in, and what work it gated.
- Renewal Year — month by month, so the lumps are not a surprise twice.
- What It Must Win — the share of gated work you would have to keep for a certificate to pay for itself.
- Setup — seven numbers and two lists; change a rate and the whole year reprices.
Who it is for
Anywhere a business holds standards, schemes, licences, registers or mandatory training: a contractor, a manufacturer, a food producer, a haulier, a care provider, a laboratory, an agency sitting on a public buyer framework.
The worked example
The worked year covers twelve certificates and 170 entries. The renewal notices said $40,090. Once everything else was written down — $49,485 of corrective actions, re-inspections and courses, 1,160 of your own hours worth $45,249, and 14.5 days of stopped work worth $34,075 — the whole bill came to $168,899, which is 4.21 times the fees and 2.5% of turnover.
Getting ready was 452 hours on its own, and six audit days stopped more work than the six cheapest certificates cost put together. On the certificate this business argued about most, What It Must Win puts the break-even at 83.1% of the gated work — far higher than anyone guesses. Two of the twelve gated nothing anybody asked to see all year, at $9,130, and April alone cost $33,798 because two renewals shared a month.
How it works
Compatible with Microsoft Excel 2016 or newer on Windows or Mac, Google Sheets, and LibreOffice. No macros, no add-ons, no account to create, nothing to install.
The download has two workbooks: one with the example above already filled in, so you can see what every column expects, and the same file completely blank for your own figures. A plain-English guide comes as a PDF. Buy it on Etsy — $9
Sold through my Etsy shop, ThePlainLedger, so the download, the payment and the buyer protection are all handled by Etsy.
A look inside the file
Questions people actually ask
How do I work out what a certificate actually costs us to hold?
You add four things: the renewal fee, everything else you paid because of it, your own hours, and the days the work stopped. In the worked year the renewal fees were $40,090 and the whole bill was $168,899, which is 4.21 times the fees and 2.5% of turnover. Three of those four never arrive as an invoice, which is why most businesses quote a quarter of the real number.
Is this only for construction, and is it worth it if we hold only two certificates?
No, it works anywhere a business holds standards, schemes, licences, registers or mandatory training: a manufacturer, a food producer, a haulier, a care provider, a laboratory, an agency on a public buyer framework. With two certificates it takes ten minutes to fill in and the answer is still worth having. There are fourteen slots and you are not obliged to use them.
We do not record the hours anywhere, and we do not know what work a certificate won us.
An honest half-hour estimate per entry, put in as you go, beats a precise number that does not exist, and it only has to be consistent between certificates to do its job. For the work a certificate gated, ask whoever fills in the prequalification forms; they know which jobs asked to see what, and a defensible estimate is all the last two tabs need.
Do I need Excel, or will it open in Google Sheets?
Both work, and LibreOffice too. It is built as .xlsx for Excel 2016 or newer on Windows or Mac, and imports into Google Sheets through File then Import then Upload. No macros, no add-ons, no account to create and no subscription.
Some of ours are legally required, and does the file hold personal data?
Legally required certificates belong in the file so their cost is counted, but not on the What It Must Win tab, which is only for the ones that are a commercial choice. The file holds no personal data: certificates, activities and amounts, with no names of individuals. It is not a compliance management system or an audit tool and it will not tell you whether you are compliant, only what being compliant has cost and what it has won.
Need it built around your business?
This file assumes certificates that gate work you bid for, renewed on an annual cycle. If yours sit differently — licences that are legally mandatory rather than a commercial choice, per-site or per-vehicle registrations that multiply with the fleet, product approvals renewed per SKU rather than per company, or a scheme audited on a three-year cycle with surveillance visits in between — I can build the same arithmetic around the way your obligations actually renew.
All other templates are listed on the Excel & Google Sheets Templates page.