Shop Inventory Book vs Google Sheet: When to Switch (and How)

By InventAsset · 2026-10-07 · Written with AI assistance, reviewed by InventAsset

Plenty of good shops run on a paper inventory book. It is cheap, it never needs charging, and anyone at the counter can use it. So this is not an article telling you paper is wrong. It is a guide to working out whether your book is still doing the job, and how to move to a spreadsheet without losing anything if it is not.

What a paper inventory book does well

• It is simple. Open the page, write a line. No login, no training.
• It is always there. It works when the internet doesn't.
• It is hard to delete by accident. A written line stays written.
• It costs almost nothing.

If you have a small number of items, one person keeping the book, and you rarely run out of things by surprise, a paper store stock book may be all you need. Keep it.

Where a paper book falls short

The weak spots appear as the shop grows:

• Math by hand. Every balance is a subtraction you have to do yourself, and one mistake carries forward.
• No overview. To see what is low, you have to flip through every page.
• No warning. The book doesn't tell you when you hit your reorder level; you have to notice.
• Several people, several handwritings. Lines get skipped, abbreviations differ, and nobody is sure which entry is right.
• Hard to search. Finding "when did we last receive this?" means reading pages line by line.

Signs it's time to switch

Ask yourself these questions. If you answer yes to two or more, a spreadsheet will probably save you time:

1. Have you run out of a regular item in the last few months without noticing in time?
2. Do you have more items than fit comfortably in one notebook?
3. Does more than one person record stock?
4. Do you regularly find the book and the shelf don't match?
5. Do you spend more than a few minutes working out what to reorder?

Side by side

A spreadsheet has its own risks. A careless edit can break a formula, and a half-filled row can throw off a total. Good sheets limit this with dropdowns, clear input areas and checks on each row.

How to switch without losing anything

You don't need to type in your whole history. Here is a clean way to move:

1. Pick a switch date, ideally a quiet day at the start of a week or month.
2. Count the shelf for every item on that day. This is your fresh starting point.
3. Write the count in your book as a final line, and draw a line under it. The book becomes your record of the past.
4. Set up the sheet with an Items tab (name, unit, opening quantity from your count, reorder level) and a Movements tab (date, item, in or out, quantity, note). Our stock in/out Google Sheets template guide shows the formulas.
5. Run both for one week if it helps. Write in the book, type it into the sheet at closing, and compare. Then stop using the book.
6. Keep the old book. Store it with your invoices.

Making the sheet work at the counter

The biggest risk after switching is that people go back to scribbling on paper. Make the sheet easy to use:

• Keep a short scrap pad at the counter and type it in at a fixed time each day.
• Use dropdowns for item names and movement types so nobody has to remember spellings.
• Put the On hand and status columns where they are easy to see.
• Decide who checks the sheet each week.

When neither is enough

If you need barcode scanning, a till, profit and valuation reports, or separate totals for several shops, you have outgrown both a book and a simple sheet. Look at POS or inventory software built for that.

Related guides

• How to make a stock register
• How to record stock in and out

Quick recap

• A paper inventory book is fine for small, simple stock with one person recording.
• Switch when you keep running out, have many items, or several people record stock.
• Switch on a count day, start the sheet from that count, and keep the old book.