What is QB ID?
QuickBooks creates Unique ID for each type of Transaction whenever it is created. We have named it as QB ID.
Use of QB ID
In some situations, it is difficult to locate the transactions using "Reference No" especially for Payments. In those scenarios, QB ID can help us to locate those transactions.
You will get QB ID in your export report if you have used our EXPORT feature.
When you upload the file using MODIFY Menu, QB ID column will be mapped to "Reference No" field automatically. Our App also enable the Option "Use QuickBooks Transaction Id for Update" in Import Settings. So, while searching for Transactions, it will search based on QB ID.
So If you have QB ID in your file, kindly make sure that "Use QuickBooks Transaction Id for Update" is enabled in Import Settings.
Please DON'T DISABLE "Use QuickBooks Transaction Id for Update" in Import Settings. If you have disabled the option, it may update the undesired Transactions.
If you want to update using "Reference No", then map the key column to "Reference No" and disable "Use QuickBooks Transaction Id for Update" in Import Settings.