Reports — terminology and data definitions

What every figure means — Sales, Net sales, Profit after costs, margins, VAT, service modes, dayparts, payment types, scope and timezone.

A glossary for the figures and groupings you'll see across the reports.

Money figures

Every sales figure in Tillable is after discounts. If you took £2 off a £10 round, that round counts as £8 everywhere: in the totals, and against each product, category, menu and offer. You will never see a total from before discounts. What you gave away is listed on its own, as Discounts.

On the Sales report:

Sales — what your customers were charged: after discounts, VAT still included, tips left out. It's also the figure used as Total Collected on the payment-type breakdown. Refunds are not taken off. (This one figure replaces the old "Gross Sales" and "Sales after discounts" cards.)
VAT collected — the tax contained inside your sales.
Sales excl. VAT — Sales with VAT stripped out. Refunds are not taken off.
Number of sales — how many transactions (the order count) in the period.
Average Sale — Sales divided by the Number of sales.
Discounts — the total amount knocked off by discounts across the period. It is shown on its own and is already taken out of Sales, so never subtract it again.

On the Daily sales report:

Gross (or Gross takings) — everything you sold, VAT included, after discounts. Tips are not sales and are left out. It is the same figure as Sales on the Sales report: "gross" here means VAT is still in, never "before discounts".
Net sales — what you took after refunds and VAT are taken off. The VAT inside a refunded sale is given back, so only the VAT on what you kept comes off. "Net" in Tillable always means this.
Profit after costs — Net sales minus the cost price of the products sold, worked out from their recipes at today's ingredient costs. A product with no cost price counts as £0, which makes profit look higher than it is.
Costs known for N% of sales — the share of your sales (before VAT) that came from products whose recipe has a cost for every ingredient. Products with no recipe, an ingredient with no cost, or a cost that looks like a whole pack price typed in per unit are left out — and the line says how many products' costs look wrong.

All money is shown in pounds and pence.

Margins

A margin is sales minus what those sales cost to make. Tillable shows a few, each worked out its own way, and each is labelled for what it holds. Margin incl. VAT means the VAT is still inside the sales figure. Every one has an (i) beside it that says the same in one line.

On the Daily product summary:

Sales (incl. VAT) — what customers were charged, after discounts, VAT included, tips left out. Each bill's discount is shared across the products on that bill, and the day's Discounts show on their own line under the headline. Refunded and part-refunded orders still count in full. It is not Net sales.
Margin incl. VAT — those sales minus each product's recipe cost today (one serving; sizes are not taken into account). A product with no recipe counts as £0 cost, so its whole sale reads as margin. A cost that looks like a pack price is not left out. An option set to count as another product shows as that product, with its own recipe cost.
For what the day really made, use Profit after costs on Daily sales (above).

On Inventory → Margin:

Dashboard tiles and the Boxes view (Left over, Kept in the pound, Margin per product and the rest) — sales of products with a recipe, VAT included, after discounts. Refunded and part-refunded orders are left out. Cost is the recipe today, with sizes and add-ons; an ingredient with no cost counts as £0. Took on Took vs cost and Did we make money is every sale, keypad amounts too, while Left over starts from recipe sales only. Wastage is priced at the ingredient's unit cost.
What you actually made (the top of the Spreadsheet view) — the same sales, VAT included, refunded orders left out, but costed its own way: recipe amounts times ingredient unit costs. It can differ from the Dashboard tiles for the same dates.
Menu margin, per dish and Menu engineering — each product's base price, VAT included, minus its recipe cost today. A menu with its own price (say a cheaper Wednesday menu) and size prices are not used, so this is what a dish would make at its base price, not what a sale took.

On a product's recipe page, Margin incl. VAT is the price in the price box minus the recipe cost. In the menu builder and on the product page, the line under a price says Margin … ex VAT: that one takes the VAT off first and uses that menu's own price.

Payment types

The Sales report's Sales by Payment Types splits Total Collected into:

Card
Cash
Gift card — shown only once a gift card has actually been redeemed (the card / cash figures are already net of the gift-card-paid portion, so the three add up to Total Collected).

Sizes

If a drink is sold in more than one size, drilling into it from Top Items splits it by size as well as by service mode.

A size row is one size as it was rung on the sale — "Pint", "Half", "175ml". Renaming or deleting a size afterwards never rewrites what your history says.
No size is the catch-all for lines sold without one: card-machine sales, offers, and anything rung before that drink had sizes. It always sorts last, however much it took. It is an answer, not a fault.
The size rows always add up to the item's own Sold and Sales totals, so the shares on the bars total 100%.
The Products report stays one row per drink — a pint and a half of the same beer are the same product. The split lives in the drill-down only.

Service modes

Item sales can be split by how the order was taken (seen when you drill into an item from the Sales report's Top Items):

Counter — rung up at the till with no tab opened.
Dine-in — opened on a table from the floor plan.
Takeaway — a click-and-collect order with a pickup time.
QR ordering — submitted by a guest via a table QR code.
Other — bar-tab style: opened without a table, pickup or QR.

The Sales and Product performance reports' Source filter uses these identical five buckets (labelled Counter/QR/Takeaway/Dine-in/Other) — one definition across reports, so a Source filter and a service-mode breakdown can never disagree. See Filtering reports.

A Location filter narrows the service-mode split the same way it narrows every other figure: the item drill-down answers for the site you are filtered to, not the whole business. Accounts with one location have no Location filter and no site dimension anywhere — every figure is simply your whole business.

Dayparts

Insights' "Bestseller by day & time" splits each weekday into three dayparts, by UK time:

Morning — 00:00 to 11:59
Afternoon — 12:00 to 16:59
Evening — 17:00 to 23:59

Pairings terms

In the Insights "Frequently bought together" view and the Cross-category pairings report:

Pair count — the number of orders that contained both items.
Attachment % — of the orders containing the first item, the percentage that also contained the second. A higher attach % means a stronger pairing.

Scope and timezone

Scope — by default a report is merchant-wide (all your terminals). You narrow it with the Terminals, Location and Floor plan filters (and, on Sales/Product performance, Source and Category). There is no staff dimension — reports can't be broken down by staff member.
Location vs floor plan — a location is a real site total and reconciles with your takings; a floor plan is a view of table-service sales only and reads lower. See Filtering reports.
Timezone — all bucketing is in UK time (Europe/London).
Reporting window — from a single calendar day up to multiple years.
Comparison window — what a report's "vs" figures compare against, chosen with the vs previous / vs last year switch. vs previous is like-for-like: a single day compares to the same day last week, longer windows to the matching block before them. vs last year compares the same stretch a year ago (day/week views line up on weekdays; month-and-longer on calendar dates). An empty comparison window shows "no data to compare".
Refunds — not modelled in the reporting data, so they don't appear in any standard report.