Sales report by product and size

Also known as: informe de ventas, ventas, sales by product, best sellers, menu engineering, sales analysis, revenue report.

The sales report answers questions like which beer pulled the most revenue last weekend, did the new flatbread outsell the old one this month, how many bottles of Marqués did we shift over Easter. It groups closed-ticket lines by product and size, so a glass of Marqués and a bottle of Marqués show as separate rows.

Open the report

1. Sign in to the till with a manager or owner PIN.
2. From the Admin menu, tap Ventas.
3. The screen loads with today's sales by default.

Choose the date range

At the top of the screen, the date inputs Desde and Hasta define the window. Common ranges:

• Today: leave both at today's date.
• This week: Monday 00:00 to today.
• Custom: any start/end you need.

The report only includes closed tickets that fall in the window. Voided lines are excluded.

Filter and sort

• Categoría — filter to a single category (e.g. Vinos, Cocina) or Todas las categorías to see everything.
• Ordenar — sort by:
  • Mayor facturación (highest revenue first — default)
  • Mayor cantidad (highest unit count first)
  • Nombre A-Z

The table refreshes server-side with each change.

Read the rows

Each row is one (product, size) pair:

| Column | Meaning | |--------|---------| | Producto | Product name | | Tamaño | The size label (e.g. Copa, Botella, Pinta). — if the product has no sizes. | | Categoría | Where the product lives in the catalog | | Uds. | Total units sold in the window | | Facturado | Total revenue (VAT included) | | Precio medio | Facturado ÷ Uds. — useful for spotting discount creep |

The Total footer summarises the filtered rows.

Export to CSV

Tap Exportar CSV in the toolbar. The file downloads with the same rows and columns, ready to drop into a spreadsheet or hand to your accountant.

The CSV is generated from the same query as the screen, so the filter and date range are preserved.

Use cases

• Stocktake support: if the report says 47 units of Estrella pinta were sold this week, your keg level should have dropped accordingly. A mismatch is a clue.
• Menu engineering: if a flatbread sells 3 units a week but pulls the same margin as a 30-unit pizza, decide whether to keep it.
• Inventory drift: size-level grouping reveals when servers are punching in the wrong size — a wine that sells "by the bottle" but appears in the report as 95% by the glass deserves a conversation.

Not working?

• Ventas menu doesn't appear: sign in as manager or owner.
• Total revenue doesn't match the Z report: make sure the date range matches the shift's open-to-close window, and check whether you have tipped or rounded payments that the Z report counts separately.
• A product I sold isn't in the list: check that its line wasn't voided or that the ticket is closed (open tabs don't count).