Embark on a journey of comparative analysis with the Like for Like report, offering a comprehensive overview of net sales across different sites. On a selected date, delve into how your current net sales measure up against the previous day, the same day in the previous week, and the corresponding day in the previous year. This report provides a strategic snapshot, allowing you to gauge performance trends and make informed decisions based on a nuanced understanding of your sales dynamics. It's not just numbers; it's your guide to deciphering the evolving landscape of net sales.
Essentially, this report is a report version of the interactive Like for Like Dashboard.
Note that yearly comparisons follow a 52 or 53 week calendar based on the ISO Week Date standard.
If required, this report can be created as a Saved Report and set up to send out periodically, providing that the report date is selected as either Today or Yesterday.
Report Filters
Access the Like For Like report via: Reports & Analysis > Sales > Like For Like.
Select the required report parameter options from:
| Select Sites |
Select which sites and/or site groups to include in the report. |
| Report Date |
Select which date to report on, or select either Today or Yesterday. |
| Transactions Up To (Time) |
If the Today option is selected, enter a time to specify which time sales up until should be included in the report. |
Report Output
The Like For Like Sales report has three levels:
Level 1 - Site Comparison
The first level of the Like For Like report is a net sales comparison for each site, displaying:
| Site |
Displays the sites name. |
| Date |
Displays net sales for the date show. (If the current date, shows sales for transactions up until the Transactions Up To time.) |
| Day Before |
Displays comparable net sales for the previous date. |
| Week Before |
Displays comparable net sales for the same day last week. |
| 4 Weeks Avg. |
Displays an average of comparable net sales for the same day over the previous 4 weeks. (Average calculation excludes days with no sales.) |
| Year Before |
Displays comparable net sales for the same day last year. |
| Last Transaction |
Displays the time of the last transaction for site within the report date timeframe. |
Percentage comparison indicators are also shown, where grey is a difference within +/- 5%; red is a difference less than -5%; green is a difference greater than 5%.
Level 2 - Hourly Sales Comparison
The second level of the Like For Like report is a net sales comparison split by sales hour for the selected site, displaying the same sales information as per level 1.
Level 3 - Transaction List
The third level of the Like For Like report is a list of all transactions within the sales hour selected in level two, displaying:
| Transaction ID |
Displays the ID of the transaction. Select this to see more. |
| Transaction Date |
Displays the date and time that the transaction occurred. |
| Till |
Displays the till that the transaction took place on. |
| Team Member |
Displays the team member that finalised the sale. |
| Sale Type |
Displays the Transaction Type. |
| Gross |
Displays the transaction gross sale value. (Excludes discount.) |
| Net |
Displays the transaction net sale value. (Excludes discount and tax.) |