How do I track raw materials vs finished goods in QuickBooks for a small manufacturer?

The foundation is your chart of accounts. Under your main Inventory Asset account, create two sub-accounts: Raw Materials and Finished Goods. If you have products that sit partially completed for any meaningful amount of time, add a third for Work-in-Progress. This separation is what lets you see how much money is tied up at each stage of production instead of lumping everything into one number.

Next, set up your inventory items in QuickBooks and map each one to the correct sub-account. Flour, packaging, resin, fabric, whatever you buy to make things goes under Raw Materials. The products you actually sell to customers go under Finished Goods. When you create each item, point its asset account to the right sub-account. This is the step most people skip, and it’s the one that makes the whole system work.

The tricky part is recording the build. When you take raw materials and turn them into a finished product, you need to move the cost from one account to the other. QuickBooks Desktop has an inventory assembly feature that handles this relatively well. You define a bill of materials listing the components and quantities, and when you build assemblies, QuickBooks reduces raw materials and increases finished goods automatically.

QuickBooks Online is more limited for manufacturing. QBO Advanced has a basic inventory assembly function, but if you’re on Plus or a lower tier, you don’t have that option natively. The workaround is using journal entries to transfer costs manually, but that gets tedious fast and introduces room for error. Many small manufacturers in this situation connect a third-party inventory app like Katana, SOS Inventory, or inFlow to their QuickBooks Online. These tools handle the production tracking and sync the financial impact back to QuickBooks.

Whichever method you use, make sure your cost of goods sold reflects the cost of the finished product when it sells, not just the raw material cost. Labor and overhead that go into production need to be factored into the finished goods cost. Otherwise your margins look different from reality. For a small operation, even a simple standard cost per unit that includes estimated labor and overhead is better than ignoring those costs entirely.

Do a physical count regularly. QuickBooks will track what the numbers should be based on purchases and sales, but shrinkage, spoilage, and data entry mistakes will create gaps between what the system says and what’s actually on the shelf. Monthly counts for finished goods and quarterly for raw materials is a reasonable starting point. Adjust the quantities in QuickBooks after each count so your balance sheet stays accurate.

If this feels like a lot of moving pieces, that’s because inventory accounting for manufacturing is genuinely more complex than a typical retail or service business. The difference between doing it right and doing it approximately is knowing your true product costs and real margins. Getting the setup right from the beginning saves you from having to untangle months of misclassified inventory later.

For small manufacturers in Central Florida who need help structuring this properly, working with someone experienced in inventory accounting in Orlando can make the difference between a system you actually trust and one you’re constantly second-guessing. The goal is a setup where you can look at your balance sheet and know exactly how much value sits in raw materials versus finished products ready to ship.