Insurance Broker Business Interruption Worksheets: Use case and AI Confidentiality
Setting a business interruption sum insured means turning the client’s accounts into a gross profit figure, an indemnity period and an allowance for extra costs. It is a spreadsheet job, which is why a business interruption worksheet is among the files staff upload to ChatGPT or Claude to check the sums or tidy the layout. The sheet carries the client’s turnover and forecast, what it pays its suppliers, its wages, its biggest customer, what it is insured for now and by how much that falls short. This page marks every item in a realistic worksheet that the Code of Practice, the Insurance Contracts Act and the Privacy Act bear on, and shows the same sheet built on Ermos inside the brokerage.
The business interruption worksheet
Built before each renewal of a business pack with a business interruption section, from the client’s accounts and forecast, to set the sum insured and the indemnity period the broker recommends.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Line (Irving Coffee Roasters Pty Ltd, Alexandria1) | Year to 30 Jun 2026 (actual) | Year to 30 Jun 2027 (forecast) | Note |
| 2 | Turnover | 2,380,0002 | 2,710,0002 | Tanti Hospitality Group is 31% of turnover; its supply contract renews 1 Jan 20278 |
| 3 | Less green coffee and packaging | 1,046,0003 | 1,184,0003 | Importer has told Isaac of a price rise from 1 Jan 20273 |
| 4 | Less freight in and out | 118,000 | 131,000 | |
| 5 | Less card and platform fees | 41,000 | 47,000 | |
| 6 | Gross profit | 1,175,0004 | 1,348,0004 | Turnover less the three lines above |
| 7 | Of which ordinary wages | 640,0005 | 702,0005 | 11 staff; includes Mr Irving, the director, at $140,0005 |
| 8 | Current sum insured (12 months) | 1,100,000 | 1,100,000 | Meridian General business pack, renews Fri 1 Jan 2027 |
| 9 | Shortfall against gross profit | 75,000 | 248,0006 | Short by 18.4% of the forecast. Check the wording for an average provision before we advise.6 |
| 10 | Indemnity period (months) | 12 | 157 | Replacement roaster has a 14 week lead time, then ramp up7 |
| 11 | Gross profit sum insured at 15 months | - | 1,685,000 | |
| 12 | Increased cost of working (toll roasting) | - | 133,0009 | 14 weeks at 9,500 a week, from a toll roaster’s indicative quote9 |
| 13 | Total to insure | - | 1,818,0009 | Draft, Wed 18 Nov. The client’s accountant to confirm the figures before Priya sends them to Meridian.10 |
An invented worksheet for an invented client. Every total has been recomputed. Hover or tap any highlighted item for the analysis; the full list is below.
Business interruption worksheet builder
An Agent+ that reshapes a client's accounts and forecast into your business interruption worksheet. It pulls out turnover, supplier costs, wages and the largest customer, and works the shortfall against the sum insured and indemnity period currently on the policy. The result is a spreadsheet in your layout for the broker to adjust.
What it does
- Reads the client's accounts, forecast and current policy schedule
- Builds the worksheet in your own spreadsheet layout
- Flags missing figures and a shortfall against the sum insured
What stays with your people. A broker reviews the figures with the client and settles the recommended sum insured and indemnity period. The agent builds the worksheet; it does not set cover.
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 brokerage
- 1The client
A named company and its suburb. Everything below is identifiable to it, and the director is named later in the sheet. The Privacy Act binds a business with annual turnover above $3 million and some smaller ones, so whether it binds the brokerage depends on the facts. The confidentiality owed to the client does not depend on it. Privacy Act 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 Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 2Turnover, actual and forecast
What the business earned last year and expects to earn next. Financial information is personal information only where it is about an identifiable individual, and it is not on the Privacy Act’s closed list of sensitive information. It is the client’s commercial information, and clause 5.3(a) of the Insurance Brokers Code of Practice (the 2022 Code, version of 1 November 2023) has a subscribing broker act in the client’s best interests when acting on their behalf.
Frontier Models (ChatGPT, Claude) A client’s turnover and forecast 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 Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 3What it pays for green coffee, and the price rise
Purchases and packaging, with a supplier’s warning of a price increase. Together with turnover they show the margin, and they show what the importer charges. Commercial information about the client and, indirectly, its supplier.
Frontier Models (ChatGPT, Claude) Supplier costs and the margin they reveal 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 Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 4Gross profit
The figure the sum insured is built on, here turnover less purchases, freight and fees. In this invented wording gross profit is defined that way, and the sheet has to match the real wording. Staff upload the sheet to have the sums checked, and an AI tool can mis-add or restate a total. A person has to check each one.
Frontier Models (ChatGPT, Claude) The key figure is transmitted, and the AI can still mis-add it Ermos Edge Stays in Australia, but the AI can still mis-add, so a person must check each total Ermos Dominion Stays on the unit, but the AI can still mis-add, so a person must check each total Use case Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 5Wages, and the director’s salary
An aggregate wages bill for eleven staff and a named director’s salary. The aggregate is commercial information. The salary is personal information about an identifiable individual. Privacy Act guide.
Frontier Models (ChatGPT, Claude) An aggregate wages bill and a named salary 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 Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 6The shortfall and the average provision
The current sum insured is $248,000 short of the forecast gross profit, which is 18.4% of it. Section 44(1) of the Insurance Contracts Act 1984 says an insurer may not rely on an average provision unless, before the contract was entered into, it clearly informed the insured in writing of its nature and effect, including whether it is based on indemnity or replacement value. Whether this wording has one is for the wording to say, and section 44 is worded around the value of the property insured, so how it applies to a gross profit sum insured is for advice. Clause 5.1(b) of the 2022 Code has a subscribing broker take steps to help clients understand the advice, including the key risks of the products it recommends, and underinsurance is one.
Frontier Models (ChatGPT, Claude) Your underinsurance finding transmitted before the client has heard it Ermos Edge Stays in Australia, but whether the wording has an average provision is for the wording to say Ermos Dominion Stays on the unit, but whether the wording has an average provision is for the wording to say Use case Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 7The indemnity period and the lead time
The broker’s proposed period and the reason for it: how long it would take to replace the roaster and win back volume. The client’s operational judgement, and a statement of how long it would be out of action.
Frontier Models (ChatGPT, Claude) Operational assumptions transmitted Ermos Edge Stays in Australia, but the right period is the broker’s and the client’s judgement Ermos Dominion Stays on the unit, but the right period is the broker’s and the client’s judgement Use case Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 8The largest customer
A named customer, its share of turnover and the date its contract renews. Commercial information about a third party, and the client’s biggest dependency.
Frontier Models (ChatGPT, Claude) A named customer and its share of turnover 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 Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 9The extra cost allowance and the total
An estimate of 14 weeks of toll roasting at 9,500 a week from a third party’s indicative quote, and the total the client would be asked to insure. 133,000 plus 1,685,000 is 1,818,000. The allowance rests on a quote the toll roaster gave for another purpose, and whether it sits inside the gross profit item or is separate is for the wording.
Frontier Models (ChatGPT, Claude) A third party’s quote and the total to insure 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 Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. See the use case - 10The accountant check and the broker
A note that the figures are a draft, who will confirm them and who will send them. The duty of disclosure in section 21(1) of the Insurance Contracts Act is the insured’s and, under section 20E, applies to contracts that are not consumer insurance contracts. A misrepresentation by the insured to the insurer before the contract is entered into is also a relevant failure under section 27AA(1)(b), so the client has to stand behind the figures that reach the insurer. Nothing here depends on where the sheet was built.
Frontier Models (ChatGPT, Claude) A note about who checks and sends the figures, with nothing sensitive in it Ermos Edge A process note with nothing in it about where data goes Ermos Dominion A process note with nothing in it about where data goes Use case Business interruption worksheet builder. Builds the business interruption worksheet from the client's accounts and forecast, laying out turnover, costs and wages so a broker can test the sum insured. 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 brokerage 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 client 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 insurance brokerages. See how this works in practice: Renewal preparation on Ermos.
Common questions
Do ChatGPT and Claude use the information in a business interruption worksheet?
Can we use ChatGPT or Claude for a business interruption worksheet if we remove the client's name?
Does uploading a business interruption worksheet to ChatGPT or Claude send more than the figures?
How can an insurance brokerage use AI for a business interruption worksheet without sending it to ChatGPT or Claude?
What does section 44 of the Insurance Contracts Act say about average provisions?
Is a client's turnover or profit sensitive information under the Privacy Act?
Whose duty is it to get the figures right for the insurer?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo