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

Do Not Auto-Create List Items when Importing

QUESTION

Is there an Option to control as to whether or not list items are auto-created when importing into QuickBooks Online (QBO) using Transaction Pro Importer?

RESOLUTION

Yes, Importer has the Options available to tell QBO to not auto-create list items during an import. The list items include: Accounts, Items (Products and Services), Customers, Vendors, Locations, Classes, Sales Terms, and Payment Methods.

Below is a example of how this option works with Checks, but this is also available on all other transactions for imports into QBO.  The example Check import allows the creation of new Vendors during import; but at the same time, it does not allow the creation of new Accounts or Classes.

When performing an import, on the PREVIEW AND IMPORT window of Importer, select OPTIONS in the upper-right hand corner to access all the Importer Options.

For this example Check import, select the Options DO NOT AUTOMATICALLY ADD ACCOUNTS and DO NOT AUTOMATICALLY ADD CLASSES. Scroll to the bottom of the Options list and click SAVE CHANGES.

Return to the TRANSACTIONS TO IMPORT and select IMPORT in the bottom-right right corner of the screen. After importing, Importer shows an error for the ExpenseAccount and the ExpenseClass fields.

  • 273
  • 13-Jul-2019
  • 1874 Views