Decide · choosing and switching

Lloyd's contract certainty tool: spreadsheet, portal or agents?

A contract certainty tool for the Lloyd's and London market has to track every bound risk from slip to agreed wording. A spreadsheet, a document portal and agents that read the slip each cover part of that; this guide runs one risk through all three, says where Contract Certainty Management fits, and gives a switch plan that keeps the old register running until the new one agrees.

Updated · 14 min read

A Lloyd's contract certainty tool is software that tracks each risk bound in the Lloyd's and London market from the moment the slip is stamped to the moment its contract is certain: every subjectivity met, the wording agreed with the slip, evidence of cover issued, and the certainty rate counted. There are three broad ways to do it: a spreadsheet and an inbox, a portal where brokers upload documents, or software agents that read the slip and the wording themselves. Each covers a different part of the job, and the difference shows up on the afternoon a subjectivity lapses. Botminds' Contract Certainty Management is the third kind: agents read each bound slip, count subjectivities down, draft the broker chaser at the deadline and compare the wording with the slip clause by clause, while the analyst releases, the underwriter clears and agrees, and the head of underwriting operations signs the rate.

The worked example follows one fictional risk from the solution's sample market, Harwell Quay Container Terminal, insured by the fictional Marlowgate Specialty, through all three approaches. Lloyd's is named here as the market the tool serves; nothing on this page describes Lloyd's own systems.

One lapsed subjectivity, three tools: how long until anyone notices

Spreadsheet and inbox, reviewed weeklyup to 7 days
Lapsed, unnoticed until the next weekly reviewup to 7 days
  • Lapsed, unnoticed until the next weekly reviewup to 7 days
Document portal, checked twice a weekup to 3½ days
Nothing uploaded; nobody has read the slip’s dateup to 3½ days
  • Nothing uploaded; nobody has read the slip’s dateup to 3½ days
Agents beside the analyst (sample)at the minute
Overdue at 17:00; chaser drafted, released and answered by 17:02 (2 minutes)
  • Overdue at 17:00; chaser drafted, released and answered by 17:02 (2 minutes)
Our illustration on the fictional Harwell Quay risk, whose signed statement of values fell due at 17:00 on 12 October 2026. The first two lanes follow from their stated review rhythm, not from measurements; a different rhythm gives a different lane. The third lane is the solution's sample: the chaser was drafted at 17:00, released, and answered at 17:02.

What is contract certainty software?

Contract certainty software holds every bound risk with what is still open on it, and tells the team what to do next. At minimum it must know each subjectivity's words, deadline and consequence; each wording version and how it differs from the slip; the documentation clock; and the firm's definition of certain at inception, so it can count the rate. Anything less is a list of risks, not a certainty tool.

The idea that technology belongs in the answer is as old as the problem. When the FSA met the market in December 2004, the meeting agreed that the key to contract certainty lay partly in "standardisation of process delivered by technology" (FSA, record of the industry meeting of 20 December 2004). Its chief executive had said the week before: "Automation is a key factor, but process simplification, integration and discipline are needed badly if this significant problem is to be resolved." More than twenty years on, the second half of his sentence is still the hard part, and it is the part a tool should be judged on.

What does a contract certainty tool track?

It tracks the objects that can leave a contract unfinished, each with the date by which it must be closed and the person who closes it.

What a contract certainty tool has to hold for each bound risk

ObjectWhat must be heldWho closes it
SubjectivityExact slip words and page, deadline in London time, consequence, evidence needed, evidence receivedClass underwriter clears
WordingEach broker version, its date and pages, and every difference from the slipWordings specialist sends notes; underwriter agrees
Endorsements and clausesEach named clause and its edition, on the slip and in the wordingUnderwriter agrees
DocumentationEvidence of cover and policy issue dates against the firm’s periodOperations
ChasersWhat was sent, to whom, quoting what, and the replyAnalyst releases
Certainty statusCertain or not at inception, under the firm’s definition, with the reasonHead of operations signs the report
Our list, matching the objects Contract Certainty Management holds in the fictional sample market.

Spreadsheet, portal or agents: one risk through each

Each approach can hold the list above; they differ in who reads the documents and who notices time passing. The spreadsheet relies on a person to type every subjectivity in and look at the dates. The portal moves documents to one place but does not read them. Agents read the slip and the wording, and still leave every decision to a person.

Three approaches to contract certainty, row by row

Spreadsheet and inbox, or a document portalAgents that read slip and wording (Contract Certainty Management)
Subjectivities in

Spreadsheet and inbox, or a document portal: Typed by hand from each slip, or not at all in a portal

Agents that read slip and wording (Contract Certainty Management): Lifted word for word with page and deadline as each slip is bound

Undated subjectivity

Spreadsheet and inbox, or a document portal: Noticed if the person typing it notices

Agents that read slip and wording (Contract Certainty Management): Flagged on the day, with a date query drafted for release

Deadline passes

Spreadsheet and inbox, or a document portal: Found at the next review

Agents that read slip and wording (Contract Certainty Management): Marked overdue at the minute; chaser drafted quoting the slip

