The law is in the documents. The tracking is in Excel
Every diligence exercise, contract register, obligation matrix, and matter budget in the profession runs on a spreadsheet somebody maintains by hand. SheetAI works in that spreadsheet, abstracting contract terms into rows with page references, reconciling WIP and realisation, and flagging what needs a lawyer rather than pretending it does not.

Clio's Legal Trends research has consistently found lawyers record a small share of an eight-hour day as billable, and collect less than they record. The gap is administration, tracking, and the reporting that surrounds the work, most of which is a spreadsheet exercise.
Source: Clio: Legal Trends ReportThis page is about the structured, repetitive work that surrounds legal practice rather than the practice itself: due diligence trackers, contract and obligation registers, matter budgeting and realisation analysis, e-billing review, entity and filing calendars, and the compliance matrices that regulated businesses maintain. SheetAI reads your documents into rows with page-level citations, builds the analysis in standard formulas, and flags ambiguity for a lawyer instead of resolving it. It does not give legal advice, it does not opine on whether a clause is enforceable, and it is not a substitute for professional judgement or supervision; the boundaries section says so in the terms your risk partner will want to see.
Where legal teams actually spend the day
Four numbers that explain why the profession's most-used software is still a spreadsheet.
Billable utilisation across the profession
Roughly 2.9 hours of an eight-hour day recorded as billable in Clio's research. Realisation and collection then reduce what is actually earned from that further.
Clio Legal TrendsAI performance on narrow contract issue-spotting
The LawGeex NDA study remains the most-cited controlled comparison. It measured a specific, well-defined task against a defined rubric, not legal judgement, and the distinction matters.
LawGeex (2018)Legal departments citing spreadsheets for matter tracking
Despite widespread matter management software, the actual tracking of diligence, obligations, and budgets overwhelmingly happens in Excel because every matter has a bespoke structure.
Legal operations surveysTime in a diligence exercise spent on extraction rather than analysis
Reading agreements to populate a tracker is the bulk of the hours in a transactional diligence review. The analysis that follows is the part clients actually pay for.
Practitioner experienceThe pattern: the extraction is mechanical and the judgement is not, but both currently consume the same lawyer's evening. Moving the extraction into the sheet, with a page citation on every field so it can be verified in seconds, is the change that gives the judgement its time back.
Anatomy of a diligence exercise
Where the hours go on a mid-market transactional diligence review, before any of it is automated.
Phase 1: Scope and build the tracker
- ›Agree the issues list with the client
- ›Build the tracker columns and conventions
- ›Assign documents across the team
Phase 2: Read and abstract
- ›Term, renewal, and termination mechanics
- ›Assignment and change-of-control provisions
- ›Liability caps, indemnities, and exclusions
Phase 3: Flag and escalate
- ›Identify provisions triggered by the transaction
- ›Escalate the genuinely problematic ones
- ›Chase the missing documents
Phase 4: Summarise for the report
- ›Aggregate findings by category and severity
- ›Cross-reference back to the source documents
- ›Draft the issues narrative
Phase 5: Track to completion
- ›Monitor consents and waivers obtained
- ›Update the tracker as documents arrive
- ›Reconcile against the disclosure schedule
When the spreadsheet is the control
In 2008, Barclays agreed to acquire assets from the collapsing Lehman Brothers. The contract schedule listing which trades were included was prepared under extreme time pressure in a spreadsheet, and rows that had been hidden rather than deleted were converted to PDF and included in the filed agreement. The result was that roughly 179 trades Barclays had not intended to acquire were captured by the executed document. The firm sought relief on the basis of clerical error. Nobody misunderstood the law; a hidden row in a spreadsheet made it into a signed agreement.
The lesson: In legal work the spreadsheet frequently is the control: the tracker is what determines what is disclosed, what is consented to, and what is acquired. That makes provenance and change history operational necessities rather than good practice. SheetAI records the source document and page behind every extracted term, logs every change it makes with a reversible diff, and flags ambiguity for a human instead of resolving it silently.
Source: Reuters: Barclays, Lehman and the hidden spreadsheet rowsWho it's for
If your matter is tracked in a workbook somebody updates by hand, start here.
Transactional Associates
Populate diligence trackers from hundreds of agreements under a closing deadline.
In-House Counsel
Maintain a contract register and obligation calendar with no dedicated system and no team.
Legal Operations
Analyse outside counsel spend and matter economics across e-billing exports.
Compliance Officers
Keep an obligations matrix current across jurisdictions and regulatory change.
Practice & Finance Managers
Report WIP, lockup, realisation, and matter profitability every month from raw exports.
Real legal workflows
The prompt, what the agent does, and what a supervising lawyer receives.
- ✓Reads each agreement and locates the relevant provisions.
- ✓Writes one row per agreement with dates as dates and caps as numbers.
- ✓Cites clause number and page against every extracted field.
- ✓Flags ambiguous or unusual drafting for a lawyer rather than resolving it.
22 agreements abstracted with clause-level citations, and 17 fields marked REVIEW across 9 documents. The review list was worked by an associate in an hour instead of the whole set being re-read.
Everything legal teams need, in the tracker they already keep
Clause-level citations on every extracted term, ambiguity flagged rather than resolved, and matter economics computed from your raw exports in formulas anyone can audit.
Plays well with your stack
- Data-room document exports
- Practice management exports (Clio, Aderant, Elite)
- E-billing and LEDES exports
- Contract lifecycle management exports
- Companies House and registry downloads
- Word and PDF agreement attachments
What one diligence exercise looks like
A representative mid-market transactional diligence review across 22 material agreements, before and after the extraction moves into the sheet.
Before SheetAI
~44 hours- MonScope the issues list; build the tracker; allocate documents~6h
- TueRead and abstract the first tranche of agreements~11h
- WedSecond tranche; conventions have already drifted~11h
- ThuFlag triggered provisions; chase missing documents~9h
- FriSummarise for the report; re-open documents to cross-reference~7h
With SheetAI
~12 hours- MonTracker built; agreements abstracted with clause citations~3h
- TueREVIEW list worked by an associate; ambiguities resolved~3h
- WedChange-of-control exposure grouped and value-ranked~2h
- ThuConsent workstream started with the report drafted from cited rows~4h
~73% reduction on a representative 22-agreement diligence exercise.
What SheetAI will not do
In a regulated profession the limits are not caveats, they are the terms on which the tool can be used at all.
Give legal advice
It extracts, organises, and computes. It does not advise on whether a clause is enforceable, what a provision means in a given jurisdiction, or what course of action a client should take. Every output is work product for a qualified lawyer to review and adopt, and it should be treated exactly as you would treat a junior's first draft: useful, and not yet advice.
Resolve ambiguous drafting
Where a provision could reasonably bear two readings, it says so and flags it. This is deliberate: an extraction tool that quietly picks the more likely interpretation produces a tracker that looks complete and is silently wrong. The REVIEW column is the most valuable output on the sheet, and it is usually short.
Replace supervision or conflict checks
Professional conduct obligations (supervision of work product, conflicts, client confidentiality, and privilege) are yours and do not transfer to a tool. Nothing here substitutes for the supervising solicitor's or attorney's review, and no output should reach a client without it.
Guarantee privilege is preserved
Processing privileged material through any third-party service raises questions your firm's risk function needs to answer, not your software vendor. Check your professional indemnity terms, your client engagement letters, and your jurisdiction's guidance on cloud processing before putting privileged documents through this or any comparable tool.
What changed was not the speed, though that was real. It was the citations. Every line in the tracker points at a clause and a page, so when the partner challenges an entry it takes ten seconds instead of reopening the document set. The REVIEW column is the first thing I read now; it is where the actual work is.
Frequently asked
The questions risk partners and general counsel ask first.
Does this give legal advice?
›
How accurate is contract abstraction?
›
What happens with ambiguous drafting?
›
Can I use it on privileged or confidential material?
›
Will it work with our existing tracker format?
›
Can it help with matter profitability and WIP?
›
Does it handle e-billing review?
›
Is there an audit trail?
›
Sources & further reading
Every benchmark and statistic on this page is drawn from publicly available research. We cite our sources because we read theirs.
- Clio: Legal Trends Report↗
Annual research on law firm economics, including billable utilisation of roughly 2.9 hours per eight-hour day and the realisation and collection gap that follows.
- LawGeex: AI vs. Lawyers NDA Study (2018)↗
Controlled comparison on NDA issue-spotting: the automated system averaged 94% accuracy against 85% for experienced commercial lawyers, completing the task in a fraction of the time.
- Reuters: Lehman and Barclays contract schedule error (2008)↗
Hidden spreadsheet rows converted to PDF and included in a filed agreement, capturing roughly 179 trades not intended to be acquired.
- Solicitors Regulation Authority: Standards and Regulations↗
The professional conduct framework governing supervision of work product, confidentiality, and competence in England and Wales.
- American Bar Association: Legal Technology Resource Center↗
Ongoing research and guidance on technology adoption in US legal practice, including professional responsibility considerations for third-party services.
- EuSpRIG: Spreadsheet Risk Research↗
Documented spreadsheet failures across sectors, including several where a tracking spreadsheet functioned as an operative legal or financial control.
Related teams using SheetAI
Adjacent functions that hit the same kinds of problems.
Stop retyping clauses.
Start reviewing them.
Attach a set of agreements, name the columns your tracker uses, and get abstracted rows with a clause citation on every field, and an honest list of what needs a lawyer.
Pay as you go, no subscription required