Build a tool in Google Sheets that analysis data from multiple quickbook accounts.

The organization needs to be able to analyze its financials. The intended outcome is that forecasts can be compared to actual and new forecasts can be made with the tool.
The organization currently has 10 companies that trade with each other. The tool will need to be able to collect the raw data, remove the intercompany transactions and then compare actual to planned to the new plan.
We want the tool used by the managers so that they can forecast their expected results and KPIs.