Back to all blogs

How to Set Up a Brewery Chart of Accounts That Works

How-To GuidesData InsightsBusiness LeadersOct 12, 2026

Generic QuickBooks and Xero templates weren't built for breweries. Learn how to set up a chart of accounts that maps revenue, COGS, and expenses to your actual brewing operations.

How to Set Up a Brewery Chart of Accounts That Works

Most brewery owners don't lose sleep over their chart of accounts. They lose sleep over cash flow, razor-thin margins, and the gnawing feeling that their books don't actually reflect what's happening on the brew floor. The chart of accounts is where all of that starts. Get it right, and your QuickBooks or Xero setup becomes a financial dashboard that mirrors your brewing operations. Get it wrong, and you're stuck with a generic small business template that tells you almost nothing about where your money actually goes.

The problem? Standard accounting software templates weren't built for breweries. They don't know what a brite tank is. They can't distinguish between grain costs and hop costs. They lump taproom revenue in with wholesale distribution. And they definitely don't help you calculate your true cost per barrel, which is the number that separates profitable breweries from ones bleeding money without realizing it.

This guide walks you through building a chart of accounts that maps directly to your brewing operations, from raw materials procurement through packaging and distribution. Whether you're running QuickBooks Online, QuickBooks Desktop, or Xero, the structure is the same. What matters is getting the categories right so every dollar flows into a bucket that tells you something useful. And when you pair a well-structured chart of accounts with brewery inventory management that tracks every transaction in real time, you stop guessing and start managing with actual data.

Why Generic Chart of Accounts Templates Fail Breweries

Open a fresh QuickBooks or Xero account and you'll get a default chart of accounts designed for a generic small business. It includes categories like "Cost of Goods Sold," "Office Supplies," and "Professional Fees." These are fine for a consulting firm or a retail shop. For a brewery, they're almost useless.

Here's the core issue: brewing is a manufacturing operation with multiple revenue channels. You buy raw materials, transform them through a multi-stage production process, and sell finished goods through taproom sales, wholesale distribution, and sometimes direct-to-consumer shipping. Each of those channels has different margins, different cost structures, and different tax implications. A single "Revenue" line item and a single "COGS" line item can't capture any of that nuance.

Consider a brewery that sells 60% of its volume through wholesale and 40% through the taproom. The taproom pours might generate $800 per barrel in revenue while wholesale kegs bring in $200 per barrel. If all revenue lands in one bucket, the owner sees an average revenue-per-barrel number that doesn't represent either channel accurately. Worse, they can't tell which beers are profitable in which channels, which makes pricing decisions a guessing game.

The same problem hits the expense side. The Brewers Association's Cost of Goods Sold manual breaks brewery COGS into detailed categories including raw materials, packaging materials, direct labor, utilities allocated to production, and equipment depreciation. A generic chart of accounts gives you one line for all of that. When your accountant tells you COGS is 45% of revenue, you have no idea whether that's because grain prices went up, you're over-spending on packaging, or your labor costs are out of control.

The Real Cost of Poor Financial Visibility

Bad accounting structure doesn't just make reports confusing. It leads to bad decisions. Breweries with generic charts of accounts consistently struggle with three things:

  • Pricing accuracy. Without granular COGS data, you can't price beers based on actual production costs. You end up pricing by gut feel or copying competitors, both of which ignore your unique cost structure.
  • Margin erosion detection. When ingredients or packaging costs creep up by 5-10%, it's invisible in a single COGS line. By the time you notice the cash flow impact, months of margin erosion have already happened.
  • Investor and lender readiness. Banks and investors want to see that you understand your business at a detailed level. A chart of accounts with five line items signals amateur hour. A structured, operations-aligned chart of accounts signals a business owner who knows their numbers.

The fix isn't complicated. It's about setting up the right categories from the start, or restructuring what you have, so every transaction lands in a place that tells you something actionable.

Building Your Brewery Chart of Accounts From Scratch

