Summary Sales Report Overview
Reports -> Sales Reports -> "Summary Sales Report"
As a sales manager or super-admin user, you need to keep an eye on the overall sales and the earnings from different payment modes during the specific date range. This will help you create strategies and discounts to boost sales.
FTx Cloud POS provides the "Summary Sales" report with Gross and Net Sales and different payment mode data (tender details). You can check which store made the highest sales and had the highest customer count during the specific period. This report gives you the store-specific summary report.
Department groups could be created only for reporting purposes to keep an eye on multiple departments' sales. If you have created and maintained the department groups properly, it is easy to get the sales data in summary for the different department groups.
In this technical document, you will see:
-How to get the summary report
-Department groups and full summary report
-Highest sales summary report
-Specific day (date)-wise summary sales report
1. Reaching the Summary Sales Report
To reach the Summary Sales report, follow the below steps:
- Step 1: Log into Control Center
- Step 2: Choose Point of Sale
- Step 3: Choose Reports
- Step 4: Choose Sales Reports
- Step 5: Choose Summary Sales
By clicking "Summary Sales," you will be redirected to the "Summary Sales" page with relevant filtering and sorting options.
You will see the "Report Data is empty" message initially. You need to select the date range to check the summarized sales data in the report.
2. Generating a Summary Sales Report
When you navigate to the Summary Sales Report page, you will get the options pre-selected by default. You can generate the summary sales report based on the two different report types: "Dept Group Customized" and "Full Summary."
2.1 Department Group Customized Report
The Department Group Customized report type is selected by default. You can generate a summary sales report based on the department groups for different departments.
By selecting "Dept Group Customized" and generating the report, you can see the overall summary of the sales for all the department groups, which means each item sold.
You will see the sales data for the "Dept Group Customized" report type in tabular format based on the date range and filter options:
Location: This column represents the different locations (stores) where the sales occurred.
Sales: This column represents the total sales amount at the locations.
Profit: This column represents the overall profit amount for the location.
Cash/Checks: This column shows the total amount paid in cash and checks.
Credit Cards: This column represents the total amount paid by credit cards. MFG Coupons: This column represents the amount of the manufacturer coupons utilized during the payment.
Store Coupons: This column represents the value of store coupons utilized during the payment.
Misc Tender: This column represents the value of store coupons utilized during the payment.
Buydowns: This column represents the total of the buydown amount that is applied to the items during sales.
Customer Count: This column represents how many customers appeared for the checkout of their items.
2.1.1 Department Groups Selection
When you select the "Dept Groups Customized" report type, you will get the "Department Groups" drop-down selection beside the Report Type. You can see the existing department groups in the drop-down selection that contains the relevant departments.
You can now generate the report for a specific department by checking the box next to any department in the list.
By selecting the Dept Group(s) and generating the summary report, you can see the selected department group in the tabular information in the last column.
The overall sales summary is shown in the preceding columns, while the department-specific sales data is shown separately in the last column with the department name selected. If you select multiple department groups, the summarized sales data for the selected department groups will be displayed in the columns following the group name.
The "Dept Group Customized" report type will be helpful to check the sales data for the selected department group(s) by comparing the overall sales for the locations.
2.2 Full Summary
You can generate the full summary of the sales data between the specified dates in the report. The "Full Summary" sales report provides overall sales data for each item that is assigned to the different departments.
By selecting "Full Summary" from the report type, click on the "Generate Report" button to get the overall sales data, including gross and net sales, in the report.
You will see the sales data for the "Full Summary" report type in tabular format based on the date range and default filter options:
Location: This column represents the different locations (stores) where the sales occurred.
Gross Sales: This column represents the location-specific total amount of the sales.
Discounts: This column represents the discounts that are applied to items belonging to the department during the transaction.
Adj Gross Sales: This column represents the adjusted gross sales value after deducting the discount value from the gross sales. [Adj Gross Sales= Gross Sales - Discount]
Taxes: This column respresents the amount of the applicable tax on the items.
Adj Net Sales: This column displays the total of adjusted net sales excluding discounts and taxes. [Adj Net Sales= Gross Sales - Discount- Taxes]
Payout: This column represents the adjusted cost deducting the buy-down value from the total cost. [Adj Cost= Total Cost - Buy-down]
The following four columns of information are the bifurcation of the "Adj Net Sales":
Cash Tendered: This column represents the payment in cash.
Credt/Debit Tendered: This column represents the payments made with credit or debit cards.
Coupons Tendered: This column represents the coupons amount (Manuf and Store) that are utilized during the payment.
Checks Tendered: This column represents the amount value that is paid through the checks.
Customer Count: This represents the margin that gains or loses in percentage. % Margin will calculate the margin against the Total Retail in percentage. [% Mgn= ($ Margin*100) / Adj Retail]
2.2.1 Bifurcation Options for Full Summary
When you select the "Full Summary" report type, you will get the "Group By Day" report bifurcate (checkbox) option.
Group By Day
By ticking the "Group By Day" checkbox, the sales data will be summarized under the dates on which the sales occurred. It will show the store-specific summary of the sales based on the day (date).
From Figure 22.214.171.124 above, you can see the summary of the sales data is arranged according to the specific day (date). You can then look at overall sales data for a specific date under the stores where the sales occurred.
By enabling the "Group By Day" option, you will get the "After Midnight" checkbox to check the sales summary that occurred after midnight (overnight). By ticking the "After Midnight" checkbox, you will see the "Day Ends At" drop-down. You can set up custom day timings by selecting the time from the drop-down menu.
The "After Midnight" option depends upon the date selection. Generally, the day (24 hrs) is counted from 00:00 to 23:59 (11:59 pm) but if you want to change the starting and ending time of the day to check the sales data for a different time interval, select the time from the list. By choosing the specific time, the 24 hours will be counted as per the selection of the time rather than the usual day timing, and you can see the summary sales data accordingly.
"Group By Day" and "After Midnight" (selecting a specific time) bifurcation options help to check the sales statistics from the summary sales data when the store was opened at midnight. So, the sales management team could plan the sales strategy for midnight sales in the stores and determine whether it is worth running the store at midnight or not based on the summary sales report. When the long holidays approach, the sales team typically operates the store after midnight to sell more items before the holidays so that people do not suffer during the holidays.
3. Report Filter Options
Now, let's see how to set up the report filter options, such as sorting and filtering, to check the summary sales report in a specific manner.
The following filter options are common for "Dept Group Customized" and "Full Summary" report types.
3.1 Sort By
You can sort the summary sales data as per the stores (Store #) or by the highest sales in ascending order (Highest Sales). The "Store #" (store no.) will be pre-selected by default.
If you select "Highest Sales," the summary sales data will show which store has made the most sales between the specific date range.
You can sort the stores by highest sales in ascending order. You can view the highest sales for the customized department group as well as the Full Summary report type.
You can filter your sales data in the report between dates as well as specific times.
By clicking the edit box, you will be taken to a tiny calendar where you can select a specific date range. You can also enter the date manually as in mm/dd/yyyy format.
If you want the summary sales data in the report with the specific time duration (until morning/evening), you can select the particular time (hour & minutes) from the date selection.
To generate the summary sales data, a preset label is provided to select the specific duration/interval.
3.3 Add to Sales
Let's check the summary of sales data based on whether the department is "Added to Sales" or "Not Added to Sales."
There's one setup (Add To Sales) at the department level. You can disable that setup if you don't want to include the items from that department in the sales reports.
You will see the three options from the "Add To Sales" drop-down: All Departments | Only Add to Sales | Not Added to Sales. "All Departments" is pre-selected by default.
If you want to check the summary sales data of the departments that have the "Add To Sales" option enabled, select the "Only Add to Sales" option from the drop-down and generate the report.
But, if you want to check the summary sales data of the departments with the "Add To Sales" option disabled, select "Not Added to Sales" and generate the report.
3.4 Filter Locations & L. Groups
To check the summary sales data for a specific location and/or location group only, you can set up the location filter option by clicking the button (No filter selected) on the top-right side.
By clicking that button, a "Manage Filters" window will pop up from where you will see the following details:
1. You will see the two tabs: "Store" & "Location Group."
2. You can select the saved custom filter from the drop-down selection. The "Manage Filters" button will open the list of the saved custom filters.
3. You can see the list of stores (locations) along with the checkbox. If there are plenty of records, you can search the store by entering the text.
4. By ticking the checkbox, the store will be selected.
5. By clicking the "move" button (green right arrow button), move the selected store record(s) to the right side under "Selected List."
You can see the selected store record in the "Selected List" section. It means, when you generate the report, you will get only the sales data for the department that is in the "Selected List" section.
You can remove the selected record by clicking the "Close" button. You can also remove all the selections from the list by clicking the "Clear Selection" button.
After selecting the store record(s), you can directly apply for the report by clicking the "Apply" button, or you can save it for future use.
Save and Manage Location Filters:
By clicking the "Save Filters" button, a pop-up will appear to allow you to enter the name of the location filter.
Enter the name of the custom filter and click the OK button to save it.
After saving the location filter, you can see:
1. Saved Filter: The saved custom filters will appear in the drop-down selection. You can select the required custom filter from the drop-down list for the report.
2. Manage Filters: You can check and manage the filters by clicking the "Manage Filters" button. By clicking on it, you will see the listing of the saved custom filters in a pop-up.
- Select FIlter: Select any filter from the list to generate the desired report. Select the filter from the list, and then click on the "Select Filter" button.
- Delete: Delete any filter from the list that is no longer required. Select the filter and then click on the "Delete" button.
In this way, the "Location Filter" options (tabs) help customize the records to get only the location-specific data for the summary sales report.
Hence, you can set up multiple custom filters at the same time to get the summary sales data in the report.