Coffee Shop Balance Sheet Template

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.

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.