Financial Adviser CPD Log Spreadsheets: Use case and AI Confidentiality
An adviser who gives personal advice to retail clients on products such as superannuation and managed investments has to complete continuing professional development every year, and someone at the practice keeps the log that proves it. In most practices that is a spreadsheet of courses, hours and certificate references, updated by the compliance manager. When the year-end gap needs finding, the courses need sorting into the right areas or the entries need tidying, the CPD log is pasted into ChatGPT or Claude. It names the adviser, the insurer and super fund that ran some of her training, the hours in each area, the evidence on file and the shortfall six weeks before the year ends. This page marks every item in an invented CPD log and shows the same check run on Ermos inside the practice.
The CPD log
Kept by the compliance manager and updated after each activity. Section 921BA(4) of the Corporations Act requires a relevant provider authorised to give personal advice to retail clients on behalf of a licensee to meet the continuing professional development requirements set under section 921B during the licensee’s CPD year. The requirements are in the Minister’s CPD Determination of 2018, and section 922HC requires the licensee to retain evidence of the CPD for 12 months after the CPD year ends.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Ref | Date | Activity | Provider | CPD area | Hours | Approved hours | Evidence | Notes |
| 2 | CPD-26-01 | 12/02/2026 | Retirement income strategies (webinar) | Langdon Learning | Technical competence | 3.0 | 3.0 | Cert LL-26-02127 | |
| 3 | CPD-26-02 | 03/03/2026 | Best interests duty and ongoing fee consents (workshop) | Macrae Advice Institute | Regulatory compliance and consumer protection | 3.0 | 3.0 | Cert MA-26-03037 | |
| 4 | CPD-26-03 | 19/03/2026 | Ethics and the Code in practice (workshop) | Macrae Advice Institute | Professionalism and ethics | 3.0 | 3.0 | Cert MA-26-03197 | |
| 5 | CPD-26-04 | 22/04/2026 | Working with clients in vulnerable circumstances (webinar)3 | Meridian Life2 | Client care and practice | 2.0 | 2.0 | Attendance email only | Insurer-run. Rohan confirmed it qualifies before approving it. |
| 6 | CPD-26-05 | 14/05/2026 | Professional reading: regulator and research publications | Self-directed | General | 2.56 | 0.0 | Reading list only | Reading counts up to 4 hours a year. Not approved.6 |
| 7 | CPD-26-06 | 17/06/2026 | Insurance inside superannuation (webinar) | Meridian Life2 | Technical competence | 2.0 | 2.0 | Attendance email only | |
| 8 | CPD-26-07 | 21/07/2026 | Conversations with clients after a market fall (workshop) | Langdon Learning | Client care and practice | 4.0 | 4.0 | Cert LL-26-07217 | |
| 9 | CPD-26-08 | 03/09/2026 | Adviser forum, Sydney | Southern Cross Super2 | Technical competence5 | 5.5 | 5.5 | Program only | Same event as NMB-26-02. Sessions ran 340 minutes; approved at 5.5 hours. |
| 10 | CPD-26-09 | 06/10/2026 | Conflicts and benefits briefing led by R. Mistry3 | Harbourview (internal) | Professionalism and ethics | 1.0 | 1.0 | Sign-in sheet | |
| 11 | CPD-26-10 | 08/10/2026 | Death benefit nominations (course module) | Langdon Learning | Technical competence | 3.0 | 3.0 | Cert LL-26-10087 | |
| 12 | CPD-26-11 | 29/10/2026 | Breach reporting update (webinar)3 | Macrae Advice Institute | Regulatory compliance and consumer protection5 | 1.0 | 1.0 | Cert MA-26-10297 | |
| 13 | Total to 20/11/2026 | 30.04 | 27.54 | Short: 10.0 hours in all, 5.0 in ethics, 1.0 in regulatory, 0.5 approved.9 | |||||
| 14 | CPD-26-12 (booked) | 10/12/2026 | Ethics and conflicts of interest in practice (workshop) | Macrae Advice Institute | Professionalism and ethics | 6.0 | 6.0 | Not attended | Do not count until attended. After it: 36.0 hours and 10.0 in ethics. Still 1.0 regulatory and 3.0 in any area to find.9 |
An invented CPD log for a CPD year of 1 January to 31 December 2026. The names, hours and dates are made up, Langdon Learning and Macrae Advice Institute are invented businesses, the certificate references are placeholders, and the hours are not a view on what counts. Hover or tap any highlighted item for the analysis; the full list is below.
CPD log reconciler
An Agent+ that keeps the CPD log in order for the compliance manager. It reads the certificates, session records and provider emails the practice holds, updates the log in your layout, and checks the totals and categories against the requirements you supply.
What it does
- Reads certificates, session records and the current log
- Updates the log and recalculates the hour totals
- Flags missing evidence and sessions not yet attended
What stays with your people. The compliance manager confirms each entry and its category. The agent updates the sheet; it does not decide what counts.
An Agent+ is built once and anyone in the practice can run it. It works from your own documents and runs on Ermos Dominion, the AI unit in your office, or on Ermos Edge, your own instance in an Australian data centre.
What leaves the practice
- 1The adviser, in the tab name
One named adviser and her training record. Training is one of the examples of personal information relating to an employee’s employment in the Privacy Act’s definition of an employee record, and section 7B(3) exempts an employer’s act or practice directly related to the employment relationship and an employee record it holds, so whether the Act governs this log in the practice’s hands is a question for its adviser. The name still ties every hour below to a person who must meet the requirement under section 921BA(4) of the Corporations Act. Privacy Act guide.
Frontier Models (ChatGPT, Claude) An adviser’s name and training record transmitted to the provider, generally offshore on personal plans Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 2Providers that are also product providers
An insurer and a super fund whose products the practice recommends are running some of the training, and the forum is the same event as an entry on the gifts and benefits register. Under section 8(2) of the CPD Determination a licensee must not approve an activity unless satisfied it is a qualifying CPD activity, and one test in section 7(1)(c) is that it primarily deals with matters related to the provision of financial product advice, financial advice services and financial advice business. A provider’s name beside an adviser’s hours shows how closely the two trade.
Frontier Models (ChatGPT, Claude) Two product providers named beside the adviser’s hours transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 3The course titles
What the adviser has been learning this year: clients in vulnerable circumstances, a conflicts and benefits briefing, a breach reporting update. Each title is harmless alone. Together they show what the practice has been dealing with, and section 6 of the Determination asks each relevant provider to plan for the year by identifying areas for improvement in her competence, knowledge and skills.
Frontier Models (ChatGPT, Claude) Titles alone are low risk; together they show what the practice is dealing with Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 4The hours and the totals
Hours claimed, hours the licensee approved and the totals. Section 9(1) of the Determination sets a minimum of 40 hours of qualifying activities in a CPD year, and section 9(3) requires at least 70 percent of that minimum (28 hours) to be spent on activities the licensee has approved. Section 8(3) says the most that can be counted for an approved activity is the number of hours in the approval. The totals are arithmetic, and a person has to check them against the entries.
Frontier Models (ChatGPT, Claude) The adviser’s hours and totals transmitted with her name Ermos Edge Stays on your instance in Australia; a person still checks every total against the entries Ermos Dominion Stays on the unit; a person still checks every total against the entries Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 5The CPD area for each activity
Section 9(2) of the Determination sets minimums of 5 hours each in technical competence, client care and practice, and regulatory compliance and consumer protection, and 9 hours in professionalism and ethics. Section 7(3) lets an activity that fits more than one area count in the area it predominantly relates to, with no double counting. Harbourview’s CPD policy has to describe how it assesses and approves activities and attributes hours (section 5(4)(c)(iii)), so someone at the practice has to judge which area each activity predominantly relates to.
Frontier Models (ChatGPT, Claude) The area names are public; the practice’s allocation for each activity is not Ermos Edge Stays on your instance in Australia; the practice still decides which area each activity counts in Ermos Dominion Stays on the unit; the practice still decides which area each activity counts in Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 6The reading line
Self-directed reading with no certificate. Section 9(4)(a) of the Determination counts no more than 4 hours of professional or technical reading in a CPD year, and section 7(2) says the requirement for a qualified leader does not apply to reading. The row shows how much of the allowance is used and what the adviser reads.
Frontier Models (ChatGPT, Claude) The 4 hour limit is public; the adviser’s reading list is not Ermos Edge Stays on your instance in Australia; the cap is applied by a person Ermos Dominion Stays on the unit; the cap is applied by a person Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 7The evidence column
Certificate numbers, attendance emails and a sign-in sheet. Section 12(1) of the Determination requires a relevant provider to make and keep complete and accurate records, including evidence of completion and the outcomes, which her licensee can keep for her under section 12(2), and section 12(4) says the records are kept for at least 7 years after they were made. Section 922HC of the Corporations Act separately requires the licensee to retain the evidence for 12 months after the CPD year ends, and failing to is an offence.
Frontier Models (ChatGPT, Claude) Certificate numbers and attendance references transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 8The formula
A SUM of the approved-hours column. It holds no client or adviser data of its own. A formula can also point at other tabs or files.
Frontier Models (ChatGPT, Claude) A SUM with no data in it; safe to share Ermos Edge Formula text only; nothing to protect Ermos Dominion Formula text only; nothing to protect Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 9The shortfall and the booked session
The adviser’s compliance position six weeks before the CPD year ends, and a session booked but not yet attended. Section 922HB requires the licensee to lodge a notice with ASIC at the end of its CPD year for a relevant provider who did not comply with a CPD provision during it, stating which provision, and section 922N lets the licensee ask the provider for the information. Section 912A(1)(f) also requires a licensee to ensure its representatives are adequately trained, including by complying with the CPD provisions. A booked session is not completed CPD, and a tool that adds the column will count it.
Frontier Models (ChatGPT, Claude) The adviser’s shortfall transmitted before the year ends Ermos Edge Stays on your instance in Australia; whether a notice to ASIC is needed stays with the licensee Ermos Dominion Stays on the unit; whether a notice to ASIC is needed stays with the licensee Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case - 10The other tabs
A tab named for the CPD plan. Section 6 of the Determination requires each relevant provider to prepare a CPD plan for each CPD year, generally before it starts, identifying areas for improvement in her competence, knowledge and skills and the activities she will complete. A spreadsheet file can carry other sheets that stay out of sight in the grid and travel with the file.
Frontier Models (ChatGPT, Claude) Other tabs travel with the file, including the plan of areas to improve Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case CPD log reconciler. Builds the CPD log from certificates and activity records, and flags totals that do not add up, unattended sessions and entries missing evidence. See the use case
What happens in Frontier Models (ChatGPT, Claude)
- The whole document is transmitted to the provider’s servers. On personal plans the user cannot choose where it is stored or processed, and for the major providers that has generally meant outside Australia, under that country’s legal process. Some business plans offer storage in Australia, but the provider still receives the content.
- On consumer tiers, prompts can be retained and used to train future models.
- The provider’s staff and systems can reach the content under the provider’s own policies.
- Once sent, the practice no longer controls it. Retention and deletion happen on the provider’s terms.
The same document on Ermos
Ermos Dominion
The document is drafted on a unit in your office, from your own templates and the client file. Every marked item stays on the unit, which keeps working with the internet switched off. Nothing in it is transmitted to an AI provider, so there is no disclosure to analyse: the confidentiality work is the same as for your file server.
Ermos Edge
Your documents, the index and your access boundaries stay on your own instance in an Australian data centre. When a staff member asks for this draft, only their question and the excerpts they are permitted to see go to a named Australian provider, who is contractually barred from keeping the content or training any model on it. Nothing is processed outside Australia.
| Frontier Models (ChatGPT, Claude) | Ermos Edge | Ermos Dominion | |
|---|---|---|---|
| Where the document is processed | Provider servers, generally offshore on personal plans | Your instance in an Australian data centre; answers generated in Australia | The unit in your office |
| Who can read it | Provider staff and systems, under policy | Your staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothing | Your staff only |
| Is it kept | On the provider’s terms | Kept on your instance; the provider is barred from retaining it | Stays on the unit |
| Can it train a model | On consumer tiers, yes | No, by contract | Only your own unit learns from it, on your hardware |
Part of Use cases in financial advice practices.
Common questions
Do ChatGPT and Claude use the information in a CPD log?
Can we use ChatGPT or Claude for a CPD log if we remove the names?
What travels with a CPD log if the spreadsheet is uploaded to ChatGPT or Claude?
How can an advice practice use AI for a CPD log without sending it to ChatGPT or Claude?
How many CPD hours must a financial adviser complete each year?
How long must CPD records be kept?
What happens if an adviser does not complete the CPD?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo