Law Firm Property Pool Spreadsheets: Use case and AI Confidentiality
The property pool is the working spreadsheet of a family law matter: every asset and debt of both parties, the client’s valuation beside the other side’s, the contribution history and a column of the solicitor’s own notes. The notes are candid, because the sheet is how the partner decides what to recommend. Staff paste it into ChatGPT or Claude to check the totals or test a percentage split. This page marks every cell in the pool that rule 9, privilege and the Court’s own rules bear on, and shows how the same sheet is checked on Ermos inside the firm.
The property pool spreadsheet
Built after both Financial Statements are exchanged, and used to advise on a settlement or prepare for a conciliation conference.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Ref | Pool: Soto & Lindahl, SYC 2026/011841 | Held by | Our figure | Per his Financial Statement4 | Contribution note5 | Internal note7 |
| 2 | A1 | Home, 12 Bayview Terrace, Coogee2 | MS | 2,100,000.00 | 2,250,000.002 | Bought Aug 2021. $310,000 deposit from MS’s father’s estate. CL paid $42,000 off the mortgage 2022 to 2025.5 | Inheritance went through the joint account for four months. Tracing is weak. Counsel to advise.7 |
| 3 | A2 | Superannuation (MS) | MS | 412,000.00 | 412,000.00 | Accrued mostly during the marriage | |
| 4 | A3 | Superannuation (CL) | CL | 186,500.00 | 184,200.00 | $61,000 of this pre-dates the marriage5 | |
| 5 | A4 | Car, 2019 Mazda CX-5 | MS | 21,500.00 | 24,000.00 | ||
| 6 | A5 | Ute and tools | CL | 60,000.00 | 49,000.00 | His tools figure looks low. Ask for insurance schedule. | |
| 7 | A6 | Savings account | MS | 38,400.00 | 38,400.00 | ||
| 8 | A7 | Joint account | Both | 14,200.00 | 14,200.00 | ||
| 9 | A8 | Bank accounts (CL)3 | CL | 22,500.00 | 9,800.00 | Statements show $31,000 to his mother on 14 Feb 2026, five weeks before separation. Did MS know? Rule 6.06(2)(g).3 | |
| 10 | C1 | Claim v Greystone (contingent) | MS | not valued | not disclosed | Conciliation 13 Nov. Range $126,000 to $168,000. Likely a future resource, s 79(5).6 | |
| 11 | L1 | Mortgage9 | MS | (640,000.00) | (640,000.00) | ||
| 12 | L2 | Credit card (MS) | MS | (7,300.00) | (7,300.00) | ||
| 13 | L3 | ATO debt (CL)9 | CL | 0.00 | (12,000.00) | We dispute it. No assessment produced. | |
| 14 | Net pool | 2,207,800.0010 | 2,322,300.00 | MS will accept 55/45 in her favour if he drops any claim on the home. EV thinks 60/40 is open.8 |
An invented spreadsheet. Figures are invented and consistent with the Financial Statement page; the contingent claim is not in the totals. Hover or tap any highlighted item for the analysis; the full list is below.
Property pool reconciler
An Agent+ that builds the property pool spreadsheet from both parties' exchanged Financial Statements and the client's own instructions. It lists each asset, liability, contribution and transfer, notes where the two sets of figures differ, and sets the client's acceptable split beside them for the solicitor to work from.
What it does
- Reads both Financial Statements and the client's instructions
- Lists assets, liabilities, contributions and transfers side by side
- Flags differences between the parties' figures for the solicitor
What stays with your people. The family lawyer checks every figure and decides what is put to the client and to the other side. The agent prepares the schedule only.
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 firm
- 1The parties and the file number
Names and a Federal Circuit and Family Court file number. With the matter identified, every figure below is tied to two living people and their children. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Two parties and a family court file identified on a third party’s servers 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 2The home and the competing valuations
The main asset, the client’s figure and the other side’s. Under section 79(3) of the Family Law Act the court identifies each party’s existing legal and equitable interests and liabilities, so the values are the case. Rule 9 confidentiality guide.
Frontier Models (ChatGPT, Claude) Both parties’ valuations of the home 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 3A possible disposal
A transfer of $31,000 to a relative five weeks before separation, from the other party’s own bank records. Rule 6.06(2)(g) lists disposals in the 12 months before separation, with an exception where the other party consented or knew. The note also records the firm’s doubt about what its own client knew. Legal privilege guide.
Frontier Models (ChatGPT, Claude) A possible disposal and the firm’s doubt 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 4The other party’s figures
Numbers taken from his Financial Statement and the documents served with it. Rule 6.04 says a person who receives a document in a proceeding under the Rules must use it for the purpose of the proceeding only, unless the court gives permission, and must not otherwise disclose its contents. Legal privilege guide.
Frontier Models (ChatGPT, Claude) Documents received in the proceeding used outside it Ermos Edge Leaves only inside a permitted excerpt, to a named Australian provider that keeps nothing; rule 6.04 still applies to the use of the documents Ermos Dominion Stays on the unit, for the proceeding; rule 6.04 still applies to the use of the documents Use case Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 5The contribution notes
Who put in what: an inheritance deposit, mortgage payments and super from before the marriage. Section 79(4) lists the contributions the court takes into account. The history of a family’s finances, and a deceased father’s estate. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A family’s contribution history and a deceased’s estate 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 6A claim not yet decided and its range
A conciliation date and a range of $126,000 to $168,000. It links two matters and reveals the client’s expectation in both. Legal privilege guide.
Frontier Models (ChatGPT, Claude) A pending claim and its range transmitted; on consumer tiers it can train future models 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 7The weak point and the notes column
That tracing the inheritance is weak, and a reminder to ask for an insurance schedule. A candid assessment, in a column labelled internal, and spreadsheet files can also carry hidden columns and comments that a paste of the visible cells does not show. Legal privilege guide.
Frontier Models (ChatGPT, Claude) The firm’s candid view of its weak point 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 8The split the client will accept
55/45 in her favour if he drops the home, and the partner’s view that 60/40 is open. The settlement authority, and the sentence that ends the negotiation if the other side sees it. Legal privilege guide.
Frontier Models (ChatGPT, Claude) The settlement authority now on a third party’s servers 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 9The liabilities
A mortgage, a card balance and a tax debt the firm disputes. Rule 6.06(2)(h) requires disclosure of liabilities and contingent liabilities. Rule 9 confidentiality guide.
Frontier Models (ChatGPT, Claude) Debts of both parties 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 Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. See the use case - 10The totals and the formula
Net pool for each side and the sum behind the first. It shows how far apart the parties are, and it leaves out the contingent claim, which a person must remember to consider. Rule 9 confidentiality guide.
Frontier Models (ChatGPT, Claude) The sum is as good as the range; a person must check it covers every asset Ermos Edge The same formula either way; the contingent claim is still left out Ermos Dominion The same formula either way; the contingent claim is still left out Use case Property pool reconciler. Reconciles both parties' Financial Statements into one pool schedule, shows each contribution and transfer, and sets out the split the client has said they will accept. 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 firm 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 matter 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 law firms.
Common questions
Do ChatGPT and Claude use the information in a property pool spreadsheet?
Can we use ChatGPT or Claude for a property pool spreadsheet if we remove the names?
Can ChatGPT or Claude be trusted with the totals in a property pool spreadsheet?
How can a law firm use AI for a property pool without sending it to ChatGPT or Claude?
What does the Family Law Act require the court to consider in a property case between married parties?
Can a party use documents the other side served in a family law case for anything else?
How is a property pool checked on Ermos?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo