What inventory system do small manufacturers actually run, and why does it stick?

Roy Rosell
September 21, 2026
10 min read

Most small manufacturers run inventory around the work order itself: a bill of materials that explodes into components, parts that issue or backflush off the shelf, and a separate ledger for the books. They are not shopping a finished-goods tool with no BOM, and they are not buying a full ERP just because a spreadsheet ran out of room.

Here is what that looks like on an ordinary Tuesday. A work order calls for 20 units. Someone pulled extra components off the shelf last week as a cushion and never logged it. Finished goods look fine on the screen. Raw material looks fine too, until Friday’s run comes up short a lot number nobody can locate. The order ships late, someone spends the afternoon hunting instead of building, and the shop keeps a pile of extra stock on hand it did not need, because nobody trusts the count anymore. Delayed orders, wasted labor, unnecessary inventory: the same three costs, every time the gap between what the shop knows and what actually happened goes unresolved.

Most software shows you the problem and leaves you the work. Fishbowl gets the work done. You still make the call.

Fishbowl is the platform. Fishbowl Inventory, Fishbowl Advanced Manufacturing, Fishbowl Advanced Warehouse, and Juno are purpose-built parts of Fishbowl, matched to how the business runs. On both Fishbowl Inventory and Fishbowl Advanced Manufacturing, data-focused AI tells you what is happening on the floor right now, what is coming, and what needs your attention today, in plain English built from your own data.

On Fishbowl Inventory specifically, Juno uses live Fishbowl data to prepare purchase orders, sales orders, transfers, receipts, and adjustments for your approval. Nothing is saved or changed without the operator’s approval. A separate cloud product, AI Manufacturing, is targeting a launch around October, and Juno will run there too. It is not live yet, so details on exactly what it prepares will follow closer to launch. Fishbowl Advanced Manufacturing runs its own data-focused AI today; it does not have Juno.

Why the spreadsheet and the books stop being enough

Neither tool fails because it is dumb. A spreadsheet can hold a multi-level BOM if someone has enough tabs and enough patience. QuickBooks can value inventory well enough to close the month. Neither was built to track work in process, component dependencies across open orders, and lot traceability at the same time, while production demand shifts under them daily.

Vendor roundups for this question tend to list ten logos and pin a warehouse SKU to a plant that actually needed manufacturing depth. Treat those lists as names, not a scorecard. The scorecard that matters is BOM depth, work order handling, issue versus backflush, material requirements planning, lot and serial tracking, and how the whole thing sits next to the accounting system already running. Check that yourself before you check anyone’s list.

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

BOM depth, issue versus backflush, and MRP

Single-level kitting is real manufacturing work, and some shops only need that. But multi-level BOMs, phantoms, and configurations are a different job, and if a subassembly is also sellable on its own, the system has to hold both without a workaround. A work order consumes components and produces finished goods, with variance flagged when the floor uses more material than the BOM called for. If you are adjusting raw inventory after the fact instead of closing a work order, you do not have a real job cost. You have a guess with a timestamp on it.

Issue is a scan when a part leaves the cage. Backflush is an automatic consume when the work order closes. Lot-tracked parts usually cannot hide inside a backflush if a recall matters, so ask a vendor which posting they actually run, and if the answer is either, make them show a lot part both ways.

Material requirements planning earns its keep once open work orders, shared components, supplier lead times, and shifting demand make purchasing math unreliable to run by hand. A messy item master will make MRP suggest nonsense no matter how good the engine underneath it is, so clean the BOM first and turn MRP on second. The longer version of that logic is in material requirements planning.

Fishbowl runs inventory, production, and the warehouse. QuickBooks or Xero keeps the books. Replacing the ledger to fix a work order problem is how ERP projects start for no reason; the full case is in the QuickBooks bottleneck.

Matching the product to the actual operation

