Check your numbers: certified metrics, dates, and known limits
Every number on a dashboard is only as useful as its definition. This article explains what the Certified badge means, how to use Show your work to see how a figure was built, how dates and business days affect results, and the current limits to keep in mind before you use a number for a financial decision.
Two reports can both be correct and still disagree, because they answer different questions. Net sales, payments, tab subtotals, and bank deposits are all different measures. This article helps you check what a number means before you rely on it.
See how a number was built: Show your work
Section titled “See how a number was built: Show your work”Every widget can explain itself.
- Open the widget’s three-dot menu and choose Show your work. In the widget builder, the same button is at the bottom right of the preview.
- Read what it tells you:
| It shows | Why it matters |
|---|---|
| Metric definition | Net sales, payments, tab subtotal, and deposits are different measures. |
| Scope and filters | A category, adjustment type, or other filter can narrow a widget. |
| Dates and comparison period | Confirm both the main period and the period it is compared with. |
| Data timestamp | Shows when the result was calculated. Today’s numbers can still be incomplete. |
| Locations | Confirms which locations contributed. |
Do this before you reconcile a widget against another report, and any time two numbers seem to disagree.
What the Certified badge means
Section titled “What the Certified badge means”Metrics in the builder carry a badge that tells you how much review their definition has had.
- A green check means the metric is certified. It has a standard, reviewed definition. Many certified metrics match the equivalent number in GoTab’s own reports. For example, Net sales matches the Net Sales number on the Sales dashboard.
- Metrics without a check are marked Custom. A Custom metric may still be useful, but inspect its definition and its result carefully before you rely on it.
A few things to know about the badges:
- The badge belongs to the metrics and formulas a widget uses. It does not come from a particular dashboard or widget. A widget built only from certified metrics shows as certified, and a widget that uses anything else does not.
- It applies the same way to everything you use, whether you built the widget yourself or installed a dashboard from the Marketplace. Know what the badges mean wherever you see them.
- Certified does not mean every filter or report is right for your question. It means the standard definition behind the number is reviewed. You still need to check the filters, dates, and locations. Use the explanation in Show your work, not the badge alone.
What the main metrics mean
Section titled “What the main metrics mean”| Metric | What it measures | Certified at the time of writing |
|---|---|---|
| Net sales | Sales after discounts, comps, voids, and refunds. Excludes tax, tips, and service fees. | Yes |
| Gross sales | Sales before discounts, comps, and refunds. Excludes tax, tips, service fees, and order-rule fees. | Yes |
| Quantity | Units sold, net of voids, comps, and refunds, which count as negative. Can be fractional for items sold by weight. | Yes |
| Amount (Sales) | Everything posted to an account as the ledger records it, including tax, tips, fees, and payments. Across all accounts it totals about zero. | Yes |
| Tax | Sales tax collected, including remitted tax. | Yes |
| Tips | Tips guests added. Excludes automatic gratuity and service fees. | Yes |
| Service fees / autogratuity | Mandatory service charges and automatic gratuities. | Yes |
| Debit, Credit, Net (Ledger) | The ledger’s debit and credit entries, and credit minus debit. Match the columns on the Accounting page. | Yes |
| Comps & refunds | Comps and refunds as a negative amount. Mirrors the Comps & Refunds line of the Sales dashboard. | No. It has not been reconciled yet. |
| Option quantity | How many times an option was ordered, counting each unit of the item. Net of voids, comps, and refunds. | No |
| Labor hours | Paid hours worked, after unpaid breaks. Paid breaks count as hours worked. | No |
| Labor cost | Each shift’s hourly wage times its paid hours, as the labor report computes it. | No |
| Declared tips | Tips staff declared when they clocked out. Not the tips guests added to checks. | No |
| Tabs, Covers, Tab subtotal | Tab counts, guests served as entered at the POS, and tab subtotals before tax and tips. | No |
| Paid (Sales by payment) | Money taken by payments, as a positive amount. Refunds are negative. | No |
Dates, business days, and timing
Section titled “Dates, business days, and timing”- Business day, not calendar day. Reports grouped by Business day follow each location’s operating-day cutover, so sales and shifts after midnight can count toward the previous day.
- Today is incomplete. The current day can still be changing. Use Yesterday or a complete period for numbers you want to compare.
- Pick the range that fits the job.
| Review | Choose |
|---|---|
| Daily operating check | Yesterday |
| Monthly close | Last month, or a complete custom month |
| Pay-period hours | The exact pay-period start and end dates |
| Week-to-week performance | Complete weeks |
- Deposits follow settlement timing. Bank deposits follow the processor’s settlement timing, so matching dates alone will not reconcile sales to deposits.
- Comparisons. Check whether a comparison means the preceding dates or the same weekdays last year, and confirm the actual periods in Show your work.
Limits to keep in mind
Section titled “Limits to keep in mind”These are current limits of the tool and its data. Some may change as it grows.
- Labor cost is straight time. It has no overtime premium, and staff with no wage set, such as salaried or unpaid staff, count as zero. Any labor percentage built from it carries the same limit. Shifts that GoTab clocked out automatically probably overstate hours.
- Average check uses the tab subtotal, which is not adjusted for refunds made after the tab closed.
- Covers only exist where the POS asks for them. Tabs without a count add nothing.
- Names are today’s names. Product and zone names show the current name, even if they were renamed after the sale.
- Some names are not people. Server names include devices and kiosks.
- Tax exemption IDs are not verified. Staff type them in, and placeholders such as 5555555 are common. Exempt tabs can also contain items set up to stay taxable.
- Option quantities are not inventory. Neither option totals nor product quantities measure how much stock was used.
- Currency. Many ready-made dashboards support USD locations only and do not convert currencies.
- Answers from an AI assistant need the same checks. If you connect an assistant such as Claude to your dashboards, ask it which metric, dates, and locations it used, and check the numbers the same way you would check a widget you built. See Build with your AI assistant.
- Not everything is available. For example, there is currently no metric for fulfillment speed, who approved a comp, or cash drawer over and short. If you need something that is not listed, contact GoTab Support through the support chat and ask for it to be added to Customer Reporting Dashboards, not the Data Hub dashboard. Describe the report you are trying to build.
Common surprises
Section titled “Common surprises”| What you see | What to check next |
|---|---|
| An empty dashboard, or a “no location” message | Open the account menu, choose Change locations, select your locations, and confirm the count. |
| ”No data for this selection” | Check the dates, locations, metric, and filters. There may be no matching activity. Category-based widgets can use names that differ from your menu. |
| A negative amount | Look at refunds, voids, comps, and reversals, and the business day they were recorded on. A reversal can land in a different period than the original sale. |
| Visible rows do not add up to the total | Check any Rows conditions, because hidden rows still count in totals. Also check refund tenders and account types. |
| Two reports disagree | Match the dates and locations, then compare the metric definitions. Sales, payments, tab balances, and bank deposits answer different questions. |
| A teammate sees different totals | Compare each person’s location access. A shared dashboard shows each person their own locations. |
| A percentage looks wrong | A ratio from period totals can differ from an average of daily ratios. Check how the widget is set to calculate. |
| A control is missing | Some controls depend on your role. For example, Custom Reporting itself needs the Manage: Analytics permission. Ask your administrator, who sets permissions user by user, or contact GoTab Support. |
Contact support with an example
Section titled “Contact support with an example”If you cannot explain a difference, send GoTab Support a reproducible example. Include:
- The dashboard link and the widget name
- The dates and locations
- The result you see
- The result you expected and where you got it from
- An example tab or transaction
- A screenshot of Show your work
Avoid including guest card details or unnecessary personal information in screenshots.