Extract each carrier's quote into the same fixed table (premium, limits, deductibles, sub-limits, exclusions, conditions), have the assistant flag gaps against the client's requirements, then draft the proposal narrative from that table. The broker checks every cell against the quote and the wording, chooses what to recommend and gives the advice.
Premium is the easy column and the least useful one. The cheapest quote often differs on indemnity period, sub-limits or conditions, and an assistant reading three PDFs will smooth those differences away unless the prompt forces them into the open. One illustrative client runs through everything below: a bakery with a shop and a production kitchen, quoted by three carriers.
Why a premium column misleads, and what to compare instead
Put three premiums side by side and the client sees a price list. What they are really buying is a bundle of promises, and the bundles differ. Some carriers write 12 months of business interruption cover and others write six. One quote includes equipment breakdown and another offers it as an extra at a price. A third caps spoilage at a fraction of the figure the client needs, or only pays after a waiting period. None of that shows in the premium, and all of it shows up on the day of a claim.
So compare in layers. First, the covers granted: which sections are actually in the quote. Second, the limits: the most the carrier pays per loss and in total. Third, the sub-limits, which are lower caps for particular losses inside a section. Fourth, the deductibles (called excesses in some markets) and any waiting periods. Fifth, the conditions and warranties, which are things the client must do for the cover to respond. Sixth, the exclusions, which are losses the carrier will not pay for. Seventh, the price, with taxes and fees shown separately. Last, the quote's validity and its subjectivities, the carrier's conditions that must be met before cover is bound. An assistant can lay these out side by side faster than you can, provided it is told to use the same fields for every quote and never to infer.
The normalisation table: fields every quote is forced into
Normalising means forcing every quote into the same set of fields, so that a gap in one column is visible instead of hidden in prose. Decide the fields once, per class of business, and reuse them. For a small commercial package the list below is a reasonable start.
| Field | Why it matters |
|---|---|
| Carrier, product and quote validity | An expired quote cannot be bound, and a short validity forces the decision date. |
| Premium, taxes and fees, total | Totals compare; base premiums mislead when taxes and fees differ. |
| Limit for each section | The most the carrier will pay, and the first thing a client asks about. |
| Sub-limits and their triggers | A lower cap inside a section, often unnoticed until a claim. |
| Deductible and waiting period | What the client pays or waits through before cover responds. |
| Business interruption: basis and indemnity period | How long the cover pays; a short period can end before the business reopens. |
| Liability: per-occurrence limit, aggregate, products | Products treatment and aggregates differ in ways that matter for food businesses. |
| Exclusions named in the quote | The losses the carrier says it will not pay for, in the carrier's own words. |
| Conditions and warranties | Things the client must do for the cover to respond. |
| Subjectivities | Carrier conditions to be met before the cover is bound. |
If you have already extracted structured data from submissions, AI submission intake for insurance brokers shows how the same discipline works on the way in, and turning carrier loss runs into remarketing summaries does it for claims history.

