![]() ![]() Item Status: Specify whether each asset is still available or whether it has discontinued.Item Reorder Quantity: Enter the asset quantity to be reordered.Days per Reorder: Enter the days between asset order and receipt from each asset vendor.Tip: To see more templates, under BROWSE BY. Choose from an assortment of templates like calendars, invoices, and budget planning. Reorder: Enter each asset’s reorder details (including an asset’s auto-fill threshold and whether it is currently on order). You don’t have to start from scratch if you start with a free template Microsoft Create.Total Asset Value: Review the auto-calculated total of all of your assets’ combined values.Īdditionally, some asset spreadsheets might contain the following details:.Photograph/Link: Enter a photograph of each asset (or a link to a corresponding visual).Vendor Number: List the unique vendor number for each asset.Total Value: Review the cumulative value for each asset (by multiplying the quantity by the asset value).Asset Value: Provide the monetary value for each asset.Quantity: Enter the number available of each asset.Condition: Enter the status for each individual asset.Warranty Expiry Date: Provide the warranty expiration date.Purchase Price Per Item: List the purchase price.Date of Last Order: Enter a date for the last time each asset was ordered.Space: Provide details of exactly where each asset is located.Department: List the department where each asset is currently located.Type: List the type of each asset (e.g., computer hardware or software).Description: Provide a brief description.Item Number: Provide the unique identifying number for each individual asset.Having a single, reliable, centralized source to account for all of your assets can save your organization time, resources, and money.Īn asset tracking spreadsheet or template typically includes the following components for managing and tracking your organization’s assets: Whether you’re in information technology (IT), fixed asset management, enterprise asset management, infrastructure asset management, or other fields, you know how crucial it is to track your assets. Use an asset tracking template to track reorder levels and cost per item, and to calculate your assets’ total value. Getting started with the Smartsheet APIĪn asset tracking spreadsheet is a tool for cataloging, managing, and tracking assets by name, ID number, vendor, and category.ENGAGE Smartsheet ENGAGE brings together our global customers, experts, and partners to share their experiences, ideas, and best practices.Smartsheet events Your hub for Smartsheet events, webinars, Q&As, and user groups.Partners Learn about the Smartsheet partner program and access our partner directory.Community Explore user-generated content and stay updated on our latest product features.Help and Learning A comprehensive knowledge base, including articles, tutorials, videos, and other resources that cover a range of topics related to using Smartsheet. ![]() Content Center Articles and guides about project management, collaboration, automation, and other topics to help you make the most of the Smartsheet platform.A safety deposit box or even a locked drawer in your office would probably work for an off-site location. When you have completed your home inventory, store a paper copy and a digital copy in a secure location outside of your home and/or in a fireproof safe. Record a quick video clip of each room in your home, and store the video clips and digital photos on a flash drive with your inventory. You might even want to do a walk-through video. Taking photos of your property for your home inventory will make working with your insurance company go a lot smoother. For insurance purposes, it would be better to list each item separately so that you can include the price, serial #, and model # for each item. Some of the descriptions in the inventory list, like "Electronics", are just placeholders to remind you to include your electronics. The Inventory Spreadsheet includes some of the common locations and items that you might want to consider when creating your own inventory list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |