Skip to content

Worksheet

Tools / Software Asset Register

A simple register of every tool the business uses. The spreadsheet that prevents shadow IT problems.

Maintain a single list of every tool the business uses — SaaS, internal apps, business-critical spreadsheets, AI tools, scripts, automations. A spreadsheet is fine. The act of keeping it up to date is half the audit.

How to use this: The bracketed items like [Company Name] are placeholders — replace them with your own details. Edit the wording to suit your business. This is a starter, not legal advice.

Columns

Use these columns as a starting point:

FieldMeaning
NameTool's display name.
CategorySaaS, internal app, spreadsheet, script, AI.
OwnerNamed person responsible.
Backup ownerWho picks it up if owner leaves.
What it doesOne sentence.
Data it touchesCustomer / Employee / Financial / None.
Who has accessNumber of users; admin count.
Approved?Yes / No / Under review.
Renewal dateIf applicable.
NotesRisks, dependencies, plans.

Example rows

NameCategoryOwnerDataApproved?Notes
Microsoft 365SaaSAndyAllYesTenant-wide MFA on.
XeroSaaSSamFinancialYesCyber Essentials cert.
CRM access spreadsheetSpreadsheetPriyaCustomerYesShould migrate to HubSpot.
ChatGPT (free)AIMarkShould be: noneNOMove to Copilot.
Power Automate flow #14Internal appPriyaFinancialNoOne-person dependency.

How often to review

  • Whole register: quarterly.
  • Approved? = No rows: monthly.
  • When a person leaves: their owned rows, before they go.

Tips for adoption

  • Start it today. An incomplete register is more than 90% of SMEs have.
  • Use it before procurement decisions.
  • When someone leaves, work this register before you close the laptop.