Which products and services fields are imported?

What this product or service is called.

Mandatory.

• Must have at least one character
• Cannot exceed 100 characters
• Cannot include a tab, newline, colon (:) or quotation mark (")
• Must be unique

A Stock Keeping Unit (often referred to as “item number”) is a unique number, letter, or combination of numbers and letters that you assign to a product. It identifies the product’s specific attributes, such as type, color, size, or material. SKUs may contain from 1 to 100 alphanumeric characters.

Optional.

Cannot exceed 100 characters

Distinguishes inventory items from other products and services.

Optional.

Choices are Service or Non-inventory if the Track checkbox isn't selected.

There is an additional choice of Inventory if the Track checkbox is selected.

Appears in the Description column on printed sales forms.

Optional.

Limit of 4000 characters

The selling price of one unit, in your home currency (USD).

Optional.

• Must be numeric
• Maximum 18 digits, with up to 11 before decimal point and 7 after decimal point (for example, 99,999,999,999.9999999)
• Can contain a comma or period
• Can be negative
• Can be blank
• Cannot contain special characters

The Income account you use to track money coming in for this product or service (for example, "Sales of product", "Services").

Optional.

Account name must match an existing account in QuickBooks.

If blank, QuickBooks will assign a default account. If necessary, edit this field after importing your Products and Services list.

If this is an inventory item, you must use an Income account with the detail type Sales of Product Income.

Appears in the Description column on purchase transactions and on printed checks.

Optional.

Limit of 1000 characters.

• Must be numeric
• Maximum 18 digits, with up to 11 before decimal point and 7 after decimal point
• Can contain a comma or period
• Can be negative
• Can be blank
• Cannot contain special characters

The account you use to track money you spend for this product or service (for example, "Cost of goods sold", "Purchases").

Optional.

If blank, QuickBooks will assign a default account. If necessary, edit this field after importing your Product and Services list. If this is an inventory item, you must use a Cost of Goods Sold account.

Applicable if you track product amounts and have turned on Track quantity on hand in Company Settings (or Account and Settings depending on what you see).

Optional.

Tracks money for this product/service.

Optional.

The date that inventory was taken.

Optional.

Must be in a date format that matches company default date format (for example, 01/01/2012).