We have added the ability to use a cross reference for customers or vendors when importing transactions using Transaction Pro Importer for QuickBooks Online (Intuit App Center version). This feature can be so helpful when the names in your import file do not match those in QuickBooks Online. Often times other applications will use a customer or vendor number whereas in QuickBooks Online the actual name is displayed.
This cross reference feature is available on the following transactions:
Customers (Clients)
- Estimates
- Invoices
- Receive Payments
- Sales Receipts
Vendors
- Bills
- Bill Payments
- Checks
For customers you store the matching value from your import file in the resale # field in QuickBooks Online. You can find this field on the Client Information screen on the Tax Info tab.
For vendors you store the matching value from your import file in the Account # field in QuickBooks Online. You can find this field on the Vendor Information screen.
Then when you are in the Transaction Pro Importer application select the options button and select one of the two options highlighted below.
After you select the import button the App goes through and queries your customer or vendor list for a match in the resale # or account # fields. If Transaction Pro Importer does not find a match these lines will be displayed on the Validation Log. At this point you either need to add these values to QuickBooks Online or do not select these lines for import.
If you do not have a subscription to Transaction Pro Importer for QuickBooks Online you can sign up for a free trial here. If you have any questions or comments please post a comment below.