Sales Tax Item Dimension

Modified on Tue, 28 Jul at 12:01 AM

Sales Tax Item Summary

The QQube Sales Tax Item Dimension combines individual QuickBooks sales tax items and sales tax groups into one dimension for analyzing the tax item applied to transaction activity.

Dimension Type

QuickBooks list dimension

Sales Tax Item Represents

An individual sales tax item or sales tax group

QuickBooks Source

Sales Tax Items and Sales Tax Groups from the Item List

Primary Use

Group or filter transaction activity by the applied sales tax item or group

Included Data Models

Customers: Sales, Open Sales Orders

Operations: Purchases, Open Purchase Orders

Auditing: Audit Trail

QuickBooks Source

The fields are derived from the Sales Tax Items and Sales Tax Groups maintained in the QuickBooks Item List. QQube combines both record types into one dimension.

Source Example

QuickBooks sales tax item and sales tax group source for the Sales Tax Item Dimension

Sales Tax Item Types

The Sales Tax Item Type field identifies whether a record is an individual SalesTax Item or a SalesTax Group. The Sales Tax Item Tax Return Line field is available only in Canadian versions of QuickBooks.

Available Fields

Display Order	Field Name
1	Sales Tax Item Active
2	Sales Tax Item Description
3	Sales Tax Item Name
4	Sales Tax Item Rate
5	Sales Tax Item Tax Return Line (CAN)
6	Sales Tax Item Type
7	Sales Tax Item Vendor Address1
8	Sales Tax Item Vendor Address2
9	Sales Tax Item Vendor Address3
10	Sales Tax Item Vendor Address4
11	Sales Tax Item Vendor Address5
12	Sales Tax Item Vendor Company Name
13	Sales Tax Item Vendor Contact
14	Sales Tax Item Vendor Name
15	Sales Tax Item Vendor Name On Check
16	Sales Tax Item Vendor Tax ID