How to track cost of goods sold in QuickBooks for a product business

How to track cost of goods sold in QuickBooks for a product business

You can run a product business for years without knowing which products make money.

Revenue comes in, expenses go out, and the number at the bottom of your profit and loss statement (P&L) tells you whether you made money in a given period. What it can't tell you is which products earned it, which ones are dragging margins down, or whether a price increase is long overdue.

The missing piece is cost of goods sold: the direct cost of making what you sell. Without it, your P&L shows total results with no way to separate production costs from everything else. This post covers what cost of goods sold means for a product business, why QuickBooks doesn't track it on its own, and what a useful setup looks like.

What is cost of goods sold and why does it matter?

Cost of goods sold (COGS) is the total direct cost of producing the goods you sold in a given period. For a physical product business, that means raw materials and components, direct labor involved in making the product, manufacturing supplies used up in production, and packaging that ships with the finished item. It doesn't include marketing, outbound shipping to customers, administrative salaries, or anything not directly tied to making the product.

Gross margin (revenue minus COGS, expressed as a percentage) is the number COGS makes possible. A business with $400,000 in revenue and $160,000 in COGS has a 60 percent gross margin: 60 cents of every revenue dollar is available to cover operating costs and generate profit. The same business with $280,000 in COGS has a 30 percent gross margin and a very different set of financial decisions ahead.

Without COGS tracked separately, you can't calculate gross margin from your books. You can estimate it from memory, but estimates and reconciled figures are not the same thing. When you're making pricing decisions, evaluating your product mix, or applying for a loan, the difference matters.

Why doesn't QuickBooks track cost of goods sold on its own?

QuickBooks tracks what you tell it to track. Out of the box, it has no way to know which purchases are raw materials for production versus general operating supplies, which employees' time is direct production labor versus administrative work, or how to value the inventory sitting in your warehouse at month-end.

Getting COGS right requires three decisions upfront: an account structure in your chart of accounts that separates COGS from operating expenses, a consistent method for recording when materials move from inventory into production, and a clear policy on which expenses belong where. Connecting a bank account doesn't make any of those decisions for you.

QuickBooks Online does have an inventory tracking feature through Products and Services that assigns a cost to each item and moves it to COGS when the item is sold. For businesses that buy finished goods wholesale and resell them, that works well. For a business that manufactures its own products, the setup is more involved: you need to track raw material inventory separately from finished goods, record the cost transfer when materials go into production, and decide how to allocate direct labor and overhead per unit. Shopify and other e-commerce integrations, along with inventory platforms, require Pilot's Core bookkeeping plan. The Essentials plan connects to business banking and credit cards only. See what's supported at pilot.com/platform/integrations.

How should you structure your chart of accounts for COGS?

A product manufacturer's COGS structure has four sub-accounts under a parent COGS account: raw materials and components, direct labor (wages for anyone whose time goes directly into making the product), manufacturing supplies (consumables used in production that aren't part of the finished item), and packaging.

That structure lets you see total COGS in one line and drill into each component when you need to. When raw material costs rise because a supplier raised prices, you'll see it in the materials sub-account before it becomes a margin problem. When direct labor climbs as you scale, you'll see it independently of everything else.

A few things that often get miscategorized: outbound shipping to customers belongs in operating expenses, not COGS. It's a cost of getting the product to the customer, not of making it. Storage and warehouse costs are operating expenses unless the space is used exclusively for active production. Equipment depreciation on production machinery can go into COGS as manufacturing overhead, but only if it's allocated using a consistent, documented method.

How do you figure out the right cost per unit?

The standard tool is a bill of materials: a list of every input a product requires, in the quantity the recipe calls for, at the current cost per unit. When input prices change, you update the bill and the per-unit cost adjusts. That bill becomes the basis for two things at once: your inventory valuation on the balance sheet (what your raw stock is worth), and your COGS calculation on the P&L (what it cost to make the units you sold this month).

For labor, track production hours separately from administrative time and apply a fully loaded hourly rate (wages plus payroll taxes and benefits) to each unit produced. Many small product businesses treat all labor as a single operating expense line. The result is understated COGS, overstated margins, and pricing decisions made on a number more flattering than it is accurate.

What does month-end close look like once COGS is working?

Once your chart of accounts is set and your bill of materials is in place, the COGS calculation runs on its own. Each sale records the associated product cost. Each production run reduces raw material inventory and increases finished goods. The month-end close confirms that the physical inventory count matches the QuickBooks balance.

When it doesn't match, investigate before moving on. A small discrepancy in January that goes unchecked becomes a significant one by June. By the time you try to make sense of your margins in Q3, you may be looking at six months of accumulated error that distorts every pricing and production decision you make.

Pilot's bookkeeping service includes chart-of-accounts setup and ongoing COGS tracking for product businesses on the Core plan. Start with your bill of materials: pick your three best-selling products, list every input and its cost, and calculate what each unit costs to make. If you want to go deeper on the underlying concepts first, the Pilot blog's COGS explainer and COGS vs. expenses guide are good next reads.

KEY TAKEAWAY

QuickBooks won't track your cost of goods sold correctly unless your chart of accounts is built to support it. Separate accounts for raw materials, direct labor, and manufacturing supplies are what turn COGS from an estimate into a number you can act on. Get that right and gross margin becomes a management tool, not a mystery.