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.

fx
ABCDEFGHI
1RefDateActivityProviderCPD areaHoursApproved hoursEvidenceNotes
2CPD-26-0112/02/2026Retirement income strategies (webinar)Langdon LearningTechnical competence3.03.0
3CPD-26-0203/03/2026Best interests duty and ongoing fee consents (workshop)Macrae Advice InstituteRegulatory compliance and consumer protection3.03.0
4CPD-26-0319/03/2026Ethics and the Code in practice (workshop)Macrae Advice InstituteProfessionalism and ethics3.03.0
5CPD-26-0422/04/2026Client care and practice2.02.0Attendance email onlyInsurer-run. Rohan confirmed it qualifies before approving it.
6CPD-26-0514/05/2026Professional reading: regulator and research publicationsSelf-directedGeneral0.0Reading list only
7CPD-26-0617/06/2026Insurance inside superannuation (webinar)Technical competence2.02.0Attendance email only
8CPD-26-0721/07/2026Conversations with clients after a market fall (workshop)Langdon LearningClient care and practice4.04.0
9CPD-26-0803/09/2026Adviser forum, Sydney5.55.5Program onlySame event as NMB-26-02. Sessions ran 340 minutes; approved at 5.5 hours.
10CPD-26-0906/10/2026Harbourview (internal)Professionalism and ethics1.01.0Sign-in sheet
11CPD-26-1008/10/2026Death benefit nominations (course module)Langdon LearningTechnical competence3.03.0
12CPD-26-1129/10/2026Macrae Advice Institute1.01.0
13Total to 20/11/2026
14CPD-26-12 (booked)10/12/2026Ethics and conflicts of interest in practice (workshop)Macrae Advice InstituteProfessionalism and ethics6.06.0Not attended
Requirements

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

  1. Reads certificates, session records and the current log
  2. Updates the log and recalculates the hour totals
  3. 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

  1. 1
    The 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.

  2. 2
    Providers 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.

  3. 3
    The 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.

  4. 4
    The 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.

  5. 5
    The 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.

  6. 6
    The 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.

  7. 7
    The 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.

  8. 8
    The 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.

  9. 9
    The 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.

  10. 10
    The 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.

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 EdgeErmos Dominion
Where the document is processedProvider servers, generally offshore on personal plansYour instance in an Australian data centre; answers generated in AustraliaThe unit in your office
Who can read itProvider staff and systems, under policyYour staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothingYour staff only
Is it keptOn the provider’s termsKept on your instance; the provider is barred from retaining itStays on the unit
Can it train a modelOn consumer tiers, yesNo, by contractOnly 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?
Everything pasted or uploaded from the CPD log is sent to the AI company's servers and processed there to produce a reply. As at October 2026, whether a conversation on a personal plan (ChatGPT Free, Plus or Pro; Claude Free, Pro or Max) can be used to train the models depends on a setting each user controls. Business plans (ChatGPT Business and Enterprise, Claude Team and Enterprise) and the developer APIs sit under commercial terms, and OpenAI and Anthropic each say they do not train on that content by default (OpenAI, Anthropic). On either product, the thumbs up and thumbs down buttons can send a whole conversation back for training. This log names Nadia Reyes in its tab, lists Meridian Life and Southern Cross Super as providers of her training, and shows a shortfall of 5.0 hours in ethics six weeks before the CPD year ends.
Can we use ChatGPT or Claude for a CPD log if we remove the names?
Not safely, because a CPD log still points to one adviser and her record without a name. Removing names rarely makes a document anonymous. Information stays personal information while the person is reasonably identifiable, and the OAIC warns that information can be at risk of re-identification even when it has been de-identified or anonymised. Certificate references, two named product providers, a conflicts briefing led by the compliance manager and a booked six-hour ethics workshop narrow it to one practice. The Office of the Australian Information Commissioner (OAIC) recommends in its guidance on commercially available AI products that organisations do not enter personal information, and particularly sensitive information, into publicly available generative AI tools, because of the significant and complex privacy risks.
What travels with a CPD log if the spreadsheet is uploaded to ChatGPT or Claude?
The whole file leaves the practice rather than just the cells in view. An uploaded spreadsheet can carry other sheets, hidden columns, comments, tracked changes and file properties. This workbook has a CPD plan tab listing Nadia Reyes's areas to improve, and its SUM formula can point at other tabs or files. The OAIC's guidance also tells organisations to review carefully the terms and settings that will apply to their use of any AI product.
How can an advice practice use AI for a CPD log without sending it to ChatGPT or Claude?
Ermos is built so the document stays under your control. On the Dominion AI unit it is drafted inside your office and none of it is sent to an AI provider. On Ermos Edge your documents and index stay on your own instance in an Australian data centre, and only the question and the excerpts the user is permitted to see go to a named Australian provider that is contractually barred from keeping them or training any model on them. The year-end gap is worked out from the practice's own CPD records and policy. A person checks every total against the entries, and the licensee decides which activities it approves.
How many CPD hours must a financial adviser complete each year?
Under section 9 of the Corporations (Relevant Providers Continuing Professional Development Standard) Determination 2018, a relevant provider must complete at least 40 hours of qualifying activities in the licensee's CPD year, or 36 if working part-time for the whole year in special circumstances with the licensee's prior written consent. At least 5 hours each must be in three areas and 9 in professionalism and ethics, and 70 percent of the minimum must be licensee-approved. Provisional relevant providers do not have to meet the requirements.
How long must CPD records be kept?
Section 12 of the CPD Determination requires a relevant provider to keep complete and accurate records of each qualifying activity, the date, the hours, the evidence of completion and the progress of the CPD plan, for at least 7 years after they were made. It is satisfied if the responsible licensee keeps them. Separately, section 922HC of the Corporations Act requires the licensee to retain evidence of CPD for 12 months after the CPD year ends.
What happens if an adviser does not complete the CPD?
Section 921BA(4) of the Corporations Act requires a relevant provider to meet the CPD requirements during the licensee's CPD year, and a contravention is a restricted civil penalty provision. At the end of the CPD year, section 922HB requires the licensee to lodge a notice with ASIC for each relevant provider who did not comply, stating which CPD provision. The Act's notes say ASIC or a Financial Services and Credit Panel may take other action.

See Dominion answering from your own documents.

A demonstration takes 30 minutes, uses no client data, and comes with no obligation.

Book a demo