Excise Tax Report

Excise Tax Report

Excise Tax Report Overview

Reports -> Sales Reports -> "Excise Tax Report"

The excise tax type will display the excise tax-related data for each store location in the selected date range, depending on your requirements. It helps in identifying the highest and lowest excise-paying store locations for your company.

Different types of filters can also be configured, depending on your requirements. The system will display the records of excise tax-related data paid for each store location only according to the selected filter options.

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. Show All: This option displays the excise tax for all the store locations.
  2. Custom Filter (Manage): This button lets you apply some filters and generate filter-specific reports.

                                                                                   Figure 2.0

By clicking the "Manage" button, a Manage Filters window will pop up. You will see the following details highlighted in Figure 2.1.

                                                                               Figure 2.1
Filters:
  1. Department: If you select "Department," you will see a report of items department-wise to be selected for the custom filter to generate the excise tax report.
  2. Manufacturer: If you select "Manufacturer," you will see the manufacturer-specific inventory data for generating the excise tax report.
  3. Vendor: If you select "Vendor," you will get the vendor-wise items to generate the customized excise tax report.
  4. Department Tag: If you select "Department Tag," you will get the department tag-wise data to generate the customized excise tax report.
After selecting and moving the records under Selected List:

                                                                                     Figure 2.2

You can decide whether you want to include or exclude when the Excise Tax Report is generated.
  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.

                                                                                                   Figure 4.1.0

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. 

    • Related Articles

    • Invoice Excise Tax Rules

      Invoice Excise Tax Rules Overview Depending on the federal and state rules, a retailer may need to pay an excise tax when buying some products. Generally, retailers may need to pay the applicable excise tax when they buy goods directly from a ...

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

    • Historical Tax Rates Report

      Historical Tax Rate Report Overview The Historical Tax Rate Report will display the records of changes made to various tax rates in the past history in the selected date range. Different types of filters can also be configured, depending on your ...

    • Tax Exempt Report

      Tax Exempt Report Overview The Tax Exempt Report will display a list of all those products on which sales tax was not applicable during a specifically entered date range. Multiple different types of filters can also be configured, depending on your ...

    • Non-Tax Sales Report

      Non-Tax Sales Report Overview Non-taxable sales are transactions where no sales tax is collected. The tax rules vary from state to state, and there is a lot of variability in sales tax as sales tax amounts can be different across a state. FTX POS is ...