
Last version published: 18/12/2020 09:06
Publication number: ELQ-35642-11
View all versions & Certificate

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
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
Write a review
People using this Best Practice also downloaded
More Best Practices from Dr. Gian Paolo Avanzo
ProfitQube™ Production Pro - Enterprise Integrated Financial Planning, Production,Trade,Services (Excel/VBA, rel.1.2.10)
ProfitQube™ establishes a new standard in financial planning as the best EIFP application for SMEs and Consultants131Discussadd_shopping_cart$149.00by Gian Paolo Avanzo
ProfitQube™ Production - Enterprise Integrated Financial Planning for Production + Services (Excel/VBA, release 1.2.10)
ProfitQube™ establishes a new standard in financial planning as the best EIFP application for SMEs and Consultants75Discussadd_shopping_cart$139.00by Gian Paolo Avanzo
ProfitQube™ Services - Enterprise Integrated Financial Planning for delivering Services (Excel/VBA, release 1.2.10)
ProfitQube™ establishes a new standard in financial planning as the best EIFP application for SMEs and Consultants71Discussadd_shopping_cart$89.00by Gian Paolo Avanzo
ProfitQube™ Trade - Enterprise Integrated Financial Planning for Trade Goods and Services (Excel/VBA, release 1.2.10)
ProfitQube™ establishes a new standard in financial planning as the best EIFP application for SMEs and Consultants83Discussadd_shopping_cart$109.00by Gian Paolo Avanzo
Can Excel be leveraged for Enterprise Integrated Financial Planning (EIFP)?
INFORMATIVE READINGS52Discussadd_shopping_cartfreeby Gian Paolo Avanzo
A walk-through Effective Planning
INFORMATIVE READINGS - Planning Activities are expanding into integrated operational and financial planning.83Discussadd_shopping_cartfreeby Gian Paolo Avanzo
ProfitQube and Company Presentation
BROCHURE - ProfitQube and Company Overview.74Discussadd_shopping_cartfreeby Gian Paolo Avanzo
How to turn Excel into a Corporate Application
INFORMATIVE READINGS - Corporate Planning with Excel/VBA61Discussadd_shopping_cartfreeby Gian Paolo Avanzo
Why Roman Auxiliary Troops give us insights for FP&A
INFORMATIVE READINGS - Top Management meetings where FP&A plays a central role29Discussadd_shopping_cartfreeby Gian Paolo Avanzo
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!