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.
Central Florida's Trusted Bookkeeping Firm
Start Here:
A 30-Minute Consultation
Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.
More Questions
How do I track cost of goods sold when my supplier prices change every order?
Use a consistent inventory costing method like weighted average or FIFO. QuickBooks Online calculates FIFO automatically when inventory tracking is enabled, so your COGS stays accurate even as purchase prices shift.
Read answerWhat's the best way to record monthly inventory adjustments in QuickBooks Online?
Use the Adjust Quantity feature under Products & Services in QBO. Enter your physical count, and QuickBooks calculates the variance automatically and posts it to an expense account like Inventory Shrinkage.
Read answerWhat's the difference between FIFO, LIFO, and weighted average for inventory valuation?
FIFO records the oldest inventory costs as cost of goods sold first, LIFO records the newest costs first, and weighted average blends all costs together. The method you pick directly affects your reported profit and tax liability.
Read answerHow does a food truck owner handle bookkeeping differently than a restaurant?
Food truck bookkeeping revolves around tracking revenue by location, managing vehicle expenses, handling commissary kitchen costs, and staying on top of variable event fees and permits. The mobility that makes the business model appealing is exactly what makes the financial tracking more complex than a fixed-location restaurant.
Read answerHow often should my business do a physical inventory count and how do I record adjustments?
Most businesses should count inventory at least quarterly, though the right frequency depends on your volume, industry, and how much shrinkage risk you face. Adjustments get recorded as changes to your inventory asset and an offsetting shrinkage expense.
Read answerWhen does a business actually need professional inventory accounting vs a spreadsheet?
A spreadsheet works fine when you carry a handful of products and restock infrequently. Once your SKU count grows, you sell across multiple channels, or your inventory value is large enough to distort your tax return if it's wrong, it's time for something more structured.
Read answer
