I need to analyse and use the data in Quickbooks better, for example pulling data by location and class, this doesn't appear to be possible without running separate reports. Does anyone have any suggestions or alternatives, how can i export the data? 

I also need a consolidation approach as i have various QB companies. Many thanks