December 10, 2021
I would appreciate advice on the best approach to exporting financial data from QuickBooks Desktop to Excel so that it arrives as close to the proper tabular form for pivot tables/charts and minimizes the amount of cleaning required by Power Query. I don't have much experience with QuickBooks and am working with someone who uses QB to create some year-end reports and dashboards in Excel. From my inexperienced point of view, it looks like it would make sense to download the general ledger detail, the income statement detail and balance sheet detail into worksheets as a foundation for creating reports and charts. It appears there would still be some cleaning required in Power Query to get rid of totals, fix headers, etc. but should be manageable. Is that the right path to go down? Would we be better served to download other specific QB reports such as for cashflow in order to use them to create a waterfall cashflow chart (for example)?
Thanks for any advice you can offer. I think a video on best practices for exporting to Excel might be helpful.
December 7, 2016
I am not a QuickBooks user myself, but it seems it is possible to connect to data source using Microsoft Query, click this link to a web page that gives such guidance. Hope it works as mentioned.