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.

fx
ABCDEFG
1RefHeld byOur figure
2A1MS2,100,000.00
3A2Superannuation (MS)MS412,000.00412,000.00Accrued mostly during the marriage
4A3Superannuation (CL)CL186,500.00184,200.00
5A4Car, 2019 Mazda CX-5MS21,500.0024,000.00
6A5Ute and toolsCL60,000.0049,000.00His tools figure looks low. Ask for insurance schedule.
7A6Savings accountMS38,400.0038,400.00
8A7Joint accountBoth14,200.0014,200.00
9A8CL22,500.009,800.00
10C1Claim v Greystone (contingent)MSnot valuednot disclosed
11L1MS(640,000.00)(640,000.00)
12L2Credit card (MS)MS(7,300.00)(7,300.00)
13L3CL0.00(12,000.00)We dispute it. No assessment produced.
14Net pool2,322,300.00
PoolSuperContributions

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

  1. Reads both Financial Statements and the client's instructions
  2. Lists assets, liabilities, contributions and transfers side by side
  3. 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

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

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

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

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

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

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

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

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

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

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

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 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 law firms.

Common questions

Do ChatGPT and Claude use the information in a property pool spreadsheet?
Everything pasted or uploaded 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. A property pool carries both parties' valuations of the home, a $31,000 transfer to his mother and the 55/45 split the client will accept.
Can we use ChatGPT or Claude for a property pool spreadsheet if we remove the names?
No. 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. 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. Dropping the initials MS and CL still leaves the Coogee home, the mortgage, both superannuation balances and the family court file number, which together describe one couple.
Can ChatGPT or Claude be trusted with the totals in a property pool spreadsheet?
Not without a qualified person checking every figure. Language models can produce fluent text with details that are not in the source, wrong figures or dates, and references that look real but are not. In this sheet the harm would come from a wrong formula or total, a liability in brackets read as an asset, a figure copied into the wrong column between our figure and his, or the contingent claim left out of the net pool unnoticed. A solicitor should check every row against the Financial Statements before the numbers support advice.
How can a law firm use AI for a property pool 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 totals are reconciled to both Financial Statements and the bank records on the matter file. The solicitor and counsel decide the recommendation.
What does the Family Law Act require the court to consider in a property case between married parties?
Since the amendments in force on 10 June 2025, section 79(3) requires the court to identify the parties' existing legal and equitable interests in property and their existing liabilities, and to take into account the contribution considerations in section 79(4) and the current and future circumstances in section 79(5). That is why a pool spreadsheet lists both sides' assets, debts and the history of each contribution.
Can a party use documents the other side served in a family law case for anything else?
Rule 6.04 of the Federal Circuit and Family Court of Australia (Family Law) Rules 2021 says that, unless the court gives permission, a person who inspects, copies or receives a document in relation to a proceeding under the Rules or an order must use it for the purpose of the proceeding only and must not otherwise disclose its contents. A solicitor may disclose them to the client or counsel.
How is a property pool checked on Ermos?
The sheet, both Financial Statements and the bank records sit on your own network. The unit can reconcile the totals to the supporting documents, find assets that appear on one side only and calculate the effect of a proposed split. A solicitor and counsel decide the recommendation, and the notes column can stay in the sheet because nothing leaves.

See Dominion answering from your own documents.

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

Book a demo