Most companies can tell you what they pay for software. Far fewer can tell you who is actually using each license, how many seats are sitting idle, or which contract auto-renews next month. And that gap is where your money leaks out and where audit surprises come from.

In this guide, we show you how to track software licenses with a method that works with any tool: spreadsheet, free asset tool, or full platform. You’ll get the fields to record, a five-step process, how to check Microsoft 365 and Google Workspace seats, and a free template you can start with today.

Quick answer: to track software licenses, keep one register of every license and run the same five steps on a schedule:

  1. Discover every license from invoices, card statements and admin consoles.
  2. Record each one: vendor, license type, seats, assigned users, cost, renewal date, notice period and owner.
  3. Reconcile seats bought against seats actually assigned and used.
  4. Reclaim unused seats and cancel what nobody needs.
  5. Automate renewal alerts so every owner hears about a deadline before the cancel-by date.

Why track software licenses?

Tracking software licenses means keeping an up-to-date record of every piece of software your company pays for or is bound by: what you bought, how many seats, who has them, what it costs and when it renews. And it really matters for three reasons.

  • Cost. Unused seats are pure waste. Zylo’s 2026 SaaS Management Index puts average unused licenses at 46% and the average organization’s waste at $19.8M a year. And those are mostly large-company numbers, but the pattern is the same in a 30-person office: people leave, tools get replaced, and the seats keep billing.
  • Renewals. Many subscriptions auto-renew and need 30 to 90 days’ notice to cancel or reduce seats. If you can only learn about the renewal from the invoice, you’ve already missed the window.
  • Compliance. Using more installs or users than you bought breaks the license terms. Vendors such as Microsoft, Oracle and Adobe audit customers, and a shortfall is billed at list price.

The real deadline here is the cancel-by date, not the renewal date. Renewal date minus the vendor’s notice period is the last day you can cancel, downgrade or cut seats. Track that date and alert on it.

What are the types of software licenses?

When people ask about the “four types of software licenses”, they usually mean the legal categories that decide what you may do with the code:

  1. Public domain: no restrictions at all.
  2. Permissive open source (MIT, Apache 2.0, BSD): free to use and modify; keep the copyright notice.
  3. Copyleft open source (GPL, LGPL, AGPL): free to use, but if you distribute changes, you must share them under the same license.
  4. Proprietary (commercial): you pay for the right to use it, on the vendor’s terms.

Open source licenses matter mostly to software teams shipping code. For day-to-day tracking, what counts is how a commercial license is counted, given that it decides what you record and what you check:

License model How it’s counted What to track
Subscription (SaaS) Per user or per seat, billed monthly or yearly Seats bought vs assigned, renewal date, notice period, auto-renew
Perpetual One-time purchase of a version License key, version, maintenance/support end date, upgrade rights
Named user One license per named person Who holds each seat; remove it when they leave
Concurrent (floating) Maximum people using it at the same time Peak concurrent use vs the limit
Device / node-locked Tied to one computer Device name or asset tag; move it when the device is replaced
Core or processor-based Server cores or CPUs (common for Microsoft SQL Server and Oracle) Server, core count, virtualization setup
Usage or credit-based API calls, storage, credits or AI tokens Monthly usage vs budget, overage price
Trial / freemium Free for a period or up to a limit Trial end date, who signed up, whether a card is on file

What should you record for each license?

One row per license or subscription. These are the fields that actually pay for themselves; anything more is optional.

Field Why it matters Example
Software and edition Different editions have different prices and rights Microsoft 365 Business Standard
Vendor or reseller Who bills you and who you call at renewal Microsoft via a CSP partner
License type Decides how compliance is counted (table above) Subscription, per user
Key, contract or order ID Proof of purchase in an audit Agreement number
Seats bought / seats in use Shows waste and over-use at a glance 50 / 46
Assigned users or devices Needed for named-user and device licenses Linked list or the admin console
Cost and billing cycle Annual cost and cost of each unused seat $7,500 a year
Renewal or expiry date Drives every alert Nov 26, 2026
Auto-renew and notice period Gives you the cancel-by date Yes, 30 days
Owner One person who decides at renewal; reminders go to them Dana Reyes, IT
Contract and invoice link So the paperwork is one click away Link to the file

Our free software license tracking template has all of these columns already set up, plus formulas for seats free, utilization, unused seat cost, the cancel-by date and days to renewal.

How to track software licenses, step by step

The first pass can take a few hours for a small company. And after that it’s a short monthly check plus a deeper review before each big renewal.

Step 1: Discover every license

