Software License Position Workbook

Most license problems come from one question that nobody can answer quickly: do we own enough of this product to cover what we are using? This workbook lets you answer it product by product, and shows what a shortfall or surplus would be worth.

What you get

  • A ready built Excel workbook with sheets for Instructions, Summary, Settings, Products, Entitlements, Deployments, Position, and Renewals.
  • Formulas already built and tested, more than four thousand of them, so you only type in your data. There are no macros.
  • Worked example rows for four fictional vendors (Vendor A to D) that show how each sheet is meant to be filled in. Overwrite or delete them when you start.
  • A chart that shows contract cost ending by month, so renewals do not catch you by surprise.
  • Simple drop-down lists and colored flags that show where you are covered, short, or holding unused licenses.

How it helps you

  • You see your license position for each product in one place, instead of in scattered contracts and exports.
  • You can show surplus and shortfall in plain numbers before a renewal, a true up, or an audit.
  • You spot unused licenses and use that in renewal negotiations.
  • You keep a clean record of entitlements and deployments that supports an audit response.

Who should get it

  • IT asset managers and software asset managers building or tidying a license position.
  • Finance and procurement partners preparing a renewal or budget.
  • IT managers who want a clear view of the top software vendors.
  • Consultants who need a clean, reusable structure for client engagements.

How to use it

Read the Instructions sheet, enter your products and the entitlements you hold, add what is deployed from your discovery or usage data, and read the Position and Renewals sheets. Update it at least every quarter.

Format

  • One Excel workbook (.xlsx), built for Microsoft Excel.
  • You enter the data yourself. The workbook does not connect to any tool.

License and good to know

  • Single organization license. You may edit, adapt, and use the files inside your own organization. Please do not resell or redistribute them.
  • These are practical templates and guidance written by working consultants. They are vendor neutral and are not tied to any specific tool.
  • They are not legal, tax, or contractual advice. Have your legal and procurement teams review any policy, notice response, or contract position before you rely on it.
  • ITIL is a registered trademark of PeopleCert International Limited. Other product and company names are trademarks of their respective owners. These materials are independent and are not affiliated with or endorsed by any trademark owner.