scottistheman123456
New Member
- Joined
- Sep 9, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
- MacOS
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!
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!