The scramble every accounting firm knows
Every small CPA firm in Canada tracks CPD hours the same way: a shared Google Sheet or an Excel workbook on the firm's OneDrive. One tab per employee, twenty rows of dates and activities, a running total at the top, and a manager who is supposed to check it once a quarter. The system works well enough through the middle of the cycle. Then, six or seven weeks before someone's renewal window closes, a partner realises the sheet has not been touched since April and the scramble begins.
The scramble looks the same at every firm. Someone sends around a Slack message asking everyone to update their tab. Half the team updates it. The other half asks whether the December webinar counted as verifiable or unverifiable. A new hire from another firm asks whether their prior-firm CPD carries over, because their old sheet had different categories. A partner starts pulling registration confirmations from three separate email accounts to prove verifiability. The firm's admin creates a fresh tab for the P.Eng. staffer who joined in March, because the CPA-flavoured template does not work for engineers.
By the time the renewal week arrives, the firm has completed the CPD. The paperwork trail is a mess. Nobody would want a Ministry of Labour or CPA Ontario examiner to open the file.
Why the spreadsheet fails structurally, not just operationally
The spreadsheet works while a firm's staff all report to the same regulator on the same cycle. It stops working the moment the firm hires anyone whose CPD rules are different.
CPA Ontario runs an annual cycle. Twenty hours per calendar year, ten verifiable, resets January 1. Four hours of ethics content required every three years. This is the cycle most Canadian CPA firms build their spreadsheet around, because Ontario is the largest CPA population and the annual reset is the simplest structure to encode.
CPA Alberta runs a rolling three-year cycle. One hundred and twenty hours across any consecutive 36-month window, with 60 verifiable, and no single year below 20. There is no January 1 reset. Every day the window slides forward by one day. A spreadsheet built around CPA Ontario's annual reset will silently miscount an Alberta member's hours from the moment they are hired.
The Law Society of Ontario runs an annual cycle for lawyers: 12 hours, all verifiable, of which 3 must be professionalism content and 1 of the 3 must be equity, diversity, and inclusion. If your firm employs a lawyer, or a CPA who is dually licensed, the spreadsheet needs a whole new column set.
Professional Engineers Ontario runs a two-year Continuing Knowledge Program, 30 hours, with no verifiable minimum but with strong recommendations. Different tab structure, different cycle length.
Engineers and Geoscientists BC runs three years, 60 hours. APEGA runs three years, 240 hours across six CPD categories.
A spreadsheet cannot encode five different regulators' rules and still be intelligible. Firms end up either forcing everyone into the same tab structure and quietly miscounting, or maintaining five parallel sheets and losing track of who is on which one. Both failure modes end up in the same place at renewal week.
What firm-wide CPD tracking software actually does
Software solves this by encoding each regulator's rules once and running the hours-in-cycle math per employee automatically. When a CPA Ontario member logs a four-hour webinar, the system knows the annual target is 20, subtracts the four, notes that the webinar was verifiable and marks it toward the ten-hour verifiable minimum. When a CPA Alberta member logs the same webinar three days later, the system knows the target is 120 over 36 months, updates the rolling total, and flags whether the member is still on pace for the 20-hour annual floor.
Every regulator's schedule becomes a data structure the system understands, not a mental model each employee has to hold themselves. New hire from a different province, or from a different profession, is a matter of picking a regulator from a dropdown at the point of onboarding. The rules follow.
A good CPD system also handles the two things spreadsheets never handle well:
Verifiability categorisation. Every logged activity carries a verifiability flag (verifiable, unverifiable, or ethics). The system computes both the total and the verifiable subtotal, and shows whether the verifiable minimum is met independently of whether the overall target is met. This is the check that most spreadsheets miss until renewal, because it is easy to hit the total by logging journal reading and still fall short of the verifiable component.
Cross-cycle carryover rules. Regulators have different rules about what to do with excess hours logged in one cycle. CPA Ontario permits no carryover. CPA Alberta's rolling window structurally carries hours until they fall off. Federal engineers' bodies have different rules again. A spreadsheet cannot enforce these rules; software encodes them.
The firm-wide view partners actually need
The individual member's hours-in-cycle badge is the smallest unit of what CPD software provides. The unit that matters to a firm's managing partner is the aggregate view: who is on track, who is behind, who is at the ethics-hour threshold, and who has less than a month left in their cycle.
A firm with fourteen employees across three regulators can be shown as a single grid. Green rows mean the employee is on pace or already complete. Amber rows mean the employee is behind pace for the current point in their cycle. Red rows mean the employee will not complete the cycle at their current activity rate. The grid updates the moment any employee logs a new activity. A partner can look at the grid for the first time in six months and see, in five seconds, whether the firm is going to have a problem at renewal season.
That five-second read is the thing the spreadsheet cannot give you regardless of how well maintained it is.
What CPA firms should actually do
If your firm has fewer than five people who track CPD, and everyone reports to the same regulator on the same cycle, keep using the spreadsheet. It will work until something changes. Write down the moment when it stops working (a new hire outside your primary regulator, the addition of an ethics-hour requirement, or the arrival of a dually-licensed employee) and treat that as the trigger for moving off the sheet.
If your firm has ten or more people, or crosses regulators, or has ever missed a verifiable-hour cutoff, replace the spreadsheet now. The migration is not complicated. Every existing activity in the sheet transcribes into a logged activity in the new system with an activity date, hours, verifiability flag, and category. The rules for each regulator apply automatically.
The Hibiscus HR CPD Hours Calculator shows the hours-in-cycle math for a single employee under any of 16 Canadian regulators. The full Hibiscus HR product does the same math for every employee at your firm simultaneously and surfaces the aggregate grid so the partner group can see the firm's CPD posture at a glance. No spreadsheet. No renewal-season scramble.
Because a CPA firm's whole reason to exist is that partners protect their designations. The designation is the licence to practise. Keeping every member of the firm on the right side of their regulator's clock should not be something the firm rediscovers six weeks before renewal.