Free template

Free Software License Tracking Template (Excel & Sheets)

Software renews whether or not anyone is using it. Our free software license tracking template keeps every license and subscription in one place, with one row per product. It works out each cancel-by date, flags seats nobody uses, converts costs to USD and turns licenses red as their renewals get close.

Download for ExcelUse in Google Sheets

No email needed. For Google Sheets, upload the Excel file to Drive and choose File → Save as Google Sheets. Prefer automatic reminders? Start a free ExpirePilot trial, no credit card required.

Cancel-by dates worked out for youUnused-seat alertsCosts in 15 currencies12 sample licenses

Preview: the License Tracker tab
License tracker12 sample licenses · sorted by renewal date
1 expired
Microsoft 365 Business StandardMicrosoft · Auto-renews · Cancel-by date has passedAct now
Slack ProSalesforce · 63 people using 60 seatsOver-allocated
Adobe Acrobat ProAdobe · 11 of 25 seats unused · $2,376 a yearUnder-used
Zoom Workplace BusinessZoom · GBP · 60 days' noticePlan
Salesforce Sales CloudSalesforce · Enterprise agreement · 90 days' noticeOn track
Cancel-by date = renewal date minus notice period. Seat check compares seats in use with seats bought.

The template works in Excel and Google Sheets. It comes with a dashboard, a seat assignment sheet, a renewal log and a guide to 12 license types. Below the download, you’ll find what each column means, how the renewal alerts work, and when a spreadsheet stops being enough.

→Skip the spreadsheet

Rather have the reminders sent for you?

A spreadsheet only works if someone opens it. ExpirePilot tracks the same licenses and emails the right people before every renewal and cancel-by date, then follows up until someone acts.

Start free trial →

14-day free trial, no credit card required. Free plan for up to 20 items.

What ExpirePilot adds to this template

  • Import this template in minutes, or scan invoices and contracts and let AI fill in the dates for you to check
  • Reminders on your schedule, to the license owner, your team or the vendor
  • Follow-ups and escalation to a manager when nobody acts
  • The contract or invoice stored with each record
  • A log of every reminder sent, opened and clicked

See all features →

iDefinition

What is a software license tracking template?

A software license tracking template is a spreadsheet that lists every software license and subscription your organization pays for, one row per product, with its vendor, license type, seats bought and in use, owner, cost and renewal date. Formulas work out the cancel-by date, the days left and how many seats sit unused, so you can renew, cut seats or cancel before you’re billed again.

!Why teams start one

A subscription renewed and nobody noticed

Most teams start a license tracker right after a tool renews for another year at full price.

Someone left, but their seat kept billing. A design tool auto-renewed for 25 users when 14 use it. An enterprise agreement needed 90 days’ notice and the window closed. The invoices exist somewhere; what’s missing is one view of seats, costs and dates, with a person named next to each one.

A software license tracker is useful if you're:

  • An IT manager or sysadmin who handles SaaS subscriptions, keys and seat counts
  • On a finance or procurement team trying to control software spend and renewals
  • A small business owner or office manager paying for a dozen tools on company cards
  • Preparing for a vendor license audit and need a clean record of what you own

✓What’s included

What's included in the free template

One workbook with seven tabs. Everything is already built, so you only need to add your licenses. A Start here tab explains each one.

Tab 1

License Tracker

Where you list your licenses: 32 columns, from ID to Notes. Dropdowns for category, license type, billing cycle, currency and compliance keep entries consistent. Free seats, annual cost, cancel-by date and status work themselves out.

Tab 2

Dashboard

A one-screen summary that updates as you edit: annual spend in USD, money spent on unused seats, seat utilization, expired and expiring licenses, the next 10 renewals, spend by month, category and license type, and two charts.

Tab 3

Seat Assignments

One row per person per license, with the date they last used it. Seats unused for 90 days are flagged “Reclaim?” so you can cut them before renewal.

Tab 4

Renewal Log

A record of every renewal decision: seats and annual cost before and after, the change in dollars and percent, and who handled it.

Tab 5

License Types

A quick reference for 12 license models, from per-user and concurrent to OEM and core-based: how each is counted, what to track and what to watch out for.

Tab 6

Lists

Change the dropdown lists and the exchange rates used to convert each cost to USD. A Start here tab with setup steps and a colour key comes first.

Already set up for you

Open the file and start adding licenses. Nothing to configure first.

  • Colour-coding: red when a license has expired or more people use it than you pay for, orange at 30 days or fewer, yellow at 31–90 days or below 70% of seats in use, green otherwise
  • Frozen header row and filters, so you can sort by renewal date, owner or vendor
  • Grey formula columns, so it’s clear which cells work themselves out
  • 12 sample licenses with dates that move with today, so the dashboard always shows how the alerts look

