We used to have 2 "consolidating" companies setup that we used to enter all of our yearend consolidation/elimination entries.
Did you ever have any luck with your consolidation problem?
But don't cross this feature off your list because it sounds like something you don't need. On the Data tab, in the Data Tools group, click Consolidate. For example, cell B2 (in distric1.xlsx) cell B2 (in district2.xlsx) cell B2 (in district3.xlsx). Note: if you don't check Top row and Left column, Excel sums all cells that have the same position.The parent company will report the “investment in subsidiary” as an asset, with the subsidiary reporting the equivalent equity owned by the parent as equity on its own accounts.At the consolidated level, an elimination adjustment must be added so that the consolidated statement is not overstated by the amount of equity held by the parent.