Most small shops start tracking stock in a spreadsheet. It is free, familiar and flexible, and for a very small business that can be enough. So when does it stop being enough, and what should you move to?
Where Excel works well
You have a small number of products, perhaps a few dozen.
One person does the selling and the record keeping.
You only need a rough idea of what is in stock.
You are comfortable with formulas and enjoy building your own sheets.
If this is you, a spreadsheet is a perfectly good tool. Do not switch just for the sake of it.
Where Excel starts to hurt
Double entry. Every sale means changing the sheet by hand. Tired people at the end of a busy day make mistakes.
Stock is never live. The sheet is only as accurate as the last time someone updated it.
Several staff. Two people editing one file causes conflicts, copies and overwritten data.
Receipts and invoices. You end up writing them in another tool or by hand.
No alerts.…