Cross-Reference Option for Accounts
**QUESTION** How does the cross-reference option work for Accounts when importing into QuickBooks Desktop (QBDT) with Transaction Pro (TPro) Importer? **RESOLUTION** In QBDT, Accounts are organized by Name. However, other databases or services that may be imported may use a the Account Description instead of a Name…
Import Accounts Instead of Items on Sales Transactions into QuickBooks Online
**QUESTION** How can a sales transaction such as Estimate, Invoice, or Sales Receipt post to a General Ledger (GL) Account instead of an Item when importing into QuickBooks Online with Transaction Pro Importer? **RESOLUTION** In QuickBooks Online, Intuit does not allow a GL Account to be used on sales transactions.…
Import Accounts Instead of Items on Sales Transactions
**QUESTION** How can a sales transaction such as Estimate, Invoice, or Sales Receipt post to a General Ledger (GL) Account instead of an Item when importing into QuickBooks Desktop (QBDT) with Transaction Pro Importer? **RESOLUTION** In QBDT, Intuit does not allow a GL Account to be used on sales transactions. Inst…
Do Not Add Options in Transaction Pro Importer for QuickBooks Desktop
**QUESTION** Is there a way to stop Transaction Pro Importer from setting up new Customers in QuickBooks Desktop (QBDT) during import? **RESOLUTION** Yes, there are options in Transaction Pro Importer to prevent new list items (Accounts, Customers, Employees, Items, and Vendors) during import. These options can be …
Account Import Fields for Transaction Pro Online
![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Account as a sub-account of another account, use format Account:Sub- Account Description Description N Alpha-numeric 100 AccountNumber Number N Alpha-numeric 2…
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 using Transaction Pro Importer? **RESOLUTION** Yes, Importer has the Options available to tell QuickBooks Online to not auto- create list items during an import. The list items include: …
General Ledger Account Formatting
**QUESTION** How do General Ledger Accounts need to be formatted in the import file when using Transaction Pro Importer with QuickBooks Online? **RESOLUTION** If Accounts are used in the import file, only the Account Name or the Account Number should be used, never both. If using Account Numbers, only the lowest S…
Import Accounts to QuickBooks Online with Transaction Pro Importer
**QUESTION** How is a Chart of Accounts (COA) imported into QuickBooks Online using Transaction Pro Importer? **RESOLUTION** When importing the COA into QuickBooks Online using Importer, the import file must contain at a minimum the Account Name, the Account Type, and the Account Sub Type. Please access [THIS ][1]…
Account Does Not Exist error during Import in Transaction Pro Importer
**MESSAGE** When importing transactions into QuickBooks Desktop (QBDT) with Transaction Pro Importer and using the Account Name, it says the Account does not exist even though it does. **RESOLUTION** There are two options to resolve this issue: 1. Check your preferences in QuickBooks Desktop to make sure that Acco…
Import Sub-Levels for Customers, Vendors, Classes, Items, or Accounts into QuickBooks Desktop
**QUESTION** If importing Sub-Levels for Customers, Vendors, Classes, Items, or Accounts into QuickBooks Desktop (QBDT) using Transaction Pro Importer, how do they need to be formatted? **RESOLUTION** **Format for Customers** If the Customer import file contains Sub-Customers or Jobs, both the main Customer and th…
