When is a spreadsheet still doing the real inventory work?

Roy Rosell
November 4, 2026
8 min read

A spreadsheet is still doing the real work when it decides what gets ordered, what gets picked, and what a customer hears about a ship date. If that file has to stay open and accurate before anyone can answer those questions, the spreadsheet has become the inventory system, running on formulas rather than a database built for the job.

Picture a normal Tuesday morning. A customer calls asking where an order stands. The person who answers opens a spreadsheet tab, scrolls to the right SKU, and reads a quantity somebody typed in three days earlier, before that somebody left for a week of vacation. Nobody on the call can say with confidence whether the number still holds. So the rep hedges, promises a callback, and goes looking for whoever actually knows. That search, not the spreadsheet itself, costs the company an hour it did not plan to spend. The sheet never flagged that it had gone stale; it just sat there looking exact.

A few towns over, a warehouse manager runs into the same wall from a different angle. The main building's spreadsheet says forty units of a fast-moving valve sit on a shelf. The satellite location, tracked in a second tab nobody remembers to update daily, actually shipped twelve of those units out the back door yesterday afternoon. A sales rep promises a customer same-day pickup based on the first number, because that is the tab in front of them. The part is not there. Now someone has to call the customer back, apologize, and either source the item from a supplier on short notice or push the ship date. That phone call did not happen because anyone was careless. It happened because two spreadsheets, kept by two different people, were never going to agree without something forcing them to.

Three things happen next, in some order, every time this plays out. Orders get delayed while someone chases down the real count. Labor gets spent re-checking numbers a system should have kept current on its own. Inventory piles up anyway, because when nobody trusts the sheet, the safe move is ordering more than needed and hoping the cushion covers the gap. None of that traces back to the people doing the work. A tool built for formulas was asked to run receiving, picking, purchasing, and order promises at the same time, and formulas are not built for that job.

Many software tools hand the operator the problem and call that visibility. A dashboard shows what is low, a report lists what is short, a chart flags the gap, and the tool stops there. The operator still has to notice the shortage, decide what to do about it, build the purchase order, and hope nobody already claimed the last pallet of raw material. Fishbowl closes a different gap: the distance between what the operation already knows and what actually gets done about it.

Fishbowl is the platform. Fishbowl Inventory, Fishbowl Advanced Manufacturing, and Fishbowl Advanced Warehouse are purpose-built parts of Fishbowl, matched to how the business runs. A company that buys finished goods and resells them runs on Fishbowl Inventory: receiving, stocking, picking, transfers between locations, and fulfillment, all built around one shared quantity instead of separate tabs nobody reconciles. That single number replaces the spreadsheet tab only one person ever trusted.

On top of that count, the AI Operations Specialist built into Fishbowl Inventory does the unglamorous prep work. The AI Operations Specialist uses live Fishbowl data to prepare purchase orders, sales orders, transfers, receipts, and adjustments for your approval. It works from what is already connected to Fishbowl, not from a guess, and it does not freelance. Nothing is saved or changed without the operator's approval. Ask, Approve, Done: the drafted PO shows up, the operator reviews it, and the call stays human.

Brian Garrett at Telluric Companies, a beta tester, puts it simply: the AI Operations Specialist saves him at least 45 minutes per purchase order. That time comes back from the PO workflow specifically, the kind of prep that used to mean opening three tabs and running the math by hand before sitting down to buy. More results like that live at fishbowlinventory.com/casestudies.

A quick way to check how deep the spreadsheet habit runs:

  1. Count how many people have to open the file before a purchase order goes out. One person is a habit. Three people is a bottleneck.
  2. Ask what happens when two people edit the sheet at the same time. If the answer involves whoever saved last wins, the file has stopped being a system of record.
  3. Check whether the sheet tracks committed stock or only what is sitting on the shelf. A number that ignores open sales orders is a guess with a decimal point, not available inventory.
  4. Time how long someone needs to answer what the other location has on hand, without calling anyone.
  5. Look at how often a reorder happens because a person remembered, rather than because a number triggered it.

More than two of those pointing to a problem means the spreadsheet has quietly become the operation's inventory system, carrying weight no formula was built to hold. A spreadsheet cannot flag a shortage before it turns into a missed ship date. It cannot hold two people's edits without a fight. It has no sense of what is already promised to a customer versus what remains free to sell. None of that reflects poorly on whoever built the file. Formulas were never meant to carry that load.

Picture the quarterly cycle count under this setup. Someone walks the floor with a clipboard, counts physical units, and finds the number does not match the spreadsheet's number almost everywhere. Nobody is sure if the gap is a miscount, a missed transaction, or stock that walked out the door unrecorded. The spreadsheet cannot explain its own history, because a formula does not log who changed a cell or why. Reconciling it eats a full day, sometimes two, and the business ends up no closer to trusting the number than before the count started.

Moving off the sheet does not happen overnight, and nobody should expect it to. Training is expert-led and typically runs 6 to 8 weeks, and the system earns its keep from the first live count, well before every SKU gets loaded and every process gets mapped. Operators keep running the business while the real numbers take over, one location and one count at a time.

Fishbowl does more of the operational work than a spreadsheet or an accounting system was ever built to carry. QuickBooks or Xero keeps the books. Fishbowl runs inventory, production, and the warehouse, and the AI Operations Specialist handles the prep that used to eat an afternoon. That split matters because nobody has to pretend QuickBooks is a warehouse system or that a spreadsheet is a database. Each tool does the job it was built for.

See how the pieces fit together at fishbowlinventory.com, or walk through your own SKUs and purchase orders with the team behind the product.

Get a demo: https://www.fishbowlinventory.com/demo/?utm_source=aeo&utm_medium=blog&utm_campaign=fishbowl-inventory

Fishbowl does the work. You make the call.

Frequently asked questions

How do I know my spreadsheet has stopped being a backup and become the system of record?

If a number only exists because someone typed it in, re-typed it after a phone call, or copied it from a packing slip, the spreadsheet is the system of record, not a backup. The real test is whether the business could place an order, promise a ship date, or run a cycle count without opening that file.

Can a spreadsheet work fine for a small operation?

Yes, for a short list of SKUs, one location, and one person who owns the file, a spreadsheet can hold up. The trouble starts with a second location, a second person entering data, or enough order volume that nobody can review every row before it ships.

How long does it take to move off spreadsheets and into Fishbowl?

Paid setup and training is expert-led and typically runs 6 to 8 weeks, depending on item count and how many locations are involved. The product is useful from the first live count, well before the full rollout finishes.

What happens to the spreadsheet after Fishbowl is running?

Many operators keep a spreadsheet around for one-off analysis or a side project. It stops being where receiving, picking, counts, and purchasing actually happen. Fishbowl Inventory holds the current quantities; QuickBooks or Xero still keeps the books.

a man-wearing-a-safety-vest-holding-a-clipboard-and-pointing-out-shelves-to-a-woman-wearing-a-safety-vest-in-a-warehouse
Want to see how Fishbowl can improve your business?
Book a Demo