Coffee shop chart of accounts template

Counter, retail and wholesale revenue kept apart, with coffee, dairy and packaging as separate cost lines so you can see which one moved.

48Accounts
3Levels deep
2Formats

Built on restaurant accounting practice, adapted for a counter-service operation. No published standard exists for coffee retail, so this follows USAR grouping without claiming to be USAR.

Download the coffee shop chart

Pick a format. The file downloads immediately.

Format

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

What is different

One Food Cost line cannot tell you why your drink margin moved

A latte is coffee, milk and a cup. Those three move independently. Green coffee is a commodity, dairy tracks its own index, and packaging jumped when your supplier changed. Averaged into one Food Cost line, a bad month looks like a bad month and nothing more.

Split, the answer is usually obvious within a minute. This chart carries Coffee & Tea Purchases, Milk & Dairy, and Cups, Lids & Packaging as separate accounts, because those are the three levers and they almost never move together.

The chart

The full Coffee shop chart of accounts

All 48 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
4000RevenueIncomeCounter, retail and wholesale revenue.
4010Beverage SalesIncomeAll drink sales where you do not split alcohol from non-alcohol.
4020Food & Pastry SalesIncomePrepared food and bakery items sold over the counter.
4030Retail Beans & MerchandiseIncomeRetail bags of coffee, brewing gear and branded merchandise.
4040Wholesale SalesIncomeProduct sold to retailers and distributors at wholesale.
4050CateringIncomeRevenue from catered food and drink, on or off premise.
4060Delivery & Mobile OrdersIncomeOrders placed through delivery apps and your own mobile ordering.
5000Cost of SalesCost of goods soldCoffee, dairy and packaging cost, the drivers of drink margin.
5010Coffee & Tea PurchasesCost of goods soldGreen and roasted coffee, tea and brewing stock bought for resale.
5020Milk & DairyCost of goods soldMilk, cream and dairy alternatives used in drinks and food.
5030Pastry & Food PurchasesCost of goods soldBakery, pastry and prepared food bought for resale.
5040Cups, Lids & PackagingCost of goods soldCups, lids, sleeves and carry-out packaging.
5050Retail Merchandise PurchasesCost of goods soldRetail stock bought for resale through a shop or front desk.
5060Barista LaborCost of goods soldBarista wages for the hours that produced the drinks sold.
5070Delivery Platform CommissionsCost of goods soldCommission retained by delivery marketplaces on their orders.
5080Syrups, Sauces & ToppingsCost of goods soldSyrups, sauces, powders and toppings used to build menu items.
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.
6210Equipment LeasingExpenseLeases on equipment rather than outright purchase.
6220Loyalty & Ordering App FeesExpenseFees for loyalty programmes and your own ordering app.
6230Cleaning & Pest ControlExpenseContracted cleaning and pest control.
6240Water Filtration & ServiceExpenseWater filtration systems and their servicing.
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

Coffee shop chart of accounts questions

How should a coffee shop track cost of goods sold?
Split it at least three ways: coffee and tea, dairy, and packaging. Those are the three inputs in almost every drink and they move independently. A single Food Cost line averages them together, which is exactly when a dairy price rise becomes invisible.
Should retail bean sales be separate from drink sales?
Yes. A retail bag and a brewed cup have completely different margins and completely different cost structures. Kept in one Sales line, growth in retail can mask a fall in drinks, or the reverse. This chart separates counter sales, retail and wholesale.
How do I account for wholesale coffee accounts?
As its own revenue line with its own cost. Wholesale runs on much thinner margin than retail, so blending the two produces a gross margin that describes neither. If wholesale becomes significant, consider tracking it as a separate class as well.
Where do loyalty and mobile ordering app fees go?
Operating expenses, not cost of sales. They are a cost of taking the order rather than a cost of making the drink. This chart carries Loyalty & Ordering App Fees separately from card processing, since the two are usually different vendors on different rates.

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.