Law Firm Earn-Out Calculation Spreadsheets: Use case and AI Confidentiality

An earn-out defers part of the price of a business until the business hits agreed profit targets, and the vendor’s solicitor models it before the first payment falls due. The sheet shows the business’s results by year, every adjustment the vendor argues for, the targets in the sale agreement, the payment tiers and the buyer’s set-off claim. Staff paste the sheet into ChatGPT or Claude to check a formula or summarise the dispute. This page marks every item in a three-year earn-out model for a cabinet-making business that rule 9, privilege and the Privacy Act bear on, recomputes each figure, and shows how the same model is worked on Ermos inside the firm.

The earn-out calculation spreadsheet

Built by the vendor’s solicitor from the sale agreement’s earn-out schedule, rerun at each reporting date and used in negotiating any dispute with the buyer.

fx
ABCDE
1LineCY26 (Year 1)CY27 (Year 2)CY28 (Year 3)Basis
2Year 1 is ten months of actual results plus forecast; years 2 and 3 are the vendor’s scenario
3Add back: group management charge48,00048,00048,000
4Add back: one-off rebrand costs00Year 1 only; invoices attached
5Less: insurance recovery included in EBITDA00Excluded by clause 4.3
6Adjusted EBITDA426,500450,000578,000Reported plus add-backs less the recovery
7Target EBITDASchedule 6 of the sale agreement
8Achievement of target101.55%97.83%115.60%Adjusted EBITDA divided by target
9Payment tier100%60%125%
10Earn-out before set-off200,000120,000250,000Annual amount multiplied by the tier
11Buyer set-off claim00Stock write-down warranty claim, disputed
12Net payable162,500120,000250,000Earn-out less set-off
13Three year total532,500Gross $570,000 less set-off $37,500
14Internal
Earn-outSet-off detail

An invented spreadsheet. Totals and percentages are recomputed from the rows. Hover or tap any highlighted item for the analysis; the full list is below.

Earn-out calculation workbook agent

An Agent+ that sets up the earn-out calculation from the sale agreement's schedule and updates it at each reporting date from the accounts supplied. It follows your firm's workbook layout, shows each adjustment and the clause behind it, and lists the items the buyer disputes.

What it does

  1. Reads the earn-out schedule and the period's accounts
  2. Updates the workbook, showing each tier and adjustment
  3. Lists disputed items and set-off claims for review

What stays with your people. The solicitor checks the workbook against the agreement and the partner decides the position taken with the buyer.

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 business, the vendor and the buyer

    The company sold, the vendor and the buyer, named in the sheet. Confidential to the client under rule 9, and commercially sensitive while the earn-out is being negotiated. Rule 9 confidentiality guide.

  2. 2
    Reported EBITDA for three years

    Actual and forecast earnings of a private business. The vendor’s confidential financial information, shared with the buyer for the sale only. Legal privilege guide.

  3. 3
    The management charge add-back and the buyer’s objection

    An adjustment of $48,000 a year ($144,000 over three years) that the buyer disputes. Without it, Year 1 reaches 90.12% of target rather than 101.55%. The dispute that decides the first payment. Legal privilege guide.

  4. 4
    The one-off add-back and the insurance exclusion

    Two further adjustments for Year 1, $22,500 added and $15,000 removed. The vendor’s argued position, with supporting invoices. Legal privilege guide.

  5. 5
    The targets

    EBITDA targets of $420,000, $460,000 and $500,000 from the sale agreement’s schedule. Confidential terms of the contract that bind both sides. Rule 9 confidentiality guide.

  6. 6
    The payment tiers and the annual amount

    Nil under 85%, 60% from 85% to under 100%, 100% from 100% to under 115% and 125% at 115% or more, on an annual amount of $200,000. The deal’s economics. Year 1 at 101.55% earns $200,000, Year 2 at 97.83% earns $120,000 and Year 3 at 115.60% earns $250,000. Legal privilege guide.

  7. 7
    The buyer’s set-off claim

    A $37,500 stock write-down claim set against the Year 1 payment, which reduces it from $200,000 to $162,500. The buyer’s claim and the vendor’s answer to it are privileged work product. Legal privilege guide.

  8. 8
    The firm’s note on the settlement floor and the vendor’s husband

    Privileged. The lowest amount the vendor will take, the date she needs the money and the reason, which is her husband’s dialysis. Health information about a third party is sensitive information under the Privacy Act. Legal privilege guide.

  9. 9
    The formula bar

    A cell formula, =B2+B3+B4+B5, that shows how the adjustments combine into adjusted EBITDA. A formula with no figure in it, though it shows the method the vendor is relying on.

  10. 10
    The tab names

    A tab called “Buyer dispute notes”. The name alone tells a reader that a dispute exists, and the tab behind it holds the firm’s analysis. Pasted workbooks carry every tab and not only the visible one. Legal privilege 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. See how this works in practice: Agreement review on Ermos.

Common questions

Do ChatGPT and Claude use the information in an earn-out calculation spreadsheet?
Whatever is pasted in 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 workbook carries three years of EBITDA for Pascoe Cabinetry, a disputed $48,000 add-back, a $37,500 set-off claim and an internal note that Nadia Pascoe will take $150,000 for Year 1 because of her husband's dialysis.
Can we use ChatGPT or Claude for an earn-out calculation spreadsheet if we remove the names?
Not safely, because the numbers identify the deal. Targets of $420,000, $460,000 and $500,000 and an annual amount of $200,000 are terms that bind both sides, and a buyer who saw them would know whose sheet it was. The settlement note also holds a third party's health information. 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.
What travels with an earn-out calculation spreadsheet 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 called Set-off detail and Buyer dispute notes beside the Earn-out tab, and an upload could carry all of them with the formula =B2+B3+B4+B5. 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 an earn-out calculation spreadsheet 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 calculation is built from the sale agreement's schedule and the vendor's accounts in the firm's own workbook. A solicitor checks every formula, the payment tiers and the set-off before any figures go to the buyer's solicitors.
What is an earn-out in a business sale?
An earn-out is part of the price that is paid later, and only if the business reaches agreed targets after completion, often measured by EBITDA over one to three years. The sale agreement sets the targets, the adjustments to profit, the payment tiers and any right of set-off. Because the buyer runs the business after completion, vendors usually negotiate how profit is calculated and how the buyer must run the business.
Can a buyer set off a warranty claim against an earn-out payment?
The sale agreement usually decides this, because it can allow or exclude set-off, and general law rules on set-off may also apply where it is silent. Vendors' solicitors often ask that the agreement limit set-off to claims that are agreed or decided, and say how a disputed amount is held. The agreement's wording controls, and a person should read it against the claim being made before any payment is reduced.
Why do EBITDA adjustments cause disputes?
Adjusted EBITDA starts from reported results and adds or removes items such as management charges, one-off costs and insurance recoveries. Each side benefits from a different treatment, so the agreement should define each adjustment and the accounting policies. In the example here, without the $48,000 add-back Year 1 reaches 90.12% of target and earns the 60% tier of $120,000 rather than $200,000.

See Dominion answering from your own documents.

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

Book a demo