Inventory Management for Small Business: Stop Losing Cash

Every unsold item on your shelf is cash you already spent but have not gotten back. For sari-sari stores, resellers, and food businesses, sloppy inventory management small business habits quietly eat profit — even when sales look fine on paper.
Why inventory is really cash sitting still
When you buy stock, money leaves your pocket immediately. You only get it back — plus profit — when the item actually sells. Until then, that stock is not an asset sitting safely on a shelf. It is your working capital, frozen.
This is why two stores with the same sales can have very different cash positions. One reorders based on gut feel and ends up with slow-moving stock tying up money that should be funding next week’s fast-sellers. The other tracks turnover and keeps cash flowing. If you have not read our guide on cash flow 101 for small business, inventory is usually the biggest hidden drag on cash that owners overlook.
Start with a real stock count
You cannot manage what you have not counted. A physical stock count — even a simple one — is the foundation of everything else.
- Count every SKU you carry, not just the ones you remember.
- Write down quantity on hand, not what your last delivery receipt said.
- Do it on a fixed schedule: weekly for fast-moving food items, monthly for slower general merchandise.
- Use one spreadsheet as your single source of truth, not scattered notebooks or memory.
A stock count that lives only in your head disappears the day you get busy, get sick, or hire help. Written down, it becomes something you can actually manage.
Know your fast movers from your slow movers
Not all products deserve equal attention. Rank your items by how fast they sell and how much profit they contribute.
- Fast movers: sell out quickly, need frequent reordering, must never run out.
- Slow movers: sit for weeks, tie up cash, and risk expiring or going out of style.
Fast movers
Sell out quickly and need frequent reordering. Protect these — a stockout here is a lost sale you never recover.
Slow movers
Sit for weeks, tie up cash, and risk expiring. Review monthly and shift the budget toward what actually earns.
Many small stores waste shelf space and cash on slow movers because “it’s always been part of the stock.” Reviewing this list monthly lets you shift buying budget toward what actually earns. This connects directly to margins — if you are unsure which items are truly profitable after cost, check our guide on how to compute COGS before deciding what to keep stocking.
Set reorder points so you never run out or overstock
A reorder point is the stock level that tells you “order now” — before you run out, but not so early that you are overstocked.
The basic formula:
Reorder point = (Average daily sales x Lead time in days) + Safety stock
Worked mini-example
Say you sell canned goods and one item averages 10 units sold per day. Your supplier takes 3 days to deliver after you order. You also want 15 units of safety stock in case sales spike or delivery is late.
- Average daily sales: 10 units
- Lead time: 3 days
- Safety stock: 15 units
- Reorder point = (10 x 3) + 15 = 45 units
How the 45-unit reorder point is built
This means the moment your stock count hits 45 units, you place a new order — not when the shelf looks empty. Do this for every fast mover and you stop losing sales to stockouts while avoiding the trap of over-ordering slow items just because a supplier offered a bulk discount.
First-in, first-out (FIFO) — especially for food
FIFO means selling your oldest stock first. It sounds obvious, but many small stores accidentally do the opposite: new deliveries get placed in front, and customers (or staff) grab what is easiest to reach, leaving older stock to expire quietly at the back.
- Rotate stock physically — old items in front, new items behind.
- Label delivery dates on boxes or containers when possible.
- Check near-expiry items weekly and move them to a discount or promo shelf before they become a total loss.
For food and perishable businesses, FIFO is not optional. Every expired item is 100% loss — no partial recovery, unlike slow-moving non-food stock you can eventually mark down.
Why FIFO matters most for food
Every expired item is a 100% loss
Unlike slow non-food stock you can mark down, spoiled goods give you zero recovery.
Spot shrinkage and spoilage before they pile up
Shrinkage is stock that disappears without a sale — theft, breakage, employee “consumo,” or simple counting errors. Spoilage is stock that expires or spoils before it sells. Both are silent profit killers because they never show up as an obvious expense; they just make your actual stock lower than what your records say it should be.
You catch these only by comparing what should be on the shelf against what is actually there, regularly, not once a year.
Reconcile stock vs. sales regularly
This is the step most small businesses skip, and it is the one that catches problems early. Reconciliation means comparing three numbers:
- Beginning stock (from your last count)
- Plus stock received (deliveries)
- Minus stock sold (from your sales records)
Beginning stock
Start from your last physical count, not memory.
Plus deliveries received
Add every unit that came in during the period.
Minus units sold
Subtract sales from your records to get expected stock.
Compare to actual count
Any gap is shrinkage, spoilage, or a recording error to investigate.
The result should match your current physical count. If it does not, the gap is shrinkage, spoilage, or a recording error — and now you know to investigate instead of letting it repeat month after month. Regular reconciliation also feeds directly into accurate numbers on your simple profit and loss statement, since unrecorded losses otherwise inflate your apparent profit.
A simple spreadsheet beats guessing
You do not need expensive inventory software to fix this. A clear spreadsheet with columns for item, beginning stock, deliveries, sales, ending stock, reorder point, and expiry date already covers 90% of what a small store needs. The discipline of updating it consistently matters far more than the tool itself.
Frequently asked questions
How often should a small store do a physical stock count?
Fast-moving food items should be counted weekly since spoilage risk is high. Slower non-food merchandise can be counted monthly. The key is consistency — a count done on the same schedule every time is far more useful than an occasional deep audit.
What is the difference between a reorder point and safety stock?
Safety stock is the buffer quantity you keep as a cushion against delays or demand spikes. The reorder point is the total trigger level — it already includes safety stock plus what you expect to sell during your supplier’s lead time. When stock hits the reorder point, it is time to order.
How do I know if an item is a slow mover I should stop stocking?
Track how many units of an item sell over a set period, such as 30 or 60 days, and compare it against how much cash it ties up. If an item consistently sells slowly, contributes thin margins, and rarely hits its reorder point, it is likely tying up cash better spent on your fast movers.
Stop guessing your stock levels
Get a ready-to-use inventory spreadsheet built for Philippine small businesses — track stock counts, reorder points, and FIFO in one place. Pay easily via GCash, Maya, or Maribank.