Let's walk through the actual structure. Both QuickBooks and Xero use a numbered account system organized by type: assets, liabilities, equity, revenue, COGS, and expenses. The numbering convention helps keep things organized and makes it easier to add sub-accounts later without disrupting your structure.

Here's a brewery-specific framework you can adapt to your operation.

Revenue Accounts (4000 Series)

Split revenue by channel. This is non-negotiable. At minimum, you need:

Account NumberAccount NamePurpose4010Taproom Beer SalesPints, flights, growler fills4020Taproom Food SalesIf applicable4030Taproom MerchandiseHats, shirts, glassware4040Wholesale — KegsDraft distribution4050Wholesale — PackagesCans, bottles to retailers4060Self-Distribution RevenueIf you run your own routes4070Contract Brewing RevenueIf you brew for others4080Event / Private Party RevenueSpecial events income

This structure lets you see exactly where revenue comes from. When you run a profit and loss report, you'll immediately see the revenue mix and can track how each channel grows or shrinks over time.

Cost of Goods Sold Accounts (5000 Series)

This is where most breweries need the most detail. Your COGS accounts should mirror your production inputs:

Account NumberAccount NameWhat Goes Here5010Raw Materials — GrainBase malt, specialty malt, adjuncts5020Raw Materials — HopsAll hop purchases allocated to production5030Raw Materials — YeastYeast purchases, propagation costs5040Raw Materials — OtherWater treatment chemicals, fruit, spices5050Packaging MaterialsCans, labels, carriers, crowns, case trays5060Production LaborBrewers, cellar workers (direct labor only)5070Production UtilitiesGas, water, electricity for brewhouse5080Production Equipment DepreciationTanks, brewhouse, packaging line5090Quality Control / LabTesting supplies, lab consumables5100Taproom COGS — FoodFood costs if you have a kitchen5110Taproom COGS — MerchandiseCost of branded merchandise

Notice how raw materials break down by category. This is what lets you answer questions like "What percentage of my COGS is hops?" or "Have my packaging costs per barrel increased?" When your inventory management system feeds transaction data into these categories automatically, you eliminate manual data entry errors and get real-time cost visibility.

For a deeper dive into allocating these costs to individual batches, check out this guide on how to calculate true cost per batch in your brewery.

Operating Expense Accounts (6000-7000 Series)

Operating expenses cover everything that isn't directly tied to producing beer. The key here is separating taproom operations from general business overhead:

  • 6000s — Sales and Distribution: distributor fees, delivery vehicle costs, sales team salaries, point-of-sale fees, taproom staff wages, marketing and events
  • 7000s — General and Administrative: rent or mortgage (non-production space), office supplies, insurance, professional services (accountant, lawyer), software subscriptions, bank fees, interest expense

Keeping sales/distribution separate from G&A helps you understand the true cost of each revenue channel. If taproom labor and marketing consume 35% of taproom revenue, that's a very different margin profile than wholesale, where distribution fees might eat 25%.

Implementing the Structure in QuickBooks and Xero

Once you have the framework, the actual software setup is straightforward. But there are platform-specific nuances worth knowing.

QuickBooks Setup

In QuickBooks Online, navigate to Settings > Chart of Accounts > New. For each account, you'll choose an account type (Income, Cost of Goods Sold, Expense) and a detail type. QuickBooks requires both, and the detail type affects how the account appears on standard reports.

A few QuickBooks-specific tips:

  1. 1Use sub-accounts liberally. Create "Raw Materials" as a parent COGS account and then add Grain, Hops, Yeast, and Other as sub-accounts. This keeps your chart of accounts organized and lets you view reports at summary or detail level.
  2. 2Set up classes for product lines. If you brew multiple brands or product lines, use QuickBooks classes to tag transactions. This lets you run P&L reports by product line without creating duplicate accounts.
  3. 3Map your bank feeds carefully. When connecting bank accounts, take time to set up rules so recurring transactions (grain supplier payments, for example) automatically categorize into the right COGS sub-account.
  4. 4Use projects for large batches or contract brews. QuickBooks Projects can track profitability on individual contract brewing jobs or special releases.

