Running distribution on spreadsheets and QuickBooks: when to switch

Switch off the spreadsheet-and-QuickBooks stack when the operation stops fitting in one person's head. The reliable tells: a pricing mistake that cost more than a month of software, an order missed in a channel nobody was watching, receivables you cannot state without building a report, or a delivery that went out to an account already over its limit. Two or more of those in a month and you are past the ceiling.

There's a stack that runs a remarkable share of American food distribution: a price-list spreadsheet, QuickBooks for invoices, a phone full of order texts, and a whiteboard for routes. If that's your operation, you'll get no sneering here. The stack is free, everyone already knows how to use it, and at a certain size it works fine.

What every operator running it eventually suspects is that it has a ceiling. Below the ceiling, shopping for distribution software is a distraction from real work. Above it, every week on the old stack costs you margin, hours, and now and then a whole account. The question is which side you're on, and you should answer it from symptoms in your own operation rather than take a software vendor's word for it. (Background on what distribution software should actually do lives in our operator's guide. This piece is only about the "when.")

Where the stack works fine

Credit where due. With a dozen steady accounts, one price list, and one truck, the spreadsheet stack is close to optimal. The whole operation fits in your head and the spreadsheet is just a mirror of it. Re-keying an order text into QuickBooks takes two minutes. Nothing breaks, because you personally are the system, and at that scale you're a good one.

The ceiling isn't a specific customer count. It's the point where the operation stops fitting in one head. Different prices for different accounts. A second person taking orders. Terms customers carrying open balances. Retail orders arriving next to wholesale ones. Each of those multiplies the ways the mirror and reality can drift apart.

The failure modes, in the order they usually show up

The price list forks. The master spreadsheet gets emailed, copied, and printed, and within a month four versions exist. Now an account is being quoted January prices in June. Per-customer pricing makes it worse, because special prices end up living in the margins of the sheet, in an order-taker's memory, or nowhere at all. The customer remembers their price perfectly, of course. They always do. The fix, one base price per product plus deliberate per-account overrides, is laid out in per-customer wholesale pricing.

Orders live in ten places. Texts, voicemails, a napkin from the market. Every order gets keyed at least twice, once into the pack list and once into QuickBooks, and every keying is a fresh chance to ship five cases instead of four. We wrote a separate piece on what phone-and-text ordering really costs, but the core problem is simple: there is no single place where an order is just true.

Credit exposure goes invisible. QuickBooks knows who owes you money, but only after you've invoiced. It cannot stop this morning's order from going out to an account that's already over its limit, because whoever keys orders at 6 a.m. isn't cross-referencing receivables. This is the slow leak that stings the most when you finally total it up. Sometimes your biggest "growth" account turns out to be your biggest collections problem with good manners.

History exists only as archaeology. What did this account order last spring? What's your real weekly volume on rainbow carrots? Answering means digging through old spreadsheets and invoice PDFs, so questions that should take a glance take an evening, and mostly they just don't get asked.

You become the bottleneck. The clearest late-stage symptom. Nothing happens, not an order, not a price change, not a route swap, without going through the one person who holds the system in their head. Vacations turn into risk events. At that point you don't own a business so much as a job with employees.

When is it time to switch?

Skip the abstractions and check your last month against this list. Two or more hits means you're past the ceiling:

• You've eaten a pricing mistake bigger than a month of software cost.
• An order got missed entirely because it arrived in a channel nobody was watching.
• You can't state your total open receivables by account without building a report first.
• An account with an overdue balance took another delivery this week, and nobody decided that on purpose.
• Order intake eats hours of somebody's day that should be spent selling.
• You want to add retail, subscription boxes, or a second salesperson, and can't picture the current system surviving it.

What a switch involves, and what stays put

The migration is smaller than the dread around it. Catalog with real prices goes in first. Then customers, with their terms, credit limits, and special prices. Then accounts move to ordering online over a few weeks, one at a time; the customer-facing side of that is covered in the migration playbook. Distributors moving onto Minori Midori typically do all of this without stopping deliveries for a single day.

And the most common fear can be put down now: QuickBooks doesn't die. Your accountant keeps the books there, which is what it was built for. What moves out is everything it was never built for. Order intake. Per-customer price lists. Credit limits enforced at the moment an order is placed instead of discovered at invoice time. Delivery-day scheduling. Invoice generation and overdue tracking. The books stay the books, and operations finally get a system of their own.

The two reconnect at month-end. Instead of re-keying every invoice back into the books, you download your invoices, payments, and orders as CSV files formatted for QuickBooks Online's own import screens, on any plan Starter and up, for any period. Columns map automatically, totals match to the cent, and the bookkeeper's least favorite afternoon of the month quietly disappears. (The import itself, and its traps, are walked through in importing invoices into QuickBooks Online.) And if even the downloads feel like a chore, the Enterprise plan adds a two-way QuickBooks sync that creates the invoices and posts the payments in QuickBooks on a daily schedule, no file in either direction. The export stays on every plan Starter and up either way.

The pivot tables move too. What's selling, who's buying, and how the month is trending are built-in sales reports (by product, by customer, over time) instead of sheets somebody maintains by hand, and each one exports back to a clean CSV whenever you or your accountant want to slice it further in Excel. The numbers reconcile with your orders to the cent, which is more than most Monday-morning spreadsheets can promise.

The spreadsheet earned its years. But if the trigger list above read like your calendar, it's told you what it needed to. Start with the operator's guide to see the other side, or check what it costs against that one pricing mistake you still remember. The arithmetic tends to be short.