QUESTION

How does the cross-reference option work for Accounts when importing into QuickBooks Desktop (QBDT) with Rightworks 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. Additionally, there might be formatting differences between the other system and QBDT as to how account names are formatted so that they do not match exactly. By default, Importer will look for a matching name in the Name field on the Account in QBDT. However, selecting the Cross-Reference Option will change it so that Importer looks for a match in the Account Description field. The option to Cross Reference Account Description for Account Name is found on the ADVANCED option tab in Transaction Pro.

An alphanumeric value up to 200 characters may be entered into the Account Description field in QBDT and then used when importing transactions. When using the cross-reference option, the column that contains the cross-referenced data will need to be mapped to the Account.

All Accounts must be cross-referenced if using the option. A mixture of some cross-referenced account names and some not cross-referenced is not allowed.

Cross-referenced values must be set up prior to importing with the option. 

All cross-referenced values must be unique. If two Accounts have the same cross-reference value, the option will not work correctly.

NOTE: Cross-reference options increase the validation time of the import file in Transaction Pro especially if QBDT company file has a large list for the cross-referenced value.