The spreadsheet works until it doesn’t

Most multi-vendor shops start with a spreadsheet, and for a while that’s the right call. Here’s where it usually breaks, and what to do about it.

Almost every antique mall, consignment store, and booth-rental shop I've looked at started the same way: one spreadsheet, one tab per month, vendor codes down the left, sales typed in by hand at the end of the day.

That's not a bad system. It's free, you already know how to use it, and when you have six vendors it genuinely works. The problem isn't the spreadsheet. It's what happens to the spreadsheet at around fifteen vendors.

Where it actually breaks

It's rarely one dramatic failure. It's a slow accumulation of small ones:

• Someone fat-fingers a commission rate in one cell and nobody notices for two months.
• A vendor negotiates 20% instead of 25%, and now there's an exception that lives only in your head.
• You add a booth fee halfway through the year and have to decide whether to go back and redo everything.
• A vendor asks "what did I sell on the 14th?" and answering takes twenty minutes of scrolling.

The last one is the one that actually costs you. Not because any single question is hard, but because with twenty vendors you're getting that question twenty times a month, usually by text, usually on a Sunday.

The month-end problem

Month-end is where the spreadsheet really shows its age. You're doing the same operation twenty times: filter to one vendor, sum their sales, apply their rate, subtract their fees, write it down, move on. It's an hour or two of work that is entirely mechanical and entirely error-prone, and you're doing it at the exact moment you're busiest.

And the output is a number you hand someone with no explanation attached. If a vendor disagrees with it, you're back in the spreadsheet reconstructing how you got there.

What "solving it" actually means

The fix isn't a better spreadsheet. It's making three things automatic:

Attribution. A sale should know which vendor it belongs to at the moment it rings up, not because you typed it in later. If your POS tracks items, the item should carry the vendor with it.

The math. Each vendor's rate, their fees, their exceptions — stored once, applied every time, not remembered.

The explanation. The vendor should be able to see the itemized list themselves. Not a number you texted them. A list with dates, items, and prices that adds up to the number.

That last one is the one people underrate. Most vendor disputes aren't really disputes about money — they're disputes about not being able to see the working. When the vendor can pull up the same breakdown you're looking at, the argument usually just doesn't happen.

When it's worth switching

Honestly? If you have five vendors and a spreadsheet you like, keep it. The overhead of moving isn't worth it yet.

The point where it stops being worth it is usually somewhere between ten and twenty vendors, or the first time you get a commission calculation wrong and have to have an awkward conversation about it. That conversation is expensive in a way that doesn't show up on any invoice.

VendNex exists because that's the point my brother's shop hit. If you're there too, the setup guide walks through getting started, and there's a free trial if you want to run it alongside your spreadsheet for a month before committing.