Evidence arrives

Spreadsheet and inbox, or a document portal: Someone opens the attachment and decides

Agents that read slip and wording (Contract Certainty Management): Matched to the subjectivity with a reason; underwriter clears

Wording arrives

Spreadsheet and inbox, or a document portal: Read against the slip by hand, or stored unread

Agents that read slip and wording (Contract Certainty Management): Compared clause by clause; material differences listed with both texts

Rate

Spreadsheet and inbox, or a document portal: Counted from a sample, or not at all

Agents that read slip and wording (Contract Certainty Management): Every incepted risk, every morning, failures named

Audit trail

Spreadsheet and inbox, or a document portal: Cell edits and sent mail

Agents that read slip and wording (Contract Certainty Management): A run log of every agent and person step on every risk

Our comparison. A portal improves document collection over email but, without something reading the documents, behaves like the spreadsheet on every row below the first.

The portal deserves fairness. For brokers and insurers that exchange many documents, a single place to upload and find them is a real improvement over email. Its limit is that it knows a file arrived, not what the file says. A portal will show that a statement of values was uploaded on 2 October; it will not notice that it was unsigned and undated, which is exactly what the sample document matcher flagged. What agents add beside a portal, without replacing it, is the subject of the contract certainty portal guide.

Can contract certainty be automated?

The reading, counting and drafting can; the decisions should not be, and regulators expect the insurer to answer for the software either way. Three parts of the job are mechanical with a right answer: what the slip says, when a deadline falls, and whether a wording's clause matches the slip's. Three are judgements: whether evidence meets a condition, whether a difference is material, and whether to send a chaser that may set a date after which terms are reviewed.

Supervisors have said where accountability sits when a third party builds the tool. New York's Department of Financial Services, writing about AI in underwriting and pricing in July 2024, says insurers retain responsibility for understanding any such tools developed or deployed by third-party vendors and for ensuring they comply with applicable law (Insurance Circular Letter No. 7, 2024). In the UK, the Bank of England and FCA's 2024 survey found that a third of all AI use cases in UK financial services were built by third parties (Bank of England and FCA, November 2024). A certainty tool bought from a vendor is the insurer's tool for every practical purpose, so it must show its work.

What should contract certainty software report?

The rate under a stated definition, the trend, and every risk not certain with its owner and reason, cut by class, broker and underwriter; the documentation rate beside it; and an audit trail from each number back to the slip page or wording section it rests on. A rate without names cannot be acted on, and a name without a citation cannot be checked.

Every chaser in one place: what it quoted, who released it, what came back

Chasers screen in Contract Certainty Management: 23 released this month, 17 answered, median reply 1.6 days. A table of chasers: CH-0420 Harwell Quay S1 signed SOV to Callum Reeve, 12 October 17:00, answered; CH-0418 Saltire Offshore S2 tow plan, a date query because the subjectivity has no date and no consequence, to release; CH-0411 Orrin Valley Foods S1 loss record, sent 9 October; CH-0416 Kestrel Data reminder 3 days before the deadline, sent; CH-0405 Brannock Mining offtake, answered; CH-0419 Meridian Cold Chain reminder scheduled. The Harwell Quay chaser is open on the right, quoting the slip and showing the broker's reply at 17:02 matched to S1.
The fictional sample chasers screen. The quoted slip text in each chaser cannot be edited, and each shows who released it and when.

What should you ask a contract certainty software vendor?

Ask to see it work on your own documents, and ask questions whose answers can be checked on the spot. A demonstration on a vendor's clean sample proves little; a run on twenty of your bound slips and their broker wordings proves most of what matters.

Questions to put to any contract certainty tool, and what a good answer looks like

AskWhy it mattersA good answer
Show me each subjectivity from my slip, with the pageSummaries lose the words that decide what is owedExact slip text, page reference, deadline in London time
What do you do with a subjectivity that has no date?A tool that guesses a date creates a false deadlineFlags it and drafts a date query for a person to send
Compare this broker wording with its slipMost uncertainty hides in the wordingClause-by-clause differences, with both texts and the wording page
Who can send a chaser, clear a subjectivity, agree a wording?These decisions change the contract or speak to the marketNamed people only; the software drafts and proposes
Change my definition of certainThe rate depends on itA setting changed by an approved proposal, with the change logged
Count last month’s rate and name the failuresA rate you cannot trace is a rate you cannot defendEvery incepted risk, each failure with owner and reason
Show me what an agent did on this riskYou answer for the softwareA run log with each step, its time and who or what did it
Our checklist for a trial. The right-hand column is how Contract Certainty Management behaves in the fictional sample market; ask any vendor, including us, to show it on your own documents.

How do you replace a contract certainty spreadsheet?

Run the new tool beside the spreadsheet until the two agree, then retire the spreadsheet. Switching on a date, with the spreadsheet frozen and the tool assumed correct, is how a certainty team loses track of the very subjectivities it was trying to watch.

