How to manage software licenses and avoid compliance issues

Summary

This guide helps you troubleshoot and resolve: How to manage software licenses and avoid compliance issues. Follow the steps below to fix the issue.

Common Causes

Effective software licence management protects your business from costly non-compliance penalties and ensures you always have the right tools available. This guide walks you through the essential steps to track, organise, and maintain licences across Windows, macOS, and cloud platforms, tailored for small businesses and home offices.

Quick Fix Steps

1. Gather all licence documentation (emails, PDFs, physical certificates) and store them in a dedicated folder on your PC, e.g. C:\Licences\.
2. Identify any licences that are about to expire within the next 30 days and note the renewal dates in a spreadsheet.
3. Log into the relevant vendor portal (Microsoft 365, Google Workspace, Apple Business Manager) and confirm the number of active seats matches your records.
4. If discrepancies are found, Open a Ticket via the support portal to request assistance.

Detailed Instructions

1. Create a Central Licence Inventory

1. Open Microsoft Excel (or Google Sheets) and create a new workbook named Software_Licences.xlsx.
2. Add the following column headers:
   • Software/Product Name
   • Vendor
   • Licence Type (e.g., perpetual, subscription, per-user, per-device)
   • Number of Seats
   • Purchase Date
   • Expiry/Renewal Date
   • Licence Key / Activation Code
   • Location of Documentation (file path or URL)
   • Assigned User or Device
   • Notes
3. Enter each licence record manually or import data from vendor CSV exports using Data → Get Data → From Text/CSV.
4. Save the workbook to a cloud-synced folder (e.g., OneDrive\Business\Licences) for easy access and backup.

2. Use Built-In Tools to Pull Licence Data

Before exporting data from vendor portals, you can use built-in operating system tools to identify software already installed on your hardware. This helps you reconcile your records with actual installations.

Windows (PowerShell)

1. Right-click the Start button and select Terminal (Admin) or PowerShell (Admin).
2. Type the following command to list installed software and press Enter: Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\* | Select-Object DisplayName, DisplayVersion, Publisher
3. Review the list and record any software titles not already in your inventory spreadsheet.
4. For Microsoft 365 specifically, sign in to the Microsoft 365 admin centre (admin.microsoft.com), navigate to Billing → Licences, and click Export to download a CSV of assigned licences.

macOS (Apple Business Manager)

1. Log in to Apple Business Manager (business.apple.com).
2. Select Apps and Books → Purchases.
3. Use the Export button to download a list of volume-purchased licences.
4. Match the exported data with your inventory and note any licences that require re-assignment.

Google Workspace

1. Open the Google Admin console (admin.google.com).
2. Go to Billing → Subscriptions.
3. Click Download report to get a CSV of all active licences.
4. Update your master spreadsheet accordingly.

3. Understanding Licence Types

Small businesses typically encounter three main licence models. Understanding the difference is critical for compliance and budgeting.

Perpetual vs Subscription Licences

• Perpetual Licences: You pay once and own the licence indefinitely. However, major version upgrades usually require a separate purchase or maintenance agreement.
• Subscription Licences: You pay a recurring monthly or annual fee. Access to the software stops if the subscription lapses. This is common for Microsoft 365 and Adobe Creative Cloud.

Volume Licensing and CALs

• Volume Licensing: Designed for organisations with multiple devices. It often provides a single key for multiple installations and simplified management through a vendor portal.
• Client Access Licences (CALs): Required for users or devices to access server software (e.g., Windows Server). Ensure you have enough CALs for every user or device connecting to your server.

4. Automate Ongoing Licence Monitoring

1. Set up a recurring calendar reminder (e.g., monthly) to review the Expiry/Renewal Date column in your inventory.
2. To automate email alerts using Zapier:
   • Create a Zap with Google Sheets as the trigger app.
   • Select the event New or Updated Spreadsheet Row.
   • Connect your Google account and select your Software_Licences.xlsx spreadsheet.
   • Set the trigger to monitor the Expiry/Renewal Date column.
   • Add an action step using Gmail or Email by Zapier.
   • Configure the email to send to your IT contact when the expiry date is within 30 days of today.
3. For smaller environments, a manual spreadsheet review combined with calendar reminders is often more cost-effective than dedicated software.
4. If you require a dedicated tool, Spiceworks IT Asset Management is a free option. Download the installer from the Spiceworks website, run the setup wizard, and configure the network scan to detect installed software on your Windows devices.

5. Maintain Compliance During Audits

1. Be aware that software vendors and organisations such as the Business Software Alliance (BSA) conduct audits. Non-compliance can result in significant financial penalties and legal action.
2. Before an audit, generate a report from your inventory workbook that includes:
   • All active licences
   • Corresponding installation counts
   • Proof of purchase (receipts, invoices)
3. Store audit-ready documentation in a read-only folder, e.g., C:\Licences\AuditReady, and restrict access to senior IT staff.
4. If a discrepancy is discovered during the audit, immediately Open a Ticket to discuss remediation options with our specialists.

6. Documenting Licence Transfers and Hardware Disposal

1. When a computer is decommissioned or replaced, record the transfer in your inventory.
2. Note which licence keys were removed from the old hardware.
3. Re-assign the licence to the new device or user via the vendor admin console.
4. Update the Assigned User or Device column and add a note regarding the hardware disposal date.

7. Renew or Re-allocate Licences

1. When a licence is due for renewal, log into the vendor portal and select Renew or Extend.
2. Update the Expiry/Renewal Date in your inventory and attach the renewal receipt to the Location of Documentation field.
3. If a user leaves the organisation, re-assign the licence via the vendor's admin console rather than de-activating it, preserving seat counts.

Troubleshooting

Common Issues and Resolutions

• Missing licence key in inventory
  1. Search your email archives for the original purchase confirmation using keywords like "licence key" or "activation code".
  2. If the key cannot be located, contact the vendor's support portal and request a re-issue.
  3. Update the inventory once the key is received.
• Seat count exceeds purchased licences
  1. Run an asset scan:
     • Windows: powershell -Command "Get-ItemProperty HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\* | Select-Object DisplayName, DisplayVersion"
     • macOS: system_profiler SPApplicationsDataType
  2. Compare the installed instances with the Number of Seats column.
  3. Remove excess installations or purchase additional licences.
• Licence expiry notifications not received
  1. Verify that your email address is correct in the vendor portal's notification settings.
  2. Check your spam/junk folder for missed alerts.
  3. Enable calendar reminders as a backup (see Step 3 above).

When to Seek Additional Help

• Complex multi-vendor environments where manual tracking becomes impractical.
• Repeated audit findings indicating systemic compliance gaps.
• Unclear vendor licensing terms that affect usage rights.

For any of the above scenarios, Open a Ticket and our specialists will assist you in streamlining your licence management process.

Still Having Issues?