Tracking COGS in QuickBooks vs. Stocksmith — What Syncs and What Doesn't

Last updated: April 2026

Most product businesses that use QuickBooks run into the same wall. Open the Profit & Loss report, find your COGS number. It’s either blank, wildly inaccurate, or just “purchases” with a label slapped on it. You know what you sold. You roughly know what you spent on materials. But the number QuickBooks shows you doesn’t feel right.

It usually isn’t.

The reason isn’t that QuickBooks is broken. It’s that QuickBooks and product businesses are solving different problems. Understanding where the line is, and what actually syncs between the two systems, saves a lot of frustration.

What QuickBooks actually does for COGS

QuickBooks is an accounting tool. It records transactions: money in, money out, what category each belongs to. When you buy materials, that purchase hits an expense account. When you sell a product, that revenue hits an income account. QuickBooks can tell you, at any moment, what your bank balance is and how much you’ve spent this quarter.

Where it gets complicated: QuickBooks doesn’t know what went into the products you sold. It doesn’t know your recipes, your batch sizes, or how much of each material went into each unit. It tracks money, not materials.

So when it reports COGS, it’s usually one of two things:

• Purchases / Cost of Goods (simple): everything you bought to run your business, assigned to a COGS account. Not per-product, just total spend.
• Inventory tracking (QuickBooks Plus/Advanced): if you manually enter each product with a unit cost, QuickBooks can track stock and adjust COGS as you sell. But that unit cost has to come from somewhere. You still have to calculate it yourself.

That second option sounds promising. But for product businesses with recipes, it breaks down fast.

Where QuickBooks falls short for recipe-based businesses

Let’s say you make a 100g face cream with eight ingredients. Each ingredient has a different cost per gram, different purchase quantities, and prices that fluctuate when you reorder. The cream takes 20 minutes to make per batch. You also have overhead: packaging, labels, and a portion of your workspace cost.

For QuickBooks to track inventory accurately, you’d need to:

1. Calculate the exact cost of each ingredient per unit of cream
2. Update that cost whenever a material price changes
3. Manually enter those cost figures into each product record
4. Recount and adjust every time you manufacture a batch

That’s a fair bit of work before you’ve made anything. And if you sell 30 different products with overlapping materials, the complexity multiplies quickly.

This is the gap Stocksmith fills.

What Stocksmith calculates (and why it matters)

Stocksmith is built around the idea that COGS has to be calculated, not guessed. It uses your recipes (called Bills of Materials, or BOMs) to figure out the exact material cost of each product, factoring in what you paid, how much you used, and the weighted average cost of your materials as prices change over time. For full technical details on what syncs to QuickBooks and which plans include this integration, see the QuickBooks integration page.

When you manufacture a batch of 50 face creams, Stocksmith:

• Deducts the exact material quantities from your inventory
• Updates the material costs based on your latest purchase prices
• Calculates the true cost per unit including materials and labour
• Records those manufactured units in your finished goods inventory

When that batch sells (whether through Etsy, Shopify, or another channel), Stocksmith automatically allocates the correct COGS to each sale.

You don’t enter a cost per product manually. You don’t recalculate when ingredient prices change. The system does it from the recipe up.

How the QuickBooks sync actually works

Stocksmith can push your COGS and inventory valuations directly to QuickBooks Online (available on Growth plans). Here’s what that means in practice:

What syncs:

• COGS journal entries: the total cost of products sold in a period, mapped to your QuickBooks COGS account
• Inventory asset value: the current value of your raw materials and finished goods, posted as an asset adjustment in QuickBooks

How it works:

1. Connect your QuickBooks Online account from within Stocksmith
2. Map your QuickBooks accounts (COGS account, inventory asset account, adjustment account)
3. Choose your sync period (monthly works well for most product businesses)
4. Push the data. Stocksmith sends a journal entry to QuickBooks with the totals.

Your accountant gets clean, accurate numbers in QuickBooks. You skip the manual journal entries. And because Stocksmith has already done the per-product, per-batch calculation, the COGS figure that lands in QuickBooks is actually correct. Not “total purchases” or a rough estimate.

What doesn’t sync (and why):

• Individual line-item detail: QuickBooks gets the period totals, not individual manufacture records
• Material-level purchase history: that stays in Stocksmith, where it’s most useful
• Recipe data: QuickBooks has no concept of a BOM, so that information lives in Stocksmith

Think of it this way: Stocksmith is the engine room, doing the detailed cost accounting per product and per batch. QuickBooks is the bridge, showing the financial impact to your accountant and for tax purposes.

Using both tools together: the workflow that actually works

For product businesses running a real manufacturing operation, the two-tool approach works better than trying to force either one into a role it wasn’t built for.

A practical monthly workflow looks like this:

In Stocksmith (ongoing):

• Enter material purchases when you restock
• Record manufactured batches as you produce them
• Orders sync automatically from your sales channels
• COGS is calculated in real time

At month-end:

• Review your Stocksmith COGS report (cost by product, by channel, by period)
• Push the period’s COGS and inventory valuation to QuickBooks via sync
• Your accountant sees accurate numbers in QuickBooks without you manually entering anything

At tax time:

• Your QuickBooks has clean, accurate COGS figures for the year
• Stocksmith has the product-level detail if you need to show your working
• Schedule C Part III (for sole proprietors) is much less painful when the numbers are already calculated

This is the setup that takes “month-end scramble” off the table.

Do you need both tools?

Not always. If you’re early-stage and selling a small number of simple products, QuickBooks alone might be enough, especially if you’re willing to manually enter unit costs and update them periodically.

But most product businesses that use Stocksmith reach a point where one of these things happens:

• They add more products and manual cost updates become untenable
• They start buying materials in bulk and prices vary, so weighted average costs become important
• They want to know which products are actually profitable, not just total COGS
• They’re preparing for tax time and the numbers don’t add up

If any of those sound familiar, Stocksmith’s free trial is worth a look. You can connect your Etsy or Shopify store, enter a few recipes, and see how your COGS actually calculates. Most product businesses have it set up in a day.

Frequently Asked Questions