I'd like to have all the data, so i could see on a granular / line level basis which costs are included, by supplier, by location, amount, date etc. Similarly for revenue. 

I'd be happy if i can export all the data and analyse in excel, i can't see how to do this though.

In terms of consolidation, i have several companies and want to be able to build a simple consolidated model, but again can't see any easy way to do this.