This report allows you to compare the sales of two stores on a per-department basis over a set date range, and shows the variance between them.
The report is only available for Multi-store sites, and only viewable if the store is set as a Master Store in Setup->Multi-Store->Store Rules, and Only Show Local Store Information is not ticked.
Generating the Report
From the main screen of Retailer, click on Reports → Sales Reports → Store Comparison Report at the top.
There are a few options you can set for the report:
- Date Range - Select the Start and End Date of sales transactions to be included in the report.
- Select Stores to include - Select the two stores you wish to compare from the drop down menus
- Exclude Home Delivery & Subagent Orders - Tick to exclude any customer delivery orders and subagent orders (for newsagencies).
Reading the Report
The Report will group the following according to each store location included on the report, and also display departments if the option is ticked:
- Total Sales - Total dollar value of sales transactions in this period
- Quantity Sold - Total number of items sold for the store or department
- Stock Turnover - Annualised Sales to Inventory Ratio; a ratio based on the sales to inventory value on an annual basis for
the selected period. Useful for comparing the same departments between
stores. The higher ratio in a store vs the other store for a particular
department can be caused by a lower stock holding, higher sell through
rate or both.
This is calculated as (Total Sales / Stock Value) / (365 - Selected Date Range). - ROI - Return on Investment - Shows the return on investment for
the department. This is the gross profit divided by the purchases for that department.
- Gross Profit (%) - Gross profit in percentages, of items sold
- Variance - Difference in values between the two stores
Exporting the Report
You can export any of these report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:
- PDF - Click on the red PDF button at the top of the report and choose your save destination.
- Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button [...] to choose your save destination. Click OK to save the file.
Related Articles
Store Order Report
This is for Multi-store customers only. The Store Order Report displays information about items transferred from one store location to another, but only if they have been accepted or received at the destination store. Accepting and receiving ...
Monthly Sales Comparison Report
We have a video guide on how to use the Monthly Sales Comparison Report - ? Monthly Sales Comparison Report If you only look at one report regularly in your Retailer software, it should be the Monthly Sales Comparison report. This report is great ...
Staff Comparison Report
The purpose of this report is to compare the sales performance of staff members within a specified date range. For this report to be effective, you must be using Staff Initials when ending sales or have Staff Logins setup. Generating the Report On ...
Store Performance Report
This report can show you the sales numbers across different stores, allowing you to compare how well they are doing, at the department level. The report will only be available for Multi-store sites. Generating the Report From the main screen of ...
Inter-Store Transfer Report
The Inter-Store Transfer Report can be used to view the inter-store transfers that have been leaving or arriving at a location. It can be used to view the items in a specific transfer, or you can view totals across a selected date range. To run the ...