StoreCashierDocumentation Free 1.6.6 Pro 1.5.6 Apps 1.5.0

Report Builder PRO

Build your own charts and KPI widgets from the store's data without any formulas: choose a dataset, a chart type and a date range, save it, and pin it to the dashboard. Owners use it to keep their three or four favourite numbers on the first screen they open.

Where: StoreCashier → Report Builder → Saved Reports · Build Report. Settings → Report Builder.
Build Report form with title, dataset, visualisation, date range and pin to dashboard
Build Report: title, dataset, visualisation, date range and the dashboard pin.

How to build a report#

  1. Go to Report Builder → Build Report and type a Report Title.
  2. Choose a Dataset (table below). You only see datasets you have permission for.
  3. Choose a Visualisation: Bar chart, Line chart, Pie chart, Table or KPI cards (the options that fit the dataset).
  4. Choose a Date Range: All time, Today, Yesterday, This week, This month, Last month, Last 7 days, Last 30 days, Last 90 days, This year or Custom range (From / To). “Some time-series datasets (monthly / daily trends) always use their natural window; the date range applies to categorical datasets like payment methods, top products or P&L.”
  5. Tick Pin to dashboard if it should appear on the Dashboard, then Save Report (or Update Report).

Datasets#

DatasetKindNeeds permission
Sales vs Purchase (monthly)Time series, 12 monthsView reports
Income vs Expense (monthly)Time seriesView reports
Daily Sales TrendTime series, 30 daysSales → View
Sales by Payment MethodBreakdownSales → View
Purchases by Payment MethodBreakdownPurchases → View
Orders by StatusBreakdownSales → View
Top Selling ProductsBreakdownSales → View
Top CustomersBreakdownView reports
Sales by LocationBreakdownSales → View
Expenses by CategoryBreakdownExpenses → View
Sales by RepresentativeBreakdownView reports
Profit / Loss BreakdownFiguresView reports
Tax SummaryFiguresView reports

Saved Reports#

Saved reports list with title, dataset, view, range, dashboard pin star and actions
Saved reports. The star pins or unpins a report on the dashboard.

“Build a report from any store dataset, then pin it to your dashboard. Reports only show data you already have permission to see.” Columns: Title, Dataset, View, Range, Dashboard (★ Pinned / Pin). Actions: Preview, Edit, Delete (“Delete this saved report?”).

Settings → Report Builder#

SettingWhat it does
Show pinned reports on dashboardYes / No.
Max pinned widgets on dashboardHow many pinned reports the dashboard renders. Each widget is gated behind the same permission as its data; reports stay available on the Report Builder screen regardless.
A colleague can't see my pinned widget.

Widgets follow the viewer's permissions — e.g. Expenses by Category needs Expenses → View.