# Extract Treaty Layers, Retentions, Premiums and Commissions to Excel | Ultrassure URL: https://ultrassure.com/use-cases/extract-treaty-economics-to-excel Source: Ultrassure (ultrassure.com), AI contract intelligence for insurers, MGAs, brokers, and reinsurers. Capture reinsurance deal economics (layers, retentions, shares, premiums, commissions and brokerage) from the contract, check each number against its clause and export to Excel or CSV. ## Page content Use case # Extract layers, retentions, premiums and commissions from a treaty into Excel. For reinsurance accounting, actuarial and underwriting operations teams. Ultrassure reads the treaty and its endorsements, captures the deal economics (layers, quota shares, retentions, cessions, premiums, commissions and brokerage) as structured fields, shows each number next to the clause it came from, and exports the result to Excel or CSV, or through the REST API. You need the signed treaty and any endorsements that change the terms. Who it’s for : Reinsurance accounting, actuarial and underwriting operations What you need : The treaty wording, schedules and any endorsements What you get : Structured economics per layer, each value cited, ready to export Where it goes : Excel or CSV, your core systems, or the REST API [See it on your documents](https://ultrassure.com/demo)[Try free](https://ultrassure.com/try) The finished result ## Sample economics export Sample data for illustration. Not from a real contract. | Layer | Limit | Retention | Placed share | Premium | Ceding commission | Brokerage | Source | | --- | --- | --- | --- | --- | --- | --- | --- | | Quota share | — | — | 40% | Per subject premium | 32.5% | 1.0% | Art. 4, p. 7 | | 1st excess of loss | USD 20m | USD 10m | 100% | USD 1.8m (rate on line 9%) | — | 10% | Schedule A, p. 2 | | 2nd excess of loss | USD 40m | USD 30m | 100% | USD 2.2m | — | 10% | Schedule A, p. 2 | Illustrative product view Step by step ## One complete example. 1. 01 ### Upload the treaty and its endorsements Upload the wording, schedules and any endorsements or addenda that change the economics, or bring them in from SharePoint, a virtual data room or S3. 2. 02 ### Let the Economics Engine capture the terms Layers, quota shares, retentions, cessions, premiums, commissions, brokerage and other financial terms are captured as structured fields. 3. 03 ### Check each number against its clause Every value sits next to the clause it came from, so the reviewer can confirm it at a glance instead of searching the document. 4. 04 ### Resolve anything flagged Values that are unclear in the source, for example on a poor scan, are flagged for a person to confirm. 5. 05 ### Export to your systems Send the validated economics to Excel or CSV, to your core systems, or through the REST API, without re-keying. ## Questions that could stop you Does it handle multi-layer programs? Yes. Economics are captured per layer and per quota share, so a program with several layers comes out as one row per layer. What about endorsements that change premium or commission? Upload them with the treaty. They become part of the same contract record, so the reviewer sees the endorsement next to the original term. Does this replace our accounting or policy admin system? No. It feeds those systems with structured, cited terms so nobody has to re-key them from the PDF. How accurate is it? In the treaty-renewal case study, accuracy on critical structured fields was about 99% after a human review pass, with ambiguous items flagged rather than guessed. Is our contract wording used to train AI models? No. Customer contracts, prompts, outputs and embeddings derived from customer data are not used to train, retrain or fine-tune generally available or third-party foundation models. Who can see the documents? Access is controlled with role-based permissions and every action is recorded in audit logs. Ultrassure can support SSO, including Microsoft Entra ID, and is SOC 2 Type II certified. See the [Trust Center](https://ultrassure.com/trust). Do we need a paid plan to try this? You can [try Ultrassure free](https://ultrassure.com/try) with no credit card, or [book a demo](https://ultrassure.com/demo) and see this workflow run on your own documents. Plans for production use are scoped with you on the demo. ## When you don’t need Ultrassure If you write a handful of simple quota shares on standard terms that are already keyed into your system, manual entry may be quicker than setting up a new tool. Ultrassure pays off when programs have several layers, endorsements change the numbers mid-term, or terms need to be checked against the wording before they reach accounting. ## Start here [**Book a demo on one of your treaties**](https://ultrassure.com/demo)[**See the Accounting solution**](https://ultrassure.com/solutions/accounting)[**Quota share vs excess of loss, explained**](https://ultrassure.com/resources/answers/quota-share-vs-excess-of-loss-reinsurance) ## Other use cases [Use case**Compare expiring and renewal treaty wording, clause by clause** Upload the expiring and renewal treaty bundle and get a cited "what changed" report by clause: limits, retentions, hours clauses, exclusions and endorsements.](https://ultrassure.com/use-cases/compare-treaty-renewal-wording)[Use case**Check policy and treaty wording against your underwriting guidelines** Turn underwriting rules and contract standards into automated checks that flag missing or non-compliant language in policies and treaties, with the clause cited.](https://ultrassure.com/use-cases/check-wording-against-underwriting-guidelines)[Use case**Answer questions about a contract, with the page and clause cited** Ask plain-language questions about policies, treaties and endorsements and get answers linked to the exact page and clause, so every answer can be checked.](https://ultrassure.com/use-cases/answer-contract-questions-with-citations) Building the tools we wish we had as underwriters. ## Make every promise provable. No credit card required · Typically live in 4 business days