Software comes in through more doors than IT sees. You can check all of them:

  • Accounts payable and card statements for the last 12 months. You can search for recurring charges; this is where forgotten SaaS turns up.
  • Expense reports, where your teams buy tools on personal or team cards.
  • Admin consoles of your main platforms (Microsoft 365, Google Workspace, Adobe, Slack, Zoom).
  • Single sign-on and identity tools, which list every app people sign in to.
  • Device inventory (an MDM or inventory agent) for installed desktop and server software.
  • Department heads. Ask each one: “What do you pay for that IT may not know about?”

Step 2: Build the inventory

You can put everything into one register, one row per license, with the fields above. Then pick one home for it that IT and finance can both reach. Name an owner for every row; a license without an owner is the one that renews by surprise.

Step 3: Reconcile what you bought against what you use

For each license, compare three numbers: seats bought (from the contract or invoice), seats assigned (from the admin console) and seats actually used (people who signed in during the last 30 to 90 days). Then look for:

  • Over-allocation: more users or installs than you bought. Fix it before an auditor finds it.
  • Shelfware: seats bought but never assigned.
  • Inactive users: seats assigned to people who left or no longer log in.
  • Duplicates: two tools doing the same job, often bought by different teams.

Step 4: Reclaim and right-size

You can remove seats from leavers, reassign idle seats before buying new ones, and move light users to a cheaper edition. Then make “remove software licenses” a line on your offboarding checklist, so that your seats come back on the person’s last day rather than at renewal.

You have to make the big cuts about a month before each cancel-by date. Given that many vendors only let you reduce seats at renewal, cutting mid-term may save nothing until then.

Step 5: Automate renewal alerts

You can set reminders on the cancel-by date, not the renewal date: for example 90, 30 and 7 days before. Send each one to the license owner, and copy a manager if nobody acts. Calendar entries work for a handful of licenses; past that, use a tool that sends the reminders and keeps a log of who was told and when.

To give you a concrete example, at ExpirePilot, we don’t simply put the renewal date in a calendar. We suggest entering the cancel-by date as the deadline, so that the reminder reaches the license owner, with escalation to their manager if nobody acts, while you can still change something.

  1. Monthly: update seats in use, check anything due in the next 90 days.
  2. Quarterly: reconcile the top 10 licenses by cost and reclaim idle seats.
  3. Yearly: rerun discovery (Step 1) to catch new tools.

How do you check Microsoft 365 and Google Workspace licenses?

These two are typically a company’s biggest subscriptions, and both admin consoles show bought and assigned licenses side by side.

Microsoft 365

  1. Sign in to the Microsoft 365 admin center with an admin account (at least License Administrator to make changes).
  2. Go to Billing > Licenses and open the Subscriptions tab. Each product shows how many licenses you have and how many are assigned.
  3. Open a product to see who holds each license. The Users and Groups tabs show whether a license was assigned directly or through a group.
  4. Go to Billing > Your products for subscription details such as renewal dates and billing frequency.

Google Workspace

  1. Sign in to the Google Admin console with an administrator account.
  2. Go to Menu > Billing > Subscriptions. Each subscription shows its payment plan and the number of available and assigned licenses.
  3. On an Annual Plan you pay for the licenses you committed to, whether or not they’re assigned; on a Flexible Plan you pay for assigned licenses, so removing unused ones lowers the bill.
  4. To remove licenses from users, go to Menu > Directory > Users, select them and use More > Remove licenses.

You can copy the bought and assigned numbers into your register each month. Most other SaaS tools (Adobe, Slack, Zoom, Atlassian) have a similar billing or licenses page in their admin area.

Which tracking method fits your company size?

There’s no need to buy a platform on day one. So match the method to how many licenses you actually have and how much they cost.

Method Best for Strengths Limits
Spreadsheet (Excel or Google Sheets) Up to about 30–50 licenses, one person in charge Free, flexible, everyone can open it No reminders, no history, depends on someone remembering to update it
Free, open-source asset tools (Snipe-IT, GLPI) IT teams that also track hardware and can host a server Seats checked out to users or devices, expiry alerts, audit history You install, update and secure it; setup takes time
Expiration reminder software (such as ExpirePilot) Small teams that mainly need renewals not to slip Automatic reminders to owners, escalation, files attached, reports Doesn’t scan devices or read SaaS usage
ITAM / SaaS management platforms (Flexera, ServiceNow, Zluri, BetterCloud and others) Hundreds of apps, many departments, audit exposure Automatic discovery, usage data, workflows Cost, rollout effort, often sold by quote