A switch plan that keeps the old register running until the new one agrees

  1. Write the definition of certain and the clocks down first

    What counts as certain at inception, the documentation period, reminder, chaser and escalation timings. The tool takes them as settings.

  2. Load every open bound risk, not just new ones

    Feed the slips and current wordings of everything still open, so nothing in flight is left in the spreadsheet alone.

  3. Reconcile the two lists line by line

    Every subjectivity in the spreadsheet should appear in the tool with the same deadline; every one the tool finds that the spreadsheet lacks is a finding in itself.

  4. Run in parallel through real deadlines

    Keep both until a meaningful number of deadlines have passed and the tool flagged each one the team expected, and any it found that the team missed were real.

  5. Compare the rate for the same month both ways

    Count one month by the old method and the new; explain every difference before trusting the new number.

  6. Turn the spreadsheet read-only, not off

    Keep it as the history for the months before the switch; the run log starts on the day of cut-over.

Our plan. The length of the parallel run is set by how many deadlines and wordings pass through it, not by the calendar.

The reconciliation step is worth doing for its own sake. A spreadsheet typed by hand can have deadlines computed differently by different people, subjectivities missing because a slip was amended, and wordings marked agreed on the strength of an email. The tool will have its own errors, which the parallel run exists to find. Each difference is resolved by going back to the slip, and the slip is the only authority both sides accept.

How long does it take to implement a contract certainty tool?

There is no public benchmark, so estimate it from the work rather than the vendor's slide. Three things set the time: how quickly the firm can agree its definition and clocks, which is a decision rather than a build; access to the bound slips, the broker wordings and the shared placement inbox; and the length of the parallel run, which should cover enough deadlines and wordings to test the tool on the firm's real mix of classes and brokers.

Contract Certainty Management is configured from the firm's own requirements and documents: its slips, its wordings and the rules it works to. It reads mail only from the shared placement inbox the firm designates, not from individual mailboxes, which narrows the access question. The honest answer to "how long" is the time the firm needs to decide what it counts, plus a parallel run long enough to believe the count.

Where Contract Certainty Management fits, and where it does not

It fits a team that binds open-market risks on slips, receives broker wordings to agree, and wants every risk counted rather than sampled. It does the first read on every slip and wording, keeps the clocks and drafts the chasers; it never sends, clears or agrees. It is built to sit alongside the systems that hold the policy, not to replace them; reading documents from a particular portal is something to test in a trial.

It is the wrong tool if the gap is elsewhere. It cannot fix placements that are bound late, because a risk whose terms are agreed after inception fails the test regardless; it will name the brokers and classes where that happens. It does not decide what is material in a wording; the rules are the firm's settings. And it cannot help with risks whose documents never reach the firm in a form it can read. A firm whose real problem is one of those should fix that first; the FSA's 2004 warning that automation needs "process simplification, integration and discipline" beside it still applies.

The chaser released, and the reply matched as it arrives

Board at 17:02 on 12 October: Harwell Quay S1 lapsed at 17:00 and the chaser was released to Callum Reeve. The released chaser, by Hannah Mercer at 17:00, quotes the subjectivity from MRC page 4, notes the unsigned draft SOV held from 2 October and asks for the signed version by 17:00 on Wednesday 14 October. Below, Callum Reeve's reply at 17:02: apologies, signed SOV attached; the document matcher matched it to S1, signed and dated 12 October by the insured's CFO, TIV US$1,187,400,000, 1.1% above the draft; ready to clear.
The fictional sample chaser after release. The reply is matched to the subjectivity it answers and waits for the underwriter to clear it.

Questions people ask

Is Excel good enough for contract certainty?

For a small book with a disciplined analyst it can be, as a list. It cannot read slips, notice a deadline passing or compare a wording with a slip, so every one of those depends on someone's attention on the right day. The sample analyst kept around 60 open bound risks in a spreadsheet and found lapses when she happened to open the file.

Do brokers have to use a portal?

No UK or US rule we know of requires one; brokers send slips, evidence and wordings by whatever route the parties agree, such as a shared placement inbox. A certainty tool should therefore read documents from where they actually arrive. Contract Certainty Management reads the shared placement inbox the firm designates.

What is the difference between a contract certainty tool and a policy administration system?

A policy administration system holds the policy, the premium and the transactions once a contract exists. A contract certainty tool watches the gap before that point is finished: open subjectivities, wording drafts, documentation clocks and the certainty rate. The two sit side by side; neither replaces the other.

Can the tool send chasers automatically?

It can be set up to, but the sample settings require a person to release every chaser, because a chaser speaks for the insurer to the broker and may set a date after which terms are reviewed. Contract Certainty Management drafts at the deadline, quoting the slip; the analyst releases.

How do we test a tool before buying it?

Give it twenty of your own bound slips and their broker wordings, including some you know have problems, and compare its findings with your reviewers'. Ask it to compute last month's rate and name the failures. A tool that finds what your best reviewer finds, cites the page each time and never acts on its own is worth a parallel run.

Contract Certainty Management.
See it on your own files.

An agentic solution from Botminds. Every bound risk tracked from bind to final wording, with the ones still uncertain at inception named and chased. Book a demo, or explore how it works.