Analytics Dashboard

The Analytics Dashboard provides a one-stop overview of all register activity. View high-level sales and returns totals on the Sales Bar and Dashboard Tiles, check out the Sales Graphs for a visual breakdown, and open the Summary View for a simplified text-only version of the report.

IMPORTANT: Sales tax figures in reporting are estimates based on how you have configured your Tax Groups in BackOffice. For official filings, always verify your current local rates, then manually calculate tax using net taxable and non-taxable revenues. Be aware that tax laws can change at any time and you should contact a tax professional for specific tax advice regarding your business.

To learn how tax is calculated in ShopKeep, visit the Sales by Tax Group Report article.

Table of Contents

Run the Dashboard

From BackOffice, run the Analytics Dashboard for an overview of register activity over a specific time period.

  1. Click 'Analytics' and select 'Analytics Dashboard'.
  2. Click the date icon to choose a preset or custom range.
    Click to Enlarge
  3. (Optional) Scroll down and choose a period of time to compare against the selected date range.
  4. Click 'Retrieve'.

Read the Dashboard

The Analytics Dashboard summarizes register activity at your business over a selected date range. Whether looking for total gross sales or the average value of a sale, it can all be found here.

Sales Bar

The Sales Bar summarizes your gross sales, returns, discounts, and more.

Click to Enlarge

Gross Sales | Total sales before discounts, returns, gratuity, and tax. Sales of liabilities are not included here but liability redemptions are.
Returns | Amount refunded to customers before tax, gratuity, and discounts.
Discounts | Total discounts on all sales minus total discounts on return transactions.
Want a breakdown of which discounts were used? Check the Sales by Discount report.
Net Sales | Gross Sales minus Returns and Discounts.
Sales Tax | Total tax collected on sales minus total tax refunded on return transactions.
▲ / ▼ | How the current date range compares with the selected comparison period.

Top Dashboard Tiles

The first set of tiles provides the transaction count and data showing what your average sale looks like.

Click to Enlarge

Transactions | Total number of sales and returns performed at the register.
Average Sale Value | Average value of a sale before tax (not including liabilities sold). This is Gross Sales minus discounts on sales and divided by the number of sales.
Average Items per Sale | Average quantity of items on each sale. Each instance of an item is considered a count (i.e. 5 of a single item counts as 5 items for that sale).
▲ / ▼ | How the current date range compares with the selected comparison period.

Top Dashboard Tiles Restaurants Only

For businesses classified as restaurants, the Analytics Dashboard tiles display restaurant-specific data.

Click to Enlarge

Transactions | Total number of sales and returns performed at the register.
# Guests Served | Total number of guests served according to the guest count of each check.
Average Sale Value | Average value of a sale before tax (not including liabilities sold). This is Gross Sales minus discounts on sales and divided by the number of sales.
Average Sale Per Guest | Average sale amount per guest served. This includes tax but not discounts.
▲ / ▼ | How the current date range compares with the selected comparison period.

Sales Graph

The sales graph tile is a visual summary of sales data with bars representing net sales and a line showing transaction count. The default view displays total sales by hour of the day but can be customized for different time periods.

Click to Enlarge
  1. Select a time period from the drop-down (see definitions below).
    Click to Enlarge

    Hours | Each position on the graph’s x-axis is a consecutive hour. The graph displays data for each individual hour in the selected date range.
    Click to view a sample Total Sales by Hour graph

    Hours of Day (default view) | Each position on the graph’s x-axis is one of the 24 hours in a day. The graph displays the total per hour of the day combined for all days in the selected range.
    Click to view a sample Total Sales by Hour of Day graph

    Days | Each position on the graph’s x-axis is a consecutive day. The graph displays data for each day in the selected range.
    Click to view a sample Total Sales by Day graph

    Day of Week | Each position on the graph’s x-axis is the same day of the week. The specific day is selected after choosing this time period. The graph displays data for each instance of that day in the range.
    Click to view a sample Total Sales by Day of Week graph

    Weeks | Each position on the graph’s x-axis is 7 days of data. The first day in the selected range determines the start of the first week. The graph displays the total for each week in the range.
    Click to view a sample Total Sales by Week graph

    Months | Each position on the graph’s x-axis is a calendar month of data. The first day in the selected range determines the first month. The graph displays the total for each month in the range.
    Click to view a sample Total Sales by Month graph

    Years | Each position on the graph’s x-axis is a calendar year of data. The first day in the selected range determines the first year. The graph displays the total for each year in the range.
    Click to view a sample Total Sales by Year graph

  2. Hover over or tap part of the graph to view the net sales amount or transaction count at a point.
  3. Click ‘Average Sales by Hour’ to view average values instead of totals.

    This graph only displays sales by hour of the day and is not customizable

Bottom Dashboard Tiles

The final set of tiles displays the top five best selling items by dollar amount, a breakdown of sales by tender type, and the number of new vs. returning customers.

Click to Enlarge

Having trouble with the Analytics Dashboard? Visit our troubleshooting guide for help.

Summary View

The Summary View provides a slimmed down, printer-friendly version of the most important analytics.

  1. Click 'Summary View' at the top.

    Nothing happening? Disable your pop-up blocker and try again.

  2. Wait for the report to open in a new web browser tab.
    Click to Enlarge

    Sales

    Sales | Total sales before discounts, returns, gratuity, and tax. Sales of liabilities are not included here but liability redemptions are.
    Discount | Total discounts on all sales minus total discounts on return transactions.
    Want a breakdown of which discounts were used? Run the Sales by Discount report.
    Returns | Amount refunded to customers before tax, gratuity, and discounts.
    Net Sales | Sales minus Discounts and Returns.
    Gratuity | Credit card tips accrued at the register minus refunded gratuity.
    To learn about accepting and paying out gratuity, visit the Tips and Gratuity article.
    Gift Card / Gift Certificate / Deposit | Total sales of each type of liability minus discounts on those liabilities and liability returns.
    Tax | Total tax collected on sales minus total tax refunded on returns.
    Total Tendered | Total amount taken in. This is Net Sales plus Tax and new liability sales.
    Net Cogs | Cost of goods sold. The cost of all sold items minus the cost of items that were returned.
    Gross Margin | Percentage of Net Sales left after accounting for Net Cogs.

    By default, Net Cogs and Gross Margin are calculated using weighted average cost.

    Drops/Payouts/Pay ins/Purchases

    Drops/Payouts/Purchases | Total removed from the cash drawer for drops/payouts/purchases.
    Pay Ins | Total amount of cash added to the drawer through pay ins.
    Mda Total | Miscellaneous Drawer Access total. The net effect that drops/pay ins/payouts/purchases have on your cash drawer. This is Pay Ins minus Drops, Payouts, and Purchases.

    Sales by Tender Chart

    Cash/Credit/AMEX/etc. | Total Tendered broken down by tender type.


  • Help us improve ShopKeep Support. Was this article helpful?
  • YES   NO