Consolidations

Hi Modano Team, 

I am building a consolidated 3-satement cashflow model for a client of mine with two operating entities. 

There are currently two Xero Files. 

We want all of the outputs to be a consolidated, what is the best approach to ensure seamless update/ roll forward monthly. 

1.  Try and consolidate one file in Xero, then connect into Modano

2. Create a 2x entity model in Modano, then roll these up into a consol view? 

Attached is a workbook that steps through the eliminations required for removing intercompany dividends between a parent and subsidiary entity.

No details explanation in the body of this post - the model is comprehensively annotated, so best to hit BUILD / AUDITING / LOCATE WIP RANGES and read through the detailed notes.

Recommend reading through Entity 2 (subsidiary), Entity 1 (parent co.) and then the Consolidated Financial Statements as the best flow. Cheers. J.

Currently I'm learning to consolidate using the multiple workbooks feature, and if I'm not mistaken the available export modules are operational exports, working capital exports and asset exports. Does it mean that I have to build the rest of the export modules (debt, other balance sheet items, etc) from scratch in order to make perfectly consolidated workbooks?

Thank you.