Xero Setup

In Xero, go to Accounting > Chart of Accounts > Add Account. Xero uses account codes (numbers) and account types similarly to QuickBooks, but the interface is slightly different.

Xero-specific considerations:

  1. 1Tracking categories replace classes. Xero allows up to two tracking categories (essentially dimensions). Use one for sales channel (Taproom, Wholesale, Contract) and one for product line or location if you have multiple sites.
  2. 2Manual journal entries for production allocation. Xero doesn't have built-in manufacturing features, so you'll likely need journal entries to move raw material costs from inventory to COGS when batches are completed.
  3. 3Lock dates matter. Set lock dates at the end of each accounting period to prevent accidental changes to closed months. This is especially important when reconciling production data against financial records.

Regardless of platform, the real power comes from connecting your production system to your accounting. When your brewery management software tracks batch costs and production analytics, you have a source of truth for what actually happened on the brew floor. That data feeds directly into the COGS and revenue categories you've built.

Maintaining and Optimizing Your Chart of Accounts Over Time

Setting up the chart of accounts is a one-time project. Keeping it useful is an ongoing practice. Breweries evolve. You add new products, open new sales channels, maybe start a kitchen or expand into self-distribution. Your chart of accounts needs to grow with you without becoming a tangled mess.

Monthly Review Habits

Build a monthly close process that includes reviewing your chart of accounts for accuracy:

  • Verify that all raw material purchases are categorized to the correct COGS sub-account
  • Confirm revenue is split by channel (no transactions sitting in a generic "Sales" account)
  • Review any "Uncategorized" or "Ask My Accountant" transactions and reclassify them
  • Compare production records to COGS entries to catch timing differences
  • Check that new vendors or products are mapped to existing accounts (or create new ones if needed)

This monthly discipline takes about an hour and prevents small errors from compounding into quarterly headaches. Many breweries find that connecting their production planning tools to their financial systems dramatically reduces the manual reconciliation work. Purpose-built craft brewery software can automate much of this data flow, so your chart of accounts stays current without manual data entry for every transaction.

When to Add New Accounts

Add new accounts when you need visibility into a cost or revenue stream that's currently hidden inside a broader category. Some common triggers:

  • You launch canned products. Split your packaging COGS into sub-accounts for cans vs. kegs vs. bottles so you can see the packaging cost difference by format.
  • You open a second taproom. Add location tracking (via classes in QuickBooks or tracking categories in Xero) rather than duplicating every account for each location.
  • You start contract brewing. Create a separate revenue account (4070 in our framework) and consider a separate COGS sub-account for contract-specific materials.
  • Ingredient costs spike. If a single category like hops suddenly represents a much larger share of COGS, break it down further (domestic vs. imported, or by variety) to pinpoint the driver.

When to Consolidate Accounts

More isn't always better. If you have accounts that rarely have transactions or that no one looks at in reports, merge them. A chart of accounts with 200+ line items creates noise. Aim for enough detail to make decisions, but not so much that running a report feels like reading a phone book.

A good rule: if you can't explain why an account exists and what decision it helps you make, it probably doesn't need to be a standalone account.

Connecting Operations to Finance

The ultimate goal is a chart of accounts where every number connects to something happening in your brewery. When you brew a batch, the raw materials consumed should flow into COGS. When you sell a keg through distribution, the revenue should land in the wholesale account. When your packaging line runs, the materials used should be recorded against the packaging COGS account.

This connection between operations and finance is what turns accounting from a compliance exercise into a management tool. You stop asking "How did we do last quarter?" and start asking "What should we change next week?"

Take the time to build this foundation properly. Your future self, your accountant, and your bank will all thank you.

Ready to streamline your production?

Join hundreds of breweries and wineries using BrewPlanner to schedule batches, track inventory, and grow their operations.

Craft breweries automated