Asset Inventory Template

A fixed-asset register with tags, assignees, warranty dates and straight-line depreciation to today’s book value.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Inventory

Tables

Assets

Fields

18

Views

grid, kanban, cards, calendar, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Assets

18 fields · 6 sample rows

  • Register (Grid)
  • By status (Kanban)
  • Gallery (Cards)
  • Warranty calendar (Calendar)
  • Asset value (Dashboard)
AssetTextAsset tagAutonumberCategorySingle selectSerial numberBarcodeAssigned toTextLocationSingle selectStatusSingle selectConditionSingle selectPurchase dateDatePurchase costCurrencyUseful life (years)NumberSalvage valueCurrencyAnnual depreciationFormulaBook valueFormulaWarranty untilDateWarrantyFormulaPhotoAttachmentNotesLong text
MacBook Pro 14" M3AST-0001IT equipmentC02XK1ABMD6TAditi KulkarniPune officeIn useGood25 Sep 2025₹2,10,0004₹30,000₹45,000₹1,58,21925 Sep 2027Active
Dell UltraSharp 27" monitorAST-0002IT equipmentCN0F8K3H74261James WhitfieldRemoteIn useGood19 Dec 2024₹42,0005₹4,000₹7,600₹27,42519 Dec 2026Expiring soon
Herman Miller Aeron chairAST-0003FurnitureMeghna DasMumbai HQIn useFair11 Oct 2022₹95,00010₹10,000₹8,500₹60,06819 Aug 2032Active
Tata Ace delivery vanAST-0004VehiclesMH12 AB 4521WarehouseUnder repairFair15 Nov 2023₹6,50,0008₹80,000₹71,250₹4,35,27414 Nov 2025ExpiredClutch replacement booked.
Epson conference projectorAST-0005AV equipmentX4KF220019Mumbai HQIn storageGood2 Jun 2024₹68,0005₹5,000₹12,600₹36,932None
Lenovo ThinkPad T14AST-0006IT equipmentPF3HX9Z2Mumbai HQRetiredPoor15 Dec 2021₹85,0004₹5,000₹20,000₹5,000None
Field details
Asset · Text
Asset tag · Autonumber
Category · Single select
IT equipment, Furniture, Vehicles, Machinery, AV equipment
Serial number · Barcode
Assigned to · Text
Location · Single select
Mumbai HQ, Pune office, Warehouse, Remote
Status · Single select
In use, In storage, Under repair, Retired
Condition · Single select
New, Good, Fair, Poor
Purchase date · Date
Purchase cost · Currency
INR
Useful life (years) · Number
Salvage value · Currency
INR
Annual depreciation · Formula
IF({Useful life (years)} > 0, ROUND(({Purchase cost} - {Salvage value}) / {Useful life (years)}, 0), 0)
Book value · Formula
IF({Purchase date}, MAX({Salvage value}, ROUND({Purchase cost} - {Annual depreciation} * DATETIME_DIFF(TODAY(), {Purchase date}, 'days') / 365, 0)), {Purchase cost})
Warranty until · Date
Warranty · Formula
IF({Warranty until}, IF(IS_BEFORE({Warranty until}, TODAY()), 'Expired', IF(DATETIME_DIFF({Warranty until}, TODAY(), 'days') <= 60, 'Expiring soon', 'Active')), 'None')
Photo · Attachment
Notes · Long text

Asset Inventory Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates