How many of each item are complimentary — no charge to the guest?
Every settled bill in the selected range — dine-in and take-out, cash and card, waived and discounted alike.
How each server performed over the selected range. Sorted by average spend per head — the number that separates selling from order-taking.
Bills a cashier rejected instead of confirming — not counted in any sales figure above. Each one is a bill that never balanced against its proof photo.
Every ticket item fired in the selected range, with target vs. actual fire-to-bump time.
Every discount, void, complimentary, and special-settlement approval raised in the selected range.
End-of-day cash reconciliation history for the selected range.
Who was marked present, by day.
Counts only what the app can see: items added from a push-tagged suggestion vs. items explicitly declined. Suggestions shown but never acted on aren't counted either way.
Every settled sale, permanently — unlike the range above, "Clear tickets, sales & reports" never touches this. This is what decides which uncurated items get pushed as slow movers (see the Push list card on Dining) — a fast seller near the top of this list doesn't need a push; something near the bottom does.
One CSV covering the selected range above — every sold, comp'd, and voided item as its own row, from seat to settle. Open directly in Excel, or upload straight to Claude for analysis.
Voids, comps, discounts & special settlements.
| Type | Items | Value given away |
|---|
| Column | Required? | What it does |
|---|---|---|
| SKU ID | No | Leave blank to create a new item. Matches an existing item's SKU ID to update it instead — batch download the current menu first if you need these. |
| Product Name | Yes for new items | Menu item name. |
| Category | Yes for new items | Matches an existing category, or creates a new one automatically. |
| ApicBase ID | No | Reference lookup only — never shown to floor staff, never validated. |
| Unit Price | Yes for new items | Whole pesos, no currency sign. |
| Cost to Make | No | What one serving costs you, in whole pesos. Leave blank for anything you haven't costed yet — blank means "not costed", which the margin report counts differently from a dish that genuinely costs nothing. Batch download, fill this column in a spreadsheet, and upload it back: that's the fastest way to cost the items that carry your revenue. |
| Hot Kitchen / Fryer / Robata Grill / Sushi Bar / Drinks Bar | Yes for new items (at least one) | Mark Y every station this dish involves (x, ✓, or 1 also work). If more than one is marked, the one that actually fires a ticket is picked in this order: Hot Kitchen, Fryer, Robata Grill, Sushi Bar, Drinks Bar — the rest show up as an informational "Also involves" note on that ticket, not a second ticket. Fryer and Robata Grill both display inside the Hot Kitchen board as their own labeled section, same as Hot Kitchen itself. |
| Course | Yes for new items | drinks / starter / raw / grill / main / carb / dessert / sharing — also drives the "completes the meal" push scoring. |
| Description 1 | No | Short description ("spiel") shown in the item's detail popup. |
| Description 2 / 3 / 4 | No | Stored for later — not shown anywhere yet. |
| Expected Prep Time | No | Minutes. Left blank on a brand-new item, it defaults to 15 — an existing item's prep time is only changed when this is actually filled in. |
| Allergens | No | Comma-separated (e.g. "Shellfish, Soy, Gluten") — shown as warning pills in the item's detail popup. |
| Matrix 1 Label / Matrix 1 Value … Matrix 4 Label / Matrix 4 Value | No | Up to 4 custom fact pairs shown in the item's detail popup. Both the label and the value are free text — what each pair means is entirely up to your team (e.g. "Weight" / "250g", "Spice Level" / "Mild"). Leave a pair blank to skip it. |