Consolidate Table Contract For Free

Contracts should also be combined if the performance provided under one contract affects the consideration to be paid under another contract. This would be the case when failure to perform under one contract affects the amount paid under another contract.

For example, in a budgeting scenario, Excel may be used to collect budget data for several departments and then consolidate the data into one overall group or company budget. Data consolidation is a tool within Excel that allows you to gather data from other workbooks and to consolidate them into one workbook.

Combine by position Open each source sheet and make sure that your data is in the same position on each sheet. In your destination sheet, click the upper-left cell of the area where you want the consolidated data to appear.On the Data tab, under Tools, click Consolidate.

Click Data>Consolidate (in the Data Tools group). In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM. Select your data.

The total assets, liabilities and equity on the consolidated balance sheet should be equal to the sum of assets, liabilities and equity, respectively, of all independent balance sheets from all the companies involved.

Consolidated financial statements are used when the parent company holds a majority stake by controlling more than 50% of the subsidiary business. Parent companies that hold more than 20% qualify to use consolidated accounting. If a parent company holds less than a 20% stake, it must use equity method accounting.

General consolidation rules say you must consolidate whenever one company has a majority of the voting power in another company, meaning it controls at least 51 percent of the subsidiary's outstanding common stock.