Preserve the original value before normalising it
A European contract portfolio can contain pounds, Swiss francs, Norwegian kroner, euros, and amounts stated only with a symbol. Record the original amount, currency wording, and source clause before converting or aggregating anything.
Separate a stated price from a deposit, annual fee, liability cap, penalty allegation, or illustrative example. The same number may recur in several roles. A matrix should identify what the amount represents so a business user cannot mistake every extracted figure for revenue or exposure.
Capture units, formulas, and qualifications
| Value type | Additional information to extract |
|---|---|
| Fixed amount | Currency, tax wording, and applicable period |
| Fee-based cap | Multiplier, fee definition, and reference period |
| Indexation | Named index, base date, and adjustment wording |
| Percentage | The amount or event to which it applies |
| Range or estimate | Whether it is binding, indicative, or conditional |
Quote the relevant definitions and exceptions. Keep missing inputs visible instead of converting an incomplete formula into a precise-looking number.
Work through a cap that cannot yet be calculated
Assume a services agreement caps a category of liability by reference to fees paid in a preceding period. The supplied contract states the formula, but the accounting records are absent. The correct extraction is the formula and its conditions, with a request for the missing fee data.
If a schedule lists an annual budget, do not silently substitute it for fees actually paid. Ask the legal and finance reviewers to confirm the inputs and interpretation. Preserve any exclusions or separate caps because combining them into one total may misstate the agreement's risk allocation.
Document conversion assumptions when comparison is needed
If the business needs a reporting-currency comparison, keep the converted figure in a separate field. Record the exchange-rate source, date, convention, rounding, and purpose. Do not change the original contractual amount.
The ECB describes its reference rates as informational and not necessarily the rates of actual transactions. That is a reason to choose the rate appropriate to the reporting task with the finance team, not to assume any published rate is contractually controlling. This workflow does not provide financial or valuation advice.
Verify the spreadsheet another team will use
Review the exported columns for lost currency labels, locale-dependent decimal separators, truncated formulas, and values converted to text. A correct source extraction can become misleading during spreadsheet handling.
Provide a data dictionary explaining each amount field and an exception list for missing inputs. Distinguish extracted facts, calculated comparisons, and legal conclusions visually through clear labels. Judicio's Review Matrix can support structured extraction and export; the team should still verify calculations and the business interpretation before relying on the report.
Sources and next steps
This is an editorial workflow guide for legal professionals. The suggested checks are our practical recommendations, not a statement that a regulator requires a particular software workflow.
Explore Review Matrix and Document Review, or review Judicio's regional coverage and limitations. Check the underlying source and your organisation's approved process before relying on an output.