Daily Sales Report

Daily Sales Report

Daily Sales Report Overview

Various types of sales reports provide the most critical statistics for running a business efficiently. A daily sales report summarizes all sales made during the day at a company.
 
FTx Cloud POS includes the "Daily Sales Report," which 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, and gift cards], and the cost-retail price calculation and profit margins.

In this technical document, you will see:
  1. How to check the daily sales report.
  2. How to apply the custom filter options to filter the daily sales report data.
  3. 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 below will help you understand the navigation better.


Figure 1.1

When you click "Daily Sales," the "Daily Sales Report" screen will open with relevant filtering and sorting options, as Figure 1.2 shows.

Figure 1.2

The report data will be empty initially. You must choose a date range, select the appropriate filters, and click "Generate Report" to generate a report. 

2. Generating the "Daily Sales Report"

Please follow the steps below to generate the "Daily Sales Report" that meets your requirements:  
  1. Navigate to the Daily Sales Report screen.
  2. Select the date range and click "Generate Report" to view the Daily Sales Report for the selected date range.
    1. Based on your requirements, you can use the filters Group By Location, Include In Sales Reporting, Filter the Sales By, Reconciliation Type, and Stores and Location Groups. You can use multiple filters to make the report more specific. Please refer to point 3. Report Filter Options to learn more about these filters.
    2. Click "Generate Report" whenever you change your selection in any field to view the updated report. 
  3. When you click the "Generate Report" button after selecting the date range, the system will show the day-wise sales records, as Figure 2.1 shows.

Figure 2.1

To view the entire report, please use the scroll bar to move the view from left to right.

Report Columns:
  1. Sales Day: This column shows the sales date.
  2. Gross Sales: This column shows the total sales for the day.
  3. Net Sales: This column shows the total sales value without tax amount calculation. [Net Sales = Gross Sales - Taxes]
  4. Manual Discount: This column shows the amount of the manual discount that the cashier entered manually during checkout.
  5. System Discount: This column shows the system discounts applied during the checkout.
  6. Adj Net Sales: This column shows the total of adjusted sales without the discounts and tax values. [Adj Net Sales = Gross Sales - Discount - Taxes]
  7. Taxes: This column shows the applicable tax amount on the items.
  8. Cash: This column shows the value paid in cash.
  9. Credit/Debit: This column shows the value paid through the credit/debit cards.
  10. Gift Cards: This column shows the gift card amount utilized during the payment.
  11. Store Coupons: This column shows the store coupon amount utilized during the payment.
  12. Manuf Coupons: This column shows how many manufacturer coupons were used during the payment.
  13. Payins: This column shows any payment made in the Payin mode. 
  14. Expected Cash: This column shows the expected cash based on the selected Reconciliation Type. 
  15. Actual Cash: This column shows the actual cash the system receives.
  16. Difference: This column shows the difference between expected cash and actual cash, if any. 
  17. Is Audited: This column shows whether the transaction record is audited.
  18. Payouts: This column represents the amounts paid from the cash drawer for in-house activities, such as paying cleaners.
  19. Tender Amount: This column represents the payment modes utilized to complete the sales.
  20. Cost of Goods Sold: This column represents the cost of sold goods. 
  21. Buydown: This column represents the total buydown amount that is applied to the items during sales.
  22. Gross Profit: This column represents the total margin of the sold quantity after calculating the Buydowns and Discounts. [$ Margin= Adj Net Sales - Cost of Goods Sold]
  23. 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


FTx Cloud POS lets you view the "Daily Sales Report" records according to your preferences using various filter options. You can configure the report with any single filter or a combination of multiple filters, as highlighted in Figure 3.1.


Figure 3.1
1: Report Filters: 
  1. Date Range and Presets: This filter lets you select the report's time interval. Point 3.1 Date Range Presets explains further details.  
  2. Group By Location: This filter lets you view the records organized by Locations or Location Groups. Point 3.2 Group By Location explains the further details. 
  3. Include in Sales Reporting: This filter lets you filter the report records based on three parameters: All departments are only included in sales reporting and not included in sales reporting. Point 3.3 Include In Sales Reporting explains the further details.  
  4. Filter the Sales By: This filter lets you filter the report records based on three parameters: All Sales, E-Commerce Sales, and In Store Sales. Point 3.4 Filter the Sales By explains the further details. 
  5. Reconciliation Type: This filter lets you filter the report records based on two parameters: Daily Reconciliation and Shift Reconciliation. Point 3.5 Reconciliation Type explains further details.  
2: Store and Locations: This filter lets you view the report for the selected stores (locations) or location groups. Point 3.6 Filter Store and Location Groups explains further details. 

3: After Midnight Checkbox: Point 3.7 After Midnight explains the further details. 

3.1 Date Range & Presets


Date Range

Please follow the steps below to select the report's required date range and time interval:  
  1. Click inside the Start Date field. The drop-down calendar will appear as shown in Figure 3.1.1.
  2. Select the specific date and time. You can also manually enter the date in MM/DD/YYYY format.
  3. Click inside the End Date field and follow the same process. 
  4. After selecting other filters appropriately, click "Generate Report."

Figure 3.1.1

Presets

Use the Presets drop-down to select the specific duration/interval, i.e., Today, Yesterday, This Week, Last Week, etc., to generate the report as shown in Figure 3.2.2.
  1. Please click on the required timeframe and click "Generate Report." The system will generate and show the report based on your selection. 

Figure 3.1.2

3.2 Group By Location

The Group By Location filter lets you view records sorted by Locations or Location Groups. By default, the system selects "None." Click the "Group by Location" drop-down highlighted in Figure 3.2.1 to change it.

 Figure 3.2.1

1. Location: If you select "Location," the system will display records grouped according to locations, as Figure 3.2.2 shows.

 Figure 3.2.2
2. Location Group: If you select "Location Group," the system will display records grouped according to location groups.
  1. As Figure 3.2.3 shows, the Include Location Group(s) drop-down menu will appear when you select "Location Group." Please select the required locations from it. 

 Figure 3.2.3
  1. The system will segregate the report based on location groups, and the Include Location Group(s) drop-down will show the selected location groups, as Figure 3.2.4 shows.

Figure 3.2.4
InfoLocation Groups are collections of locations that can be created from "Manage Location Groups." (POS -> Maintenance -> Locations.)

3.3 Include In Sales Reporting 

The Include In Sales Reporting drop-down lets you filter the report records based on three parameters: All Departments, Only Include in Sales Reporting, and Not Include in Sales Reporting. 
Info
What is "Include In Sales Reporting?"

"Include in Sales Reporting" is a preference available at the department level and is managed by the Include In Sales Reporting drop-down. 
  1. If you activate it, the system will include the department in sales reporting.
  2. If you deactivate it, the system will not include the department in sales reporting. 
You can activate or deactivate this preference from the respective "Options" tab in "Departments." ("Departments" >> Add/edit a department>> the "Options" tab >> the Include In Sales Reporting drop-down). Please refer to "Departments" to learn more about this preference. 
  1. Click the Include In Sales Reporting drop-down.
  2. As Figure 3.3.1 shows, the drop-down menu has three options: All Departments, Only Include in Sales Reporting, and Not Include in Sales Reporting. The system selects "All Departments" by default.

Figure 3.3.1
  1. Choose "Only Include in Sales Reporting" to display the daily sales records with the activated "Include in Sales Reporting" option at the department level.
  2. Choose "Not Include in Sales Reporting" to see the daily sales records where the "Include in Sales Reporting" option is deactivated at the department level. 

3.4 Filter the Sales By

The Filter the Sales By drop-down lets you filter the report records based on three parameters: All Sales, E-Commerce Sales, and In Store Sales. 
  1. Click the Filter the Sales By drop-down. 
  2. As Figure 3.4.1 shows, the drop-down menu has three options: All Sales, E-Commerce Sales, and In Store Sales. The system selects "All Sales" by default.

Figure 3.4.1
  1. Select "E-Commerce Sales" to include only e-commerce sales data in the report. 
  2. Select "In Store Sales" to include only in-store sales data in the report. 

3.5 Reconciliation Type

The Reconciliation Type drop-down lets you choose whether to generate the report based on daily or shift reconciliation. 
  1. Click on the Reconciliation Type drop-down.
  2. As Figure 3.5.1 shows, the drop-down menu has two options: Daily Reconciliation and Shift Reconciliation. The system selects "Daily Reconciliation" by default and shows you the report records fetched based on daily reconciliation. You can change it to "Shift Reconciliation" and click "Generate Report" to view the report records fetched based on shift reconciliation.   

Figure 3.5.1

3.6 Filter Stores & Location Groups

The Store and Location Group filter lets you view the report for selected stores (locations) and Location groups. Please follow the steps below to apply the Store & Location Group filter.
  1. Click the "No Filter Selected" button in the top right, highlighted in Figure 3.6.1.

Figure 3.6.1
  1. The Manage Filters screen will appear, as Figure 3.6.2 shows. 

Figure 3.6.2
1: Manage Filters Drop-Down: The drop-down shows the list of saved custom filters, if there are any. Select the required filter from the drop-down and click the "Apply" button to apply it. The "Manage Filters" button next to this drop-down helps you open the Manage Saved Filters screen. Point 3.6.1 Save and Manage Location Filters explains more details.
2: Parameter Tabs: You will see two tabs: Store and Location Group. Select the required tab, e.g., Store, to create or apply a custom filter specific to the selected stores. 
3: Use this Search box to search for a specific location. 
4: Use this drop-down to view the results (stores or location groups) based on Pricebook Zone. 
5: Use this drop-down to view the products based on four parameters: All Locations, Only Active, and Only Deleted.
6: Results: This section shows the list of selected parameters. For example, if you have selected the Store tab, it will show a list of stores.  
7: Selection Checkboxes: You need to select the required stores by ticking the checkbox.
8: Arrow: Click the green Arrow button to move the selected stores to the Selected List. 
  1. The Manage Filters screen will look like the one in Figure 3.6.3.

Figure 3.6.3
1: Click the "Clear Selection" button to remove the whole selection. To remove any record from the list, click the Remove (x) icon.
2: Click "Apply" to apply the selection. You can click the "Save Filters" button to save the custom filter for future use. Point 3.6.1 Save and Manage Location Filters explains the details.

3.6.1 Save and Manage Location Filters

You can also save the configured custom filters for future use.
  1. Click the "Save Filters" button shown in Figure 3.6.3.
  2. The Name screen will appear as shown in Figure 3.6.1.1. Enter the name of the custom filter and click "OK." A success message will appear, and the custom filter will be saved. You can see this custom filter listed in the Manage Filters drop-down.

Figure 3.6.1.1
  1. You can use the saved custom filter from the Manage Filters drop-down whenever needed and delete it when you no longer need it. Open the Manage Filters screen again and follow the steps shown in Figure 3.6.1.2 according to your requirements.   

Figure 3.6.1.2
1: Saved Filter Drop-Down: All saved custom filters will appear in the Saved Filter drop-down. You can select the required custom filter and click "Apply." 
2: Manage Filters: Use the "Manage Filters" button to view and manage the saved filters. The "Manage Saved Filters" pop-up screen will appear when you click the "Manage Filters" button. 
3: Filter Name: The Filter Name list shows all saved custom filters. Click on a filter's name to select it.     
4: You can click "Select Filter" or "Delete."
  1. "Select Filter": Click on the filter's name, then click the "Select Filter" button to select any filter from the list.
  2. "Delete": Use the "Delete" button to remove the filter no longer required from the list. Click on the filter's name and then the "Delete" button. A warning message will appear. Click "OK."
  1. Similarly, you can filter the records by selecting the location group(s). 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, as shown in Figure 3.6.1.3.

 Figure 3.6.1.3

3.7 After Midnight

The After Midnight checkbox lets you view the daily sales data for the sales that occurred after midnight (overnight).
Info
What is the "After Midnight" feature, and how is it useful?

The "After Midnight" feature depends on the time chosen. Typically, a day runs from 00:00 to 23:59. However, you can select a different end time if you wish to analyze sales data over a different time frame. This selection will redefine the 24-hour period according to your chosen time, allowing you to view the daily sales data for that specific interval.
  1. The "After Midnight" feature, which allows for selecting a specific time, is useful for reviewing sales statistics to assess store performance at midnight. This enables the sales management team to devise strategies for midnight sales and evaluate their effectiveness using daily sales reports. As the long holidays draw near, the sales team often works at midnight to maximize sales, ensuring customers have what they need before the holiday period.
  2. The "After Midnight" feature, which allows for selecting a specific time, is useful for analyzing sales statistics to determine if the store was operational at midnight. This enables the sales management team to devise strategies for midnight sales and assess their viability based on daily sales reports. As the long holidays draw near, the team often keeps the store open past midnight to boost sales, ensuring that customers have access to necessary items during the festive season.
Please follow the steps below to utilize the "After Midnight" feature. 
  1. Tick the After Midnight checkbox. The Day Ends At drop-down will appear, as Figure 3.7.1 shows. Select the required end time and click "Generate Report."

 Figure 3.7.1

4. Scheduling a Report

FTx Cloud POS supports report automation. You can configure a report and schedule it. The system will send the scheduled report to the indicated email IDs at defined frequencies (Daily, Weekly, Bi-weekly, Monthly, Quarterly, etc.) 

Please refer to Scheduling a Report to learn how to schedule a report.

5. Printing/Exporting a Report 

You can print or export any report according to your requirements. When you use the Print function, the system creates and opens the report's PDF file in a new tab. You can download the soft copy or print the paper copy according to your requirements. 

Please refer to Printing a Report to learn how to print or export a report. 

6. Manage Favorites 

FTx Cloud POS allows quick access to the reports you need to view frequently through "Favorite Reports." You can save a report as a favorite and manage all your favorite reports from any of the report screens using the "Manage Favorites" button. 

Please refer to Managing the Favorite Reports to learn how to manage or export a 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 ...

    • Employee Sales Report

      Employee Sales Report Overview The "Employee Sales Report" helps identify the employees who made maximum/minimum sales in the selected date range. These reports work with different types of filters that can be configured depending on 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 ...