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.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Holding | Asset class | Value ($) | Actual % | Target (range) % | Drift (pts) | Trade ($) | Notes |
| 2 | Halberd Australian Shares Fund | Australian shares | 52,0002 | 25 | 28 (23-33)5 | -3 | 0 | In range. |
| 3 | Hawkesby Global Shares Fund | Global shares | 49,0002 | 23 | 24 (19-29)5 | -1 | 0 | In range. |
| 4 | Tesla, Inc. shares3 | Global shares (one stock) | 38,0002 | 18 | 8 (3-13)5 | 10 | 0 | Over range. The clients chose on 21 October to hold against Nadia’s advice to sell. Do not trade. Recorded in the ROA of 23 October.3 |
| 5 | Jepson Property Securities Fund | Listed property | 12,0002 | 6 | 10 (7-13)5 | -4 | 9,1006 | Under range. Buy up to target. |
| 6 | Gallimore Fixed Interest Fund | Fixed interest | 38,0002 | 18 | 20 (15-25)5 | -2 | 0 | In range. |
| 7 | Platform cash | Cash | 22,0002 | 10 | 10 (5-15)5 | 0 | -9,1006 | Funds the property buy. Falls to 12,900. |
| 8 | Total | 211,0002 | 100 | 100 | 0 | 0 | ||
| 9 | Growth assets | Rows 2 to 5 | 151,000 | 72 | 70 (65-75) | 2 | Tesla counted as growth. | |
| 10 | Defensive assets | Rows 6 and 7 | 60,000 | 28 | 30 (25-35) | -2 | ||
| 11 | Basis | Prices at close on Friday 13 November 2026, from the platform export. Draft only: no trade without the clients’ instruction after advice is given. No discretionary authority.7 | ||||||
| 12 | Not in this sheet | Tom’s redundancy payment (about $85,000, expected in December) is not counted. The ROA sends it to the offset account.8 | ||||||
| 13 | Account | Platform account 0000 4417, held jointly2 |
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
- Reads the holdings export and recorded targets
- Builds the comparison in your worksheet layout
- 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
- 1The 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.
Frontier Models (ChatGPT, Claude) Two named clients 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 Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 2The 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.
Frontier Models (ChatGPT, Claude) Every holding, every value and the platform account 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 Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 3A 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.
Frontier Models (ChatGPT, Claude) The record of a client-directed decision 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 Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 4The 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.
Frontier Models (ChatGPT, Claude) A rounding formula with no data in it; safe to share Ermos Edge Nothing to protect in a rounding formula Ermos Dominion Nothing to protect in a rounding formula Use case Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 5The 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.
Frontier Models (ChatGPT, Claude) The clients’ target allocation transmitted Ermos Edge Stays on your instance in Australia; whether the targets still suit the clients is the adviser’s call Ermos Dominion Stays on the unit; whether the targets still suit the clients is the adviser’s call Use case Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 6The 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.
Frontier Models (ChatGPT, Claude) Trades not yet advised transmitted before the clients have them Ermos Edge Stays on your instance in Australia; the trades still need the adviser’s judgement and the clients’ instruction Ermos Dominion Stays on the unit; the trades still need the adviser’s judgement and the clients’ instruction Use case Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 7The 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.
Frontier Models (ChatGPT, Claude) A generic procedure with a price date; low risk, depends on your policy Ermos Edge A procedure line; nothing to protect Ermos Dominion A procedure line; nothing to protect Use case Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 8A 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.
Frontier Models (ChatGPT, Claude) A confidential redundancy and the expected payout 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 Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. See the use case - 9The 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.
Frontier Models (ChatGPT, Claude) Other tabs travel with the file 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 Rebalancing worksheet builder. Builds a rebalancing worksheet comparing current holdings with target allocations, and notes client restrictions and pending items that affect any proposed change. 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 portfolio rebalancing spreadsheet?
Can we use ChatGPT or Claude for a portfolio rebalancing spreadsheet if we remove the names?
Is it safe to upload a rebalancing workbook to ChatGPT or Claude?
How can an advice practice use AI for a portfolio rebalancing spreadsheet without sending it to ChatGPT or Claude?
Is a rebalancing recommendation personal advice?
Is a sheet of holdings personal information?
Can an AI tool work out the drift and suggest the trades?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo