Excise Tax Report Overview

Reaching the "Excise Tax Report"

To reach the "Excise Tax 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
   

                                                                                 Figure 0.0

1. Step 5: Choose Excise Tax

                                                                                   Figure 0.1

You will see the Report Data is Empty message initially. You need to select the date range to check the summarized excise tax data in the report. See Figure 0.2.

                                                                                  Figure 0.2

1. Generating the "Excise Tax Report"

When you navigate to the Excise Tax Report page, you will see the options pre-selected by default. You can generate the report for the selected date range.

                                                                                         Figure 1.0

Fields:

1. Store #: This column displays the store number.
   
2. Store Name: This column displays the name of the store location.
3. Total Cost: This displays the total cost that incurred for the excise tax item to the store.
   
4. Adj Cost: This displays the adjusted cost against the Total Cost of the sold item with excise tax, i.e., Adj Cost=Total Cost - Buydown (if any applied). It is calculated by the system automatically.
5. Total Retail: This displays the total retail for that transaction, excluding the discounts. 
6. Adj Retail: This is the adjusted retail amount for the transaction that includes excise tax on the sold items, i.e., Adj Retail = Total Retail - Discount (if any applied). It is calculated by the system.
7. Excise Tax Collected: This column displays the excise tax that is collected by the cashier at the store location in the selected date range. 
   

2. Filter Items

1. Include: If the flag is selected to Include, it means the Excise Tax Report will be generated by applying the selected records.
   
2. Exclude: If the Exclude flag is selected, the sales report will be generated, but the selected records will be ignored. It will consider the selected records that need to be excluded and the left-side records for reports.

2.1 Save Filters

You can also save the configured custom filters for future use. By clicking the "Save Filters" button, a pop-up will appear to allow you to enter the name of the custom filter.

                                                                                                              Figure 2.1.0

1. Click on "OK," and the saved filter will appear under the Manage Filters drop-down list.
   

                                                                                Figure 2.1.1

3. 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 manually enter the date in mm/dd/yyyy format.

See Figure 3.1, Figure 3,2, and Figure 3.3.

1. Start Date: This option lets you set the start date for the selected date range.
   

                                                                                          Figure 3.1

1. End Date: This option lets you set the end date for the selected date range.

                                                                                                      Figure 3.2

1. Presets: The Presets label is provided to select the specific duration/interval to generate the excise tax data with that.
   

                                                                                  Figure 3.3

4. Checkbox Filters:

Two checkbox filters that are explained below are also available to get the custom results in the report.

4.1. Exclude Zero Excise Tax

This checkbox filter will not include (exclude) excise tax records where the excise tax is equal to zero.

4.2. Group by Date:

This filter groups the excise tax report by date on which the transaction is carried out.

                                                                                                                                                                                         Figure 4.2.0

5. 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 the defined frequencies (daily, weekly, biweekly, monthly, quarterly, etc.). 

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

6. 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. 

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