A contract register is the single, authoritative list of every contract your organisation holds — who with, for what, worth how much, and running until when. Without one, contracts auto-renew unnoticed, expire mid-supply or roll on at outdated prices. This free Excel template gives you a structured register with counterparty, value, start and end dates, notice period and owner, and it flags contracts approaching expiry automatically so you can renegotiate or exit in good time.
Why keep a contract register
Contracts that no one is watching cost money: an auto-renewal you meant to renegotiate, a price escalation you missed, or a critical agreement that lapsed just as you needed it. A register makes every commitment visible in one place so nothing slips through.
It also gives you leverage. Knowing exactly when a contract ends — and how much notice you must give — means you go into renewals early and prepared, not scrambling at the last minute from a weak position.
How to use this contract register template
Build and maintain your register:
- Add a row for each active contract with its counterparty and category.
- Record the value, start and end dates, and the notice period required.
- Let the template calculate days to expiry and flag upcoming renewals.
- Mark any auto-renewing contracts so you review them before they roll over.
- Assign an owner to each contract and review the register regularly.
Contract register best practices
Make the register the single source of truth — every new contract goes in immediately, with a link to the signed document. Set your renewal review far enough ahead of the notice deadline to act, especially for critical suppliers. Assign a clear owner to each contract so renewals have an accountable person, and review the whole register on a regular cadence rather than reacting to expiries one at a time.
Download the Contract Register Template
Free, editable Excel (.xlsx). Complete the form above and your download starts instantly.
Common questions
What is a contract register template?
A contract register template is a spreadsheet that lists every contract an organisation holds — counterparty, value, dates, notice period and owner — so contracts are tracked centrally and renewals or exits are never missed.
What should a contract register include?
Counterparty, contract description and category, value, start and end dates, notice period, auto-renew status, owner and a link to the document. This register captures all of these and flags upcoming expiries.
Is this contract register template free?
Yes. Enter your work email above and the editable Excel file downloads immediately, at no cost.
How does the expiry alert work?
The template calculates the number of days between today and each contract's end date and flags those approaching expiry, so you can start renewals or exits before the notice deadline passes.
More free procurement tools
Procurement Policy Template
An editable Word procurement policy covering approval limits, sourcing rules, PO controls and ethics.
Supplier Scorecard Template
An Excel scorecard to track a supplier's ongoing performance on weighted KPIs, with an automatic rating.
Payment Terms Calculator
Model the cash impact of the payment terms in your contracts.
Procurement Academy
Guides, research and tools organised by procurement topic.
All free tools & templates
Browse every Lapasar procurement calculator and template.