The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowBefore the first quote goes in: client data and tool settings
Quotes carry the client's name, address and details of the risk. Replace the name and contact details with [CLIENT] and [LOCATION 1] before pasting, and keep the figures that make the comparison work: trade, sums insured, revenue basis, limits. If claims history matters, summarise it, rather than pasting the carrier's loss run in full. On the tool side, use a plan whose provider does not train on business content by default, or an individual plan with the model-training switch turned off, and switch memory off, or limit it to a single Project, so that one client's figures cannot appear in another's chat.
Two practical points. First, test the tool on the actual PDF before trusting it. Ask it to quote the third line of a named page and see whether it matches. Scanned, image-only PDFs may not be read properly, and long documents can be cut short without any warning. Second, speak to your professional liability insurer before AI becomes routine in client work. Whether agency errors and omissions cover responds to AI mistakes sets out the questions to ask. Whatever the answer, keep a file note of what the assistant did and what you checked, because that note is the record that protects you.
Pull each quote into the table, with page references
The extraction prompt has one job: copy what each quote says into fixed fields, with the page it came from. It is not allowed to infer, to merge quotes or to draw on what it knows about a carrier. The page reference does most of the work later, because it turns checking into a lookup.
You are helping an insurance broker compare three carrier quotes for
one client. Fill in the same table for EACH quote. Use only the text of
that quote. Never infer, never combine quotes, never use general
knowledge about the carrier.
Fields: Carrier and product | Quote valid until | Premium before taxes
and fees | Taxes and fees | Total payable | Contents and equipment limit
| Stock limit | Business interruption: basis, limit, indemnity period
| Liability: per-occurrence limit, aggregate, products treatment |
Property deductible | Equipment breakdown | Spoilage or refrigeration
cover: limit and waiting period | Exclusions named in the quote (quote
the wording) | Conditions and warranties | Subjectivities
For every cell give the page number. If the quote does not state a
field, write NOT STATED. Write "none" only if the quote says none.
List the pages you read for each quote and say if any page was unreadable.
Illustrative output for the bakery, with page references left out to save space. The shop and kitchen are quoted by three carriers, here called A, B and C:
| Field | Carrier A | Carrier B | Carrier C |
|---|---|---|---|
| Premium before taxes and fees | $3,920 | $3,410 | $4,380 |
| Taxes and fees | $310 | $265 | $350 |
| Total payable | $4,230 | $3,675 | $4,730 |
| Contents and equipment | $180,000 | $180,000 | $180,000 |
| Stock | $25,000 | $25,000 | $30,000 |
| Business interruption | $250,000 gross profit, 12-month indemnity | $250,000 gross profit, 6-month indemnity | $250,000 gross profit, 12-month indemnity |
| Liability | $1m per occurrence, $2m aggregate, products inside the aggregate | $1m per occurrence, $2m aggregate, products capped at $1m | $2m per occurrence, $2m aggregate, products included |
| Property deductible | $1,000 | $2,500 | $1,000 |
| Equipment breakdown | Included, $100,000 | NOT STATED; endorsement offered at +$420 | Included, $100,000 |
| Spoilage (refrigeration) | $10,000, 24-hour waiting period | $5,000; waiting period NOT STATED | $15,000, no waiting period |
| Conditions and warranties | Extraction system cleaned every six months | NOT STATED | Alarm maintenance certificate required |
| Subjectivities | Survey within 30 days | None (the quote says so) | Alarm evidence within 14 days |
| Quote valid | 30 days | 14 days | 30 days |
The checks are the broker's. Open each PDF beside the table and verify every cell, starting with the three rows where mistakes cost most: sub-limits, deductibles and the indemnity period. Treat NOT STATED as a question for the carrier, not as a zero: the missing waiting period on Carrier B's spoilage cover could be nothing, or a clause on a page you have not seen. Check that premiums are on the same basis, annual and with or without taxes and fees. And compare the list of pages read with the real page count. If the tool read 12 pages of an 18-page quote, stop and find out why before going further.
Flag the gaps against what this client needs
A normalised table says what each carrier offers. It does not say whether that is enough. The second prompt takes the requirements from your fact-find and lists where each quote falls short. In the example, the bakery's needs are as follows (invented): equipment and contents of $180,000, stock up to $30,000 at the holiday peak, business interruption on $250,000 of gross profit with a 12-month indemnity period because the owner estimates nine months to replace the oven line and reopen, liability of at least $1m per occurrence because the landlord requires it, spoilage cover of at least $15,000 for the walk-in fridge and freezer, equipment breakdown cover, and a property deductible no higher than $1,000.
Below are (1) the client's requirements from my fact-find and (2) the
normalised quote table. Compare each carrier with each requirement.
Return a gap list: Carrier | Severity (Critical, Significant, Minor) |
Gap | Why it matters for this client | Question to put to the carrier.
Rules:
- Use only the table and the requirements. Do not rank the carriers and
do not recommend one.
- A requirement met exactly is not a gap. Say "meets" only if the table
proves it.
- Treat every NOT STATED as a gap with a question.
Then give the like-for-like cost: each carrier's total payable after
adding the price of any endorsement needed to meet a requirement, with
the sum shown.
Illustrative output, abridged:
| Carrier | Severity | Gap | Why it matters | Question for the carrier |
|---|---|---|---|---|
| B | Critical | Business interruption indemnity is 6 months | The owner estimates nine months to reopen, so cover would end first. | Can B quote 12 months, and at what price? |
| B | Critical | Equipment breakdown not in the quote | Ovens and refrigeration are the main equipment; the endorsement is +$420. | What are the endorsement's limit and conditions? |
| B | Significant | Spoilage $5,000; waiting period NOT STATED | The client needs at least $15,000. | State the waiting period; can the limit rise? |
| B | Significant | Property deductible $2,500 | The client's maximum is $1,000. | What would a $1,000 deductible cost? |
| A | Significant | Spoilage $10,000 with a 24-hour waiting period | Below the $15,000 need, and a failure over a weekend could pass unnoticed within the waiting period. | Can A raise the limit or remove the wait? |
| A | Minor | Warranty on cleaning the extraction system every six months | If the client misses a cleaning, cover may not respond to a fire claim. | Is the warranty a condition of all fire claims? |
| C | Minor | Alarm evidence due within 14 days; highest total | The client must produce the certificate quickly; the total is $500 above A. | Which certificate is acceptable? |
The like-for-like line reads: B is $3,675 plus the $420 endorsement, or $4,095; A is $4,230; C is $4,730. The gap between B and A shrinks from $555 to $135, but B still meets neither the 12-month indemnity requirement nor the $15,000 spoilage need. This is the sum that corrects the impression a premium column gives: the cheapest quote was cheapest only because it covered less.
Three checks stay with the broker. Severity labels are suggestions: you know the client's tolerance and the assistant does not, so a "Minor" warranty on an extraction system may deserve more weight for a kitchen with a deep fryer. Next, "meets" is a claim to verify against the table, not accept. And read the "why it matters" column for statements about how cover works that the table does not support, such as a general claim about waiting periods. Those sentences are the assistant's own, and each one needs your confirmation or deletion. Recompute the like-for-like totals yourself. Then treat the whole output as a working document that no client sees.
Draft the proposal from the table and your reasons
The proposal is where advice reaches the client, so the assistant's role here is narrow: it writes up the reasoning you give it, in plain words, in a set order. You choose the recommendation and you list the reasons. The tool must not add reasons of its own, must not rank the carriers beyond your choice, and must not state anything the verified table does not say.
Draft the client proposal from the verified quote table and my
reasoning. You are writing up my advice, not giving your own.
MY REASONING (use only these reasons):
1. I recommend Carrier C.
2. C is the only quote meeting the spoilage need: $15,000, no waiting
period (A: $10,000 with a 24-hour wait; B: $5,000).
3. C and A give 12 months of business interruption and a $1,000
deductible; B does not.
4. C costs $500 a year more than A ($4,730 against $4,230).
5. C needs alarm maintenance evidence within 14 days: client to confirm.
6. A is the lower-cost alternative if the client accepts the lower
spoilage cover and the cleaning warranty.
7. B is not recommended: 6-month indemnity, $2,500 deductible, $5,000
spoilage, all below the client's stated needs.
Structure: Summary of our recommendation; What we compared; Comparison
table (copy the verified table); Why we recommend C; What is conditional;
The lower-cost alternative; Why not B; Next steps with dates.
Rules:
- Plain words for a small-business owner. Define any insurance term the
first time it appears.
- State no cover, benefit or claim outcome that is not in the table.
- Do not mention any carrier's financial strength or claims record.
- Where my firm's required wording belongs, write [BROKER TO INSERT].
Illustrative output, abridged:
Summary of our recommendation. We recommend Carrier C for your bakery's property, business interruption and liability cover, at $4,730 a year including taxes and fees.
Why we recommend C. It is the only quote that meets the spoilage cover you told us you need: $15,000 with no waiting period, against $10,000 with a 24-hour waiting period on Carrier A and $5,000 on Carrier B. C and A both provide business interruption cover for 12 months, which matches your estimate of nine months to replace the oven line and reopen, and both carry a $1,000 deductible on property claims. C costs $500 a year more than A.
What is conditional. Carrier C requires evidence of alarm maintenance within 14 days. [CLIENT TO CONFIRM: certificate date.]
The lower-cost alternative. Carrier A costs $4,230 a year. The differences are its lower spoilage limit and waiting period, and a condition that the extraction system is cleaned every six months.
Why not Carrier B. It has the lowest total, $3,675, but its business interruption cover lasts six months, its property deductible is $2,500 and its spoilage limit is $5,000, all below what you asked for.
Next steps. Quotes from A and C are valid for 30 days and B's for 14. Please confirm your choice by [DATE]. [BROKER TO INSERT: required disclosures.]
The recommendation is the broker's. C is not the right answer, only a defensible one: A would be just as defensible for a client who put premium first and accepted the lower spoilage cover. The assistant should not know which way you lean until you tell it, and it should not be able to tell the client either. Read the draft for any sentence that sounds like a guarantee ("you will be covered") and cut it, because the table says what the quote offers and not what a claim will pay. Check that every sentence maps to the table or to your seven reasons, and fill the placeholders yourself. Your own compliance rules decide the required wording: the disclosures, the advice statements and anything about how you are paid. Finally, ask whether the client could follow it without you in the room.
The broker's check sheet before anything reaches the client
Run this sheet on every proposal, initial and date it, and keep it in the client file. It takes about ten minutes, and it is the part of the workflow that makes the rest defensible.
| # | Check | What to look at | Fail means |
|---|---|---|---|
| 1 | Cells against the PDF | Every cell against the page cited, starting with sub-limits, deductibles and the indemnity period. | Correct the table; rerun that quote. |
| 2 | Pages read | The pages the tool lists equal the PDF's page count, with none unreadable. | Stop; read the missing pages yourself. |
| 3 | Wording against the quote | Each exclusion and condition named in the proposal checked against the policy wording where you have it. | Hold the proposal; ask the carrier. |
| 4 | Totals and basis | Premium, taxes and fees add up, and every carrier is on the same basis and period. | Fix the table. |
| 5 | Requirements | The gap list reflects what the client told you in the fact-find, not what the assistant assumed. | Rebuild the requirements list. |
| 6 | Dates and subjectivities | Validity dates and conditions in the proposal match the quotes, and the client can meet them. | Correct; ask for an extension. |
| 7 | Narrative claims | Every sentence maps to the table or your reasons; no guarantees and no rankings you did not make. | Delete or rewrite. |
| 8 | Recommendation record | A file note says why you recommended this option and why you rejected the others. | Write it before sending. |
| 9 | Required wording | Your firm's disclosures and advice statements are in place. | Insert them. |
| 10 | Client data | Real names go back in only in your own documents, and the chat is handled as your policy says. | Fix before sending. |
Where the assistant slips on quotes, and how each slip shows up
These are the failures to expect, written as illustrations.
- The second deductible. Carrier A's quote states a $2,500 deductible on equipment breakdown claims, separate from the $1,000 property deductible. The table had only one deductible row, so the assistant wrote $1,000 for both. It shows up when you read the equipment breakdown page against the table. The fix is to add an "other deductibles" row and rerun, because a fixed schema is only as complete as its fields.
- The brochure. A carrier emails a quote with a glossy cover overview attached, and the overview shows a $20,000 spoilage figure above the quote's own schedule. The assistant uses the brochure's number. The page reference gives it away, since it points to page 1 of a different document. Keep brochures out of the upload, or tell the tool which document governs.
- The short read. The tool reads 12 of an 18-page quote and reports "no exclusions beyond the standard list". The exclusions schedule is on page 16, so the statement means nothing: the tool cannot know what it did not read. It shows up in check 2, where pages read and page count do not match. That is also why the prompt reserves "none" for quotes that actually say so, and uses NOT STATED for everything else.
The hour it returns, and where to spend it
These timings are illustrative, for three quotes and one proposal. By hand, extracting the three quotes takes about 105 minutes, the gap analysis 30 and the proposal narrative 60, which makes 195 minutes. With the workflow, running the extraction takes about 24 minutes and verifying it against the PDFs another 45, the gap list 15, the narrative 25 and the check sheet 15, which makes 124 minutes. The saving is about 70 minutes, and the largest single item left is verification, as it should be. Time your own renewals first, because your quotes may be longer or shorter than these.
The hour is best spent on a call to the underwriter about the NOT STATED items, which clients value and no assistant can do. The table also carries forward: next year's renewal starts with the same fields filled in. When the policy arrives, checking an issued policy against the quote and binder closes the loop, and comparing policy wordings at renewal goes deeper on the clauses that quotes only summarise.
Broker questions about AI quote comparison
Can AI recommend which carrier the client should buy?
It can list differences against the client's needs, but a recommendation is advice, and advice is yours. Give the assistant your reasons and let it draft the wording. If it ranks the carriers unprompted, delete the ranking: a ranking implies a judgement about suitability, and the tool does not know your client.
Should I upload the policy wording as well as the quote?
Yes for the clauses that matter, but not in place of your own reading. A quote summarises and the wording governs. Ask for exclusions and conditions with page references, then read those pages yourself, and check the binder and the issued policy against the quote later.
What client data can I paste into the tool?
Swap the client's name, address and any personal data for placeholders and keep the figures that make the comparison work. Use a plan whose provider does not train on your content by default, or an individual plan with training switched off, and ask your professional liability insurer how it views AI use.
How do I stop the assistant mixing up limits and deductibles?
Force a fixed table with named fields, require a page reference for every cell, and mark anything missing as NOT STATED. Then check the sub-limit and deductible rows against the PDF first, because those are the cells where a figure most often slips into the wrong column.
Further reads
- ChatGPT for Insurance Brokers: Client Emails, Summaries and Limits — Client emails and summaries, with the limits to respect.
- AI in General Insurance: What a Small Broker Can Use Today — Other jobs a small broker can hand to AI today.
- Where AI Saves Time in a Small Insurance Brokerage — Where the hours go in a small brokerage and what AI returns.
- Insurance Broker AI App: A Buying Checklist for a Small Brokerage — What to ask before paying for an insurance-specific AI app.
- How to Catch Made-Up Figures in AI-Drafted Proposals — A general method for catching invented figures in drafts.
- Best AI Tools for Insurance Agents: Seven for Quotes, Renewals and Calls — Seven AI tools for independent insurance agencies, with costs, test scripts, a six-person agency sum and the E&O checks before you buy.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: OpenAI, Anthropic, Google Workspace and Microsoft privacy pages (business-plan training defaults); the quotes, limits and premiums in the worked example are invented.