Law Firm Costs Estimate Tracker Spreadsheets: Use case and AI Confidentiality

Every law firm tracks whether fees are running past the estimate it gave the client, because the Legal Profession Uniform Law requires the firm, with exceptions such as commercial or government clients and matters below the costs thresholds, to tell the client when a disclosed estimate changes significantly. The tracker is a spreadsheet of matters, estimates, billed amounts and candid notes about who has not been told. Someone asked to check the totals or draft the update letters might paste it into ChatGPT or Claude. This page marks every item in a realistic costs tracker that rule 9 and sections 174 to 178 and 187 of the Uniform Law bear on, and shows how the same sheet is checked on Ermos inside the firm.

The costs estimate tracker spreadsheet

Kept by the practice manager and reviewed by each partner at the monthly costs meeting, so that a client is told in writing when an estimate changes significantly. The tracker shows what has been disclosed; it does not replace the written disclosure.

fx
ABCDEFGHI
1MatterClient and matterEstimate disclosed (incl GST)Billed to dateUnbilled WIPProjected totalOver or (under)Over %Note
2KELL-021138,50021,6009,35041,2002,7007.0%
3LENN-030622,00019,8006,05031,90045.0%
4KARA-018814,3009,9002,20013,200(1,100)(7.7%)
5KENW-009452,80047,30015,40078,10047.9%
6LANG-04029,9009,90009,90000.0%EV. Final bill given 30 Oct. Close and archive
7LASK-015018,70016,5004,40024,2005,50029.4%
8KWAN-02336,6003,3001,6506,60000.0%EV. CDD done 12 Oct. Settlement 27 Nov
9LISO-04125,5002,2003,3005,50000.0%
10LORI-03914,95003,8506,0501,10022.2%EV. Estimate given 3 Nov. Costs of production not yet raised with Kemp’s solicitors
11Total173,250130,50046,200Estimates are the last amounts disclosed to each client
Costs trackerDisclosure logArchive

An invented spreadsheet. Amounts are in whole dollars including GST and disbursements, and every total has been recomputed. Hover or tap any highlighted item for the analysis; the full list is below.

Costs estimate tracker updater

An Agent+ that keeps the costs estimate tracker current. It reads each matter's costs agreement and the latest billing records, updates the spreadsheet, and lists matters where fees exceed the estimate disclosed, with a note of whether written disclosure appears on file.

What it does

  1. Reads the costs agreements and the latest billing records
  2. Updates the tracker with fees against each disclosed estimate
  3. Flags matters where no updated disclosure is on file

