# Contract Redline Issue Log Worksheet

> Source: https://netray.co/tools/contract-redline-issue-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable issue log for contract negotiations with an impact times likelihood risk score per clause.

## Category

compliance-legal

## Industry

Discrete Manufacturing

## Audience

- Contracts manager
- Buyer
- Owner
- Supply chain manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Clause

**Key:** clause

**Type:** text

#### Topic

**Key:** topic

**Type:** select

**Options:**

- Price and payment
- Delivery and delay
- Warranty
- Liability and indemnity
- Intellectual property
- Confidentiality
- Termination
- Quality and audit
- Compliance and export
- Other

#### Their position

**Key:** their_text

**Type:** text

#### Our position

**Key:** our_ask

**Type:** text

#### Fallback

**Key:** fallback

**Type:** text

#### Impact (1-5)

**Key:** impact

**Type:** number

#### Likelihood (1-5)

**Key:** likelihood

**Type:** number

#### Risk score

**Key:** score

**Type:** number

**Expr:** impact * likelihood

**Format:** integer

#### Est. exposure

**Key:** exposure

**Type:** number

**Format:** currency

#### Status

**Key:** status

**Type:** select

**Options:**

- Open
- Proposed
- Agreed
- Escalated
- Accepted risk

#### Owner

**Key:** owner

**Type:** text

**Rows:**

#### Delivery and delay

**Clause:** 9.2

**Their text:** No delay damages

**Our ask:** 0.5% per week, cap 10%

**Fallback:** 0.25% per week, cap 5%

**Impact:** 4

**Likelihood:** 4

**Exposure:** 18000

**Status:** Proposed

**Owner:** Buyer

#### Warranty

**Clause:** 11.1

**Their text:** 6 months from shipment

**Our ask:** 24 months from commissioning

**Fallback:** 12 months from commissioning

**Impact:** 5

**Likelihood:** 3

**Exposure:** 40000

**Status:** Open

**Owner:** Quality

#### Liability and indemnity

**Clause:** 13.4

**Their text:** Cap at 10% of price

**Our ask:** Cap at 100% of price

**Fallback:** Cap at 50%, carve-out for IP

**Impact:** 5

**Likelihood:** 2

**Exposure:** 120000

**Status:** Escalated

**Owner:** Legal

#### Termination

**Clause:** 15.2

**Their text:** Only for cause

**Our ask:** Convenience with 90 days

**Fallback:** Convenience after year 2

**Impact:** 3

**Likelihood:** 3

**Exposure:** 12000

**Status:** Open

**Owner:** Owner

#### Price and payment

**Clause:** 7.1

**Their text:** Net 15

**Our ask:** Net 60

**Fallback:** Net 45

**Impact:** 2

**Likelihood:** 5

**Exposure:** 6000

**Status:** Agreed

**Owner:** Finance

**Totals:**

#### Total estimated exposure

**Key:** exposure

**Agg:** sum

**Format:** currency

#### Highest risk score

**Key:** score

**Agg:** max

**Format:** integer

#### Average risk score

**Key:** score

**Agg:** avg

**Format:** decimal

**Summary:**

#### Average risk score

**Key:** avg_score

**Expr:** avg_score

**Format:** decimal

**Description:** Average of impact times likelihood across all open and closed lines.

#### Average exposure per issue

**Key:** exp_per_issue

**Expr:** sum_exposure / count

**Format:** currency

**Notes:** A negotiation tracking tool, not legal advice. Rate impact and likelihood from 1 (low) to 5 (high). Scores of 15 or more are usually worth escalation. Exposure is your own estimate of money at risk if the clause goes against you.

## Content

**Intro:** Most contract negotiations are run from an email thread and a marked-up Word file. That works until you have forty open points and cannot see which ones matter. This worksheet keeps every issue in one table, scores the risk and lets you export to Excel.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per clause issue after your first read of the other side's draft. Write their position, your ask and a fallback you would accept. Score impact and likelihood from 1 to 5; the risk score is computed. Estimate the money at risk. Update the status after every call. Sort by risk score when preparing for a meeting so you spend time on the points that matter, and concede low scoring items first.

**Bullets:**

- One row per issue, not per paragraph
- Always write a fallback before the call
- Estimate exposure in money, even roughly
- Review the log with legal before signature

#### The scoring method

**Body:** Risk score is impact multiplied by likelihood, the same logic as a simple risk matrix. Impact reflects how bad the clause is if it bites: lost production, uncapped liability, lost IP. Likelihood reflects how probable that is in this relationship. A high impact, low likelihood clause such as a liability cap can still deserve attention. Consistent scoring across contracts helps you compare suppliers and customers.

#### Worked example

**Body:** In the sample, the warranty clause scores 15 (impact 5, likelihood 3) with USD 40,000 exposure, while payment terms score 10 and are already agreed. The liability cap scores 10 but is escalated because the exposure is USD 120,000. The total exposure line shows how much is still in play, which helps decide where to spend negotiation capital.

#### Common mistakes

**Body:** Teams log everything with the same weight, forget to record concessions, and lose the history of what was agreed on which call. Keep a dated note when status changes. After signature, move key obligations such as notice dates and audit rights into the contract renewal tracker so they are not forgotten.

**Cta:** Netray can help connect contract terms to ERP supplier and customer records so key terms are visible at the point of use. This is optional.

**Faq:**

#### How many issues should be on the log?

**Answer:** Log every point where you want a change or where the draft departs from your standard terms. For a typical supply agreement that is often 15 to 40 items. Long lists are fine if you sort by risk.

#### What is a good fallback position?

**Answer:** A fallback is the least favorable outcome you would still accept for that clause. Decide it before the call, ideally with legal or finance, so you do not concede under pressure.

#### Can I export it to Excel?

**Answer:** Yes. Every worksheet exports to Excel, CSV, PDF or Word. The risk score is exported as a value, so you can sort and filter in a spreadsheet.

#### Does this replace a lawyer?

**Answer:** No. It organizes your negotiation. Legal review of liability, indemnity, IP and governing law is advisable for any contract of significant value.

## Search terms

contract negotiation issue log, redline tracker excel, contract issues list template, clause negotiation tracker, supplier agreement issues log, contract review risk register excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json