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.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Matter | Client and matter | Estimate disclosed (incl GST) | Billed to date | Unbilled WIP | Projected total | Over or (under) | Over % | Note |
| 2 | KELL-0211 | Kellerman Roofing Pty Ltd: debt claim against a former supplier1 | 38,500 | 21,600 | 9,350 | 41,200 | 2,700 | 7.0% | EV. Supplier offered $62,000 on 6 Nov. Settlement estimate to client before any deed is signed5 |
| 3 | LENN-0306 | Lennox Park Owners Corporation: levy recovery1 | 22,000 | 19,800 | 6,050 | 31,900 | 9,9002 | 45.0% | HR. Tribunal adjourned twice. Committee has not been told the estimate is stale. Meets 24 Nov3 |
| 4 | KARA-0188 | Dimitra Karabatsos: her mother’s estate1 | 14,300 | 9,900 | 2,200 | 13,200 | (1,100) | (7.7%) | EV. Brother Nikos has agreed to pay half. Nothing on file to him. Not yet checked whether he owes us4 |
| 5 | KENW-0094 | Kenward Brothers Pty Ltd: lease dispute1 | 52,800 | 47,300 | 15,400 | 78,100 | 25,3002 | 47.9% | HR. Estimate reset 2 Oct, from $29,700 in March. Client asked for itemised bill 9 Nov. Due 30 Nov7 |
| 6 | LANG-0402 | Langford Engineering Pty Ltd: supply contract review1 | 9,900 | 9,900 | 0 | 9,900 | 0 | 0.0% | EV. Final bill given 30 Oct. Close and archive |
| 7 | LASK-0150 | Peter Lasker: unfair dismissal claim1 | 18,700 | 16,500 | 4,400 | 24,200 | 5,500 | 29.4% | HR. Mediation 18 Nov. On an instalment plan since losing his job. Do not chase6 |
| 8 | KWAN-0233 | Kwan Property Trust: purchase of a unit1 | 6,600 | 3,300 | 1,650 | 6,600 | 0 | 0.0% | EV. CDD done 12 Oct. Settlement 27 Nov |
| 9 | LISO-0412 | Mateusz Lisowski: purchase of a unit1 | 5,500 | 2,200 | 3,300 | 5,500 | 0 | 0.0% | EV. Compliance review required. Hold billing8 |
| 10 | LORI-0391 | Leanne Lorimer: response to subpoena (Kemp v Lowther)1 | 4,950 | 0 | 3,850 | 6,050 | 1,100 | 22.2% | EV. Estimate given 3 Nov. Costs of production not yet raised with Kemp’s solicitors |
| 11 | Total | 173,250 | 130,500 | 46,200 | 216,6509 | 43,4009 | 25.1%9 | Estimates are the last amounts disclosed to each client |
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
- Reads the costs agreements and the latest billing records
- Updates the tracker with fees against each disclosed estimate
- 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
- 1Matter 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.
Frontier Models (ChatGPT, Claude) 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 Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 2The 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.
Frontier Models (ChatGPT, Claude) Each client’s disclosed estimate and the firm’s forecast transmitted Ermos Edge Stays in Australia; the AI can compute the gap but a lawyer decides if it is significant Ermos Dominion Stays on the unit; the AI can compute the gap but a lawyer decides if it is significant Use case Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 3A 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.
Frontier Models (ChatGPT, Claude) The firm’s own record of a missed disclosure 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 Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 4A 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.
Frontier Models (ChatGPT, Claude) A third party’s arrangement 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 Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 5The 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.
Frontier Models (ChatGPT, Claude) A client’s settlement position 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 Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 6A 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.
Frontier Models (ChatGPT, Claude) A client’s job loss and payment plan 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 Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 7The 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.
Frontier Models (ChatGPT, Claude) A date to check; the request itself is the client’s Ermos Edge A person must check the date against the request; not about where data goes Ermos Dominion A person must check the date against the request; not about where data goes Use case Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 8The 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.
Frontier Models (ChatGPT, Claude) A neutral flag, but it names a client under review 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 Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. See the use case - 9The 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.
Frontier Models (ChatGPT, Claude) No client names, but the whole book and the gap are visible Ermos Edge The AI can mis-add; a person must check the totals Ermos Dominion The AI can mis-add; a person must check the totals Use case Costs estimate tracker updater. Updates the costs tracker from billing records and each matter's disclosed estimate, and flags matters where fees have moved past it for the partner. 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 costs estimate tracker spreadsheet?
Is it safe to paste a costs estimate tracker into ChatGPT or Claude?
What travels with a costs estimate tracker when it is uploaded to ChatGPT or Claude?
How can a law firm use AI for a costs estimate tracker without sending it to ChatGPT or Claude?
Does a law firm have to tell a client when its costs estimate changes?
What happens if a law firm does not make the required costs disclosure?
When can a client ask for an itemised bill?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo