1. Order Management
  2. Order Management Reports
  3. Same-Store Sales Report
  4. Understanding the Same-Store Sales Report

Understanding the Same-Store Sales Report

The Same-Store Sales Report indicates the difference in sales or revenue of the same store, over a certain period this year as compared to the identical period in the previous year.

On the Same-Store Sales Report page, from Reports > Sales > Same-Store Sales, you can specify the reporting parameters, which are discussed in the following sections.

Store Options

This field enables you to select either comparable stores, non-comparable stores, or both that the report will include.

It is a store’s sales data in a specified period this year, that is compared to the sales data in an identical period last year. The report will list all comparable stores with sales data displayed according to specified metrics. Each metric is displayed in columns, for sales data This Year (TY), Last Year (LY), and % Difference.

The report will list all noncomparable stores with their data displayed according to specified metrics, but sales data may be missing in the Last Year column and no difference.

Selecting Both from Store Options will display all stores grouped according to comparable and noncomparable with their sales data corresponding the specified reporting period.

Reporting Period and This Year (TY) and Last Year (LY) Date Fields

The Reporting Period field, in combination with This Year (TY) and Last Year (LY) date fields, enable you to specify the reporting period of the Same-Store Sales Report. Then, the SuiteApp references the dates you entered on the retail calendar that you created and imported.

You can select the following reporting periods and specify corresponding date fields:

Reporting Period

Description

Day

The reporting period will cover one day. Selecting Day requires you to specify the End Date - This Year (TY) date field. After doing so, the Start Date - This Year (TY) is automatically filled out with the same date as the End Date - This Year. The Start Date - Last Year (LY) is automatically filled out with the corresponding date coordinate as in Start Date-This Year, and the End Date - Last Year is filled out with the same date as the Start Date - Last Year.

For example, 10 March 2021 (with coordinates Year:2021, Quarter:1, Period:2, Week:2, Day:4), is entered in End Date - This Year. The following date fields are automatically filled out with corresponding dates:

Start Date - This Year: 10 March 2021 (Year:2021 Quarter:1 Period:2 Week:2 Day:4)

End Date - Last Year: 11 Mar 2020 (Year:2020 Quarter:1 Period:2 Week:2 Day:4)

Start Date - Last Year: 11 Mar 2020 (Year:2020 Quarter:1 Period:2 Week:2 Day:4)

The End Date - Last Year date coordinates, consisting of quarter, period, week and day, is the same as the date coordinates specified in End Date - This Year.

Calendar with start date and end date highlighted.

Week

The reporting period will cover a week. Selecting Week requires you to specify the End Date - This Year (TY) date field. After doing so, the Start Date - This Year (TY) is automatically filled out with the start date of that week (week to date). The Start Date - Last Year (LY) is automatically filled out with the corresponding start date coordinates of the identical week last year, and the End Date - Last Year is filled out with the end date of that week.

For example, 10 Mar 2021 (with coordinates Year:2021 Quarter:1 Period:2 Week:2 Day:4), is entered in End Date - This Year. The following date fields are automatically filled out with corresponding dates:

Start Date - This Year: 7 Mar 2021 (Year:2021 Quarter:1 Period:2 Week:2 Day:1)

End Date - Last Year: 11 Mar 2020 ,(Year:2020 Quarter:1 Period:2 Week:2 Day:4)

Start Date - Last Year: 8 Mar 2020 ,(Year:2020 Quarter:1 Period:2 Week:2 Day:1)

The End Date - Last Year date coordinates, consisting of quarter, period, week and day, is the same as the date coordinates specified in End Date - This Year. In this example, 10 Mar is the fourth day of the second week of the second period in year 2021. So, the End Date - Last Year will be the fourth day of the second week of the second period in year 2020, which in this example is 11 Mar 2020.

Start Date - This Year is the start date of the second week of the second period of year 2021, which in this example is 7 Mar 2021.

Start Date - Last Year is the start date of the second week of the second period of year 2020, which in this example is 8 Mar 2020.

Calendar with weeks highlighted as described in the example.

Period

The reporting period will cover a period. Selecting Period requires you to specify the End Date - This Year (TY) date field. After doing so, the Start Date - This Year (TY) is automatically filled out with the start date of that period (period to date). The Start Date - Last Year (LY) is automatically filled out with the corresponding start date coordinates of the identical period last year, and the End Date - Last Year is filled out with the end date of that period.

For example, 10 Mar 2021 (with coordinates Year:2021 Quarter:1 Period:2 Week:2 Day:4), is entered in End Date - This Year. The following date fields are automatically filled out with corresponding dates:

Start Date - This Year: 28 Feb 2021 (Year:2021 Quarter:1 Period:2 Week:1 Day:1)

End Date - Last Year: 11 Mar 2020 (Year:2020 Quarter:1 Period:2 Week:2 Day:4)

Start Date - Last Year: 1 Mar 2020 (Year:2020 Quarter:1 Period:2 Week:1 Day:1)

The End Date - Last Year date coordinates, consisting of quarter, period, week, and day, is same as the date coordinates of the specified End Date - This Year. In this example, 10 Mar is fourth day of the second week of the second period in year 2021. So, End Date Last - Year will be the fourth day of the second week of the second period in year 2020, which in this example is 11 Mar 2020.

Start Date - This Year is the start date of the second period of year 2021, which in this example is 28 Feb 2021.

Start Date - Last Year is the start date of the second period of year 2020, which in this example is 1 Mar 2020.

Calendar with weeks highlighted as described in the example.

Quarter

The reporting period will cover a quarter. Selecting Period requires you to specify the End Date - This Year (TY) date field. After doing so, the Start Date - This Year (TY) is automatically filled out with the start date of that quarter (quarter to date). The Start Date - Last Year (LY) is automatically filled out with the corresponding start date coordinates of the identical quarter last year, and the End Date - Last Year is filled out with the end date of that quarter.

For example, 12 May 2021 (Year:2021 Quarter:2 Period:4 Week:2 Day:4), is entered in End Date - This Year. The following date fields are automatically filled out with corresponding dates (provided that each quarter has 3 periods and a year has 4 quarters):

Start Date - This Year: 2 May 2021 (Year:2021 Quarter:2 Period:4 Week:1 Day:1)

End Date - Last Year: 13 May 2020 (Year:2020 Quarter:2 Period:4 Week:2 Day:4)

Start Date - Last Year: 3 May 2020 (Year:2020 Quarter:2 Period:4 Week:1 Day:1)

The End date Last Year date coordinates, consisting of quarter, period, week, and day is same as the date coordinates of the specified End Date - This Year. In this example, 12 May is fourth day of the second week of the fourth period. This falls on the second quarter in year 2021.

End Date Last Year will be the fourth day of the second week of the fourth period. It falls on the second quarter of the year 2020, which in this example is 13 May 2020.

Start Date - This Year is the start date of the second quarter of year 2021, which in this example is 2 May 2021.

Start Date - Last Year is the start date of the second quarter of year 2020, which in this example is 3 May 2020.

Calendar with weeks highlighted as described in the example.

Year

The reporting period will cover a year. Selecting Year requires you to specify the End Date - This Year (TY) date field. After doing so, the Start Date - This Year (TY) is automatically filled out with the start date of that year (year to date). The Start Date - Last Year (LY) is automatically filled out with the corresponding start date coordinates of the previous year, and the End Date - Last Year is filled out with the end date of that year.

For example, 12 May 2021 (Year:2021 Quarter:2 Period:4 Week:2 Day:4), is entered in End Date - This Year. The following date fields are automatically filled out with corresponding dates (provided that each quarter has 3 periods and a year has 4 quarters):

Start Date - This Year: 31 Jan 2021 (Year:2021 Quarter:1 Period:1 Week:1 Day:1)

End Date - Last Year: 13 May 2020 (Year:2020 Quarter:2 Period:4 Week:2 Day:4)

Start Date - Last Year: 2 Feb 2020 (Year:2020 Quarter:1 Period:1 Week:1 Day:1)

The End Date - Last Year date coordinates, consisting of quarter, period, week, and day is same as the date coordinates of the specified End Date This - Year. In this example, 12 May is the fourth day of the second week of the fourth period. This falls on the second quarter in year 2021. So, End Date - Last Year will be the fourth day of the second week of the fourth period. It falls on the second quarter of the year 2020, which in this example is 13 May 2020.

Start Date - This Year is the start date of the year 2021, which in this example is 31 Jan 2021.

Start Date Last Year is the start date of the year 2020, which in this example is 2 Feb 2020.

Calendar with weeks highlighted as described in the example.

Custom

The reporting period will cover a time frame of your choice. Selecting Custom requires you to specify the Start Date - This Year (TY), End Date - This Year (TY), Start Date - Last Year (LY) and End Date - Last Year (LY) fields. With Custom reporting period, you can specify in the date fields time frames that are not identical, with unequal number of days. For example, you can compare store sales in a certain week this year with the sales in a quarter of last year. Or, compare the store sales in a day for This Year with store sales in a week for Last Year.
Note:

In the reporting period, you can specify any year as This Year (TY) provided that you have created and uploaded the calendar for that year and the previous year to be compared with.

For example, assuming that the current year is 2021. If This Year is 2016, Last Year will automatically be 2015 (except when Custom is selected, where you must specify a year for Last Year).

Requirements for Custom Reporting Period

The following are validations if you select Custom for the Reporting Period:

Metrics

The Metrics field enables you to select metrics to display store sales data. When the Same-Store Sales Report is generated, each metric is displayed in columns, for displaying sales data This Year (TY), Last Year (LY) and the % Difference. You can select any or multiple metrics. At least one metric is selected by default.

Metric

Description

Net Sales Amount

Net Sales Amount = Gross Sales $ - Discount - returns

Net Sales Amount is displayed in 3 columns:

  • Net Sales Amount TY = net sales This Year

  • Net Sales Amount LY = net sales Last Year

  • % Difference in Net Sales Amount = ((Net Sales Amount TY - Net Sales Amount LY) / Net Sales Amount LY) * 100

Net Sales Quantity

Net Sales Quantity = Gross Sales Unit - Returns

Net Sales Quantity is displayed in 3 columns:

  • Net Sales Quantity TY = net sales quantity This Year

  • Net Sales Quantity LY = net sales quantity Last Year

  • % Difference in Net Sales Quantity = ((Net Sales Quantity TY-Net Sales Quantity LY) / Net Sales Quantity LY )* 100

Number of Sales

Number of Sales = Number of Sales Transactions

Number of Sales is displayed in 3 columns:

  • Number of Sales TY = number of sales This Year

  • Number of Sales LY = number of sales Last Year

  • % Difference in Number of Sales = ((Number of Sales TY - Number of Sales LY) / Number of Sales LY )* 100

Gross Margin

Gross Margin (amount) = Net Sales - Cost of Goods Sold

Gross Margin is displayed in 3 columns:

  • Gross Margin TY = net sales - cost of goods sold This Year

  • Gross Margin LY = net sales - cost of goods sold Last Year

  • % Difference in Gross Margin = ((Gross Margin amount TY - Gross Margin amount LY) / Gross Margin amount LY )* 100

Gross Margin %

Gross Margin % = (Gross Margin / Net Sales) * 100

Gross Margin % is displayed in 2 columns:

  • % Gross Margin TY = (Gross Margin / Net Sales) * 100, This Year

  • % Gross Margin LY = (Gross Margin / Net Sales) * 100, Last Year

General Notices