IT Asset Inventory template
Assets, locations, and equipment checkouts with validated EAN-13 barcodes and serial numbers, a straight-line depreciation formula, per-location count rollups, and an overdue-checkout digest.
Tables
Assets
Asset tag, Asset, Category, Barcode (EAN-13), Serial number, Location, Status, Condition, Purchased on, Purchase price, Useful life (years), Book value, Photo, Supplier and 15 more
Locations
Location, Type, Address, Map position, Country, Timezone, Site manager, Site e-mail, Phone, Opens, Desks, Insured site, Notes, Assets and 4 more
Checkouts
Asset tag, Checked out by, Purpose, Asset, Asset name, Ticket, Out date, Due back, Returned on, Returned, Condition when issued, Approved by, Department, Contact e-mail and 4 more
Views
- All assets (grid)
- Asset cards (gallery)
- By condition (kanban)
- Open checkouts (grid)
- By status (kanban)
Forms
- Check out equipment
- Register an asset
Automations
- Daily overdue-checkout digest
- Email IT on new checkout
- New record in “Assets”
- “Assets” reached “Retired”
- Daily sweep — still open in “Assets”
- “Insured” was ticked in “Assets”
- Large value in “Purchase price”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.