Office Inventory Template

Keep office supplies and small equipment stocked — serials, purchase dates, minimum levels — and let staff request what they need.

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

Items, Supply requests

Fields

23

Views

grid, dashboard, kanban, 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.

Items

14 fields · 6 sample rows

  • Stock (Grid)
  • Shopping list (Grid)
  • Overview (Dashboard)
ItemTextCategorySingle selectSerial / modelTextLocationSingle selectUnitSingle selectIn stockNumberMinimumNumberStock statusFormulaUnit priceCurrencyStock valueFormulaVendorTextLast purchasedDateRequestsLink to another tableOpen requestsRollup
A4 copier paper 75 gsmStationeryStore roomReam1810In stock₹260₹4,680Amazon Business30 Oct 20260
HP 79A tonerPrinter suppliesCF279AStore roomCartridge12Reorder₹3,800₹3,800HP Store20 Sep 2026Toner for 2nd floor printer1
Logitech wireless mouseIT accessoriesM331 SilentFloor 2 cupboardPiece63In stock₹1,100₹6,600Croma21 Aug 2026Mouse replacement0
Whiteboard markersStationeryReceptionPack04Out of stock₹180₹0Amazon Business5 Oct 2026Markers for workshop1
Filter coffee powder 1 kgPantryPantryPack32In stock₹720₹2,160Cothas Coffee9 Nov 20260
USB-C to HDMI adapterIT accessoriesAnker 310Floor 2 cupboardPiece22Reorder₹1,500₹3,000Croma22 Jul 2026Adapter for meeting room1
Field details
Item · Text
Category · Single select
Stationery, Printer supplies, IT accessories, Pantry, Cleaning, Furniture
Serial / model · Text
Location · Single select
Store room, Reception, Pantry, Floor 2 cupboard
Unit · Single select
Piece, Box, Ream, Pack, Cartridge
In stock · Number
Minimum · Number
Stock status · Formula
IF({In stock} <= 0, 'Out of stock', IF({In stock} <= {Minimum}, 'Reorder', 'In stock'))
Unit price · Currency
INR
Stock value · Formula
{In stock} * {Unit price}
Vendor · Text
Last purchased · Date
Requests · Link to another table
Links to Supply requests
Open requests · Rollup
sum of Open via Requests

Supply requests

9 fields · 4 sample rows

  • Requests (Grid)
  • Board (Kanban)
  • Request supplies (Form)
RequestTextItemLink to another tableRequested byTextEmailEmailQuantityNumberNeeded byDateStatusSingle selectOpenFormulaNotesLong text
Toner for 2nd floor printerHP 79A tonerMeghna Das[email protected]221 Nov 2026Ordered1
Markers for workshopWhiteboard markersLucas Fernandes[email protected]320 Nov 2026Requested1
Mouse replacementLogitech wireless mouseTom Becker[email protected]116 Nov 2026Fulfilled0
Adapter for meeting roomUSB-C to HDMI adapterAnanya Iyer[email protected]124 Nov 2026Approved1
Field details
Request · Text
Item · Link to another table
Links to Items
Requested by · Text
Email · Email
Quantity · Number
Needed by · Date
Status · Single select
Requested, Approved, Ordered, Fulfilled, Rejected
Open · Formula
IF(OR({Status} = 'Fulfilled', {Status} = 'Rejected'), 0, 1)
Notes · Long text

Form view “Request office supplies” asks for: Request, Item, Requested by, Email, Quantity, Needed by, Notes.

Office 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