You tell them apart by tracking available inventory separately from on-hand inventory. On-hand counts every unit in the building. Available subtracts what's already committed to open sales orders, pending transfers, or quality holds. A picker, a reorder report, and a sales rep on the phone should all be working from the available number, not the on-hand one.
Here's the scene that plays out in a lot of warehouses: the count says 240 units of a 3/8 inch stainless bolt. A picker grabs 30 of them Tuesday morning for an order that ships by noon. A sales rep, looking at the same screen Tuesday afternoon, quotes another customer 50 units for next week because the number on her screen still says 240. Thirty of those units were never free to promise in the first place. Nobody lied. The system just never separated "in the building" from "spoken for," and now Friday's order is short by thirty pieces with no warning until someone tries to pick it.
That gap costs real money three ways. You oversell and have to call a customer back with bad news on a Thursday afternoon. You hold safety stock you don't need because nobody trusts the number, so cash sits on a shelf instead of in the bank. Or a picker takes the only ten units left for a rush order that's actually reserved for a different customer, and now two people are waiting on the same part while someone tries to figure out who gets it.
Most software shows you the problem and leaves you the work. It'll tell you there's a shortage. It won't tell you which open order caused it, which transfer is already in motion, or what to do about either one. Somebody still has to open three screens, cross-reference a pick list, and guess.
What actually separates reserved from available
Three things determine whether a unit is free to pick:
- An open sales order has allocated it, even if it hasn't shipped yet. A customer ordered 50 units for delivery next Tuesday; those 50 should drop out of the available count the day the order is entered, not the day it ships.
- A transfer order has it moving between locations, so it's counted at the destination before it physically arrives. If a pallet left the main warehouse for a satellite location Monday, the receiving building should already show it as incoming, and the shipping building should already show it as gone.
- A quality hold or lot restriction has flagged it as not sellable yet, even though it's sitting on the shelf. A lot waiting on a supplier certificate shouldn't show up as pickable stock just because it's physically present.
Any one of those should pull a unit out of the available column as soon as the order, transfer, or hold is entered, not at end of day when someone reconciles a report by hand.
A buyer's checklist for testing this before you commit to a system
Before you sign anything, run these five checks against the demo environment, not the sales deck:
- Create a sales order for a part, then check the available quantity on a second screen. Did the number change before you moved on to the next task, or does it wait for a batch process?
- Start a transfer between two locations. Does the receiving location show the stock as incoming, or does it vanish from the total until it physically lands?
- Put a lot on quality hold. Can a picker still pull it from a pick list, or does the system block it outright?
- Ask what happens when two sales orders compete for the last five units. Does the system allocate on a first-come basis, or does it let both orders show "in stock" and leave the conflict for someone to discover later?
- Check whether a picker's handheld scanner shows the same available number the sales rep sees on their screen, taken at roughly the same time.
If any of those checks come back fuzzy, you've found where your next oversell is going to come from.
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. Inside Fishbowl Inventory, committed stock separates from available stock as soon as an order, transfer, or hold is entered, so a picker and a sales rep are reading the same number without waiting on a manual reconciliation. Fishbowl Advanced Manufacturing applies that same discipline to work orders and allocated components on the shop floor.
Picture a two-building operation: a main warehouse and a satellite location twenty minutes away. A picker at the satellite pulls the last six units of a part for a local delivery. At the same hour, a rep at the main office is quoting a different customer on the total company-wide count, which still includes those six units because the transfer hadn't been logged yet. That's the exact mismatch that turns into an apology call. When transfers are logged the moment they're created instead of at the end of the shift, both screens agree before either person acts on the number.
Inside Fishbowl Inventory, that available number feeds straight into the prep work the AI Operations Specialist does for you. The AI Operations Specialist is currently in beta and uses live Fishbowl data to prepare purchase orders, transfers, receipts, and adjustments for your approval. Nothing is saved or changed without the operator's approval. Ask, Approve, Done.
Brian Garrett at Telluric Companies saves 45 minutes per purchase order using that prep work.
Fishbowl exports finished transactions to QuickBooks Online or Xero on a schedule you set, while Fishbowl stays the system of record for inventory. The books stay in QuickBooks or Xero. Fishbowl runs the count a picker actually trusts. You can see how that split plays out on fishbowlinventory.com.
None of this requires a bigger warehouse or a second person watching the floor. It requires one number that updates as soon as something gets committed, instead of a spreadsheet that's right only until the next sale happens.
A third scene plays out on the loading dock at shift change. A night crew stages six pallets for a 6 a.m. truck, but nobody logs the pick until the truck actually pulls away four hours later. At 5:45, the day shift picker checks the floor count, sees the full case quantity still sitting as on-hand, and starts pulling from the same pallet for a rush order that came in overnight. The count was never wrong. It just hadn't caught up to what was already sitting on the truck apron. Logging the reservation the moment the night crew staged the pallets, rather than when the truck physically left, would have kept the day shift picker out of stock that was already gone in every way that mattered.
Manufacturers run into the same wall from a different angle. A work order allocates forty pounds of a raw material Monday morning for a production run scheduled Wednesday. Tuesday afternoon, QA pulls a sample from that same lot and flags it pending a supplier certificate. If the hold doesn't touch the quantity that's already allocated, a scheduler can still see forty pounds sitting there and promise it to a second work order, not realizing the first claim and the hold are both sitting on the exact same lot. The fix isn't more paperwork. It's making sure an allocation and a hold both subtract from the same available number the moment either one happens, so nobody downstream has to guess which claim came first.
See it against your own part numbers: get a demo.
Fishbowl does the work. You make the call.
Frequently asked questions
What is the difference between on-hand and available inventory?
On-hand is every unit physically in the building. Available is on-hand minus what is already committed to open sales orders, pending transfers, or held for quality review. A picker should only ever be sent after the available number, not the on-hand number.
Can a spreadsheet track committed versus available stock accurately?
A spreadsheet can hold the formula, but it only reflects reality at the moment someone last updated it. The gap between that update and the next sale or pick is where committed stock quietly gets picked and shipped twice.
How long does it take to go live on a system that tracks reserved stock?
Fishbowl says most customers go live in 2 to 6 weeks, useful from the first live count. That range covers mapping items, locations, and reorder rules, not a separate certification period.
How does Fishbowl's QuickBooks or Xero integration handle inventory data?
Fishbowl exports finished transactions to QuickBooks Online or Xero on a schedule you set, while Fishbowl stays the system of record for inventory. Item quantities don't sync to QuickBooks.
