ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
  • ProfitQube™ Consolidation for Production, Trade and Services Organizations (Excel/VBA, release 1.0.2)
Originally published: 02/08/2019 20:09
Last version published: 11/03/2020 09:46
Publication number: ELQ-35642-8
View all versions & Certificate
certified

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

ProfitQube ™ Consolidation is the ProfitQube ™ add-on that facilitates Corporate Planning Consolidation exercise

Description
**********************************************************************************
****************** E X C E P T I O N A L ***** P R O M O T I O N ******************
**********************************************************************************

Get this Professional Application for ONLY $79.00 till 31-MAY-2020!

**********************************************************************************

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 ProfiQube; 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 stand-alone application.

Designed and developed by Crown Consultancy Services (Crownapplications).

**********************************************************************************
****************** E X C E P T I O N A L ***** P R O M O T I O N ******************
**********************************************************************************

Get this Professional Application for ONLY $79.00 till 31-MAY-2020!

**********************************************************************************

This Best Practice includes
1 Consolidation Version, ReadMeFirst!_ProfitQubeConsolidation_1.0.0.txt

Acquire business license for $79.00

Add to cart

Add to bookmarks

Discuss

Further information

ProfitQube Consolidation for Multi-Industry Organizations provides an all-in-one professional application enabling the consolidation of the most important Financial Statements (Income Statement, Balance Sheet and Cash Flows).

The Parent Company will consolidate in one single entity the financial statements of all subsidiaries applying adjustments to display the Group financial position.

Here below steps:

Step 1 - Export Financial Statement files
Parent Company and Subsidiaries export financial statements to a common location (e.g. OneDrive, Intranet share drive etc.) from any of the ProfitQube Versions (Services, Trade, Production or Production Pro).

Step 2 - Consolidate Financial Statements
Upload files in ProfitQube Consolidation and merge into a single entity.

Step 3 – Export Consolidated Financial Statements
Export file with consolidated figures from ProfitQube Consolidation into a new file.

Step 4 – Adjust Financial Statements
Adjust Consolidated Financial Statement in the new file created per Step 3 and get the Group financial position.
This file is unprotected thus free for any further modification.

Function buttons, Export functionality with formats, User Friendly interface and colors and User Manual (Consolidation chapter included in ProfitQube User Manual) facilitate the use of this cutting-edge ProfitQube add-on which exceeds both SMEs and Corporations expectation for the management of Group consolidation.

-----------------------------------------------------------------------------------------------------------------------------------------------------
ProfitQube™ Consolidation 1.0.2 - Update - January 26, 2020
BUG FIXING
- BS wrong “Accounts Payable” sum has been fixed.
- Various calculation bugs fixed.

PERFORMANCE IMPROVEMENT
- Hidden ranges size has been reduced to improve calculation speed.
- Various formulas simplified to improve calculation speed.
- Relationship logic reviewed to improve VBA modules standardization.
- Improved VBA read and write of large blocks of cells.

THE PROFITQUBE DEVELOPMENT TEAM
-----------------------------------------------------------------------------------------------------------------------------------------------------

Produce accurate and complete financial consolidation forecasts on the fly.

Enable what-if analysis to support top management strategic decisions at Group level.

Evaluate customers business plan to support loan review process for multi-company and multi-industry organizations.

Prepare credible projections to win investors for Corporate.

Standardize budget and planning exercise across subsidiaries and aggregate for Corporate Strategic Decisions.

N/A

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Dr. Gian Paolo Avanzo

keyboard_arrow_leftkeyboard_arrow_right

Related categories


See all

Any questions on ProfitQube™ Consolidation For Production, Trade And Services Organizations (Excel/VBA, Release 1.0.2)?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...