Financial Adviser Portfolio Rebalancing Spreadsheets: Use case and AI Confidentiality

Advisers compare what a client actually holds with the allocation they agreed, mark the holdings that have drifted out of range and draft the trades that would bring them back. The sheet is built from a platform export, so staff paste it into ChatGPT or Claude to calculate the drift or suggest trades. A portfolio rebalancing spreadsheet carries the clients’ names, every holding and its value, targets that follow from their risk profiles, a position held against advice, draft trades and a note about a confidential redundancy. This page marks every item in an invented sheet and shows the same drift check run on Ermos inside the practice.

The portfolio rebalancing spreadsheet

Prepared from a platform export, usually at a review or when markets move, to compare actual holdings with the clients’ target allocation and to draft trades. A recommendation to buy or sell given with the clients’ circumstances considered is personal advice (section 766B(3) of the Corporations Act). Division 3 of Part 7.7 applies to personal advice provided to a retail client (section 944A), and section 946A(1) requires a Statement of Advice, subject to sections 946AA and 946B.

fx
ABCDEFGH
1HoldingAsset classValue ($)Actual %Target (range) %Drift (pts)Trade ($)Notes
2Halberd Australian Shares FundAustralian shares25-30In range.
3Hawkesby Global Shares FundGlobal shares23-10In range.
4Global shares (one stock)18100
5Jepson Property Securities FundListed property6-4Under range. Buy up to target.
6Gallimore Fixed Interest FundFixed interest18-20In range.
7Platform cashCash100Funds the property buy. Falls to 12,900.
8Total10010000
9Growth assetsRows 2 to 5151,0007270 (65-75)2Tesla counted as growth.
10Defensive assetsRows 6 and 760,0002830 (25-35)-2
11Basis
12Not in this sheet
13Account
Notes

An invented rebalancing sheet. The names, holdings and amounts are made up, the funds are invented, and the account number is a placeholder. Nothing in it is advice. Hover or tap any highlighted item for the analysis; the full list is below.

Rebalancing worksheet builder

An Agent+ that prepares the worksheet for a review. It reads the holdings export and the client's recorded targets and restrictions, builds the comparison in your layout, and lists drift and notes for the adviser. It sets out the numbers; it proposes no trade.

What it does

  1. Reads the holdings export and recorded targets
  2. Builds the comparison in your worksheet layout
  3. Notes client restrictions and unadvised items

What stays with your people. The adviser decides any change and gives the advice. The paraplanner checks the figures against the source export.

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 clients, in the tab names

    Two named people in the title of the workbook. Personal information under the Privacy Act where the Act applies to the practice, and the key that ties every holding below to real people. Privacy Act guide.

  2. 2
    The holdings, the values and the platform account

    The whole non-super portfolio: what the clients own, how much of it, and the account it sits in. A client’s financial position, and what a scammer or an impostor would build from. APP 11.1 asks the practice to take reasonable steps to protect personal information from misuse, interference and loss, and from unauthorised access, modification or disclosure. Privacy Act guide.

  3. 3
    A position held against advice

    One shares holding well over its range, with the note that the clients chose to keep it against the adviser’s recommendation. Standard 8 of the Code of Ethics asks for client records that are complete and accurate, and this is the record of the decision. Section 961G asks that advice be appropriate to the client, and the ROA says what was advised and what the clients decided.

  4. 4
    The formula

    A rounded percentage of one cell over a total. It holds no client data of its own. Formulas can also point at other tabs or workbooks.

  5. 5
    The targets and the ranges

    The allocation agreed for these clients, which follows from the risk profiles on the fact find. Section 961B(2)(a) and (b) describe the provider identifying the client’s objectives, financial situation and needs, and the targets are the result for one household. The adviser’s strategy, written for these clients. Privacy Act guide.

  6. 6
    The draft trades

    A buy the adviser has not yet advised, and the cash that pays for it. A recommendation to trade, given with the clients’ circumstances considered, is personal advice (section 766B(3)), and Division 3 of Part 7.7 (section 944A) and section 946A(1) then apply for a retail client. A pasted sheet gives the recommendation away before the clients have it.

  7. 7
    The basis note

    The price date and the practice’s rule that nothing is traded without the clients’ instruction and that the practice has no discretionary authority. A statement of how the practice works, with a date.

  8. 8
    A confidential redundancy

    That a client’s employer is about to end his job, the expected payout and where it is going. Employment information the client shared in confidence. Privacy Act guide.

  9. 9
    The other tabs

    Tabs named for each client’s super stay out of sight in the grid and travel with the file. A workbook can hold the whole household as well as the sheet on screen.

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 portfolio rebalancing spreadsheet?
Everything pasted or uploaded from a rebalancing sheet 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 sheet lists every holding and value for Tom and Lucy Harrington, a Tesla position held against advice and a confidential redundancy.
Can we use ChatGPT or Claude for a portfolio rebalancing spreadsheet if we remove the names?
Not safely, because the holdings still describe one household. 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. A joint platform account, six holdings with exact values, one share the clients would not sell and a redundancy payment expected in December point to one couple. 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.
Is it safe to upload a rebalancing workbook to ChatGPT or Claude?
An uploaded workbook leaves the practice as a whole file, which can carry other sheets, hidden columns, comments, tracked changes and file properties. The OAIC's guidance also tells organisations to review carefully the terms and settings that will apply to their use of any AI product. Here the Tom super and Lucy super tabs would travel with the joint non-super sheet, although they stay out of sight in the grid.
How can an advice practice use AI for a portfolio rebalancing spreadsheet 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 drift check is run from the platform export and the practice's own template. The adviser checks every total against the export and decides each trade, and nothing is traded without the clients' instruction.
Is a rebalancing recommendation personal advice?
Financial product advice is personal advice if the provider has considered one or more of the person's objectives, financial situation and needs, or a reasonable person might expect it to have (section 766B(3) of the Corporations Act). A trade recommended from a client's target allocation is likely to meet that test. Division 3 of Part 7.7 applies to personal advice to a retail client, and section 946A(1) requires a Statement of Advice, subject to sections 946AA and 946B.
Is a sheet of holdings personal information?
It is when it carries names, account numbers and what people own. Where the Privacy Act applies to the practice, APP 11.1 requires reasonable steps to protect it from misuse, interference and loss and from unauthorised access, modification or disclosure. Sending it to an overseas AI provider also engages APP 8.1, which asks the practice to take reasonable steps to ensure the overseas recipient does not breach the APPs.
Can an AI tool work out the drift and suggest the trades?
It can do the arithmetic, and the totals can be checked against the platform export. The judgement is the adviser's. Section 961G requires advice to be appropriate to the client, and the Code of Ethics says the duty of competence is ultimately personal and cannot be outsourced. On an Ermos unit the sheet is checked on your own hardware, and every trade still needs the adviser's decision.

See Dominion answering from your own documents.

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

Book a demo