Load data and Consol from Q2\Q3

Hi, we are investigating the best approach for loading data and starting the consolidation from Q2 or Q3 of a specific year. We would like to load from the core system trial balances however for the starting position for P&L accounts we will have to load the YTD values at the group consolidated and translated position for each entity and therefore not load from the source systems as they do not hold the translated values used by group (the consol is done in Excel currently). Alternatively we would need to load each period from the start of the year and