Coefficient
90-day Reddit mention audit · prepared for Centropy (centropy.co.nz)
I'm not familiar with G-Connector, but I love love love [Coefficient](https://coefficient.io/) which sounds similar. My current process is basically what you describe. Coefficient will take the email address and do a contact record lookup. If a matching record is found, it can return any field of your choosing. The only downside is that it becomes extremely manual if the attendee list is larger than around 250 people because Coefficient can only handle \~50 of these queries at a time before they start failing.
I'm typically looking up at least 4 fields so even for 250 people that would mean 1000 queries which can only be run in batches of 50. I wonder if G-Connector is faster?
Show full
I use [Coefficient.io](https://coefficient.io/) for just that issue. It can pull directly from multiple QBO instances. No need to download/paste/update. Just click the refresh button and the latest data loads. Also, you can schedule refreshes if that makes sense for your workflow.
I've been using [Coefficient.io](https://coefficient.io/) to pull in month-end balances and other data for reconciliations. Really cuts down on the time needed to gather after updates. Due to/from recons get easier when you just have to click the 'refresh' button.
I've been using [Coefficient.io](https://coefficient.io/) to pull in data. For smaller firms doing multiple sets of books, it's a good balance of data direct from QBO and cost. I build the checklists in Excel and then have Coefficient refresh the data. Nice part is that it's SUPER easy to refresh.