You can track inventory for a small business without spending a dime using spreadsheets, free-tier software, or a combination of both paired with a phone’s camera as a barcode scanner. The right approach depends on how many products you carry, how fast they move, and whether you sell online, in person, or both.
Start With a Spreadsheet
Google Sheets is the simplest free option and works surprisingly well for businesses with a few dozen to a few hundred products. You can build a tracker from scratch or grab a free template, and the whole thing lives in the cloud so you can update it from your phone, laptop, or tablet.
At minimum, your spreadsheet needs these columns: item name, item number or SKU, description, cost per item, stock quantity, and reorder level (the number at which you need to order more). If you work with suppliers, add columns for vendor name, date of last order, and reorder quantity. If you sell across channels or store products in different places, add columns for stock location and sales channel.
The real power of a spreadsheet comes from a few basic formulas. A Total Value column that multiplies cost per item by stock quantity gives you a running view of what your inventory is worth. A simple conditional formula in a Reorder column can flag items that drop below your reorder threshold, essentially acting as a free restock alert. For businesses that receive and issue stock, a balance formula that subtracts issued quantity from received quantity keeps your numbers current without manual math. Google Sheets also lets you use conditional formatting to turn cells red when stock is low, making problems visible at a glance.
The weakness of spreadsheets is that every change requires a manual entry. If you sell 15 units of something today, you or a team member has to type that in. For a business processing a handful of transactions a day, that’s manageable. Once you’re handling dozens of daily sales across multiple products, errors creep in fast.
Free Inventory Software Worth Considering
Several inventory management platforms offer permanently free tiers, not just trial periods. The limits vary significantly, so matching the right tool to your business size matters.
- Odoo: The most generous free plan available. Unlimited users, unlimited products, unlimited locations, and unlimited transactions. It’s open-source software with a modular design, so you can add inventory tracking without paying for features you don’t need. The learning curve is steeper than simpler tools, but the capacity is unmatched at zero cost.
- Square: If you already use Square for payment processing, its free plan includes inventory tracking with unlimited users, unlimited products, and up to two locations. Sales automatically deduct from your stock counts, which eliminates the manual-entry problem that plagues spreadsheets.
- Zoho Inventory: Best for a solo operator selling online. The free tier covers one user, one location (plus one Shopify store connection), and unlimited products. The catch is a cap of 50 orders per month, so this works only for low-volume sellers.
- Sortly: A visual inventory app that lets you add photos to each item. The free plan supports one user and up to 100 items across unlimited locations. Good for businesses tracking equipment, supplies, or assets rather than high-volume retail products.
- Toast: Designed specifically for restaurants. The free plan covers one location with unlimited users, products, and transactions. If you run a food business tracking ingredients rather than retail SKUs, this is purpose-built for you.
- Backbar: Another food-and-beverage option, focused on bar inventory. Free for unlimited users and products at one location.
For most small retailers or online sellers, Square or Odoo will cover the basics without hitting a paywall. If you sell primarily through Shopify and move fewer than 50 orders a month, Zoho Inventory connects directly to your store and updates stock automatically.
Use Your Phone as a Barcode Scanner
You don’t need a dedicated barcode scanner. Free apps like SCANPET turn your phone’s camera into a scanner that reads standard retail barcodes (UPC, EAN, QR codes, Code 128, and others). SCANPET uses Excel files as its database, so you can scan items directly into a spreadsheet without importing or exporting. Any edits you make in the spreadsheet file show up in the app automatically.
This is especially useful during receiving. When a shipment arrives, scan each item’s barcode instead of typing product names or numbers by hand. It cuts data entry time dramatically and reduces the typos that cause inventory records to drift from reality. The app is ad-supported with optional in-app purchases, but the core scanning and spreadsheet sync features are free.
Pick an Inventory Valuation Method
If you sell physical products, you need a consistent method for valuing your inventory, both for your own decision-making and for tax reporting. The two most common approaches are FIFO and LIFO.
FIFO (First In, First Out) assumes you sell your oldest stock first. If you bought 100 widgets at $5 each in January and another 100 at $7 each in March, FIFO says the next sale comes from the $5 batch. This method typically shows higher profits on paper because the lower, older costs get matched against current revenue. Higher reported profit means a higher tax bill.
LIFO (Last In, First Out) assumes you sell the newest stock first. Using the same example, the next sale would come from the $7 batch. When costs are rising, LIFO reduces reported profit and lowers your tax obligation. However, not all jurisdictions allow LIFO, and international accounting standards prohibit it.
For most small businesses, FIFO is the simpler and more intuitive choice. It also reflects how most physical products actually move: you sell the older stock before the newer stock, especially with perishable goods. Whichever method you choose, use it consistently. Switching methods mid-year creates accounting headaches.
Keep Your Counts Accurate With Cycle Counting
No system, whether it’s a spreadsheet or dedicated software, stays accurate on its own. Products get damaged, miscounted, stolen, or simply put back in the wrong place. The fix is cycle counting: regularly counting a small portion of your inventory rather than shutting everything down for one massive annual count.
Here’s how to do it. First, review your existing records and correct any data entry errors you already know about. Then pick a subset of items to count, either a specific product category, a shelf section, or your highest-value items. Physically count what’s on the shelf and compare it to what your records say. When the numbers don’t match, adjust your records to reflect reality and look for patterns. Are discrepancies clustered around a certain product type, location, or time of day? Those patterns point to the root cause, whether it’s receiving errors, theft, or sloppy recording habits.
A good rhythm for most small businesses is to count a different section each week so that over the course of a month or quarter, you’ve verified everything. High-value or fast-moving items deserve more frequent counts. After each cycle, calculate your accuracy rate (correct counts divided by total counts). Tracking that percentage over time tells you whether your processes are improving or slipping.
Putting It All Together
The practical setup for most small businesses on a zero budget looks like this: pick either a Google Sheets tracker or a free software tier as your central system, use a free barcode scanning app to speed up data entry during receiving and counting, choose FIFO as your valuation method, and schedule weekly cycle counts to keep your numbers honest.
If you’re just starting out with fewer than 100 products and minimal sales volume, a well-structured spreadsheet with a barcode scanner app is genuinely sufficient. Once you’re processing more transactions than you can reliably enter by hand, or selling across multiple channels, migrate to a free software tier like Square or Odoo that automatically deducts stock when a sale happens. The transition is easier if your spreadsheet was well-organized from the start, because you’ll already know your SKUs, costs, reorder levels, and vendor details.