It is a very common problem that  the file used to import your Sales and Expense transactions ( invoice, Sales Receipts , Payments ,Bills , Expenses & etc) may not contain exact  names of a customer or vendor as QuickBooks Desktop. It could be due to following scenarios.

1. The file is generated by 3rd party app which does not follow the same name as QuickBooks Online.

2. The file is manually created. But we don't follow the same name as QuickBooks Online due to our business.

If you are spending countless hours to map your file data ( Customer Names, Vendor Names or Account Names )  to respective QuickBooks names, then  use "SaasAnt Transactions (Desktop)" lookup features as described below.

You just need to provide us the mapping (Lookup) of  Names used in the files and it's equivalent QuickBooks Name.  Once you have imported the lookup file, Our app will find the customer/vendor/Account details from the lookup based on the file data.

You can configure lookup mapping for Customers, Vendors, Employees, and Items.

You need to follow the below simple steps to match your own file names with QuickBooks Names.

1. Navigate to Import Settings  ( Settings Edit >> Import Settings).

2. Click on "Lookup" Tab.

3. Select the required Lookup Type (Customers, Vendors, Employees, and Items)

4. Download the Sample template and update your File text and it's equivalent Display name in QuickBooks Names. 

5. Upload the updated file using the Browse Button.

If you want to make any edits on the existing lookup data, you need to download the saved lookup data and upload it again.

Lookup.xlsx

(9.02 KB)