There are a number or reasons why mass updating a list of contacts by mass uploading another list of contacts is an outdated idea. The solution is through an API. My fav is zapier.
We run zaps from Hubspot to QBO seamlessly upon trigger=contact update, deal closed/won, or quote paid. We also send closed/won deals that paid to QBO as created invoices that are paid too.
You can set this up more simply with a google sheet to QBO zap. Triggers are the same. Cost is nearly free.
Anyone wants help setting this up so that their QBO data matches and external dataset lmk I will show you in a screencast.
Hope this helps. Cheers and happy holidays.
