Daily Sales Report

Daily Sales Report

Daily Sales Report Overview

Reports -> Sales Reports -> "Daily Sales"

The most critical and important statistics for running a business efficiently are various types of sales reports. A daily sales report provides a summary of all sales made during the day at a business.
 
FTx Cloud POS includes a Daily Sales report that allows you to view daily sales data. As a sales manager/super-admin user, you will get all the sales summaries, including the System/Manual discounts, applied coupons [Manufacturer, Store, & Gift Cards], and the cost-retail price calculation and profit margins.

In this technical document, you will see:
- How to check the daily sales report
- How to apply the custom filter options to filter the daily sales report data
- Grouping options to get the daily sales data in a specific manner

1. Reaching the Daily Sales Report

To reach the "Daily Sales" report, follow the below steps:
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reports
  4. Step 4: Choose Sales Reports
  5. Step 5: Choose Daily Sales


                                                                                                                       Figure 1.1

By clicking "Daily Sales," you will be redirected to the "Daily Sales Report" page with relevant filter options.


                                                                                                       Figure 1.2
You will see the "Report data is empty" message initially. You need to select the date range to check the daily sales data in the report.

2. Generating Daily Sales Report

When you navigate to the "Daily Sales Report" page, you will get the options pre-selected by default. You can generate the daily sales report by clicking the "Generate Report" button.

                                                                                                                              Figure 2.1

After generating the daily sales report, you will see the sales data for the day in tabular format based on the date range and filter options:
Sales Day: This column represents the day (date) on which the sales occurred.
Gross Sales: This column represents the total amount of the sales for the day.
Net Sales: This column represents the total sales value without taxes amount calculation. [Net Sales= Gross Sales - Taxes]
Manual Discount: This column represents the amount of the manual discount that was manually entered by the cashier during the checkout.
System Discount: This represents the system discounts that are applied during the checkout.
Adj Net Sales: This column represents the total of adjusted sales without the discounts and taxes values. [Adj Net Sales= Gross Sales - Discount- Taxes]
Taxes: This column represents the amount of the applicable tax on the items.

Cash: This column represents the amount value that is paid in cash.
Credit/Debit: This column represents the amount value that is paid through the credit/debit cards.

Gift Cards: This column represents the gift card amount that is utilized during the payment.
Store Coupons: This column represents the store coupon amount that is utilized during the payment.
Manuf Coupons: This column shows how many manufacturer coupons were used during the payment.

Payouts: This column represents the amounts that are paid out from the cash drawer for the in-house activities i.e., paying to cleaners.
Tender Amount: This column represents the total of all the payment modes utilized to complete the sales.

Cost of Goods Sold: This column represents the total of the buydown amount that is applied to the items during sales.
Buydown: This column represents the total of the buydown amount that is applied to the items during sales.
Gross Profit: This column represents the total margin of the sold qty after calculating the Buydowns and Discounts. [$ Margin= Adj Net Sales - Cost of Goods Sold]
Profit Margin: This represents the margin that gains or losses in percentage. % Margin will calculate the margin against the total retail in percentage. [% Mgn= ($ Margin*100) / Adj Retail]

3. Report Filter Options

Now, let's see how to set up the report filter options to generate the daily sales report with specific criteria.

                                                                                                           Figure 3.1

3.1 Date Range & Preset

You can filter your sales data in the report by selecting the date range 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 in mm/dd/yyyy format.


                                                                                                                             Figure 3.1.1
If you want the daily sales data in the report for a specific time duration (till morning/evening), you can select the particular time (hour & minutes) from the date selection.

Presets
The Presets label is provided to select the specific duration/interval to generate the daily sales data with that.
                                                                                                                                        Figure 3.1.2

3.2 Group By Location

Let's see how to check the daily sales data by grouping it into a location or location groups.
You will see a "Group By Location" drop-down from which you can select either "Location" or "Location Group" for grouping the daily sales data. By default, None will be pre-selected, which means the sales data will be displayed without any grouping, as shown in Figure 3.2.1.

                                                                                                                                        Figure 3.2.1
Location: If you select "Location," the daily sales data will be displayed in the grouping according to the locations (stores) individually.
Once the Location-specific report is generated, you can check the total sales data for the daily sales separated as per the locations.
                                                                                                                                        Figure 3.2.2


