Sales Tax Report Definitions

Sales Tax Report Definitions

You can view order information by state using the Sales Tax Report. You can filter by Date, Client, Campaign, and State. Select "Show Inactive" boxes to view inactive information in filters. This is a report that you can create an   automated schedule   for, in order to delivery the data via email or to an FTP site.

The report displays: Order ID, Transaction Date, Transaction Type, Amount Collected, Total, Unit Price, Shipping, Tax, Bill to State, Bill to County, Bill to City, Bill to Zip code, Shipping State, Shipping County, Shipping City, Shipping Zip code, and Client.

This is a report that gives you the ability to hyperlink to the order detail screen, in order to access further detailed information. Click on the link that is the order id and it will pull up another window.

Select control options from the   report tool bar .

Sales Tax Report Column Definitions
Order ID
Order ID
Transaction Date
Payment batch create date
Transaction Type
DEBIT or CREDIT
Amt Collected
Quantity * Unit Price + Shipping + Tax of the items
Total
Quantity * Unit Price + Shipping + Tax of the items
Unit Price
Quantity * Unit Price of the items
Shipping
Shipping of the items
Tax
Tax of the items
Bill State
The state of the master customer record
Bill County
The county of the master customer record
Bill City
The city of the master customer record
Bill Zip
The postal code of the master customer record
Ship State
The shipping state of the order
Ship County
The shipping county of the order
Ship City
The shipping city of the order
Ship Zip
The shipping postal code of the order
Client
Client of the source of the order
 
FILTERS
Date Range
Create date of the payment batch the successful payment transaction was in         
Client
Client of the source of the order
Campaign
Campaign of the source of the order
State
The shipping state of the order
 
GROUPING                            
Bill State
The state of the master customer record
Campaign
Campaign of the source of the order
Client
Client of the source of the order
Date
The create date of the payment batch
Ship State
The shipping state of the order
Order ID
Order ID of the order



    • Related Articles

    • Sales Tax by State Report Definitions

      You can view sales tax by using the Sales Tax By State Report. You can filter by Date, State, Client, Campaign, or Product Group. The report is grouped by Country and State/Province, and displays Order ID, Client Campaign, Item Price, Shipping, ...
    • Gross Sales Report Definitions

      This report is for orders placed in the date range. It shows information for debit items regardless of their processed status. Gross Sales Report Column Definitions # Ords / Ord ID Number of orders for the specific grouping level, order id on the ...
    • Sales Agent Commission Summary Report Definitions

      This report is run by commission batches that are created and breaks out the commission batch by team and employee. Sales Agent Commission Summary Report Column Definitions Team Team Name Emp. # Employee Number Employee Employee Name (Last, First) # ...
    • Returns Report Definitions

      Module: Reports Path: Reports > Processing Reports > Returns Report Topic: Returns Report Version(s): 5.1 and up Editions: All What Is Returns Report Returns Report displays the returns for auto-generated (continuity/subscription) and ...
    • Return Analysis Report Definitions

      This report shows the past 7 months from the run date and the items that were processed in those months. It also shows successfully processed credit items attached to the debit items processed and when those credit items were processed in relation to ...