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 Online. It could be due to following scenarios.
- The file is generated by 3rd party app which does not follow the same name as QuickBooks Online.
- 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 "Excel Transactions" lookup features as described below.