Starting from:

$23.99

Small Business Inventory & Order Tracker — Stock, Reorder Alerts, Orders & Revenue (Excel + Google Sheets, UK £ / US $)

Small Business Inventory & Order Tracker — Stock, Reorder Alerts, Orders & Revenue (Excel + Google Sheets, UK £ / US $)

Know what's in stock, what to reorder and which orders still need to ship.

A ready-made inventory and order system for makers, small shops and resellers. Add up to 200 products (SKUs), log restocks and orders, and the spreadsheet works out stock on hand, stock value at cost, margin %, reorder alerts, open and overdue orders, and revenue by month.

What you get

  • UK (£) and US ($) versions, each as EXAMPLE (filled) and BLANK
  • Tabs: Dashboard, Products, Purchases, Orders, Suppliers, How to use
  • Order statuses: New, Packed, Shipped, Delivered, Returned (returns excluded from stock and revenue)
  • Quick-start PDF

How it works

  • Download after purchase.
  • Open in Excel, or upload to Google Sheets (File > Import).
  • Add your products, then log purchases and orders.

Gross profit is an estimate (sale price minus unit cost); platform fees, postage and tax are not included.

Please note

  • Digital download — no physical item is shipped.
  • Personal use only; please don't resell or share the files.
  • Colours may vary slightly between screens and printers.
  • Because this is a digital file, returns aren't accepted, but if anything is wrong with a file, message me and I'll fix it.

How this was made

Designed by Oddwren (a small UK shop in Portsmouth). I use AI-assisted tools for drafting text and layout ideas; every page, formula and mockup was checked and finished by hand. Mockup images show the real files.

1 file (237.8KB)