Using a spreadsheet to track software licenses or cloud subscriptions might be effective for small organizations. However, as your software estate grows, it becomes increasingly difficult to manage your software assets and their processes. If you aren\u2019t convinced, here are 10 reasons why you need to reconsider managing your software assets in a spreadsheet.<\/p>\n
Multiple departments and upper management rely on information from the IT department. This can be for budgeting, forecasting or just making a purchasing decision. However, it\u2019s hard to rely on information taken from spreadsheets. The manual entry of data makes spreadsheets prone to human error<\/strong>. With hundreds of cells, it isn\u2019t difficult to enter some numbers in the wrong row or column. As cloud solutions make it possible to share spreadsheets, there is also the possibility of erasing data, changed or moved. And, the lack of ownership is a great concern as users make unapproved changes that can potentially be spread across the company<\/span><\/a>. Finally, spreadsheets have the risk of not updating at all.<\/p>\n Learn about VIZOR<\/a>Try VIZOR Online<\/a><\/p>\n It is the IT department\u2019s responsibility to know what is going on with the organization\u2019s assets. However, the data in a spreadsheet can be hard to analyze and extract. The sheer volume of data makes it easy to misinterpret<\/span><\/a>. Overall, spreadsheets don\u2019t give you the answers you need<\/strong> when you need them. It isn\u2019t easy to find out how many software licenses you have, how many are currently used or how much they cost, without spending too much time on finding an answer that may not even be accurate.<\/p>\n IT departments execute several processes surrounding software assets<\/strong> like deploying software to employees. In a company of 100 employees, for example, it is quite difficult to deploy 100 licenses and keeping track of them in a spreadsheet. Imagine listing the number of computers in the company and the licenses on each device. Then, updating those cells every time an employee leaves or joins the company. The static nature of the spreadsheet does not consider the processes or even the historical data<\/span><\/a> that IT may need access to.<\/p>\n Part of managing software is knowing when you need to purchase more licenses, when it needs to be renewed or when maintenance is due. This information can be displayed in a few columns of a spreadsheet but will require active checking. Spreadsheets aren\u2019t intuitive<\/strong> to proactively send you notifications or reminder emails. Why is that important? Being up-to-date on renewals, for example, gives you a leg up on negotiations and purchase discounts whereas maintenance notifications ensure doesn\u2019t elapse exposing you to penalties to renew. The reactive approach of a spreadsheet does not keep the department informed of the status of their software estate.<\/p>\n The information IT needs cannot be in one spreadsheet. For example, the cost of software might be in an accounting system, the vendor name can be in one of your spreadsheets and the physical contract could be in a cabinet. The data stored in spreadsheets are limited and do not include all the pieces of information<\/strong> that are essential for decision-making. For IT to work effectively, they need information readily available and not hidden from the company.<\/p>\n A large component of managing software assets is knowing who is using them. In a spreadsheet, software licenses are associated with the correct user. It requires updating every time an employee leaves or joins the company. This process is then repeated for every software license. The lack of integration with the \u201clive\u201d employee directory makes it difficult to maintain an updated list of who is using what<\/strong>. In addition, the spreadsheet will not assist in the processes surrounding the provisioning or de-provisioning of the software. IT will need to coordinate with HR to retract or deploy software.<\/p>\n As software is becoming a more significant part of business, its cost is increasingly important to management. However, as discussed before, the information in spreadsheets is usually inaccurate. Not only can expenditure be poorly tracked in spreadsheets but may not even be displayed at all. Spreadsheets are not even able to integrate with an accounting system<\/strong> that can monitor expenditure for them.<\/p>\n Related to the previous point, when there isn\u2019t a good grasp of software expenditure, it’s difficult to forecast the costs of the next quarter or the next year. Also, without connection to the employee directory, you can\u2019t anticipate the number of employees that will join the company or account for the change of employees over the last few years. The inability to spot trends<\/a><\/span> over time make it difficult to forecast software expenditure, making it almost impossible to negotiate with vendors and get good prices.<\/p>\n An Effective License Position (ELP) indicates whether you\u2019re over- or under- licensed.<\/a><\/span>\u00a0 Spreadsheets are not able to automatically detect if there are too many licenses or not enough. Having too many licenses poses a surplus cost and missing licenses is not ideal for employee productivity or vendor audits.<\/p>\n It is already a challenge to monitor intangible assets<\/strong> like software licenses. There is another level of difficulty when the software is not even installed on the company\u2019s computers, like cloud subscriptions. How do you track cloud subscriptions in a spreadsheet? You can\u2019t. Other than listing the subscriptions you never really<\/em> know how many you have, who is using them and if they\u2019re used. As a software asset, cloud subscriptions are still IT\u2019s responsibility and spreadsheets do not help the department in monitoring cloud subscriptions.<\/p>\n Spreadsheets consume a lot of resources in exchange for very limited information. Therefore, you should consider alternative solutions if you\u2019re currently using spreadsheets to manage your software assets. So if you just started monitoring your software, do not even start with a spreadsheet<\/em>. The time you invest in searching for a solution is a fraction of the time you would have spent updating your spreadsheets!<\/p>\n","protected":false},"excerpt":{"rendered":" Using a spreadsheet to track software licenses or cloud subscriptions might be effective for small organizations. However, as your software estate grows, it becomes increasingly difficult to manage your software assets and their processes. If you aren\u2019t convinced, here are 10 reasons why you need to reconsider managing your software assets in a spreadsheet. 10. … Continue reading Top 10 Reasons NOT To Manage Software Licenses In A Spreadsheet<\/span><\/a><\/p>\n","protected":false},"author":101011,"featured_media":2961,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[28],"tags":[307,341,337,340,332,334,333,338,72,78,335,336,99,220,107,199,331,339],"_links":{"self":[{"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/posts\/2957"}],"collection":[{"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/users\/101011"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/comments?post=2957"}],"version-history":[{"count":14,"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/posts\/2957\/revisions"}],"predecessor-version":[{"id":3778,"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/posts\/2957\/revisions\/3778"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/media\/2961"}],"wp:attachment":[{"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/media?parent=2957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/categories?post=2957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vizor.cloud\/blog\/wp-json\/wp\/v2\/tags?post=2957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}9. Hidden Data<\/strong><\/h3>\n
8. Static Information<\/strong><\/h3>\n
7. No Notifications<\/strong><\/h3>\n
6. Information Isn\u2019t Centralized<\/strong><\/h3>\n
5. No Integration With The Employee Directory<\/strong><\/h3>\n
4. Lack Of Tracking Costs<\/strong><\/h3>\n
3. Inability to Forecast<\/strong><\/h3>\n
2. Unable To Maintain An Effective License Position<\/strong><\/h3>\n
1. Neglects Cloud Subscriptions<\/strong><\/h3>\n
SUMMARY<\/h5>\n