Bar financial model: revenue, costs and cash

A bar financial model turns sales mix, inventory consumption, staffing and property costs into a monthly operating result and cash balance. Start with the point-of-sale export and stock count, then compare actual results with the approved budget. Purchases and consumption need separate lines because they affect cash and profit at different times.

Gather comparable monthly records

Use sales rows with service date, product category, units sold, net selling price and refunds. Keep sales tax and employee tips outside operating revenue. Add opening and closing inventory at cost, supplier purchases, payroll including employer costs, property expenses and card settlement records.

The sales export should show what was sold, not just the processor's deposit. Deposits may already exclude fees and may include collections for others. Reconcile these deductions before comparing receipts with revenue. The IRS recordkeeping guidance calls for records that clearly show income and expenses; retain the transaction exports behind each total.

The bar manager owns the stock count and staffing assumptions. Finance owns account mapping and the profit-to-cash reconciliation. Use one monthly cutoff for purchases, receiving records and inventory counts, including deliveries received before an invoice arrives.

This is an operating budget for an existing business. The startup financial model covers a different starting point, while the hotel financial model uses room nights rather than drinks as its activity driver.

Work the sales mix before applying costs

An illustrative US bar compares a monthly plan with actual sales. Prices are realized net prices after discounts; all money is USD. There are no price changes between plan and actual, so category volume explains the sales difference.

In Excel, enter these formulas in E2, F2, E5 and F5, respectively:

=B2*D2
=C2*D2
=SUM(E2:E4)
=SUM(F2:F4)

Fill the first two formulas through row 4. Microsoft documents SUM for adding a range. Covirage is not affiliated with Microsoft.

Cocktail sales fall by $4,800, beer rises by $1,400 and nonalcoholic sales rise by $1,000. Together, −$4,800 + $1,400 + $1,000 = −$2,400. More lower-priced drinks do not fully replace the lost cocktail revenue. Keep category detail instead of explaining the result with an average check alone.

Connect inventory and payroll to operating profit

For this example, inventory consumption uses opening stock plus purchases minus closing stock. The IRS explanation of cost of goods sold describes deducting closing inventory from goods available for sale. Here, there are no transfers or other inventory adjustments; add explicit rows if your operation has them.

On a separate operating sheet, put plan in B and actual in C. Costs are positive deductions. Amounts are exact whole dollars, and the assumed processing fee is 2.5% of sales.

Enter these formulas in B6, B10 and B11, respectively:

=B3+B4-B5
=B2*2.5%
=B2-SUM(B6:B10)

Copy these formulas to C. This defined operating result excludes depreciation, interest and income taxes. For the wider distinction between sales and direct costs, see gross profit margin.

Actual profit is $5,840 below plan. The reconciliation is −$2,400 sales − $1,500 additional consumption − $2,000 additional labor + $60 lower processing fees = −$5,840. Adding that difference to planned profit of $12,550 gives actual profit of $6,710.

Investigate the consumption increase with stock movements and recipes. It may reflect purchasing prices, product mix, waste, unrecorded servings or a count error. The aggregate figures identify the question; they do not prove which explanation is correct.

Reconcile cash, then change the purchase assumption

Assume opening cash of $25,000, all sales settle during the month, purchases and operating expenses are paid during the month, and equipment spending is $4,000. There are no other cash movements in this simplified example. Tips and sales-tax collections are excluded from these business cash figures.

The actual cash check is $25,000 + $6,710 profit − $500 inventory growth − $4,000 equipment = $27,210. This also explains why actual closing cash misses plan by $6,340 rather than the $5,840 profit difference.

The scenario changes only purchases, from $38,000 to $35,000, while holding consumption and sales constant. Closing inventory becomes $18,000 + $35,000 − $37,500 = $15,500. Profit stays $6,710 and cash improves by $3,000. The manager must confirm that the lower stock supports the assortment and delivery schedule; cash savings alone do not establish feasibility.

For businesses with unpaid suppliers or unsettled card receipts, extend the reconciliation with the relevant balance changes. Working capital explains that connection in more detail.

Where it goes wrong

• Purchases treated as consumption. This hides cash invested in stock and distorts profit after large deliveries.
• Counts at different cutoffs. A delivery included in purchases but excluded from the stock count overstates consumption.
• Payroll without employer costs. Wages alone understate the cost of staffing the planned shifts.
• Net deposits treated as sales. Processing fees disappear from expenses and revenue becomes understated.
• Profit treated as available cash. Inventory, equipment and settlement timing can absorb the reported surplus.

Compare your bar workbook in Covirage

Bring your approved budget, sales export, inventory movements and payroll file. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for hospitality teams for the supporting industry context.