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.
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
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.
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
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 |
Import this template and your reminders start the same day.
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.
No credit card required. Free plan available.