RepairDesk multi-store sales breakdown report is designed to allow multi-store owners to easily view store wise summaries and to evaluate the progress of stores by comparing them against each other in a single report.
Let’s go through the details below to know how this report works and what value it can add to your business!
Why it is important for your business?
Multi-store sales breakdown report can add value to your business by enabling you to:
- Easily compare the progress of multiple stores
- Keep track record of sales generated from repairs, unlocking, accessories, trade-in, casual as well as cost of goods sold, discount given, tax paid, gross profit and profit margin on daily, weekly and monthly basis.
- Compare and contrast profit margins from each store to see which store is performing well.
- Ease of exporting and printing the data of multiple stores in a single Excel or PDF file.
How to View Multi Store Report?
To view the multi-store sales breakdown report, head to Reports section from POS screen.
You will get the multi-store sales breakdown report displayed.
To get a detailed view of each store report, use View Report option under the store name as shown below.
To get back to multi-store sales report, head to the bottom of dashboard screen and click on Multi Sore Sales in the Sales Report section.
Multi-store sales report comes with a variety to filters to make it easy for you to filter data according to your requirements. You can filter data Store Wise and Date Wise to get information about a specific store for particular time period. Follow the steps below to filter the report.
Select Store Filter
1. Use select store filter to view data for a particular store. You can select multiple stores at the same time.
1. To apply date filter, click on the calendar icon and you will get the calendar displayed. To view report for a specific time period, click on start date and drag it to end date for which you want to display the report.
Hit Apply button to apply the filter. You can remove the filter anytime using Cancel button.
Note: To filter data for daily, weekly or monthly basis, following options can be used to automatically mark the dates on calendar. To jump directly to current date on calendar, double click on any date in the same month and it will filter report to display data for that particular date.
Once you have selected the required filters, hit Run Report button to get filtered report.
Note: Another way to filter report on daily, weekly and monthly basis is by using toggles appearing at right side of the report as shown below
The report has been divided into multiple columns to display various fields that sum-up the results of multiple transactions. The details of each column are explained below.
1. Store Name
This column shows the list of all available stores of your business.
Repair column shows the total sales that a store has generated by repair transactions.
Similar to repairs, this column shows the total sales generate by unlocking transactions.
If you have sold any accessory item, then the effect of that transaction is reflected in products column.
This column shows the sum of all trade-in transactions of a particular store.
The sum of all transactions related to causal items.
The value in this column shows the sum of discount given against every transaction.
8. Total Tax
Sum of tax value applied to all transactions is shown in this column.
9. Cost of Goods Sold (COGS)
The total cost of goods sold is shown in this column.
10. Avg sales
Average sales is calculated by dividing total sales amount by the total numbers of days selected.
Avg sales= total sales /number of days selected
11. Net Profit
The total Net profit earned by a store is reflected in this column. It is calculated by the following formula
Net Profit= Sale Price- discount – Cost of goods sold
Sale Price = Retail Price + Tax
This column shows the percentage of profit generated on sales and is calculated by the formula below
Profit Margin = (Net Profit /Sale Price- discount
) * 100
12. Payment Received
this column will show the amount of payment received against invoices.
C. EXPORT AND PRINT
To export the report in Excel or PDF format, use the Excel or PDF button and to print report, use Print button.
You will also have an option to view the individual report for a store as a dashboard by using View Report option.
The following example has been designed to illustrate the working of report with a few transactions for a single store.
Q. Does this report shows the impact of refund transactions?
A. Definitely it shows the impact of refund transaction as well. In case of refund, the values in respective columns will be subtracted from current total value.
Q. Does the value for discount includes both inline and overall discount?
A. Yes, the value of discount shown in this report is the sum of inline as well as overall discount.
Q . Is there any option to view average transaction size?
A. User can view average transaction size by clicking the amount under repair, unlocking, Products and causal.
Note: user can view the details description by clicking the tooltip provided.
Q. Is there any option to view franchise fee against each store?
A. Yes, you can add franchise fee from store settings. To view Franchise Setup Click Here
Once you have set up the franchise setup, a column will be displayed on the multi-store report from where you can view the franchise fee against each store.
Note: If user doesn't set franchise fee aganist any store then this colunm will not be available in the report. but if user adds franchise fee for any of its store then clounm will be displayed aganist all other store .