How to read a bar sales report.
By Better Bartender · Published
Start with item-level net sales and quantities for a defined venue and trading period. Then check discounts, refunds, opening hours and missing data before deciding what changed.
1. Check what the report measures
A sales report and a payment settlement answer different questions. A bank payout can reflect processing fees, timing and other adjustments. It cannot tell you which cocktail sold. For drink-level analysis, retain item names or IDs, variants, quantities, sales values, adjustments, timestamps and the venue identifier where the source provides them.
Check your provider’s definitions. Square’s UK documentation, for example, defines net sales as gross sales less discounts and refunds, and distinguishes that from total collected. Other products and regions can use different labels. Do not silently combine fields that happen to have similar names.
2. Keep the trading period consistent
Compare the same location, timezone and reporting hours. A late Friday shift may finish after midnight; a calendar-day report may split that shift. Note closures, private events and reduced hours. A missing report is unknown, not zero sales. Keep a record of the source file and its reporting period so a later correction can be traced.
3. Separate price from volume
Consider an illustrative drink with 100 serves and £1,000 net sales in one comparable period, then 90 serves and £990 in the next. Quantity fell 10%, while revenue fell 1%. Average realised revenue per serve rose from £10 to £11. That could reflect a price change, fewer discounts or a different variant mix; the totals alone do not identify the cause.
Calculate the quantity and revenue changes separately. Review the underlying variants and adjustments before describing an improvement or decline. When the earlier value is zero, show the absolute change rather than an undefined percentage.
4. Read the product mix
A stronger total can conceal a weaker category. Break down drinks into useful, consistently mapped groups, then inspect the items behind the change. Keep original item names alongside your grouping. Renamed products, generic open-price buttons and missing modifiers can distort comparisons. Do not infer a particular spirit brand from an unnamed “house gin” sale.
A daily bar reporting checklist
- Confirm venue, currency, timezone and trading dates.
- Check that the report is complete and has not been imported twice.
- Reconcile item totals and adjustments using the provider’s definitions.
- Review quantity, net sales and realised price together.
- Mark closures, stockouts and events before comparing periods.
- Write down one decision, its evidence and when you will review it.
What this report cannot tell you
Revenue is not profit. You need recipe or purchase costs to estimate contribution, and a wider cost picture to calculate operating profit. POS quantities alone do not measure physical wastage. See our pour-cost guide and menu performance example for the next steps.
Source and scope
Square UK: sales summary and payment report definitions. The example and checklist above are Better Bartender’s explanatory material, not a Square integration claim.
Better Bartender is testing the reporting foundations with venues. Request early access.