Brewery chart of accounts template

Taproom, wholesale and direct sales separated, with production cost tracked from grain through to filled vessel and excise duty on its own line.

53Accounts
3Levels deep
2Formats

Built on production accounting practice for licensed producers. No published standard chart exists for craft brewing, so this describes what it is modeled on rather than claiming a standard.

Download the brewery chart

Pick a format. The file downloads immediately.

Format

Opens in Excel, Google Sheets and Numbers. No spam.

What is different

Three channels, three margins, one Sales line hides all of it

A pint poured in your own taproom, a keg sold to a bar and a four-pack sold at the door earn wildly different margins. Taproom is the best of the three by a distance; distribution is the worst once freight and distributor fees are taken out.

When all three sit in one Sales account, a shift in mix looks like a change in efficiency. This chart separates Taproom Sales, Distribution & Wholesale and Direct to Consumer Sales, and carries Excise Taxes and Distributor Fees & Freight as their own lines, so channel margin is readable.

The chart

The full Brewery chart of accounts

All 53 accounts, with the note that tells you what belongs in each one. This is the same file the download gives you, rendered here so you can read it without opening a spreadsheet.

CodeAccountTypeWhat belongs here
4000RevenueIncomeTaproom, wholesale and direct sales, kept apart because margin differs sharply.
4010Taproom SalesIncomeBeer and food sold in your own taproom.
4020Distribution & WholesaleIncomeSales through distributors and wholesale accounts.
4030Direct to Consumer SalesIncomeProduct sold straight to the customer, online or at the door.
4040Merchandise SalesIncomeBranded apparel, glassware and retail packaged goods.
4050Tours & TastingsIncomePaid tours, tastings and flight experiences.
4060Private EventsIncomeRevenue from private bookings of the room or venue.
4070Contract ProductionIncomeProduction work delivered under a signed contract or statement of work.
5000Cost of SalesCost of goods soldProduction and packaging cost from grain through to filled vessel.
5010Grain & MaltCost of goods soldGrain and malt used in production.
5020HopsCost of goods soldHops used in production.
5030Yeast & AdjunctsCost of goods soldYeast, sugars and adjuncts used in production.
5040Botanicals & Base SpiritsCost of goods soldBotanicals and base spirit bought for distilling and blending.
5050Cans, Bottles & KegsCost of goods soldPackaging vessels filled with finished product.
5060Production LaborCost of goods soldLabor directly producing a show or shoot.
5070Excise TaxesCost of goods soldFederal and state excise duty on alcohol produced or sold.
5080Distributor Fees & FreightCost of goods soldDistributor charges and freight on wholesale shipments.
5090Taproom LaborCost of goods soldTaproom service wages.
5100Lab & Quality TestingCost of goods soldLaboratory analysis and quality testing of product.
5110Merchandise PurchasesCost of goods soldBranded goods bought for resale.
5120CO2, Chemicals & Production SuppliesCost of goods soldGas, cleaning chemicals and consumables used in production.
6000Operating ExpensesExpenseOperating costs of running the business, below the gross profit line.
6010Management & Office SalariesExpenseSalaries for management and administration.
6020Payroll Taxes & BenefitsExpenseEmployer payroll taxes and the cost of employee benefits.
6030Rent & OccupancyExpenseRent plus the occupancy costs that come with the building.
6040UtilitiesExpenseElectricity, gas, water and waste for the premises.
6050Repairs & MaintenanceExpenseRepairs and upkeep of the building, plant and fixtures.
6060Software & SubscriptionsExpenseRecurring software licences and subscriptions.
6070Advertising & MarketingExpenseAdvertising spend and marketing programmes not tied to one event.
6080Professional FeesExpenseAccounting, legal and consulting fees.
6090Business InsuranceExpenseGeneral liability, property and business insurance.
6100Card Processing FeesExpenseMerchant fees on card payments taken from customers.
6110Office & SuppliesExpenseOffice consumables and general supplies.
6120Telephone & InternetExpensePhone lines, mobile plans and internet connectivity.
6130TravelExpenseAgency travel not recharged to a client.
6140Meals & EntertainmentExpenseBusiness meals and entertaining. Partially deductible, so keep it separate.
6150Licenses & PermitsExpenseOperating licences and permits to trade.
6160Dues & MembershipsExpenseTrade body memberships and professional dues.
6170Training & EducationExpenseStaff training, certification and continuing education.
6180Bank FeesExpenseAccount, wire and other charges levied by the bank.
6210TTB & State Alcohol PermitsExpenseFederal TTB and state permits to produce or sell alcohol.
6220Keg Losses & ReplacementExpenseKegs lost, damaged or written off.
6230Equipment LeasingExpenseLeases on equipment rather than outright purchase.
6240Barrels & CooperageExpenseBarrels and cooperage, where not capitalised.
6250Waste RemovalExpenseGeneral waste, recycling, food waste and confidential shredding.
8000Other IncomeOther incomeIncome earned outside normal trading activity.
8010Interest IncomeOther incomeInterest earned on operating and reserve balances.
8020Grants & IncentivesOther incomeGrant funding and government or utility incentives received.
8030Vendor Rebates & CommissionsOther incomeRebates and commissions paid back to you by suppliers.
9000Other ExpensesOther expenseBelow the line costs that are not part of operations.
9010Depreciation & AmortizationOther expenseWrite-down of tangible assets and amortisation of intangibles.
9020Interest ExpenseOther expenseInterest on notes payable and long-term debt.
9030Penalties & Late FeesOther expenseFines, penalties and late payment charges.

Questions

Brewery chart of accounts questions

Where should excise duty sit in a brewery chart of accounts?
In cost of sales, on its own line. Excise is a direct cost of the product you made and sold, and it moves with volume. Burying it in operating expenses overstates gross margin and makes your cost per barrel wrong.
How should taproom sales be separated from distribution?
As separate revenue accounts with separate cost lines. Taproom is retail margin; distribution is wholesale margin after distributor fees and freight. A single Sales line makes a shift toward distribution look like rising costs.
What production costs should be tracked separately?
At minimum grain and malt, hops, yeast and adjuncts, and packaging. Those are the four inputs whose prices move independently, and hop contracts in particular can swing sharply year to year. This chart carries each separately plus CO2, chemicals and production supplies.
Do I need to track kegs as inventory?
Track keg losses at least. Kegs are a real asset that walks away, and most breweries discover the scale of it only when they count. This chart carries Keg Losses & Replacement as an operating expense so the annual number is visible rather than absorbed.

See your own invoices coded to this chart

Send us a week of real vendor invoices. We will run them through Cleo, code each one to the right account, and show you the result posted in QuickBooks.