#Columns

Software license tracker columns, explained

Each row is one license or subscription. The columns marked auto work themselves out from your entries, so you never fill them in.

Col Column What to enter Example
A ID auto Fills in as LIC-001, LIC-002… when you add a name LIC-001
B Software name The product you pay for Microsoft 365
C Version / edition Plan, tier or version Business Standard
D Vendor Who bills you Microsoft
E Category Type of software (dropdown) Productivity & office
F License type How it’s counted (dropdown) Subscription (SaaS)
G License key / contract ID Key, agreement or order number MS-AGR-48213
H Seats bought Licenses you pay for 50
I Seats in use Seats actually assigned or used 46
J Seats free auto Seats bought minus seats in use; red if negative 4
K Utilization auto Share of seats in use, with a data bar 92%
L Seat check auto OK, Under-used (below 70%) or Over-allocated OK
M Department Team that uses it IT
N License owner The one person who decides on renewal Dana Reyes
O Owner email Where reminders should go dana@example.com
P Region / entity Office, country or legal entity UK – Ltd
Q Purchase date When you first bought it Nov 26, 2025
R Renewal / expiry date When it renews or expires Nov 26, 2026
S Billing cycle Monthly, Annual, 3-year, One-time… (dropdown) Annual
T Cost per cycle The amount on one invoice 7,500.00
U Currency Invoice currency (dropdown; blank = USD) USD
V Annual cost (USD) auto Cost × cycles per year × exchange rate $7,500
W Unused seat cost auto Share of annual cost paid for free seats $600
X Auto-renew? Yes or No Yes
Y Notice period (days) Days’ notice the vendor needs to cancel or change 30
Z Cancel-by date auto Renewal date minus notice period Oct 27, 2026
AA Days to renewal auto Counts down to the renewal date 20
AB Renewal status auto Expired, Due ≤30 days, Due ≤90 days or Active Due ≤30 days
AC Compliance Result of your last check (dropdown) Compliant
AD Last audit date When you last checked it Sep 7, 2026
AE Contract / invoice link Where the paperwork lives Link
AF Notes Anything else Price locked until 2027

→How to use it

How to use the software license tracking template

About an hour to set up 30 licenses, then 10 minutes a month.

Step 1

Download it

Download the Excel file, or upload it to Google Drive and save it as a Google Sheet. Keep it where IT and finance can both reach it.

Step 2

Clear the sample rows

See how the 12 examples fill each column and change colour, then delete the rows marked “Example row” in Notes. Leave the grey formula columns alone.

Step 3

Find every license

Check invoices, card statements and each tool’s admin console. Card statements are where forgotten SaaS subscriptions turn up.

Step 4

Fill in seats and notice periods

Seats bought vs in use drives the unused-seat alerts. The notice period, from the contract or terms, drives the cancel-by date.

Step 5

Set currencies and an owner

Pick each license’s currency and update the rates on the Lists tab. Name one owner per row and tell them.

Step 6

Check the dashboard monthly

Act on anything red, plan for anything yellow, and reclaim unused seats a month before each renewal, not after.

!Renewal alerts

How the renewal and seat alerts work

The template warns you in three ways: a cancel-by date that shows your real deadline, a seat check that finds money you’re wasting, and colour-coding so urgent rows stand out.

1. The cancel-by date

The date that matters isn’t the renewal date. It’s the last day you can cancel or reduce seats. If a license renews on March 1 and needs 30 days’ notice, your real deadline is January 30.

Days to renewal counts down every time the file opens. When an auto-renewing license gets within 30 days of its cancel-by date, that cell turns orange; once it passes, red.

Cancel-by date (Z8):    =IF(OR(R8="",Y8=""),"",R8-Y8)
Days to renewal (AA8):  =IF(OR(B8="",R8=""),"",R8-TODAY())

Both formulas are already filled in on the template, for 300 rows. They’re shown here if you’re building your own.

2. The seat check

Most vendors bill for the seat count on the renewal date, so unused seats are the easiest money to save. The template compares seats in use with seats bought and puts a dollar figure on the gap.

Seats free (J8):        =H8-I8
Utilization (K8):       =I8/H8
Unused seat cost (W8):  =MAX(0,J8)/H8*V8

Over-allocated (more people than seats) is a compliance risk; Under-used (below 70%) is a saving waiting to happen.

3. Colour-coding

