Error message when you import items into Small Business Accounting: "InventoryItemAccount: 'ItemName': Cannot Import. COGS account is required" (916270)

The information in this article applies to:

Microsoft Office Small Business Accounting 2006
Microsoft Office Small Business Management Edition 2006

SYMPTOMS

When you import items into Microsoft Office Small Business Accounting, you may receive the following error message:

InventoryItemAccount: "ItemName": Cannot Import. COGS account is required.

CAUSE

This problem occurs when any one of the following conditions is true:

The Account field in the header row contains a number.
The account name in the Account field differs from the account name in the Chart of Accounts.

RESOLUTION

To resolve this problem, change the account name in the file that you want to import so that the account name matches the account name in the Chart of Accounts. Also, row 1 must be a header row that contains fields that describe the data in the columns. The required fields in the header row include the following fields:

COGS Account
Income Account
Asset Account
Item Name

MORE INFORMATION

You can use a standard template to import a Microsoft Office Excel worksheet. The standard template is named ImportData.xls. By default, the standard template is installed in the following location:

C:\Program Files\Microsoft Small Business\Small Business Accounting\Templates\Excel

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

906096 How to import master records into Microsoft Office Small Business Accounting

Modification Type:	Major	Last Reviewed:	4/10/2006
Keywords:	kbtshoot kbMBSMigrate kbprb KB916270 kbAudEndUser kbAudKnowledgeWorker