Sales Variance (Add-On Tax)

Comparison report that shows sales across multiple dates.

Description

The Sales Variance report is a comparison report that consists of KPI tiles, bar charts, and tables that show net sales for a selected date, the previous week, and the previous year. The report calculates the variance among the three dates. This report is for restaurants with add-on taxes.

Permission: Sales and Operations.

Report Tags

Simphony, RES 3700, e7, Add On Tax, Table Service, and Quick Service.

Selected Date

Visualization: KPI tile.

Permission: Sales and Operations.

Table 5-133 Selected Date

Category Data Format Description

Net Sales

Currency

Net sales

Previous Week

Visualization: KPI tile.

Permission: Sales and Operations.

Table 5-134 Previous Week

Category Data Format Description

Variance Percent

Percent

Variance between the selected date and the date one week prior

Previous Year

Visualization: KPI tile.

Permission: Sales and Operations.

Table 5-135 Previous Year

Category Data Format Description

Variance Percent

Percent

Variance between the selected date and the date one year prior

Net Sales Over Three Dates

Visualization: Bar chart.

Permission: Sales and Operations.

Table 5-136 Net Sales Over Three Dates

Category Data Format Description

Net Sales

Currency

Net sales on the Y axis

Selected Date

Date

Selected date for each location on the X axis

Same Day Previous Week

Date

The date one week prior to the selected date for each location on the X axis

Same Day Previous Year

Date

The date one year prior to the selected date for each location on the X axis

Average Net Sales

Currency

Single line noting the average net sales

Sales Variance by Location and Revenue Center

Visualization: Table.

Permission: Sales and Operations.

Table 5-137 Sales Variance by Location and Revenue Center

Category Data Format Description

Total Row

 

The top row of the table shows totals for each category

Name

String

Name of location or revenue center

Selected Date Net Sales

Currency

Net sales on selected date

Same Day Previous Week Net Sales

Currency

Net sales on the date one week prior to the selected date

Variance Amount

Currency

Monetary variance between the selected date and the date one week prior

Variance Percent

Percent

Percent of variance between the selected date and the date one week prior

Same Day Previous Year Net Sales

Currency

Net sales on the date one year prior to the selected date

Variance Amount

Currency

Monetary variance between the selected date and the date one year prior

Variance Percent

Percent

Percent of variance between the selected date and the date one year prior

Report Notes

Variance calculations do not take into account missing or partial days.

Selected Date: MM/DD/YYYY

Same Day Previous Week: MM/DD/YYYY

Same Day Last Year: MM/DD/YYYY