You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

Import Sub-Levels for Customers, Vendors, Classes, Items, or Accounts into QBO

QUESTION

If importing Sub-Levels for Customers, Vendors, Classes, Products and Services, or Accounts into QuickBooks Online (QBO) using Transaction Pro Importer, how do they need to be formatted?

RESOLUTION

Format for Customers

If the Customer import file contains Sub-Customers, both the main Customer and the Sub-Customer must be included in the same field, separated by a colon with no space before or after the colon, and mapped to the CUSTOMER field.

Example:

Import File formatted like this:                       will appear in QB as:

                 

Any time a Customer is used when importing transaction such as Invoices, Sales Receipts, or Journal Entries, the entire Customer Name has to be included in the import file for Sub-Customers.

Format for Vendors

The instructions are the same for Vendor with Sub-Vendors as Customers above.

Format for Classes

The instructions are the same for Classes with Sub-Classes as Customers above.

Format for Products and Services

The instructions are the same for Products and Services with Sub-Items as Customer above.

Format for Account Numbers

If the Account import file contains Sub-Accounts, both the main Account and the Sub-Account must be included in the same field, separated by a column with no space before or after the colon, and mapped to the ACCOUNT field. 

Import File formatted like this:                       will appear in QB as:

                          

Any time Account is used when importing transaction such as Bills, Checks, or Journal Entries, either the Sub-Account Number or the entire Account Name is to be used but never both.

  • 344
  • 23-Jun-2020
  • 5950 Views