NAME

(Required) The name of the invoice item.

TIMESTAMP

(Export files only) A unique number that identifies the company file from which you exported the Item list.

REFNUM

(Export files only) A unique number that identifies an entry in the list.

INVITEMTYPE

(Required) Indicates the type of invoice item. import files^IIF, . If you are creating an import file, use one of these keywords to indicate the item type.

COMPTAX

Sales tax item

DISC

Discount item

GRP

Group item (groups several invoice items into a single item)

INVENTORY

Inventory part item

OTHC

Other charge item

PART

Non-inventory part item

PMT

Payment item

SERV

Service item

STAX

Sales tax group item

SUBT

Subtotal item

DESC

A description of the item as you want it to appear in the Description column on invoices, credit memos, and sales receipts.

PURCHASEDESC

(Inventory part items only) A description of the item as you want it to appear on purchase orders.

ACCNT

(Required) The name of the income account you use to track sales of the item. import files^IIF, . The type of this account should be INC.

ASSETACCNT

(Inventory part items only) The name of the asset account you use to track the value of your inventory. import files^IIF, . The type of this account should be OASSET.

COGSACCNT

(Inventory part items only) The name of the account you use to track the cost of your sales. import files^IIF, . The type of this account should be COGS.

PRICE

(All item types except group, payment, and subtotal) The rate or price you charge for the item. import files^IIF, . If you are creating an import file, add a percent sign (%) if the amount is a percentage.

COST

(Inventory part items only) The unit cost of the item.

TAXABLE

(Discount, other charges, part, and service items only) Indicates whether the item is taxable. import files^IIF, . If you are creating an import file, enter one of these keywords in the TAXABLE field:

Y

Yes. import files^IIF, . The item is taxable.

N

No. import files^IIF, . The item is not taxable.

PAYMETH

(Payment items only) The payment method customers use (check, Visa, etc.).

TAXVEND

(Sales tax items only) The name of the agency to which you pay sales tax.

TAXDIST

(Sales tax items only) The name of your tax district.

TOPRINT

(Group items only) Indicates whether QuickBooks includes a list of the items in the group when you print an invoice, credit memo, or sales receipt. import files^IIF, . If you are creating an import file, enter one of these keywords in the TOPRINT field:

Y

Yes. import files^IIF, . QuickBooks lists each item.

N

No. import files^IIF, . QuickBooks adds a one line summary instead of listing the individual items.

PREFVEND

(Inventory part items only) The name of the vendor from whom you normally purchase the item.

REORDERPOINT

(Inventory part items only) The minimum quantity you want to keep in stock at any given time. import files^IIF, . When your inventory reaches this level, QuickBooks informs you that it is time to reorder the item.

EXTRA

Adds additional information about the invoice item. import files^IIF, . These keywords can appear in the EXTRA field:

AUTOSTAX

Identifies a sales tax item as the automatic tax rate you set up for your QuickBooks company.

REXPGROUP

Indicates that the item is a group of reimbursable expenses that you included on the invoice.

REXPSUBTOT

Indicates that the item is the subtotal amount for a group of reimbursable expenses you included on the invoice.

CUSTFLD1
CUSTFLD2
.
.

CUSTFLD5

The custom field entries for the item (you can have up to 5 custom field entries). import files^IIF, . Custom fields let you track special information about the item, such as color, unit or measure, or size. import files^IIF, . What you use custom fields for is entirely up to you.

DEP_TYPE

(Payment items only) Indicates how you want QuickBooks to handle deposits of the payment item.

1

You want QuickBooks to deposit the payment in the bank account of your choice when you record the payment. import files^IIF, . The payment does not go into the Undeposited Funds account, and you do not have to use the Make Deposits window to deposit the payment.

0

You want QuickBooks to "hold" all the payments in a special account named Undeposited Funds. import files^IIF, . To move the payments to a bank account, you must use the Make Deposits window to group the payments into one deposit.

ISPASSEDTHRU

(Service, non-inventory part, and other charge items) Indicates whether you pass the item through as an expense to the customer.

Y

Yes. import files^IIF, . You pass the item through as an expense.

N

No. import files^IIF, . You do not pass the item through as an expense.