Tracking COGS in QuickBooks vs. Craftybase — What Syncs and What Doesn't
QuickBooks tracks your money. Craftybase calculates your costs. Here's exactly what each tool does for COGS, why they differ, and how makers use both together.
Last updated: April 2026
Most makers who 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 maker 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 silver wire went into each pair of earrings. 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 makers 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:
- Calculate the exact cost of each ingredient per unit of cream
- Update that cost whenever a material price changes
- Manually enter those cost figures into each product record
- 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 Craftybase fills.
What Craftybase calculates (and why it matters)
Craftybase 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.
When you manufacture a batch of 50 face creams, Craftybase:
- 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), Craftybase 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
Craftybase 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:
- Connect your QuickBooks Online account from within Craftybase
- Map your QuickBooks accounts (COGS account, inventory asset account, adjustment account)
- Choose your sync period (monthly works well for most makers)
- Push the data. Craftybase 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 Craftybase 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 Craftybase, where it’s most useful
- Recipe data: QuickBooks has no concept of a BOM, so that information lives in Craftybase
Think of it this way: Craftybase 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 makers running a real product business, 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 Craftybase (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 Craftybase 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
- Craftybase 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 makers who use Craftybase 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, Craftybase’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 makers have it set up in a day.
Frequently Asked Questions
Does QuickBooks Online automatically calculate COGS for handmade products?
QuickBooks Online does not automatically calculate COGS from recipes or Bills of Materials. It tracks money in and out: if you assign material purchases to a COGS account, those totals appear in your P&L. But it doesn't know what ingredients went into each product, how much you used per batch, or how costs shift when you reorder at different prices. You'd need to enter and update unit costs manually for every product. Craftybase calculates this automatically from your recipes, so the COGS figure is accurate without manual input.
What exactly syncs from Craftybase to QuickBooks?
The Craftybase–QuickBooks sync pushes two things: COGS journal entries (the total cost of goods sold in a period, mapped to your QuickBooks COGS account) and inventory valuations (the current asset value of your raw materials and finished goods). It sends these as journal entries to QuickBooks Online, where your accountant can review them. Individual manufacture records, recipes, and material-level data stay in Craftybase. QuickBooks receives the financial summary only. The sync is available on Growth plans.
How does Craftybase calculate COGS differently from QuickBooks?
Craftybase calculates COGS from your recipes and manufacture records: it takes the exact material quantities used per batch, prices them at weighted average cost (accounting for price changes over time), and allocates the result to each unit produced. When a product sells, the pre-calculated cost per unit becomes the COGS. QuickBooks, by contrast, assigns COGS based on account categories in your bookkeeping. It doesn't have access to your recipe data or manufacture history. Craftybase gives you per-product profitability; QuickBooks gives you the financial statement totals.
Do I need both QuickBooks and Craftybase, or can I use one?
Most makers use both for different purposes. QuickBooks handles your full financial picture: bank reconciliation, invoicing, payroll, tax reporting. Craftybase handles the operational side: material tracking, recipe costing, manufacture records, per-product COGS. They're designed to work together rather than replace each other. If you only sell simple finished goods you buy pre-made (no recipes), QuickBooks alone may be sufficient. But if you make products from raw materials, Craftybase is the tool that calculates what it actually costs you to make them.
Can Craftybase help me prepare my COGS for Schedule C?
Yes. Craftybase generates a COGS report that maps directly to Schedule C Part III (for sole proprietors and single-member LLCs). It tracks your beginning inventory, material purchases during the year, ending inventory, and cost of goods sold. Those are exactly the figures the IRS asks for. You can run the report for any date range and export it for your accountant or enter the numbers directly on your tax return. Combined with the QuickBooks sync, your financials and operational records stay in agreement throughout the year.