The Renewal status column colours each license by how close its renewal is. The Dashboard counts each group and lists the next 10 renewals with their cancel-by dates.

Status When What to do
Expired Renewal date has passed Renew, replace or remove it
Due ≤30 days 30 days or fewer left Decide now; check the cancel-by date
Due ≤90 days 31 to 90 days left Review seats, get quotes, negotiate
Active More than 90 days left Nothing to do yet

?License types

Software license types explained

The license type decides what you count and what can go wrong at renewal. The template has this reference on its own tab.

License type How it’s counted What to track
Subscription (SaaS) Paid monthly or yearly; stops working if you stop paying Renewal date, auto-renew, seat count
Per-user (named) One license per named person, on any device Who holds each seat; leavers
Concurrent (floating) A shared pool; limits how many use it at the same time Peak use vs seats bought
Per-device One license per computer or device Asset tag; retired devices
Perpetual Bought once; updates need a yearly maintenance plan Proof of purchase, maintenance renewal
Site Unlimited use at one location or company Which sites or entities are covered
Volume / enterprise agreement Bulk deal over 1–3 years, often with yearly true-ups Term end, true-up date, notice period
OEM Pre-installed and tied to one device The device it came with
Core / processor-based Priced by CPU cores on the server Cores per server, virtualization
Free / freemium Free tier with limits; paid tier unlocks more Who signed up; company data stored there
Open source Free to use; the license sets rules for sharing code License name (MIT, GPL…) and where it’s used
Trial / evaluation Time-limited free use before buying Trial end date; card on file

$Save at renewal

How to cut software costs at renewal

The month before a renewal is when you have the most leverage. Use the tracker to walk in with numbers.

  • Reclaim seats first. Remove leavers and anyone flagged “Reclaim?” on Seat Assignments before the renewal date sets the count.
  • Watch the notice period. Contracts with 30–90 days’ notice renew long before the renewal date. Act by the cancel-by date.
  • Plan for true-ups. Volume agreements often bill once a year for seats added mid-term. Track seats in use so the bill isn’t a surprise.
  • Negotiate with history. The Renewal Log shows what you paid last time and what changed. Bring it to the vendor call.
  • Merge overlapping tools. Filter by category: two chat tools or three file-sharing apps usually means one can go.
  • Switch off auto-renew you didn’t choose. If a tool is under review, turn it off and decide before the date.

vsWhen to move on

When a license tracking spreadsheet stops being enough

A spreadsheet works well for a few dozen licenses and one careful owner. It gets risky when more people, more tools or more renewal dates are involved.

Capability This template ExpirePilot
Renewal and cancel-by dates in one place Yes Yes
Unused-seat and cost totals Yes Totals in reports
Reminders before each date Only when someone opens the file Emails each owner on your schedule
Follow-up when nobody acts No Escalates to a manager
Invoices and contracts stored with each record Link only Attached files
Dates read from documents Typed by hand AI scanning for you to check
Several people editing safely Risky with copies Team roles: Owner, Admin, Member, Viewer
Proof for auditors Renewal Log you keep up Reminder log and Excel/PDF reports
Start free trial →

Import this template and your reminders start the same day.

?FAQ

Frequently asked questions

Still have a question? Email support@expirepilot.com.

Yes. Download the Excel file and use it in Excel or Google Sheets. No email or sign-up is needed, and you can use and change it however you like.

Yes. Upload the Excel file to Google Drive and choose File → Save as Google Sheets. Formulas, dropdowns and colours carry over, and dates follow your spreadsheet’s locale.

The renewal date is when the license renews or expires. The cancel-by date is the last day you can cancel or reduce seats: the renewal date minus the notice period. A license renewing March 1 with 30 days’ notice has to be changed by January 30.

A software inventory lists what’s installed on each device. License tracking records what you’re entitled to use: seats bought, contract terms, costs and renewal dates. Comparing the two shows whether you’re over or under licensed.

Yes. Pick each license’s currency from the dropdown and set exchange rates on the Lists tab. Each cost is converted so the dashboard can total spend in USD. The rates in the file are examples, so update them first.

The License Tracker has formulas ready for 300 licenses, Seat Assignments for 500 people and the Renewal Log for 200 entries. To add more, copy the last row’s formulas further down.

Yes. ExpirePilot imports Excel and CSV files, so you can bring in this tracker as it is. The free plan covers up to 20 items, and every account starts with a 14-day trial with no credit card.

Never pay for another forgotten license

Keep using the free template, or let ExpirePilot remind the right people before every renewal and cancel-by date.

Start free trial →Download the template

No credit card required. Free plan available.

Privacy Preference Center