The following table outlines which QuickBooks data items are converted to Sage 50 and which are not.
|
In QuickBooks |
In Sage 50 |
Comments |
|
|---|---|---|---|
|
Item Name\Number |
Item ID |
When converted to Sage 50, a number will be appended to the item name to ensure unique IDs. |
|
|
Item Description |
Description |
Sage 50 will convert the first 30 characters of the item description listed in QuickBooks. |
|
|
Item Full name |
N/A |
Sage 50 cannot convert parent names, those items that are components of another item. In QuickBooks, parent items can contain inventory and non-inventory item components, which is not possible in Sage 50. In Sage 50 you can create assemblies that contain only inventory components. |
|
|
Type |
Item Class |
In QuickBooks |
In Sage 50 |
|
Service |
Non-Stock item |
||
|
Inventory Part |
Stock item |
||
|
Inventory Assembly |
Assembly Note: QuickBooks permits zero-sum assemblies—assemblies without components—while Sage 50 does not. So zero-sum assemblies must be converted to stock items in Sage 50. |
||
|
Non-Inventory Part |
Non-Stock item |
||
|
Other Charge |
Non-Stock item |
||
|
Subtotal Group Discount Payment |
Not converted N/A N/A For more information, see QuickBooks Items List. |
||
|
Tax Item |
Sales Tax Agency and Sales Tax ID. For more information, see Customers. |
||
|
Tax Group |
Sales Tax ID For more information, see Customers |
||
|
Taxable |
Item Tax Type |
Sage 50 allows you to set up 10 item tax types in Inventory Defaults . If the item is taxable in QuickBooks, it is converted to Item Tax Type 1 (Regular - Taxable). If the item not taxable in QuickBooks, it is converted to Item Tax Type 2 (Exempt - Exempt). |
|
|
Inactive |
Inactive |
||
|
Description on Sales Transactions |
Description for Sales |
||
|
Description on Purchase Transactions |
Description for Purchases |
||
|
Rate Sales Price Price Amount or % Currency |
Sales Prices Level 1 |
Each of these QuickBooks fields is converted to Sage 50's Sales Price Level 1. Sage 50 offers five or ten sales pricing levels, depending on which version of Sage 50 you are using. QuickBooks uses a different field based on the items type. Note: QuickBooks "Other Charge" items can use percentages in the Amount field. Sage 50 will convert these as amounts. |
|
|
Income Account |
GL Sales Account |
QuickBooks allows for subaccounts. If a parent account and subaccount are selected (PARENT:SUBACCOUNT), the subaccount is used as Sage 50's G/L sales account. |
|
|
Inventory Asset Account |
GL Inventory Account |
QuickBooks allows for subaccounts. If a parent account and subaccount are selected (PARENT:SUBACCOUNT), the subaccount is used as Sage 50's G/L inventory account. |
|
|
COGS Account |
GL Cost of Sales |
QuickBooks allows for subaccounts. If a parent account and subaccount are selected (PARENT:SUBACCOUNT), the subaccount is used as Sage 50's G/L cost of sales account. |
|
|
Qty on Hand |
Quantity on Hand |
The current total number of inventory item's on hand in QuickBooks is converted to Sage 50 as the items beginning balance. |
|
|
Reorder Point |
Minimum Stock |
||
|
Reorder Quantity |
QuickBooks does not provide this information. It will have to be updated in Sage 50. |
||
|
Preferred Vendor |
Preferred Vendor |
The vendor must already be converted in Sage 50; Sage 50 will convert the first 21 characters of a vendor's name and append a number to the ID to distinguish between duplicate names. |
|
|
Custom Fields 1-5 |
Custom Fields 1-5 |
Custom fields will be converted only for enabled fields. Only the first 16 characters will be converted. |
|
|
N/A |
Note |
QuickBooks does not provide this information. You can optionally enter a 250-character note in Sage 50 for each inventory item. |
|
|
N/A |
Stocking U/M |
Sage 50 will assign "Each" to every item. |
|
|
N/A |
Cost Method |
Sage 50 will assign the costing method (FIFO, LIFO, or Average Cost) selected during the conversion process. |
|
|
Cost |
QuickBooks does not provide this information. It will have to be updated in Sage 50. This field is used for initial cost of an item. After purchasing or selling an item for the first time, it is used for information purposes only. It does not reflect the current estimated cost based on the costing method selected. For more information see Cost. |
||
| Ship Via | Ship Via | not converted | |
|
Bill of Materials |
Bill of Materials |
In QuickBooks |
In Sage 50 The conversion of QuickBooks inventory assembly items also creates the following Bill of Materials fields in Sage 50. |
|
Item |
Item ID. Sage 50 will convert the first 20 characters. |
||
|
Description |
Description |
||
|
Quantity |
Quantity Needed. QuickBooks allows a maximum of 5 digits to the right of the decimal; Sage 50 will convert up to 5 places to the right of the decimal. |
||