QuickBooks Setup Mistakes That Cost CPG Founders Thousands

QuickBooks is the go-to accounting software for most early-stage CPG brands, and for good reason — it's affordable, widely supported, and your CPA probably already knows how to work with it. But here's the thing: QuickBooks is only as good as how it's set up. And most founders set it up wrong from day one.

The default chart of accounts QuickBooks gives you is designed for a generic small business, not a product company with co-packers, multiple sales channels, inventory, and complex COGS. If you're running your CPG brand on a vanilla QuickBooks setup, you're almost certainly missing critical financial data — and it's costing you money in ways you might not realize.

Here are the most common mistakes and how to fix them.

Mistake 1: Using the Default Chart of Accounts

When you first set up QuickBooks, it gives you a basic chart of accounts with categories like "Cost of Goods Sold" as a single line item and a handful of generic expense categories. For a service business, that's fine. For a CPG brand, it's useless.

You need sub-accounts under COGS that break out raw materials, packaging, co-packing fees, and freight. You need separate expense accounts for Amazon fees, trade spend, samples, and warehousing. Without this granularity, your P&L tells you almost nothing about where your money is actually going.

The fix takes about an hour. Sit down and build a chart of accounts that reflects how your business actually spends money. If you're not sure what that should look like, work with a bookkeeper who understands CPG — the structure they set up will pay for itself many times over.

Mistake 2: Not Tracking Inventory Properly

A lot of CPG founders start by expensing everything they buy as COGS immediately. You buy $10,000 in ingredients, it shows up as $10,000 in COGS that month. But if you haven't sold all that product yet, your COGS is overstated and your profit is understated.

QuickBooks has inventory tracking features, but many founders either don't turn them on or don't set them up correctly. At minimum, you should be using inventory asset accounts to hold the cost of raw materials and finished goods until they're actually sold. When a sale happens, the cost moves from inventory to COGS.

This matters more than most founders realize. Without proper inventory tracking, your monthly P&L swings wildly based on when you happen to buy ingredients rather than when you actually sell product. That makes it nearly impossible to understand your real profitability.

Mistake 3: Lumping All Sales Into One Revenue Account

If you're selling through Shopify, Amazon, wholesale, and maybe farmers markets, and all of that revenue lands in a single "Sales" account, you can't see which channels are actually making you money.

Create separate revenue accounts for each channel — or at minimum, use QuickBooks classes or tags to track channel performance. When you can see that your DTC channel does 60% gross margin but Amazon does 35% after fees, you make very different strategic decisions than if you just see a blended number.

This also matters for investor conversations. Investors want to understand your channel mix and the economics of each one. If you can't break it out, it raises questions about how well you understand your own business.

Mistake 4: Ignoring Sales Tax Setup

If you're selling DTC across state lines, you likely have sales tax obligations in multiple states. QuickBooks can handle multi-state sales tax, but only if it's configured correctly. Many founders either ignore sales tax entirely (risky), manually calculate it (error-prone), or set it up for their home state only.

Get this right early. The longer you go without properly collecting and remitting sales tax, the bigger the liability that's quietly building on your balance sheet. Most states have lookback periods, and the penalties and interest add up fast.

QuickBooks integrates with tools like TaxJar and Avalara that automate multi-state sales tax. The setup takes a bit of effort upfront, but it's far cheaper than dealing with a sales tax audit later.

Mistake 5: Not Connecting Your Bank and Payment Feeds

This sounds basic, but a surprising number of founders are still manually entering transactions or importing CSV files. QuickBooks can connect directly to your bank accounts, credit cards, Shopify, PayPal, and other payment processors to pull in transactions automatically.

The key is that automatic imports still need to be reviewed and categorized correctly — they're not a "set it and forget it" solution. But they eliminate the risk of missing transactions entirely, which is one of the most common causes of books that don't balance.

Set up your feeds, then build a weekly habit of spending 15 minutes categorizing and reviewing new transactions. It's much easier to stay current than to catch up after months of neglect.

Mistake 6: Misusing Classes, Tags, and Locations

QuickBooks offers classes, tags, and location tracking as ways to slice your data across different dimensions. These are powerful tools for CPG brands — you can use them to track profitability by product line, by sales channel, or by region.

The mistake is either not using them at all or using them inconsistently. If you tag some Amazon transactions with a "Marketplace" class but forget on others, your reports are unreliable. If you set up classes for channels but also use tags for the same purpose, you've got duplicate data that doesn't match.

Pick one system, define what each class or tag means, and use it consistently on every transaction. Document it so that anyone who touches your books (including a future bookkeeper) knows the system.

Mistake 7: Not Reconciling Marketplace Payouts

Amazon, Shopify, and other marketplace payouts don't match your actual sales one-to-one. Amazon batches payments every two weeks, deducts fees, returns, and chargebacks, and deposits a net amount. Shopify does something similar depending on your payment terms.

If you're just booking the deposit amount as revenue, your books are wrong. You need to break out gross sales, fees, returns, and refunds so your revenue and expense numbers are accurate. This is especially important for understanding your true channel economics.

QuickBooks doesn't do this automatically. You'll either need to reconcile marketplace settlement reports manually or use an integration tool that breaks out the components for you.

The Real Cost of a Bad Setup

Every one of these mistakes has a compounding effect. Bad data leads to bad decisions. Founders underprice their products because they think margins are higher than they are. They keep pouring money into channels that aren't profitable. They show up to investor meetings with financials that don't hold up under scrutiny.

The worst part is that fixing a bad QuickBooks setup after a year of messy data is significantly more expensive than setting it up right from the start. You're not just reconfiguring the software — you're reclassifying a year's worth of transactions.

The Bottom Line

QuickBooks is a great tool for CPG brands, but only when it's configured for how your business actually works. Take the time to set it up properly — or better yet, work with someone who's done it before for brands like yours. The visibility you gain into your real numbers will pay for itself almost immediately.

Beck & Call Bookkeeping sets up and manages QuickBooks for CPG brands, giving founders clean data and real visibility into their numbers. If your QuickBooks is a mess (or you're just getting started), we can help. Get in touch →