For those of you doing small business consulting whose clients use QuickBooks, what is your approach to QuickBooks integration?
I’ve been consulting for 20-plus years, and I know QBooks very well. I’ve even used Transaction Pro Importer (they have changed their name), and QODBC. So I’m extremely aware of the difficulties of extracting data from their database (which isn’t really a relational database).
Currently, I’m running reports, converting to Excel, and running macros to at least get the data in a readable, 2×2 format. If I need to unwrangle further, I do.
I’d be remiss if I didn’t ask you guys about your secrets to QuickBooks integration with Quantrix. Any tips other than Excel-based exports?
Incidentally, the techniques above take 10-15 minutes monthly per client. I just don’t like having to manually intervene in the process.
Hi mgandy, just couple of additions to excellent comments from Rich:
- You can automate this process of importing data from csv and pushing to Sql database if you have a Qloud. You can use automation feature and run import and push scripts periodically. Then you do not need to do the whole thing manually
- If your historical data in csv files are large, then it would be better to use import flat file to DB feature in MS SQL Management studio