Sales Tax Fields (QuickBooks Conversion)

How Do I...

The following table outlines which QuickBooks data items are converted to Sage 50 and which are not.

In QuickBooks

In Sage 50

Comments

Tax Item

Sales Tax Agency

Tax Name

ID

Sage 50 will convert the first 8 characters of a tax item name and append a number to it to ensure unique IDs.

Description

Description

Sage 50 will only convert the first 30 characters of a tax description.

Rate

Tax Rate

Tax Agency

Tax Payable To

Tax agencies are set up as vendors in Sage 50. The vendor must already be converted to Sage 50; Sage 50 will convert the first 20 characters of a vendor's name and append a number to the ID.

Sales Tax Payable G/L account

Sage 50 will use the Sales Tax Payable Account set up in the QuickBooks chart of accounts for this field. Sales tax payable accounts are automatically set up in QuickBooks when you first set up sales taxes or enter the first sales transaction.

Tax Group

Sales Tax ID

Group Name/Number

Sales Tax Number

Sage 50 will convert the first 8 characters of a tax group name and append a number to it to ensure unique IDs.

Description

Description

Sage 50 will only convert the first 31 characters of a tax group description.

Components of Tax Groups

Components of Sales Tax ID

Tax Item

ID

Sage 50 will convert the first six or seven characters of a tax item name and append a number to it to ensure unique IDs.

Rate

Rate

Description

Description

Sage 50 will only convert the first 31 characters of a tax description.

G/L Account-Description

Sage 50 will use the Sales Tax Payable Account set up in the QuickBooks chart of accounts for this field. Sales tax payable accounts are automatically set up in QuickBooks when you first set up sales taxes or enter the first sales transaction.