STOCKORA: Small Business Inventory Template for Google Sheets

STOCKORA tracks a small shop's stock on a single tab and flags what's running low before you do. Each item carries what came in and what went out; the sheet works out what's left and what it's worth, and colours the row when you've hit the reorder point. It's a small business inventory template for Google Sheets with no account behind it and no trial — the free .xlsx download is the product, and it opens in Google Sheets, Excel or LibreOffice.

What the inventory tracker holds

The Inventory tab gives each product a row: SKU, name, category (from a dropdown), units received, units sold, current stock, the reorder level, unit cost and stock value. Four figures sit above the table and read the whole sheet: number of items, units in stock, total inventory value and how many items need reordering. The Lists tab is the editable source of the category dropdown — your own product categories, however many you keep.

How the stock spreadsheet calculates and alerts

Two columns are calculated and shouldn't be edited: current stock is received minus sold, and stock value is that quantity times the unit cost. The headline totals build on them — units in stock sums the current-stock column, inventory value sums the stock-value column, and the to-reorder figure counts the items at or below their reorder level. Colour rules turn the work into a glance: a row goes amber once current stock falls to or under its reorder point, and red when it hits zero and the item is out. Twelve sample items arrive across mixed categories, with a couple already below their minimum and one sold out, so both alerts and every formula are visible before your own products go in.

How to track inventory in Google Sheets

1. Set your product categories on the Lists tab.
2. Add each item with its SKU, units received and sold, reorder level and unit cost.
3. Leave current stock and stock value alone — both are calculated for you.
4. Read the amber rows as a reorder cue and the red ones as out of stock.
5. Check the totals up top for units, inventory value and how many items to reorder.

An inventory template in twelve languages

Small businesses don't all keep stock in English, so STOCKORA ships in twelve language editions — each a separate .xlsx with tab names, column labels, sample categories and currency formats translated, formulas untouched. Download the one that matches your page language, and use the opening guide if the .xlsx import step is unfamiliar.

Stock is one ledger a small business keeps; the money owed to it is another — PAYVEX follows each invoice through to collection. Both sit under inventory templates for Google Sheets, part of the wider set of business templates for Google Sheets.