Snipe-IT is a free, self-hosted asset tool. Each license has a number of seats that you check out to people or to devices, and it can email you when licenses are about to expire. GLPI is another free, open-source option. Its licenses are linked to software in its inventory, and it can send a notification before a license expires, but only if the expiration date field is filled in. GLPI’s own documentation notes that its license management isn’t automated: someone still has to keep the records current.

A lesson admins share again and again: no tool keeps itself accurate. What makes tracking work is one owner per license, a monthly check, and alerts that reach a person before the deadline.

Do software licenses expire?

It depends on the license type:

  • Subscriptions expire at the end of each term unless they renew, and many renew automatically.
  • Perpetual licenses don’t expire, but the maintenance or support plan does. Once it lapses you usually lose updates, security patches and upgrade rights, and some vendors charge a reinstatement fee to come back.
  • Trial and evaluation licenses expire after a fixed period, often turning into a paid plan if a card is on file.
  • Term and enterprise agreements (for example a three-year agreement) end on a fixed date and need a renewal decision months ahead.
  • Keys, certificates and API credentials tied to software often have their own expiry dates. Track them in the same register.

So every row in your register needs at least one date to watch, even for “perpetual” software.

How do you stay ready for a software audit?

If a vendor audit letter arrives, you’ll usually have a short window to show what you bought and what you use. Being ready means you can produce, for each license:

  • proof of purchase (invoice, order or agreement number);
  • the current count of users or installs, from the admin console or inventory;
  • the license terms that apply, including any special rights in your agreement;
  • a record of who was told about each renewal and when.

Keep the contract and invoice attached to each license record, rerun the reconciliation in Step 3 every quarter, and export a report before any true-up or renewal meeting. In practice, fixing an over-allocation yourself is usually far cheaper than paying for it at list price after an audit.

Tracking licenses across countries

If your company works in more than one country, add a few extra checks:

  • Region or legal entity column. The same product may be bought by different entities, through different resellers, in different currencies. Record the entity and currency so totals add up.
  • Local terms. Prices, tax, notice periods and the right to transfer licenses between countries can differ by region and reseller. Read the agreement that actually applies to each entity.
  • Personal data. A register that lists users by name and email holds personal data. In the EU and UK, GDPR applies to it: store only what you need, limit who can see it, and remove leavers’ details when they no longer have a reason to be there.
  • Data residency. Some SaaS contracts say where data must be stored. Note the region in the license record so it’s checked again at renewal.

14-day free trial · No credit card

Never miss a software renewal deadline again

ExpirePilot keeps every license, contract and renewal date in one place and emails the owner before the cancel-by date, with escalation to a manager if nobody acts. Import your spreadsheet, attach the contracts, and see the reminder log. Try every Business feature free for 14 days, then stay on the Free plan or pick a paid plan.

✓ No credit card needed   ✓ Free plan after the trial   ✓ Nothing is deleted

Free $0Basic $15/moProfessional $39/moBusiness $79/moEnterprise $159/mo

Where ExpirePilot fits

ExpirePilot is software renewal tracking for teams that have outgrown a spreadsheet but don’t need a full ITAM platform. It doesn’t scan devices or measure SaaS usage; it makes sure renewal and expiry dates reach the right person in time.

It also tracks the other dates that live next to licenses, such as contract renewals, SSL certificates and domains. See plans and pricing.

Disclosure: ExpirePilot is our product. The method in this guide works the same with any tool.

Sources

Last checked: November 17, 2026.

The author

Venchito Tampon, founder of ExpirePilot

Venchito Tampon

Venchito Tampon is the Founder of ExpirePilot, document expiration tracking software that helps small businesses keep licenses, certifications, insurance certificates and contracts from lapsing, with reminders that reach the right people before anything expires.

He is also the CEO and Founder of eLearning Solutions Lab, a Philippines-based eLearning production company specializing in custom eLearning development and rapid eLearning solutions for global clients.

He founded Rainmakers Training & Consultancy, a corporate training and leadership development firm where he has trained and spoken at 250+ conventions, seminars, and workshops across the Philippines and internationally, including Singapore, Slovakia, and Australia. He has worked with top corporations including SM Hypermarket, Shell, and National Bookstore.

His other ventures include SharpRocket, a digital marketing and SEO company, and Hills & Valleys Cafe, a local café with available franchising.

He is a certified member of The Philippine Society for Talent Development (PSTD), the premier organization for Talent Development practitioners in the country, and an active Go Negosyo Mentor under the Mentor Me program.

Privacy Preference Center