Sales Tax by State Report Definitions

Sales Tax by State Report Definitions

Info
Module: Reports
Path: Reports > Sales Reports > Sales Tax by State Report
Topic: Sales Tax by State Report
Version(s):  5.1 and up
Editions: All

What Is Sales Tax by State Report

  1. Sales Reports
    1. Sales Tax By State/Order Report - This drill-down report breaks down sales tax by country, then state, then order. 

Making The Connection

Where Will I See This Within OLX?

You can view sales tax by using the Sales Tax By State Report.

What Imports/Exports Relate to Sales Tax by State Report?

  1. At this time there are no imports/exports related to the report

Setup


Preview



You'll notice control buttons displayed just above the results. Review Report Tools (orderlogix.com) article for more information on how to utilize each control button. :
  1. View Report  - Displays results
    1. Displays the toolbar 
  2. Hide Controls - Hides report filters
    1. Show Controls - Displays report filters
  3. Show Schedules  - Displays schedule editor
    1. Format filter will display at top of screen
    2. Delivery and Encryption tabs will display on bottom left of screen
  4. Show Instances - Displays list of previously ran and pending reports. Click on the status to review the job log.
  5. Close  - Close out of the report popup.

Report Definitions

Using Calendar Icon to Set Date(s) is a good article to review when running reports manually or scheduling for automation.

Filters

Filter
Definition
Fiscal Year
(only shows during manual run when utilizing User Selected Date Type above)
This will set the below Fiscal Week and Date Range to the first available date range within the year selected
Date Type
  1. User Selected
    1. Allows the user to select any calendar day for start and end range.
  2. Last Week (S)
    1. The previous week starting with Sunday will automatically be set in the Date Range
  3. Last Week (M) 
    1. The previous week starting with Monday will automatically be set in the Date Range
  4. This Quarter
    1. Date Range will set to the current quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  5. Last Year
    1. Jan 01 of previous year to Dec 31 of previous year
  6. Last Month
    1. Day one of previous month to the last day of the previous month
  7. This Week (S) - Sunday
    1. Current week from Sunday to the following Saturday
  8. This Week (M) - Monday
    1. Current week from Monday to the following Sunday
  9. This Month
    1. First day of current month to last day of current month
  10. This Week to Date (S) - Sunday
    1. Sunday of current week to current date
  11. This Week to Date (M) - Monday
    1. Monday of current week to current date
  12. This Month to Date
    1. First day of current month to current day
  13. Tomorrow
    1. Current day plus one
  14. Now to End of Week (S) - Sunday
    1. Current day the next Sunday
  15. Now to End of Week (M) - Monday
    1. Current day to the next Monday
  16. Now to End of Month
    1. Current date to last day of the current month
  17. Now to End of Year
    1. Current date to Dec 31 (current year)
  18. Last Quarter
    1. Date Range will set to the previous quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  19. This Quarter To Date
    1. Date Range will set to the current quarter based off the current date up to the current dates data:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  20. Year to Date
    1. Jan 01 (current year) to current date
Fiscal Week
(only shows during manual run when utilizing User Selected Date Type above)
This will set the below Date Range to the Monday - Sunday date range selected from this drop down.
Create date of the payment batch the successful payment transaction was in
Expand
  1. None
    1. will not expand any of the selected groupings and only show the first layer of the Groupings set in Report Layout
  2. One
    1. will expand only the first Grouping to display the first and second layer of the Groupings set in Report Layout
  3. Two
    1. will expand all Groupings to display all layers of the Groupings set in Report Layout
Format
 (only shows when setting up a schedule)
This is the format that the report will export in:
  1. PDF
  2. Excel
  3. CSV
Client of the source of the order
Show Inactive (Client)
Show in the report:
  1. Checked - show active and inactive Clients
  2. Unchecked - only show active Clients
Campaign of the source of the order
Show Inactive (Campaign)
Show in the report:
  1. Checked - show active and inactive Campaigns
  2. Unchecked - only show active Campaigns
Product group of the items
Processing account of the payment batch
The shipping state/province of the order
Show County Info
  1. checked - the shipping county will be visible in the County grouping level
  2. unchecked - will show 'All Counties'.
Show City Info
  1. checked - the shipping city will be visible in the City grouping level,
  2. unchecked - will show 'All Cities'



Grouping/Report Layout

Grouping
Definition
CountryThe shipping country of the order
The shipping state/province of the order
If 'Show County Info' is checked the shipping county of the order, otherwise 'All Counties'.
If 'Show City Info' is checked the shipping city of the order, otherwise 'All Cities'.



 Column Definitions

Column
Definition
Order IDThe Order ID of the order. Debit and credit items will be separated out, credits will show up under the Order ID (CR)         
Client
Client of the source of the order
Campaign
Campaign of the source o the order
Item Price
Quantity * Unit Price (negative amount for credit items)
Shipping
Shipping (negative amount for credit items)
Tax
Tax (negative amount for credit items)
Federal Tax
Federal tax (negative amount for credit items)
Grand Totals
Sum of column(s)




Copyright 2019
Revised 1.27.2026

    • Related Articles

    • Sales Tax Report Definitions

      Module: Reports Path: Reports > Sales Reports > Sales Tax Report Topic: Sales Tax Report Version(s): 5.1 and up Editions: All What Is Sales Tax Report Sales Reports Sales Tax Report - View process transactions and sales tax information. Making The ...

    • Gross Sales Report Definitions

      Module: Reports Path: Reports > Sales Reports > Gross Sales Report Topic: Gross Sales Report Version(s): 5.1 and up Editions: All What Is Gross Sales Report Sales Reports Gross Sales Report - Sales By Client/Product Group/Product Code. Making The ...

    • Campaign Statistics By Hour Report Definitions

      This report shows hourly reporting metrics with one page for each source, dnis and date. Campaign Statistics By Hour Report Column Definitions ORDER_COUNT The number of OLX calls that had orders attached to them INQUIRY_COUNT The number of OLX calls ...

    • Datawarehouse Export Definitions

      Module: Reports Path: Reports > Processing Reports > Data Warehouse Export Topic: Data Warehouse Export Version(s): 5.1 and up Editions: All What Is The Data Warehouse Export? The Data warehouse Export and the Flattened Export are both very valuable ...

    • Net Sales Report Definitions

      Module: Reports Path: Reports > Sales Reports > Net Sales Report Topic: Net Sales Report Version(s): 5.1 and up Editions: All What Is Net Sales Report Sales Reports Net Sales - Breaks down credits, declines, rejects and holds. Making The Connection ...