Excel can be a useful tool for setting up very basic inventory, equipment tracking, and asset management systems. There are a lot of great asset tracking software tools out there, but if you just need a simple solution, you can download the free Asset Tracking Template below. It is particularly useful for tracking computer hardware, tools, repair equipment, and other fixed assets. For tracking software licenses, try our Software Inventory template.
AdvertisementFor smallish companies, a simple spreadsheet like this may be all you need. However, if you need a more advanced asset management system, there are numerous software solutions designed for just that purpose. But, give the Vertex42 template a whirl and let me know if there are things you'd like it to do that it currently does not.
License: Private Use (not for distribution or resale)
AdvertisementThe Asset Inventory worksheet is set up to help you include the following information:
Depending on your intended use, you may not need all of the columns, or you may want to add more. For example, if you don't put ID tags on your equipment, you may not need the "ID" column. Though, if you are really interested in tracking your equipment, you may want to consider ID tags.
The asset tracking template also contains a Suppliers worksheet, so you can keep track of supplier contact information for repair, maintenance, and warranty purposes.
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer