Coffee Shop Balance Sheet Template

Start with the Fixed Assets sheet before entering anything else. Pull your depreciation schedule from last year's tax return or your accountant's records and list every major asset: espresso machines, grinders, refrigeration units, furniture, POS system, and leasehold improvements. Enter the original cost, purchase date, and useful life for each item, and the sheet handles depreciation calculations and produces category totals that flow into the balance sheet automatically. Espresso equipment is often the largest single asset line — make sure you record the full purchase cost and not the financed amount, since the loan appears separately on the liabilities side.

Next, complete the Inventory Tracker with a physical count of your coffee beans, dairy, syrups, food items, packaging supplies, and retail merchandise at the end of the period. Pull current purchase costs from your most recent roaster and supplier invoices and enter them alongside the unit counts. The sheet calculates ending inventory value by category and feeds the totals into the balance sheet's current assets section. Then fill in the rest of the balance sheet: pull cash from your bank statement, accounts receivable from any outstanding wholesale or office coffee contracts, accounts payable from your vendor aging report, and gift card liability from your POS system's loyalty and gift card ledger.

Update the balance sheet monthly or at least quarterly. The inventory tracker changes every period — bean costs fluctuate with commodity markets and supply levels shift with seasonal demand, so accurate inventory on the balance sheet is essential for calculating true COGS. Use the Period Comparison sheet when preparing for a bank renewal, applying for an SBA loan, reviewing the economics of opening a second location, or simply tracking whether the business is building equity over time. Coffee shops with organized balance sheets — particularly ones that clearly account for equipment depreciation, café card liabilities, and inventory — have smoother conversations with lenders than those presenting only a P&L.

Most coffee shop owners watch their daily sales and labor percentages closely but rarely look at a balance sheet. The P&L shows whether last month was profitable; the balance sheet shows what the business is actually worth and whether it can absorb a slow week or a broken espresso machine. Coffee shops face real balance sheet complexity: significant equipment investment subject to wear and replacement, a commodity input (coffee beans) whose cost can shift meaningfully quarter to quarter, and loyalty and gift card programs that generate upfront cash representing future drink obligations. None of that shows up properly on a P&L alone.

Three items on a coffee shop balance sheet are frequently missing or understated. The first is equipment: a quality commercial espresso setup — machine, grinder, knock box, water filtration — can represent $20,000 or more in capitalized assets, and that investment needs to be tracked through depreciation to reflect its declining book value and plan for eventual replacement. The second is café card and gift card liability: when a customer loads $50 onto a loyalty card, you've collected real cash for drinks not yet served — that's deferred revenue and a genuine liability until the balance is drawn down. For shops with active loyalty programs, this balance can be substantial. The third is bean and supply inventory: physical stock on hand is a current asset, and estimating it rather than counting it leads to misstated COGS and an inaccurate picture of working capital.

Lenders evaluating a coffee shop balance sheet want answers to three questions: Is there enough working capital to survive a slow season or an equipment failure? How much capital is tied up in equipment, and is it maintained or nearly depreciated? And is owner's equity growing, or are draws outpacing profits? A café owner who can answer those questions with a current, accurate balance sheet — one that properly accounts for equipment depreciation, gift card obligations, and actual inventory value — signals the financial discipline that makes lenders comfortable and gives the operator a real understanding of what the business is worth.