CPE Tracking Log Template for CPAs 2026: What to Record

The simplest way to survive a CPE audit is to keep a running log from the day your cycle starts. A good log records the date, the provider, the course title, the hours, the subject area, the delivery method and where the certificate is stored, and it shows a running total against each requirement. Boards differ on how long you must keep the underlying proof: in the state guides we have published, Arizona says three years, California four, Texas and New Jersey five, Illinois and Kansas six. This guide gives a template you can copy into a spreadsheet, explains each column, and shows how to adapt it to the rules in your state. It is a working tool, not legal advice; confirm record-keeping rules with your board.

At a glance

Why a log beats a folder of certificates

A folder of certificates proves you attended. A log shows that you have met every requirement, which is what a board really wants to see. It lets you total hours by category, spot a shortfall months before renewal, and produce a clean report if you are audited. Our guide to what boards ask for in a CPE audit describes what boards ask for in an audit; the log is how you answer quickly.

The columns to keep

A practical template has ten columns: course date; provider or sponsor name; course title; field of study (for example accounting and auditing, taxation, ethics, behavioural, non-technical); delivery method (group live, self-study, webinar, teaching, authoring); hours or credits claimed; the basis of that count (for example 50-minute hour or half-hour increments); whether the provider is on the list your board accepts; where the certificate is stored; and a running total. Add a status column to flag courses awaiting a certificate.

Add the category totals

Most boards require minimums in particular categories, such as ethics or accounting and auditing, and some cap others, such as self-study or teaching. Put a small summary block at the top of the sheet that shows each requirement, how many hours you have, and how many remain. Our guides to self-study rules by state and carryover rules by state show where caps and carryover apply.

Count hours the way your board does

Boards count differently. Some use a 50-minute hour, some allow half-hour increments, and some convert minutes. Record the unit your board uses and the board's source for it, rather than trusting the number on the certificate. See our guide to how CPE credits are counted for the common counting rules.

How long to keep proof

Retention periods vary. Arizona says three years, California four years after the end of the renewal period, Texas the five most recent reporting periods, New Jersey five years, and Kansas and Illinois six. The US Virgin Islands rules say five years, although one Board form appears to say three, so keep five. If you hold more than one licence, follow the longest. Store certificates as PDFs in a folder named by cycle, and back them up.

Template layout you can copy

Create a sheet with the ten columns above, one row per course, and sort by date. Freeze the header row. Add a second tab named Summary with one row per requirement: required hours, completed hours, remaining hours and a formula for each. Add a third tab named Licences if you hold several, with each licence's cycle end date, renewal date and reporting deadline. Our CPA mobility and CPE guide explains why separate tracking matters across states.

Mistakes to avoid

Do not log a course until you have the certificate. Do not round hours up. Do not mix up the reporting period and the licence period, which differ in some states. Do not forget mandatory courses, such as ethics or state-law courses, which often must be taken in a particular format. If you are short, act early; our guide to CPE deficiency and late reporting explains the options.

Frequently asked questions

What should a CPE log include?

The date, provider, course title, field of study, delivery method, hours claimed, the certificate location and a running total against each requirement.

How long should I keep CPE certificates?

It depends on your board: Arizona three years, California four, Texas and New Jersey five, Illinois and Kansas six. Follow the longest period if you hold several licences.

Can I use a spreadsheet?

Yes. A spreadsheet with one row per course, a summary tab and a licences tab is enough for most CPAs.

Do I need to log self-study differently?

Record the delivery method and, where your board requires it, the exam score, because many boards limit self-study and require proof of a passed exam.

Will the log replace the certificates?

No. The log is your index; the certificates are your proof.

Finding courses that count

Learnsignal publishes accounting, tax, audit, ethics and finance courses in its CPD and CPE library. Before you pay for any course, check the awarding body's own rules on what it accepts, and keep the certificate and the course details. Confirm record-keeping rules with your state board.

Source: Learnsignal state CPE guides for Arizona, California, Texas, New Jersey, Kansas, Illinois and the US Virgin Islands, each based on the board's rules and website, checked October 2026.