Inventory Templates

Inventory database templates keep stock in a table where quantities, reorder levels and values are calculated rather than typed in. Choose the template that matches what you count, from products and fixed assets to kitchen ingredients and bar bottles.

13 templates

Product Inventory Template

Products with SKUs, costs and prices, where stock on hand is calculated live from every stock-in, sale, return and adjustment.

2 tables · 25 fields
Art Inventory Template

Catalogue every artwork with images, medium, location, provenance and pricing, linked to the artists you represent.

2 tables · 24 fields
Asset Inventory Template

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

1 table · 18 fields
Bar Inventory Template

Count spirits, beer, mixers and bar equipment against par levels, see what to order from which supplier and what your stock is worth.

2 tables · 21 fields
Book Inventory Template

Track titles, ISBNs, copies on the shelf and margins for a bookstore or library, with low-stock flags and cover gallery.

1 table · 17 fields
Equipment Inventory Template

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

2 tables · 27 fields
Home Inventory Template

Room-by-room record of what you own, with photos, receipts, warranties and replacement values — ready for an insurance claim.

1 table · 16 fields
Liquor Inventory Spreadsheet

Track every bottle by type, age, ABV and proof, count partial bottles, and see pour cost per 30 ml against your menu price.

1 table · 17 fields
Office Inventory Template

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

2 tables · 23 fields
Order Tracker

Follow every order from placed to delivered — items, totals, payment, courier and tracking — with lifetime value per customer.

2 tables · 24 fields
Pantry Inventory Template

Know what is in the kitchen, what is running low and what expires soon — and get a ready-made shopping list.

1 table · 13 fields
Personal Property Sheet

Collect each owner’s details and a documented list of their belongings, with proof of ownership and insured value per owner.

2 tables · 25 fields
Restaurant Inventory Template

Count ingredients and supplies against par, flag use-by dates, and log kitchen waste so you can see what it is costing you.

2 tables · 23 fields

About inventory templates

This category holds 13 inventory templates for Edesy Tables. For businesses that sell, the Product Inventory Template keeps products with SKUs, costs and prices, and works out stock on hand from a linked table of stock movements: every purchase, sale, return or adjustment is a row. The Order Tracker follows each order from placed to delivered with items, payment and courier details, linked to customers. For things you own rather than sell, the Asset Inventory Template is a fixed-asset register with tags, assignees, warranty dates and depreciation, the Equipment Inventory tracks who has which item checked out and when it is due for service, and the Office Inventory lets staff request supplies through a form. Hospitality teams get Restaurant, Bar and Liquor templates that count stock against par levels, flag use-by dates and log waste, while the Book, Art, Home and Pantry templates and the Personal Property Sheet cover catalogues and household records. Each template uses typed fields, so quantities stay numbers and categories stay consistent, and formulas or rollups produce low-stock flags, totals and values automatically. Gallery views show items with photos, dashboards summarise stock value, and calendar views show expiry or service dates. You can import a current stock list from CSV or Excel and export it again at any time.

What they are used for

Retail and online store stock

Keep each product's SKU, cost and price, and let stock on hand update from every stock-in, sale and return you record.

Fixed assets and equipment

Register laptops, machines and furniture with tags, assignees, warranty dates and book value, and see who has borrowed what.

Restaurant and bar stock

Count ingredients and bottles against par levels, flag what expires soon, and log waste so you can see what it costs.

Office supplies

Track stationery and small equipment with minimum levels, and take supply requests from staff through a form.

Catalogues and collections

Catalogue books, artworks or household items with photos, values and locations, ready for a stock check or an insurance claim.

Which template to use when

TemplateUse it when
Product Inventory TemplateYou sell products and want stock on hand calculated from purchases, sales and returns.
Order TrackerYou need to follow customer orders from placed to delivered, with payment and courier details.
Asset Inventory TemplateYou keep a register of company assets with assignees, warranties and depreciation.
Equipment Inventory TemplateEquipment is lent out and serviced, and you need to know who has each item.
Restaurant Inventory TemplateA kitchen counts ingredients against par levels and wants to track waste.
Office Inventory TemplateYou stock office supplies and want staff to request items through a form.

How to create one

  1. 1

    Decide whether you are tracking stock you sell, assets you own, or consumables, and pick the matching template.

  2. 2

    Open it, click Use this template, sign in with your Edesy account and click Use template in the preview.

  3. 3

    Adjust categories, units, locations and reorder levels to your own items and warehouse or shop layout.

  4. 4

    Delete the sample rows and import your current stock list from a CSV or Excel file.

  5. 5

    Record each stock movement or checkout as a row, and add an automation that posts to Slack or calls a webhook when an item falls below its reorder level.

Frequently Asked Questions

Yes, in templates built on movements. In the Product Inventory Template, stock on hand is a formula over rollups of the linked stock movements (opening stock plus units in minus units out), so adding a sale or purchase row changes the quantity without editing the product.

The templates flag items below their reorder or par level with a formula. To be told about it, add an automation that runs when a record matches that filter and posts to a connected Slack channel or calls a webhook.

Yes. Attachment fields hold images and files, and gallery views show items as cards with their photo, which helps with art, book and asset catalogues.

Add a location field, or a locations table linked to stock movements, and create a filtered view per location. Totals across all locations stay in the main products table.

Yes. Export any table or view to CSV or Excel, for example a filtered view of the month's stock movements or the current stock value.

Build your database in Edesy Tables

Start from a template or a blank base, import a spreadsheet, and work in grid, kanban, calendar, form and dashboard views.

Free Inventory Database Templates | Edesy Tables