Equipment Inventory Template

Know where every piece of equipment is, when it is due for service, and who has it checked out right now.

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

Equipment, Checkouts

Fields

27

Views

grid, kanban, cards, calendar, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Equipment

16 fields · 5 sample rows

  • All equipment (Grid)
  • Availability (Kanban)
  • Gallery (Cards)
  • Service calendar (Calendar)
EquipmentTextTagAutonumberPhotoAttachmentCategorySingle selectMake & modelTextSerial numberBarcodeHome locationSingle selectStatusSingle selectConditionSingle selectPurchase costCurrencyLast servicedDateService every (days)NumberNext serviceFormulaService dueFormulaCheckoutsLink to another tableTimes borrowedCount
Sony FX3 cinema cameraEQ-001Camera & AVSony ILME-FX35012345Studio AChecked outExcellent₹3,85,00031 Aug 202618027 Feb 2027OKClient shoot – Nykaa campaign1
Aputure 300d light kitEQ-002Camera & AVAputure LS 300d IIStudio AAvailableGood₹92,0002 Jun 202618029 Nov 2026Due soonProduct video1
Bosch cordless drillEQ-003Power toolsBosch GSR 18V-50811000231WorkshopChecked outWorn₹14,5003 May 202612031 Aug 2026OverdueShelf installation1
Digital oscilloscopeEQ-004LabRigol DS1054ZLab 2In maintenanceDamaged₹38,0009 Nov 20263659 Nov 2027OK0
Spare laptop pool #3EQ-005ITDell Latitude 5440DL5440-77812IT cageAvailableGood₹78,000Visiting consultant1
Field details
Equipment · Text
Tag · Autonumber
Photo · Attachment
Category · Single select
Camera & AV, Power tools, Lab, IT, Safety
Make & model · Text
Serial number · Barcode
Home location · Single select
Studio A, Workshop, Lab 2, IT cage
Status · Single select
Available, Checked out, In maintenance, Retired
Condition · Single select
Excellent, Good, Worn, Damaged
Purchase cost · Currency
INR
Last serviced · Date
Service every (days) · Number
Next service · Formula
IF(AND({Last serviced}, {Service every (days)}), DATEADD({Last serviced}, {Service every (days)}, 'days'), BLANK())
Service due · Formula
IF({Next service}, IF(IS_BEFORE({Next service}, TODAY()), 'Overdue', IF(DATETIME_DIFF({Next service}, TODAY(), 'days') <= 14, 'Due soon', 'OK')), '')
Checkouts · Link to another table
Links to Checkouts
Times borrowed · Count

Checkouts

11 fields · 4 sample rows

  • Log (Grid)
  • Loans (Calendar)
  • Check out equipment (Form)
PurposeTextEquipmentLink to another tableBorrowerTextBorrower emailEmailChecked outDateDue backDateReturned onDateReturn statusFormulaDays overdueFormulaCondition on returnSingle selectBorrower signatureSignature
Client shoot – Nykaa campaignSony FX3 cinema cameraArjun Pillai[email protected]17 Nov 202622 Nov 2026Out0
Shelf installationBosch cordless drillHannah Brooks[email protected]13 Nov 202618 Nov 2026Overdue1
Product videoAputure 300d light kitLucas Fernandes[email protected]5 Nov 20269 Nov 20269 Nov 2026Returned0As issued
Visiting consultantSpare laptop pool #3Sophie Laurent20 Oct 20263 Nov 20264 Nov 2026Returned0Minor wear
Field details
Purpose · Text
Equipment · Link to another table
Links to Equipment
Borrower · Text
Borrower email · Email
Checked out · Date
Due back · Date
Returned on · Date
Return status · Formula
IF({Returned on}, 'Returned', IF(AND({Due back}, IS_BEFORE({Due back}, TODAY())), 'Overdue', 'Out'))
Days overdue · Formula
IF(AND(NOT({Returned on}), {Due back}, IS_BEFORE({Due back}, TODAY())), DATETIME_DIFF(TODAY(), {Due back}, 'days'), 0)
Condition on return · Single select
As issued, Minor wear, Damaged
Borrower signature · Signature

Form view “Check out equipment” asks for: Purpose, Equipment, Borrower, Borrower email, Checked out, Due back, Borrower signature.

Equipment 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