If you buy finished goods and resell them, Fishbowl Inventory handles receiving, stocking, picking, transfers, and fulfillment. Add Fishbowl Channels when those products sell through Shopify, Amazon, Walmart, or other channels. If you manufacture the product and need BOMs, work orders, MRP, production scheduling, or job and labor costing, use Fishbowl Advanced Manufacturing, with Channels added if you also sell online. If you do not manufacture but need deeper warehouse workflows such as 3PL management or EDI-driven fulfillment, use Fishbowl Advanced Warehouse. Multiple storefronts or owned locations alone do not automatically mean you need Advanced.

Fishbowl Advanced Manufacturing is one product, not a manufacturing module stacked on a warehouse module. It already covers warehousing plus manufacturing, which is why there is no pairing it with Fishbowl Advanced Warehouse; each one covers what the other does not need to. Beyond BOMs, work orders, MRP, and traceability, it also carries production scheduling and job and labor costing, which is the difference between a manufacturing platform and a tool that only kits parts.

What the numbers look like on Fishbowl Advanced Manufacturing

Hodo Foods runs Fishbowl Advanced Manufacturing with data-focused AI and cut stockouts 35 percent. Koken USA, also on Fishbowl Advanced Manufacturing with data-focused AI, cut sales backorders 10 percent. Cascadia Motion, an EV and hybrid powertrain manufacturer, cut inventory costs 18 percent on Fishbowl Advanced Manufacturing with data-focused AI, from sharper forecasting, better procurement calls, and less overstock sitting in the warehouse. See more outcomes on the case studies page.

Going live without buying the wrong SKU

Training is expert-led, typically six to eight weeks, with an assigned specialist walking your team through the item master, BOMs, and the accounting connection. Support after go-live is in-house: US experts for US customers, APAC for APAC, reachable by phone, email, or chat, never an AI agent reading a script.

Do not chase a perfect BOM before go-live. Start with the top 20 or 30 items, get issue or backflush right, then expand. A dirty item master feeding MRP will generate purchase orders you will spend a month unwinding, and connecting the books before item names, quantities, and costs settle just forces a reconciliation project nobody asked for.

Deciding without guessing

The choice is rarely finished goods versus a full BOM. It is how much operational work the shop actually carries: how many levels the BOM has, whether lot traceability matters, whether production scheduling and job costing are part of the daily fight, and whether the warehouse side needs 3PL or EDI depth on top of it. Match the platform to that, not to a single yes-or-no test.

If the daily fight is a work order against the gun, the board, or the batch, walk one BOM, one issue or backflush, and the books posting in a live demo before you commit. See how Fishbowl handles your own item master, BOM, and work order on a live walkthrough. Get a Fishbowl demo and choose Inventory or Advanced Manufacturing on purpose.

Fishbowl does the work. You make the call.

Frequently asked questions

What inventory system do small manufacturers actually run, and why does it stick?

Most run a system built around the work order: a bill of materials that explodes into components, parts that issue or backflush off the shelf, and a separate accounting system for the books. They need BOM depth, issue versus backflush, and material requirements planning, not a finished-goods tool with no BOM or a full ERP bought to fix an accounting problem.

Can QuickBooks run manufacturing inventory?

QuickBooks keeps the books, and some versions handle basic assemblies, but not multi-level BOMs, work orders, MRP, or shop-floor traceability. Manufacturers keep that accounting system in place and run inventory, BOMs, and production in a system built for that job, such as Fishbowl Advanced Manufacturing.

What is the difference between Fishbowl Inventory and Fishbowl Advanced Manufacturing?

Fishbowl Inventory covers finished-goods work: receiving, picking, transfers, and kitting for light assembly, with Juno preparing purchase orders, sales orders, transfers, receipts, and adjustments for your approval. Fishbowl Advanced Manufacturing is a separate platform built for multi-level BOMs, work orders, MRP, production scheduling, job and labor costing, and lot traceability.

What happens on a demo, and how long does it take to go live?

A demo walks your own item master, BOM, and work order through Fishbowl Inventory or Fishbowl Advanced Manufacturing so you can see the fit before you buy. Training after that is expert-led, typically six to eight weeks, with support in-house: US experts for US customers, APAC for APAC, by phone, email, or chat.