How to sync QBO reports to Excel's Power Query and PivotTables

Get QBO risk free 30-day trial then a 30- 50% off next 12 months.
quickbooks.intuit.com/partner...
E-mail your QuickBooks questions to [e-mail] or schedule an intro call with Steve Chase at calendly.com/sequentiasolutions.
Visit Sequentia Solutions website (www.sequentiasolutions.com) to view upcoming training classes on Excel and QuickBooks Online.

[@AdnanAhmad7]

Thank you for the video Steve. But I was looking for some way to link directly to Power Query. Do you think there is a possibility?

[@arvindazad]

I'm also looking for the same. Did you find it?

[@608er]

Nice job. Thanks for the video.

[@gomez199021]

Would this be the same process if i want to export invoices with products and goods sold?

[@charlieholland6572]

Before you did the refresh, you deleted the top and bottom rows. Your power query script already had those steps, couldn't it have taken care of the deletion?

[@SteveChase1]

Yes the PowerQuery took care of the removing the top and bottom rows. I think I must have been explaining from the Excel file that is was we wanted to do. The data source was Excel which I think I was trying to explain it again which may have seemed redundant.

[@gomez199021]

Would this be the same process to export sales and group by products and goods sold?

[@SteveChase1]

Maybe. Whenever the report has groupings built in it is not as straight as a table format.