Field Definitions: GUI Tax Report (02-43-03)

Overview

Below are descriptions of each field on the GUI Sales Tax Report screen.

Table of Contents

By Branch Tab

Click image to enlarge.

Column
Description

By Branch
This column displays the store branch.

Tax Code
This column displays the tax code used to calculate sales tax for a transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Departments or product types with a tax exception in Department GM-Taxable (02-18-02 will appear below the tax code.

Level
This column breaks down each tax code by level number. If a tax code has more than one level set up, each level will display on its own line.

Tax %
This is the tax percentage that is charged for the level. This column shows the current settings from Sales Tax Tables Entry (30-02-04).

Total Sales Excl Tax
This is the total written or delivered sales dollars for the store, excluding tax, per tax code.

Non-Tax Dollars by Level
This is the branch’s total written or delivered sales dollars, per level, that were non-taxable.

Trade Portion Non-Tax$
This is the total sales dollars for non-taxable trade in transactions, per tax code. An amount displays in this column (for trade in items) if:

  • The ’48. Allow Trade In’ and ’80. Display TradeIn as Payment Type’ fields are set to ‘Yes’ in Transaction Processing Preferences (02-18-01).
  • The ‘TradeIn Taxable’ field is set to ‘N’ for your levels in Sales Tax Table Entry (30-02-04).

Trade Portion Taxable$
This is the total sales dollars for taxable trade in transactions, per tax code. An amount displays in this column (for trade in items) if:

  • The ’48. Allow Trade In’ and ’80. Display TradeIn as Payment Type’ fields are set to ‘Yes’ in Transaction Processing Preferences (02-18-01).
  • The ‘TradeIn Taxable’ field is set to “Y” for your levels in Sales Tax Table Entry (30-02-04).

RS Taxable $
This is the total sales dollars for taxable return to supplier (RS) transactions, per tax code.

Dollars Taxed by Level
This column displays the total amount of all transactions that will be taxed, per level.

Tax Collected by TaxCode
This is the total tax collected at the time the transaction was processed.

Tax Due For All Lines
This is the total tax due.

By Tax Code Tab

Click image to enlarge.

Column
Description

Tax Code
This column displays the tax codes used to calculate sales tax for a transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Departments or product types with a tax exception in Department GM-Taxable (02-18-02 will appear below the tax code.

Level
This column breaks down each tax code by level number. If a tax code has more than one level set up, each level will display on its own line.

Branch
This column displays the store branch.

Tot Sales Excl Tax
This is the total written or delivered sales dollars, excluding tax, per tax code.

Non-Tax Dollars by Level
This is the total written or delivered sales dollars, per level, that were non-taxable.

Trade Portion Non-Tax$
This is the total sales dollars for non-taxable trade in transactions, per tax code. An amount displays in this column (for trade in items) if:

  • The ’48. Allow Trade In’ and ’80. Display TradeIn as Payment Type’ fields are set to ‘Yes’ in Transaction Processing Preferences (02-18-01).
  • The ‘TradeIn Taxable’ field is set to “N” for your levels in Sales Tax Table Entry (30-02-04).

Trade Portion Taxable$
This amount is the total sales dollars for taxable trade in transactions, per tax code. An amount displays in this column (for trade in items) if:

  • The ’48. Allow Trade In’ and ’80. Display TradeIn as Payment Type’ fields are set to ‘Yes’ in Transaction Processing Preferences (02-18-01).
  • The ‘TradeIn Taxable’ field is set to “Y” for your levels in Sales Tax Table Entry (30-02-04).

RS Taxable $
This is the total sales dollars for taxable return to supplier (RS) transactions, per tax code.

Dollars Taxed by Level
This column displays the total amount for all transactions that will be taxed, per level.

Tax Collected by TaxCode
This is the total tax collected at the time the transaction was processed.

Tax Due For All Lines
This is the total tax due.

By State

Click image to enlarge.

Column
Description

State
This column displays state in which the tax was charged.

City
This is the city in which the tax was charged.

Level
This column displays the tax code used to calculate sales tax for the transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Departments or product types with a tax exception in Department GM-Taxable (02-18-02 will appear below the tax code.

Tax%
This is the tax percentage that is charged for the level. This column shows the current settings from Sales Tax Tables Entry (30-02-04).

Tot Sales Excl Tax
This is the total written or delivered sales dollars, excluding tax, for each tax code.

Non-Tax Dollars by Level
This is the total written or delivered sales dollars, per level, that were non-taxable.

Trade Portion Non-Tax$
This amount is the total sales dollars for taxable trade in transactions, per tax code. An amount displays in this column (for trade in items) if:

  • The ’48. Allow Trade In’ and ’80. Display TradeIn as Payment Type’ fields are set to ‘Yes’ in Transaction Processing Preferences (02-18-01).
  • The ‘TradeIn Taxable’ field is set to “Y” for your levels in Sales Tax Table Entry (30-02-04).
NOTE: This column does not appear on the printed or PDF version of the report.

Trade Portion Tax$
This amount is the total sales dollars for taxable trade in transactions, per tax code. An amount displays in this column (for trade in items) if:

  • The ’48. Allow Trade In’ and ’80. Display TradeIn as Payment Type’ fields are set to ‘Yes’ in Transaction Processing Preferences (02-18-01).
  • The ‘TradeIn Taxable’ field is set to “Y” for your levels in Sales Tax Table Entry (30-02-04).

RS Taxable$
This is the total sales dollars for taxable return to supplier (RS) transactions, per tax code.

Dollars Taxed By Level
This column displays the total amount for all transactions that will be taxed, per level.

Tax Collected by Tax Code
This is the total tax collected at the time the transaction was processed

Tax Due for All Lines
This is the total tax due.

Non-Taxable Tab – Detail View

Click image to enlarge.

Column
Description

Sold At Branch
This column displays the store branch.

Tax Code
This column displays the tax codes used to calculate sales tax in a transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Dept
When a transaction occurs where an item’s product type and department have a non-taxable tax exception set up, this column displays the department code used.

Tax exceptions are set up for specific product types and departments in Department GM-Taxable (02-18-02).

Prod Type
When a transaction occurs where an item’s product type and department have a non-taxable tax exception set up, this column displays the product type code used.

Tax exceptions are set up for specific product types and departments in Department GM-Taxable (02-18-02).

Trans Date
This is the date on which the transaction took place.

Trans Number
This is the transaction number assigned to the transaction that is being referenced.

Trans Type
This column displays the transaction type for the transaction that is being referenced.

Trans Taxable
This column displays if the referenced transaction was marked as Taxable (Y) or Non-Taxable (N). In some cases, only specific items might be set up as non-taxable, but the transaction itself is taxable.

Non-Tax Trans
This amount is the portion of the transaction that was non-taxable. A transaction could be non-taxable because you are using a non-taxable branch, or if you selected non-taxable checkbox while entering the transaction.

Non-Tax Dept/PType
When a transaction occurs where an item’s product type and department have a non-taxable tax exception set up, this column displays the amount that was non-taxable.

Level
This is the level on which the over limit maximum was set up. The tax limit is set up, by level, in the Sales Tax Table Entry (30-02-04) selection. You can also set it up for specific product types and departments in Department GM-Taxable (02-18-02).

Over Limit
This column displays the amount a transaction was over its maximum tax limit, per tax code.

Non-Tax Total
This column calculates and totals all transactions for a branch and tax code (light blue), as well as providing a grand total of tax codes within a branch (dark blue).

Non-Taxable Tab – Summary View

Click image to enlarge.

Column
Description

Tax Code
This column displays the tax code used to calculate sales tax for a transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Sold At Branch
This column is displays the store branch.

Dept
When a transaction occurs where an item’s product type and department have a non-taxable tax exception set up, this column displays the department code used.

Tax exceptions are set up for specific product types and departments in Department GM-Taxable (02-18-02).

Prod Type
When a transaction occurs where an item’s product type and department have a non-taxable tax exception set up, this column displays the product type code used.

Tax exceptions are set up for specific product types and departments in Department GM-Taxable (02-18-02).

Trans Date
This is the date on which the transaction took place.

Trans Number
This is the transaction number assigned to the transaction that is being referenced.

Trans Type
This column displays the transaction type for the transaction that is being referenced.

Trans Taxable
This column displays if the referenced transaction was marked as Taxable (Y) or Non-Taxable (N). In some cases, only specific items might be set up as non-taxable but the transaction itself is taxable.

Non-Tax Trans
This amount is the portion of the transaction that was non-taxable. A transaction could be non-taxable because you are using a non-taxable branch, or if you selected non-taxable checkbox while entering the transaction.

Non-Tax Dept/PType
When a transaction occurs where an item’s product type and department have a non-taxable tax exception set up, this column displays the amount that was non-taxable.

Level
This is the level on which the over limit maximum was set up. The tax limit is set up, by level, in the Sales Tax Table Entry (30-02-04) selection. You can also set it up for specific product types and departments in Department GM-Taxable (02-18-02).

Over Limit
This column displays the amount a transaction was over its maximum tax limit, per tax code.

Non-Tax Total
This column calculates and totals all transactions for a branch and tax code (light blue), as well as providing a grand total of tax codes within a branch (dark blue).

Detail Tab

Click image to enlarge.

Column
Description

Tax Code
This column displays the tax code used to calculate sales tax for a transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Branch
This column displays the branch at which the tax was charged.

Date
This is the date each transaction occurred.

Ticket #
This is the ticket number assigned to the transaction. Double-click the ticket number to open the full transaction details.

Total Sale
This column displays the entire sales total of the transaction.

Non-Taxable
This is the portion of the transaction that was non-taxable.

Taxable
This is the portion of the transaction that was taxable.

Collected
This is the total tax collected at the time of the transaction.

Level 1
This column displays the percentage of tax per dollar for Level 1, as it was set up for the tax code in Sales Tax Tables Entry (30-02-04).

Level 2
This column displays the percentage of tax per dollar for Level 2, as it was set up for the tax code in Sales Tax Tables Entry (30-02-04).

Level 3
This column displays the percentage of tax per dollar for Level 3, as it was set up for the tax code in Sales Tax Tables Entry (30-02-04).

CPU
Two asterisks (**) display in this column for transactions designated as Customer Pickup. This includes all Take With transactions and any other ticket on which the ‘Customer Pickup’ box was checked in POS Entry (02-02) or Order Maintenance (02-08-02).

NOTE: This column does not appear in when printed.

Address
This is the bill to address for the transaction.

NOTE: This column does not appear in when printed.

City
This is the bill to city for the transaction.

NOTE: This column does not appear in when printed.

State
This is the bill to state for the transaction.

NOTE: This column does not appear in when printed.

Zip
This is the bill to zip code for the transaction.

NOTE: This column does not appear in when printed.

Rental/Brch Tab

Click image to enlarge.

Column
Description

Branch
This column displays the store branch.

Tax Code
This column displays the tax code used to calculate sales tax for a transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Level
This column breaks down each tax code by level number. If a tax code has more than one level set up, each level will display on its own line.

Tax %
This is the tax percentage set up for each level. This will display what is set up for the level in Sales Tax Tables Entry (30-02-04).

Rental Inc
This is the total income earned from rental fees.

Sales Inc
This is the total income earned from sales transactions.

Insurance Inc
This is the total income earned from insurance charges.

Late Charges
This is the total income earned from late charges.

Misc Inc
This is the total income earned from miscellaneous charges.

Interest Inc
This is the total income earned from interest charges.

Total Tran Amt
This column displays the total amount for all income earned that will be taxed, per level.

Tax Collected
This amount is the total tax collected at the time the transaction was processed.

Tax Due
This amount is the total tax due.

Rental/TaxCd Tab

Click image to enlarge.

Column
Description

Tax Code
This column displays the tax code used to calculate sales tax for a transaction. Tax codes are created in Sales Tax Tables Entry (30-02-04) and assigned to branches in Branch Maintenance (30-02-02).

Level
This column breaks down each tax code by level number. If a tax code has more than one level set up, each level will display on its own line.

Branch
This column displays the store branch.

Rental Inc
This is the total income earned from rental fees.

Sales Inc
This is the total income earned from sales transactions.

Insurance Inc
This is the total income earned from insurance charges.

Late Charges
This is the total income earned from late charges.

Misc Inc
This is the total income earned from miscellaneous charges.

Interest Inc
This is the total income earned from interest charges.

Total Tran Amt
This column displays the total amount for all income earned that will be taxed, per level.

Tax Collected
This amount is the total tax collected at the time the transaction was processed.

Tax Due
This amount is the total tax due.