Small warehouse WMS vs Excel is a question I wrestled with for two years, and I wrestled with it the way every small warehouse owner does: by staring at the bank balance. Our warehouse is only about 3,000 square meters, seven people, order volume up and down like a roller coaster. Every vendor who walked in told us we were falling behind without a system. My only thought was: we cannot afford to burn money like that. I got burned once, patched things together with homemade fixes for a while, and only then worked out three lines that actually decide the question. Here is the honest math, so other small warehouses can skip my mistakes.

Our awkward reality: Excel was not bad, we just ran out of people-power

When we started in 2023, we had fewer than 400 SKUs and sixty or seventy orders a day. One spreadsheet handled receiving, inventory, and shipping, plus a group chat for shouting orders across the floor. It worked. Pickers remembered where things lived, two people double-checked every shipment, and we mis-shipped maybe one or two orders a month. Customers even praised us for being flexible.

Then a promotion broke us. One autumn, a regular client went live on a livestream, and in three days our volume jumped from seventy orders a day to more than two hundred. Same old method, only now the spreadsheet stretched longer every hour, pickers ran around with printed sheets, and the checker’s eyes glazed over by noon. That week we mis-shipped nine orders. One pair of customers literally got each other’s goods. The return shipping and apology costs alone would have paid half a month’s wages for an extra worker. Excel had not suddenly gone bad. We had simply passed the volume that human memory and eyeballs can cover.

That is the first lesson I want every small owner to hear: this is not a contest between advanced and backward. It is a question of whether your people can still cover the gaps. If they can, Excel is the cheapest good system you will ever own. If they cannot, no amount of trying harder fixes it.

The homemade fix that bought us time

After that bruising week, I did not rush out and buy software. Instead, I upgraded our homemade method first, and honestly, this is the step most small warehouses skip. They buy a system while their process is still a mess, and then they are shocked when the mess just moves into the new system.

We did three unglamorous things. First, we gave every location a fixed code, printed it, and stuck it on the end of each rack. Pick lists stopped saying “the second shelf over there” and started saying a code. Finding goods got faster overnight. Second, we split the spreadsheet into three sheets: one for stock quantity and location, one for orders and status, one for weekly reconciliation, all linked by order number so every change left a trace. Third, we made one non-negotiable rule: every day’s shipments had to be closed out in the sheet before anyone went home. No “we’ll catch up tomorrow,” because one day of delay turns into three days of confusion.

That homemade version carried us for another half year. Back at around a hundred orders a day, mis-shipments fell to two or three a month, and stock counts stopped being a nightmare. The takeaway: if your chaos comes from missing rules, a system will only automate the chaos. Fix the rules first, and the system becomes worth paying for.

Small warehouse WMS vs Excel: three lines to check

Eventually volume climbed again, and the homemade method started showing three distinct strains. I turned them into three lines. Cross any one of them for a sustained period, and it is time to seriously consider a WMS.

The first is the order-volume line. Once you are steadily above about 150 orders a day, printed lists plus manual checking will produce errors. It is not about effort; human attention simply slips during repetitive work. A WMS earns its keep here by scanning at dispatch, checking against the order, and shouting the moment something is wrong. It is a checker who never gets tired.

The second is the SKU line. Below 500 SKUs, experienced pickers can work from memory. Past 1,000 SKUs, new hires cannot memorize the floor, and both search time and wrong picks climb together. A WMS stops being about bookkeeping at that point and starts being about finding the right item in the right location, which is a different problem entirely.

The third, and most important, is the mis-ship line. My rough rule: more than five mis-shipments a month, or mis-ship costs — returns, reshipping, and lost customers — approaching half a worker’s monthly wage, means stop debating. Mis-shipping hurts worst where you cannot see it on a spreadsheet: trust. Winning back a lost regular customer costs far more than any starter system.

What to check Excel still works Time to consider a WMS
Daily orders Under about 100 a day, stable Steadily above about 150 a day
SKU count Under 500, veterans know the floor Above 1,000, new hires struggle
Mis-shipments One or two a month, cause is clear More than five a month, worse when busy

Here is the counterintuitive part: the worst thing a small warehouse can do is copy a big warehouse’s system. Large operations buy a WMS to manage hundreds of people and hundreds of thousands of SKUs. If you have seven people, importing their full workflow will bury you. Pick a system that lets you switch on just scanning, receiving, and stock alerts first. Everything else can wait. A system that grows with you beats a system that impresses a vendor’s sales team.

How we switched without blowing the budget

When we finally switched, we did it the small-warehouse way. First, we bought only the basic package: inventory, picking, and dispatch checking. Fancy reports and wave-planning features stayed switched off. Second, we ran two weeks in parallel, new system and spreadsheet side by side, reconciling numbers every day. When they disagreed, we checked the process first, not the software. Those two weeks were exhausting, but after go-live we barely had to rework anything. Third, training covered exactly three actions: how to scan on receiving, how to scan on putaway, how to scan on dispatch. Nothing else. Staff were productive the same day.

The result surprised even me. In the first month after switching, mis-shipments fell from seven or eight a month to one or two, and a stock count that used to take two people a full day took half a day. When you do the total math, do not compare the software quote with zero. Compare it with mis-ship costs, recount labor, and overtime. On that honest comparison, many small warehouses discover that “free” Excel is actually the most expensive option they have.

My advice: small warehouse WMS vs Excel, in that order

If you are still stuck on small warehouse WMS vs Excel, run this check in order. First, look at the three lines: orders, SKUs, mis-ship rate. Is any one of them crossed for good? Second, look at your rules: location codes, separated sheets, same-day closeout. Are those three in place? Third, look at your budget: buy only what you need right now, with room to expand later.

There is no shame in running a small warehouse the small way. Use Excel until it genuinely runs out, and when you switch, buy only enough. Do not let anyone scare you with “you’ll fall behind,” and do not keep struggling when your people clearly cannot cover the gaps anymore. Spend where it counts, and every dollar you save is a dollar you earned.

By Xiao Ma, Small Warehouse Owner