How do you know a cycle count is real before you trust the dashboard?

Roy Rosell
November 3, 2026
8 min read

A cycle count is real when the number was captured at a single point in time, every open order and in-transit transfer was accounted for before the count, and the variance carries a documented reason alongside the corrected quantity. If any of those three are missing, the dashboard is showing you a guess with good formatting.

Here is what actually happens on a lot of floors. Someone counts a bin on Tuesday morning. A sales order ships out of that same bin Tuesday afternoon, but the adjustment from the count has not posted yet. By Wednesday, the dashboard shows a number that was accurate for about four hours and wrong ever since. Nobody lied. The count just got overtaken by the business before anyone noticed.

The costs show up in predictable places: a sales order promised against stock that was already gone, a purchasing manager reordering a part that is sitting in a bin nobody rechecked, and cash tied up in inventory the system says you need but the shelf says you do not. None of that gets fixed by counting more often if the count itself cannot be trusted.

Many systems show you the variance and leave you to figure out whether it is real. They flag a mismatch, maybe send an email, and stop there. The work of tracing the cause, checking for an uncounted transfer, an open pick, or a receiving error, still lands on a person with a spreadsheet and a long afternoon.

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. On Fishbowl Inventory, the AI Operations Specialist, currently in beta, 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.

That matters for cycle counting specifically because many of the gaps between a count and the dashboard trace back to a timing or process issue, not a math error. The AI Operations Specialist can surface the open transactions touching a bin before a count is locked in, so the person counting is not comparing a physical shelf to a number that a shipment already moved past.

Before trusting any count against the dashboard, run it through a short test. These are the same checks a warehouse lead should be making by hand if the software is not doing it for them.

  1. Was the count frozen against a specific timestamp, with no receiving or shipping posted to that location during the count window?
  2. Were in-transit transfers between locations accounted for, so stock on a truck is not missing from both ends or double-counted on both ends?
  3. Did every variance get a reason code, such as damage, miscount, or theft, rather than a silent quantity correction?
  4. Was the counted quantity reconciled against committed sales orders, so available stock and on-hand stock are not being confused?
  5. Did the same person count and approve the adjustment, or did a second set of eyes check anything over a set dollar threshold?

If the answer to more than one of those is no, the dashboard number is not wrong exactly, it is just not describing the floor you think it is. A real count also has to survive contact with what is still moving. A part sitting in a receiving dock, logged but not yet put away, is inventory the company owns and cash the company has spent, but it will not show up in a bin count. A kit or light-assembly item that got broken down into components for one order and not rebuilt for the next will throw off any count that assumes finished and component quantities move in lockstep. These are not edge cases on a busy floor. They are Tuesday.

Take a hardware distributor running three shifts out of one building. A pick for an online order pulls six units of a fastener from bin A14 at 6 PM. The cycle count crew hits that same bin at 7 AM the next day, before the night shift's shipment has posted because the paperwork sat in the driver's cab overnight. The count comes back six units short. On paper, someone stole six fasteners, or the sales order never got filled correctly. In reality, the shipment posts at 9 AM, two hours after the count already logged as a variance, and now someone has to spend thirty minutes backtracking through pick history to prove the six units are not actually missing. Multiply that by forty bins a week and it stops being a one-off. It becomes a standing tax on whoever owns inventory accuracy.

The same problem shows up with partial receipts. A supplier ships 500 units against a purchase order for 750, with the remaining 250 on backorder. If the receiving clerk closes the line as fully received instead of partial, the dashboard shows 750 units landed when only 500 are physically on the shelf. A cycle count against that bin two weeks later will not match the system record, and whoever is reconciling has to dig back through the purchase order history to find a receiving error that happened long before the count was ever scheduled. None of this is rare. It is what happens whenever a human keys in a transaction and the system has no way to flag the gap before the next count runs.

The fix is not more frequent counting for its own sake. A high-value, high-velocity SKU earns a weekly or monthly count. A slow mover might only need a quarterly check. What changes the outcome is catching the gap between counted and committed before it reaches a customer promise or a purchase order. That is the unglamorous work: checking what is open, what is in transit, and what has not posted yet, every single time, instead of trusting that last week's reconciliation still holds.

Brian Garrett at Telluric Companies says the AI Operations Specialist saves him at least 45 minutes per purchase order by preparing the draft from live data instead of starting from a blank screen. That is the same category of work as a cycle count reconciliation: pulling together what the system already knows so a person can make the call faster, with the context already assembled. See more results at fishbowlinventory.com/casestudies.

Before the next count, it helps to have a short list the whole team uses, so "trust the dashboard" means something specific instead of a vague feeling that the number looks right.

  1. Lock the count window and stop transactions in that location before anyone starts counting.
  2. Check open sales orders, transfers in transit, and anything sitting in receiving but not yet put away.
  3. Require a reason code on every variance over a set threshold, alongside the corrected number.
  4. Compare on-hand to available, not just on-hand to the last count, so committed stock is not mistaken for free stock.
  5. Route adjustments through approval instead of auto-posting, so a pattern of repeated variance on one SKU gets noticed.

None of this requires a bigger team. It requires the system to hand a person the context instead of just the number. Fishbowl runs inventory, production, and the warehouse; QuickBooks or Xero keeps the books, and the resulting adjustments are sent to QuickBooks or Xero on the export schedule so the accounting side reflects what the floor actually found, not what the dashboard assumed. You can read more about how Fishbowl approaches inventory accuracy at fishbowlinventory.com.

A dashboard is only as honest as the process feeding it. Get the timing, the open transactions, and the reason codes right, and the number on screen starts matching the shelf. Skip any of the three, and you are just looking at a guess with a nicer interface.

See how the AI Operations Specialist prepares your next count reconciliation for approval: Get a Demo.

Fishbowl does the work. You make the call.

Frequently asked questions

What is the difference between a cycle count and a full physical inventory?

A cycle count checks a subset of SKUs or a single location on a rolling schedule, so discrepancies get caught in days instead of once a year. A full physical inventory counts everything at once, usually shuts down shipping and receiving, and is harder to run often enough to catch drift early.

How often should a warehouse run cycle counts?

High-velocity and high-value SKUs typically get counted weekly or monthly, slower movers quarterly. The schedule should follow transaction volume and dollar risk, not a flat calendar, so the items most likely to drift get checked the most often.

Does setting up cycle counting in Fishbowl take long?

Setup is expert-led, and Fishbowl says most customers go live in 2 to 6 weeks, but the system is useful from your first live count. You do not need to wait for the full rollout to start catching variance on your busiest SKUs.

Can someone on the Fishbowl team help if a count does not reconcile?

Yes. Fishbowl offers in-house phone, live chat, and email support, so customers can reach a person when a count does not reconcile.

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