Bar chart of accounts template

Liquor, beer and wine as separate cost accounts, with bar consumables tracked apart from the spirits themselves, because a single Beverage line cannot produce a pour cost.

54Accounts
3Levels deep
2Formats

Built on restaurant accounting practice, with beverage costs split the way operators actually track pour cost. Follows USAR grouping without claiming to be a USAR chart.

Download the bar chart

Pick a format. The file downloads immediately.

Format

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

What is different

One Beverage account cannot produce a pour cost

Pour cost is the number a bar is run on, and it is not one number. Liquor, beer and wine each run at a different percentage, and a shift in what people order moves the blended figure without anything being wrong.

This chart splits Liquor Purchases, Beer Purchases and Wine Purchases, and keeps Ice & Bar Supplies and Mixers & Garnish out of the spirit accounts. A change in the blended pour cost can then be traced to a category rather than argued about.

The chart

The full Bar chart of accounts

All 54 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
4000RevenueIncomeBeverage-led revenue centres, with food kept separate.
4010Liquor SalesIncomeSpirits and cocktails.
4020Beer SalesIncomeBeer, split by package because margin differs sharply.
4030Wine SalesIncomeWine by the glass and by the bottle.
4040Non-Alcoholic Beverage SalesIncomeSoft drinks, mocktails, coffee, energy drinks and bottled water.
4050Food SalesIncomeKitchen, snack and bar food sales.
4060Cover ChargesIncomeDoor admission and ticketed entry.
4070Private Events & BuyoutsIncomePrivate bookings and full-venue buyouts, including minimum spend.
4080Merchandise SalesIncomeBranded apparel, glassware and retail packaged goods.
5000Cost of SalesCost of goods soldBeverage cost split to the level pour cost is actually managed at.
5010Liquor PurchasesCost of goods soldSpirits bought for resale.
5020Beer PurchasesCost of goods soldBeer bought for resale, bottled, canned and draft.
5030Wine PurchasesCost of goods soldWine bought for resale, by the glass and by the bottle.
5040Mixers & GarnishCost of goods soldJuices, sodas, bitters, fruit and garnish used behind the bar.
5050Food PurchasesCost of goods soldFood bought for resale, including produce, protein, dairy and dry goods.
5060Bar LaborCost of goods soldBartender wages for the hours that produced the drinks sold.
5070Door & Security LaborCost of goods soldDoor staff and security wages for trading hours.
5080Ice & Bar SuppliesCost of goods soldIce, straws, napkins and consumables used at the bar.
5090Merchandise PurchasesCost of goods soldBranded goods bought for resale.
5100DJ & Entertainment FeesCost of goods soldFees paid to DJs and entertainers.
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.
6210Liquor License & ComplianceExpenseLiquor licensing, renewals and the compliance work around them.
6220Music LicensingExpensePerforming rights fees for music played on the premises.
6230Contract Security & Alarm MonitoringExpenseAlarm monitoring and contracted security cover.
6240Linen & LaundryExpenseLinen hire and laundry, in house or contracted.
6250Glassware & Bar SmallwaresExpenseGlassware and small bar equipment replaced through the year.
6260Cleaning & Pest ControlExpenseContracted cleaning and pest control.
6270Waste 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

Bar chart of accounts questions

What pour cost should a bar target?
Most bars run between 18 and 24 percent overall, but the blend hides a lot. Liquor typically runs lowest, draft beer higher once waste is counted, and wine higher still. Chasing a single blended target without splitting the categories usually means cutting the wrong thing.
Why split beer into draft and packaged?
Because their costs per ounce and their loss profiles differ. Draft carries foam, line cleaning and shrinkage that a bottle does not. In one account the two average, and the draft system's waste stays invisible until someone counts kegs.
Where do garnish, ice and mixers belong?
Cost of sales, but in their own account rather than inside the spirit lines. They are a real cost of the drink, and they are also the costs that quietly inflate if a bar gets loose with prep. Separated, they are visible; combined, they distort pour cost.
Should glassware be cost of sales?
No. Glassware is an operating expense, because it is replaced on a breakage cycle rather than consumed per drink. Putting it in cost of sales makes pour cost jump every time you restock, which is exactly when you least want a false signal.

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.