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

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 (QBO)?

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 QBO company file before importing.

  • 74
  • 07-Jul-2019
  • 2610 Views