Group Consolidation Model - Ready to use Excel Template with Dynamic Dashboard

Group Consolidation Model - Ready to use Excel Template with Dynamic Dashboard

This workbook consolidates up to fifteen entities into one set of group figures. Enter each trial balance in its own currency; the model translates it, eliminates intercompany positions, applies your elimination journals, accounts for associates by the equity method, calculates non-controlling interests and produces the consolidated statement of profit or loss and statement of financial position. The Entity Analysis dashboard and its filters show any one company, or any selection, on its own. Sixteen integrity checks confirm that every step balances.

Instructions and guidance for using the template are included within the workbook.

This is a generic, standard template designed for use across most industries. You may need to add, remove or change items to match your own reporting systems and policies.

© Thefinanceintellect.com. Licensed for use within your own organization; not for resale or redistribution. This workbook is a general-purpose tool and is not financial, tax or legal advice. Results depend entirely on the data you enter: review them before relying on them for any decision.