Settle the bar, and find out what walked out the door.
A free Excel settlement for table service and event bars. Full deduction waterfall from gross collected down to net to venue, an inventory count that produces your cost of goods, and a POS variance check that shows what you poured but never rang up.
Most bar settlements answer one question: what did we sell. This one answers the harder one, which is what happened to the inventory. Counting in and out and comparing usage against the POS turns a settlement from a receipt into a control. In the preview night, two premium spirits alone run 9 units long, about $318 of product with no sale attached. On a weekly event that is real money, and it is invisible in any settlement that stops at sales.
The full waterfall. Beverage sales by category, admin fee, service charge, tips and tax up to total collected, then every deduction down to net to venue: card processing, operator fee, tax remitted, cost of goods by category, comps, staffing, service charge and tips paid back out, management fee and deposit shortage.
Open plus what you brought in, minus your closing count, gives usage. Usage times unit cost gives your cost of goods, split by category and read automatically by the settlement tab. No retyping numbers between sheets.
The column most settlement sheets do not have. Next to what you used, enter what the POS says you sold. The gap is product that left the building without a sale attached to it: overpours, comps nobody logged, or theft.
Set admin fee, service charge and sales tax once for your venue and jurisdiction, and the settlement reads all three. Includes a refund reconciliation, because a comped table that already carried a service charge shows up as a negative and will otherwise overpay your staff.
Same-day ACH to bartenders, security, the distributor and every contractor who worked the room, with W-9s collected up front and a clean sync to QuickBooks so the month closes faster than the night did.
See Cleo Pay for venues