Free Inventory Software, Spreadsheets or Custom? How to Set Up Barcode Inventory Tracking
Should you track inventory in a spreadsheet, a free app or a custom system? The limits of each option, a step-by-step barcode inventory setup for small businesses and the most common mistakes.
In brief: Spreadsheets and free inventory apps are fine for a small start with few products and one user, but errors and workload rise fast once several people work at once, or you need barcodes, lot/expiry tracking and accounting integration. Barcode inventory tracking takes five steps: (1) clean up item records and units, (2) give every item a barcode/QR code, (3) define warehouses and bin locations, (4) do an opening count, (5) record receipts, issues and transfers only by scanning. A phone camera is enough to scan; handheld scanners speed up busy warehouses. Aktaş Digital, a software development company based in Istanbul, Türkiye, builds custom barcode inventory software and works with clients internationally, remotely and in English.
Last updated: 17 November 2026
The limits of spreadsheet inventory
- Version chaos and lost data when several people edit the same file
- Sales, returns and transfers entered by hand, late or forgotten
- Hard-to-manage lot and expiry tracking
- No automatic low-stock alerts
- Juggling accounting and e-commerce stock separately
If three of these apply to you, it's time to switch.
When are free tools enough?
| Situation | Free / spreadsheet | Subscription | Custom |
|---|---|---|---|
| Few products, one person | Enough | Not needed | Not needed |
| Several users, barcodes | Not enough | Suitable | Suitable |
| Lot / expiry, several warehouses | Not enough | Partly | Suitable |
| Accounting + marketplace integration, custom approvals | Not enough | Limited | Suitable |
For costs see inventory management software cost for small businesses.
How to set up barcode inventory tracking
1. Clean up item records
The same item must not exist under two names, units (each, case, kg) must be clear and variants (size, colour) should be separate items.
2. Assign barcodes
Use the manufacturer's barcode if there is one; otherwise print the system's barcode or QR label. Shelf and carton labels follow the same logic.
3. Define warehouses and bins
If you have several warehouses or shelves, give each location a code and record transfers location to location.
4. Do an opening count
Before going live, count all stock with barcodes and close the gaps with your spreadsheet figures. Skip this and the system starts wrong on day one.
5. Record movements only by scanning
Receiving, sales/issues, returns and transfers are recorded by scanning; manual stock adjustments are open only to authorised people, with a reason.
6 common mistakes
- Switching without an opening count
- Not cleaning item records (one item, two records)
- Letting everyone make manual stock adjustments
- Not setting low-stock levels
- Not reconciling accounting and stock monthly
- Handing out scanners without training
Frequently Asked Questions
Is free inventory software enough for a small business?
For few products and one person it can be. With several users, barcodes, lots and integrations, a subscription or custom system is needed.
Do I need special hardware for barcode inventory?
No; a phone camera can scan barcodes. Handheld scanners and label printers speed up busy warehouses.
Can my spreadsheet data be imported?
Yes; item records are cleaned and imported, then verified with an opening count.
Conclusion
Spreadsheets and free apps are for starting out; as team, products and channels grow, a barcode-based, integrated inventory system prevents errors and lost time. The keys are clean item records and an accurate opening count. See our service page or fill in the quote form.