Location Group: When you select "Location Group," one more filter option will be enabled to select the specific location group(s). You can see the "Include Location Group(s)" drop-down option to check the sales data for the specific location group.
The "Location Groups" are collections of locations and can be created from "Manage Location Groups" in POS -> Maintenance -> Locations.
By clicking "Location Group," you will get the "Include Location Group(s)" drop-down selection to select the specific location group record(s).


                                                                                                                                        Figure 3.2.3
By clicking the drop-down, you can see all the locations groups will be pre-selected by default. You need to select/deselect the location group accordingly.

After selecting the Location Group(s) and generating the report, you can see the daily sales data grouping into Location Groups individually.

                                                                                                                                        Figure 3.2.4
You can see the totals for each grouping, and you can also see the grand total details at the end of the report.

3.3 Filter Locations & L.Groups

To check the daily sales data for the specific location (store) and/or location groups only, you can set up the location filter option by clicking the button (No filter selected) on the top-right side.

                                                                                                                               Figure 3.3.1

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" and "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.


                                                                                                                       Figure 3.3.2
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) on 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.


                                                                                                                  Figure 3.3.3
- Clear Selection: 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.
- Apply or Save Filters: 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 enter the name of the location filter.

                                                                                                    Figure 3.3.4
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.


                                                                                                             Figure 3.3.5
3.
- 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 to customize the records to get only the location-specific data for the daily sales report.

Similarly, you can select the location group and filter the records.

                                                                                                                        Figure 3.3.6
When you set up the filters for locations (stores) and location groups, you can see the selected details by hovering the mouse cursor over the filter button.


                                                                                                                         Figure 3.3.7
Note: "3.2 Group By Location" will group the daily sales data based on Locations or Location Groups you have selected, while the "3.3 Locations & Location Groups" custom filter option sets up a specific record selection. The daily sales data will be generated in the report as per the selected locations (stores) or location groups only.

3.4 Add to Sales

Let's check the daily sales data based on the item sold from the department that is enabled with the "Added to Sales" or "Not Added to Sales" option.
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. You can see "All Departments" pre-selected by default.


                                                                                                                            Figure 3.4.1

If you want to check the daily 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 daily sales data of the departments that have the "Add To Sales" option disabled, select "Not Added to Sales" and generate the report.


                                                                                                                            Figure 3.4.2

3.5 After Midnight
Tick the "After Midnight" checkbox to check the daily sales data that occurred after midnight (overnight). By ticking the "After Midnight" checkbox, you will see the "Day Ends At" drop-down. By selecting the time from the drop-down, you can set up the custom day timings.

                                                                                                              Figure 3.5.1
The "After Midnight" option depends upon the date selection. Generally, the day (24 hours) is counted from 00:00 to 23:59 (11:59 pm), but if you want to change the starting and ending times 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 daily sales data accordingly.

The "After Midnight" (selecting a specific time) option helps to check the sales statistics to see if 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 daily sales report. When the long holidays appoach, 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. 
Hence, you can set up multiple custom filters at the same time to get the daily sales data in the report.

    • Related Articles

    • Store Daily Sales Summary List Report

      Store Daily Sales Summary List Report Overview Reports -> Sales Reports -> "Store Daily Sales Summary List" Sometimes there is a need to check the overall sales for a store without needing to know specific items or quantities sold. The Store Daily ...

    • Unaudited Daily Reconciliations Report

      Unaudited Daily Reconciliations Report The "Unaudited Daily Reconciliations Report" displays the daily reconciliation data that has gone unaudited (not checked for any discrepancy by the corporate user) within the selected date range. The report ...

    • Sales Tax Report

      Sales Tax Report The "Sales Tax Report" will display the detailed sales tax-related data for each location during a specifically entered date range. Multiple different types of filters can also be configured, depending on your requirements. The ...

    • Sales Trend/Comparison Report

      Sales Trend/Comparison Report The "Sales Trend/Comparison Report" is a compilation of multiple reports in one, showing different trends and plots based on quantity sold, dollar value sold, and profit made on items in a specific date range. It uses ...

    • 12 Week Sales Report

      12 Week Sales Report Overview The "12 Week Sales Report" will display the sales data of the products only that were sold in the previous 12 weeks from the date entered in the field labeled Date. Many types of filters can also be configured, depending ...