ProfitQube™ Consolidation for Production, Trade and Services (Excel/VBA, release 1.0.3)

Description
The functionality of financial consolidation plays an essential role in making business planning, budgets and forecasts more precise, quicker and easier to produce for multi-entity organizations.

ProfitQube™ Consolidation is a tool that makes it easy to manage and report financial statements, whether the organization is a SME or a Corporation operating in a domestic or global market.

ProfitQube™ Consolidation is a management accounting add-on of ProfitQube™ which enables the consolidation of Income Statement, Balance Sheet and Cash Flow (Direct and Indirect) with few clicks.

Combine your Subsidiaries and Parent Company Financial Statements for corporate internal control, plan, budget or forecast and for evaluating strategic investments and joint ventures.

The consolidation process consists of the aggregation of a Parent Company financial statements (Controlling Company) with that of its Subsidiaries (Controlled Companies) displaying the parent and the subsidiaries as one single entity.

The process starts by exporting Financial Statements from Subsidiaries and Parent Company from ProfitQube™; these files are then imported in ProfitQube™ Consolidation application (ProfitQubeC.xlsb).

ProfitQube™ Consolidation sums the Financial Statements from Subsidiaries and Parent Company into one single entity.

The single entity worksheet is then exported in a new file for further re-working to offset (eliminate) the intercompany transactions, the subsidiary’s shareholder equity and the parent’s investment accounts.

ProfitQube™ Consolidation works only in conjunction with ProfitQube. It is not meant to be used as a stand-alone application.

Designed and developed by Crown Consultancy Services.