Inventory Tracking for Small Business: Spreadsheet, App or Custom?

Picture a small plumbing outfit in Forest Lawn with four vans. Every van carries fittings, valves and a couple of water heater parts. The office keeps a spreadsheet, but techs grab parts from the shop shelf at 7 a.m. and nobody writes it down. By Thursday, a tech is driving to a supply house in the middle of a job because the part the sheet says is on the shelf isn't there.

That is the real question behind inventory tracking for small business: not "which software is best", but "how do I get counts I can trust without turning my team into data entry clerks?" The answer depends on how many items you carry, how many people touch them, and whether your stock is sold, used on jobs, or turned into something else.

01First, figure out what kind of inventory you have

Inventory tools are built for different jobs. Picking the wrong type is the most common reason small businesses abandon an app after a few months.

Resale stock

You buy items and sell them as they are: a bike shop in Kensington, a boutique in Inglewood, a supplement store in Airdrie. You care about what sold, what's left and when to reorder. Point-of-sale systems and e-commerce platforms handle this well.

Job materials

You buy parts and use them on service jobs: trades, cleaning companies, auto repair. You care about what went on which job (so you can bill it) and what's in each van or bay. Most retail inventory tools don't model this well.

Production inputs

You turn raw materials into finished goods: a bakery, a cabinet shop, a small manufacturer in an industrial park off Barlow Trail. You need a recipe or bill of materials, so selling one finished item reduces several ingredients.

02Level 1: a spreadsheet done properly

For a business with up to a few hundred items and one or two people managing stock, a well-structured spreadsheet is genuinely fine. The trick is structure, not formulas.

• One row per item. No merged cells, no notes jammed into random cells.
• A short item code. "PEX-12-ELB" beats "half inch pex elbow thingy".
• A unit. Each, box of 50, litre, metre. Mixed units are where counts go wrong.
• Location. Shop shelf, van 2, back room. One row per item per location if stock lives in several places.
• Quantity on hand and reorder point. Add a simple column that flags anything at or below the reorder point.
• Supplier and last cost. So reordering doesn't depend on one person's memory.
• Last counted date. So you can see what hasn't been checked in a while.

Pick one person who owns the sheet, and set a fixed time each week to update it. A spreadsheet updated every Friday afternoon is more useful than one updated "whenever".

03The habits that matter more than any software

Every inventory system drifts. Parts get used without being logged, deliveries get shelved without being entered, something gets returned to the wrong bin. Good software makes recording easier, but it can't make people do it.

1. Make taking stock easy to record. A clipboard at the shelf, a simple form on a phone, a quick text to the office. If recording takes longer than grabbing the part, it won't happen.
2. Receive deliveries in one place. Check the packing slip against the order before anything goes on the shelf.
3. Cycle count, don't just year-end count. Count a handful of your most expensive or fastest-moving items every week. Small, frequent counts catch problems early.
4. Label shelves and bins. Match the label to the item code in your list.
5. Review the gaps. When the count doesn't match, ask why. The answer usually points to a process fix, not a software fix.

Inventory software records what people tell it. The count is only as good as the habit behind it.

04Level 2: when an inventory app makes sense

Off-the-shelf inventory apps are worth it when the spreadsheet starts fighting you. Common signs:

• Several people take stock out, and you can't tell who used what.
• You carry stock in more than one location, such as a shop plus vans, or two retail locations.
• You sell the same stock in store and online, and you've oversold because the counts didn't sync.
• You want barcode scanning to speed up counting and receiving.
• You need purchase orders that update stock automatically when the delivery arrives.

Which type of app depends on the kind of inventory you identified earlier. Retailers usually get the most from the inventory features in their POS or e-commerce platform. Trades and service businesses often get it from a field service app that tracks parts per job and per van. Some accounting tools, including some QuickBooks Online plans, include basic inventory features for simple resale.

If you are weighing a few apps against each other, our guide to off-the-shelf vs. custom software lays out the questions that matter, like data ownership, contract terms and how much of your process you'd have to change to fit the tool.

05Level 3: when custom inventory software pays off

Custom software isn't the default answer, but it is the right one in a few specific situations:

• Inventory is tangled up with your jobs. Parts get reserved when a quote is accepted, pulled when the job is scheduled, and billed when the job closes. Few apps connect quoting, scheduling and stock the way you actually work.
• You make things. Your products have recipes or cut lists that off-the-shelf tools model badly or only on expensive tiers.
• You're paying for three tools that don't talk. A POS, a spreadsheet and an accounting app, with someone retyping between them.
• You have rules nobody else has. Serial numbers on rental gear, lot numbers on food products, consignment stock, or equipment that goes out and comes back.

A custom build can be small. Often it is a phone-friendly screen where techs log what they took, a dashboard showing what's low, and an automatic reorder email to your supplier. If your jobs are already managed in a scheduling tool, look at job scheduling and dispatch software for trades first, since stock tracking often belongs alongside the job.

06Spreadsheet vs app vs custom at a glance

07A worked example: is a better system worth it?

Use your own numbers here. These are illustrative only.

Say each of your four techs loses about 45 minutes a week to missing parts: driving to a supplier, calling the office, or rebooking a visit. That is three hours a week of paid tech time. If a tech's time costs you $60 an hour including wages and the van, that is $180 a week, or a little over $9,000 a year, before you count rebooked jobs or annoyed customers.

Now compare that to what a fix would cost: tidying the spreadsheet (free, a few hours), an app subscription for your team, or a custom build. The point of the exercise isn't the exact number. It is knowing whether you're solving a $500 problem or a $10,000 one, so you spend accordingly.

08Where Sidekick fits

If a clean spreadsheet or an off-the-shelf app covers you, use it, and we'll say so on a call. Where we help is the messy middle: stock that's tied to quotes and jobs, vans that need phone-friendly check-out, or several tools that need to share one set of counts. We build custom systems at a fixed price agreed before any work starts, with no lock-in contract. Before you talk to anyone, our guide on how to plan a custom software project will help you get your requirements down on paper.

Frequently asked questions

What is the easiest way to track inventory for a small business?

A shared spreadsheet with one row per item, columns for location, quantity on hand and reorder point, and a weekly count. It is free, and it teaches you what you actually need before you pay for anything.

When should I stop using a spreadsheet for inventory?

When more than a couple of people take stock out, when you run multiple locations or vans, or when you keep finding that the sheet and the shelf don't match. Our post on when spreadsheets stop working has a fuller checklist.

Can QuickBooks Online track inventory?

Some QuickBooks Online plans include basic inventory tracking for items you buy and sell. Check what your current plan includes, since features vary by plan and change over time. It works for simple resale, less so for parts used on jobs or multiple locations.

Do I need barcodes to track inventory?

No. Barcodes speed up counting and cut typing errors once you have dozens of items moving daily, but a clear item list with short codes and labelled shelves gets most small businesses a long way.

How often should a small business count inventory?

Do a full count at least once a year for your books, and a short cycle count of your fastest-moving or most expensive items weekly or monthly. Frequent small counts catch problems while they are still easy to explain.