Modano has some interesting consolodation software. XBRL-based structured information can make things like this significantly easier. For a quick overview, watch this video. To get a more detailed understanding, watch this video.
Have a look at these libraries to get a better feel.