CostLoop extension is live.Find subscriptions hiding in your inboxInstall free

How can a spreadsheet track software licenses without losing seat assignments?

Rohan Deshpande

How can a spreadsheet track software licenses without losing seat assignments?

A row saying “20 licenses” does not explain who can use them, whether all seats are assigned or what the agreement actually permits. A spreadsheet also becomes risky if someone copies a license key or password into a widely shared tab.

What is a workable spreadsheet layout for purchase records and individual assignments, with enough detail to review an offboarding or renewal decision?

Use separate tables for purchases and assignments. A purchase record can hold product, agreement reference, license type, purchased quantity, term and responsible owner. An assignment record links that purchase to the authorized user, device or other licensed unit, with an assignment date and status.

Compare purchased and assigned quantities only when their units match. Named-user, device, concurrent and other metrics are not interchangeable. Record evidence from the vendor administrator console and date each reconciliation. Restrict access to identifying information and keep secrets in an appropriate credential store. A difference in the counts is a reason to investigate, not an automatic compliance finding. Check the actual agreement before reallocating or reducing entitlements.

Which assignment change is most likely to be missed during an employee departure?

0 likes · 0 comments

Join the conversation

The first top-level comment is an example provided by CostLoop.

Diego Salazar

Use a separate assignment list rather than putting several people's names into one license cell. Link each assignment back to the relevant entitlement or subscription record.

Read public discussions

Use your CostLoop account to start a thread or reply.

Community guidelines

Be helpful and respectful. Share relevant experience, disclose commercial relationships, protect personal information, and avoid spam. Disclose commercial interests. Do not post promotional spam or personal information.