How to track inventory for free: 5 methods and a setup that works with any of them

You can track inventory for free with pen and paper, a whiteboard, a spreadsheet, a shared spreadsheet or a free inventory app. The method matters less than the setup behind it: a clear list of what you count, one unit per item, a named place for everything, a counting routine and a reorder point for the things you cannot run out of.

This guide walks through the five free methods, says honestly when each one is enough, and then gives you a setup you can use with any of them. If you later switch methods, the setup comes with you.

The five free ways to track inventory

Every free method is a place to write down two things: what you have, and where it is. They differ in who can see the numbers, how easy they are to change, and what happens when something goes wrong.

Method	Works well when	Starts to struggle when
Pen and paper	One person, one room, a short list	Several people update it, or you need history
Whiteboard	A shared stockroom where everyone walks past	Numbers need to leave the room, or get wiped
Spreadsheet	One owner, a longer list, sorting and totals	Several people edit copies of the same file
Shared spreadsheet	A small team that edits from different places	Edits clash, or nobody knows who changed what
Free inventory app	A team that updates stock on the move	You need features outside inventory, such as accounting

None of these is wrong. Pick the simplest one that fits how many people touch the stock and how often it changes.

Pen and paper: still fine for a short list

A notebook or a printed count sheet on a clipboard is the fastest way to start. There is nothing to install, anyone can use it, and writing a number next to an item name forces you to actually look at the shelf.

It works best for one person looking after one space: a studio’s art supplies, a small office’s printer paper and toner, a home workshop. Keep a column for the date of each count so you can see how fast things go.

The limits are practical. Paper has no search, no backup and no alerts. If the notebook lives in the stockroom, nobody at a desk can check it, and if it gets lost, so does your history.

A whiteboard: visible to everyone who walks past

A whiteboard on the stockroom wall turns inventory into something the whole team sees. Write the item, the current count and the reorder point in three columns. When someone takes the last box of gloves, they update the board on the way out.

This works because it is in the way. People do not have to remember to open anything. It suits a shared storeroom, a kitchen or a workshop where the same people handle the same stock every day.

A whiteboard only exists in one room, though. You cannot check it from the supplier’s shop, and one careless sleeve can erase a column. Take a photo after every count so you keep a record.

A spreadsheet: sorting, totals and a longer list

A spreadsheet is the natural next step when the list grows past what fits on a page. You get sorting, filtering, formulas for totals, and a place to note suppliers and reorder notes. Excel, Google Sheets and any other spreadsheet app all work.

A simple layout is enough: one row per item per location, with columns for item name, unit, location, quantity, reorder point and last counted date. Add a column that flags rows where quantity is at or below the reorder point.

A spreadsheet is strongest with one owner. The trouble starts when copies multiply: one on the laptop, one in email, one printed for the count. Each copy drifts, and soon nobody knows which number is right.

A shared spreadsheet: one file for a small team

Putting the spreadsheet in a shared online file solves the copies problem. Everyone opens the same file, and changes appear for everyone.

This suits a small team that updates stock from different places. Agree on a few rules: only change the quantity column, never delete rows, and add a note when you move stock between locations.

The weak spots show up as the team grows. Two people can type over each other’s numbers. A sorted column can scramble rows. Version history exists, but finding who changed a single cell last Tuesday is slow. And updating a spreadsheet on a phone while holding a box is awkward.

A free inventory app: built for updating on the move

A free inventory app is made for exactly this job. Instead of a grid, you get items, places and quantities, with buttons to add or subtract stock and a record of every change.

Apps help most when several people take and restock items, when stock sits in more than one place, or when you want to be told something is running low instead of noticing an empty shelf. Scanning a label with a phone camera is quicker than scrolling a spreadsheet.

Check what the free plan actually includes before you commit: how many people can join, how long history is kept, and whether you can export your data to a spreadsheet if you leave.

A setup that works with any method

The method is a container. What makes tracking reliable is the setup you put in it. These six steps work the same on paper, on a whiteboard, in a spreadsheet or in an app.

1. Decide what to count. List only what you actually run out of, pay for, or lose track of. Consumables (gloves, packing tape, coffee filters) and valuable equipment (a projector, a laser level) usually matter. Paper clips usually do not.
2. Pick one unit per item. Decide whether you count boxes, packs or single pieces, and write the unit next to the name. “Gloves, box of 100” avoids someone counting single gloves while someone else counts boxes.
3. Name every place. Give each shelf, cabinet, room or vehicle a short name, such as “Shelf A2” or “Van 1”. Record stock per place. The total for an item is the sum of its places.
4. Name items the same way every time. Use a pattern like what, then variant: “Tape, packing, clear” and “Tape, masking, 24 mm”. One item, one name. Duplicates are how counts go wrong.
5. Set a counting routine. Update the count every time stock comes in or goes out, and do a full count on a fixed schedule. Count fast-moving and valuable items more often, and the slow, cheap ones less.
6. Set a reorder point. For each item you cannot run out of, write the quantity at which you reorder. Base it on how long a refill takes to arrive and how much you use in that time, plus a small buffer.

Write these rules at the top of the sheet, on the edge of the board, or in the app’s notes, so a new team member follows them from day one.

Signs you have outgrown your current method

A free method is enough as long as the numbers stay right. Watch for these signs:

• You find out something ran out only when you need it.
• Two people give different answers to “how many do we have?”
• Nobody can say who took the last one, or when.
• The count takes longer every time because things are in the wrong place.
• Stock sits in several rooms or sites and the list only covers one.

One sign is a reason to tighten your setup. Several at once usually mean it is time for the next method in the table.

Where Tana fits

Tana is an inventory app with a free plan. There is no card to enter and no trial countdown. It follows the same setup described above.

You create items (what you count) and storages (a shelf, box, room or vehicle), and stock is recorded per storage, with the item total as the sum. Optional locations group storages by building or site. You can paste up to 200 item names at once, one per line, to move a list over from paper or a spreadsheet. Item names are unique in a team, so duplicates do not creep in.

Counting is one tap: − or + when stock moves, and = to set the exact number during a stocktake. Each item can have a low-stock threshold, and Tana alerts you on the home page, by email and push, and optionally in a Slack channel. QR labels printed from the web app open an item or storage when scanned with an iPhone or iPad camera or the browser camera.

Everyone on the team sees the same live numbers, and the history shows who changed which quantity, when and where. The free plan keeps 30 days of activity history. You can export your stock to CSV and open it in any spreadsheet at any time. Tana runs on iPhone, iPad and Mac, and in the browser on any computer, including Android devices.

Frequently asked questions

What is the easiest free way to track inventory?

For one person and a short list, a notebook or printed count sheet is the easiest. For a team, a shared spreadsheet or a free inventory app is easier, because everyone sees the same numbers.

Can I track inventory without software?

Yes. Pen and paper or a whiteboard work well for small, single-room stock. Use the same setup: one unit per item, named places, a counting routine and reorder points.

How often should I count my inventory?

Update the count whenever stock comes in or goes out, and do a full count on a regular schedule. Count fast-moving and valuable items more often than slow, low-cost ones.

How do I set a reorder point?

Estimate how much you use while waiting for a refill to arrive, then add a small buffer. When the count reaches that number, reorder.

Is a spreadsheet good enough for inventory?

For one owner and a steady list, often yes. It gets harder when several people edit it, when stock is in several places, or when you need to know who changed what.