QUESTION

How do General Ledger Accounts need to be formatted in the import file when using Rightworks 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 Sub-Account Number should be used in the import file.

If using Account Names, the full Account Name must be used with the Account and Sub-Account separated by a colon with no space on either side of the colon.

If Account Numbers are being used in the import file, the Option to ENABLE ACCOUNT NUMBERS ON TRANSACTIONS must be selected in Importer Options.

If the import type is Journal Entry, the Accounts must exist in the QuickBooks Online company file before importing.