What stays with your people. The practice manager checks the tracker, and each partner decides what to tell the client in writing.

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
    Matter codes, clients and what they are in dispute about

    Each row names a client and the matter, and some name the other side. A list of matters is a list of who has instructed the firm and why, confidential to each client under rule 9.1, and an estate, a dismissal claim and a lease dispute are the kind of detail clients do not expect to leave the firm. Rule 9 confidentiality guide.

  2. 2
    The projected total and the amount over the estimate

    A comparison of the estimate the client was last given with where fees are heading. Section 174(1)(b) of the Uniform Law requires the firm, when or as soon as practicable after any significant change to anything previously disclosed, to give the client information about the change, including the change in the costs payable. The Act does not define significant, and the sheet’s gap is evidence of when the firm knew. Rule 9 confidentiality guide.

  3. 3
    A stale estimate the client has not been told about

    The firm’s own note that the estimate is out of date and the client has not been told. Section 178(1) provides that if a law practice contravenes the disclosure obligations, the costs agreement is void, the client is not required to pay until the costs are assessed or a dispute is determined, and the practice cannot sue for them. A candid admission, in a column nobody thinks of as sensitive. Rule 9 confidentiality guide.

  4. 4
    A relative paying half

    A named brother who has agreed to pay half the costs. Section 176 requires the same disclosure to be made to an associated third party payer, that is, a person under a legal obligation to pay the firm, to the extent the disclosure is relevant to the costs the payer must pay. Whether he is one has not been checked. Information about a family arrangement. Rule 9 confidentiality guide.

  5. 5
    The settlement offer and the next step

    A figure offered by the other side and the firm’s reminder to itself. Section 177 requires a firm that negotiates the settlement of a litigious matter to disclose to the client, before the settlement is executed, a reasonable estimate of the costs payable if the matter settles and of any contribution from the other party. The offer is the client’s confidential information and is potentially privileged. Legal privilege guide.

  6. 6
    A client’s circumstances

    A named client, a mediation date and the fact that he lost his job and is on an instalment plan. Personal financial information, and a note that tells anyone reading how the firm will treat his account. Rule 9 confidentiality guide.

  7. 7
    The itemised bill request and the due date

    A client’s request on 9 November for an itemised bill. Under section 187 a person entitled to apply for assessment of a lump sum bill may ask for an itemised bill within 30 days after the costs become payable, and the firm must comply within 21 days after the request is made, which here means by Monday 30 November. A date a person must check.

  8. 8
    The compliance flag

    A note that a matter needs compliance review and billing is on hold, beside the client’s name. The Law Society of NSW’s AML/CTF guide suggests flags that do not reveal the nature of a suspicion. This one is neutral, but in a spreadsheet read with the rest it tells the reader the client is under review. Law Society AI guidance.

  9. 9
    The totals and the formula

    A sum over a range, the total projected fees, the total over the estimates and the percentage. It names no client, but it shows the firm’s whole book and how far its disclosures lag behind it. The arithmetic must be checked by a person.

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 costs estimate tracker 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. This tracker carries nine client matters, including Kellerman Roofing's debt claim and Dimitra Karabatsos's mother's estate, with $173,250 in disclosed estimates against a projected $216,650.
Is it safe to paste a costs estimate tracker into ChatGPT or Claude?
No, because each row is confidential to a client under rule 9 and the notes record where disclosure has fallen behind. 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. One note says the Lennox owners corporation committee has not been told its estimate is stale. Under section 178(1) of the Legal Profession Uniform Law, a contravention of the disclosure obligations makes the costs agreement void and stops the firm suing for the costs until they are assessed.
What travels with a costs estimate tracker when it is uploaded to ChatGPT or Claude?
An uploaded file leaves the business as a whole file, which can carry other sheets, hidden columns, comments, tracked changes and file properties. This workbook has tabs named Disclosure log and Archive beside Costs tracker, and an upload could carry them with the notes column, the SUM formula and the total projected fees. 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 a law firm use AI for a costs estimate tracker 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 tracker is checked against the matter files and the firm's own billing records. A person recomputes the totals, and a partner decides whether a change is significant under section 174(1)(b) and what each client is told in writing.
Does a law firm have to tell a client when its costs estimate changes?
Generally yes. Section 174(1)(b) of the Legal Profession Uniform Law requires a law practice, when or as soon as practicable after any significant change to anything previously disclosed, to give the client information about the change, including any significant change to the legal costs payable. The information must be enough for the client to make informed decisions (s 174(2)(b)) and must be in writing (s 174(6)). The Act does not define significant. The duty does not apply to a commercial or government client (s 170), and disclosure is not required where the total costs are not likely to exceed the lower threshold in the Uniform Rules (s 174(4)).
What happens if a law firm does not make the required costs disclosure?
Under section 178(1) of the Legal Profession Uniform Law, the costs agreement concerned, if any, is void. The client or an associated third party payer is not required to pay the legal costs until they have been assessed or a costs dispute has been determined. The practice must not commence or maintain proceedings to recover the costs until then, and the contravention can amount to unsatisfactory professional conduct or professional misconduct. The Uniform Rules can modify these consequences in specified circumstances (s 178(3)).
When can a client ask for an itemised bill?
If a bill is a lump sum bill, a person entitled to apply for an assessment of the costs can ask for an itemised bill within 30 days after the costs become payable. The law practice must comply within 21 days after the request is made (s 187). A practice cannot start proceedings to recover the costs until at least 30 days after the later of the bill or the itemised bill (s 194).

See Dominion answering from your own documents.

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

Book a demo