Financial Statement Consolidation and Intercompany Reconcilation Templates/Macros

Hi all,

I will soon need to prepare a financial statement consolidation excel file for parent company that consolidates all parent and subsidiary companies financial data , while also doing intercompany eliminations / reconciliations and also foreign currency translation of the subsidiary financials. I will be given different trial balances for the different companies. Does anyone have a financial statement consolidation template/macro where if you paste the different trial balances, the consolidated financial statements would update automatically? In addition, does anyone have a template/macro for reconciling/eliminating intercompany balances?

Thanks!