ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
  • ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)
Originally published: 09/05/2019 13:57
Last version published: 21/06/2020 16:39
Publication number: ELQ-79470-15
View all versions & Certificate
certified

ProfitQube™ - Enterprise Integrated Financial Planning for Production, Trade and Services (Excel/VBA, release 1.2.8)

ProfitQube™ establishes a new standard in financial planning as the best EIFP application for SMEs and Consultants

Description
ProfitQube™ enables Top Managers, CFOs, Entrepreneurs, Bank Managers, Chartered Accountants, Financial Analysts and Business Professionals to formulate an organization integrated forecast and verify profitability over a period of 5 years (12MTH+4Y).

Manage multi-company/scenario with this user friendly yet powerful and flexible application developed in Excel/VBA where financials are analysed and projected with such a detail, reliability and clearness to satisfy both financial experts and entrepreneurs.

For CHARTERED ACCOUNTANTS and FINANCIAL CONSULTANTS
• Deliver Effective Consultancy that increases Client’s Profitability and Retention
• Deliver Consultancy that enhances Organizational Knowledge and understanding of Business Processes Relationship
and more

For COMPANIES
• Streamline Management Accounting/Financial Controlling and Business Case Analysis
• Facilitate Evaluation of new Initiatives and start-up analysis
• Enable Strategy alignment with Financial Forecast
• Standardize subsidiaries forecast
• Harmonize typical Franchisee’s and Franchisor’s financial models
and more

For BANKS/FINANCIAL INSTITUTIONS
• Engage Clients in Financial Planning exercise
• Standardize Client’s Financial Statements projections and KPI’s analysis
and more

For BUSINESS SCHOOLS
• Improve Engagement
• Increase Knowledge Retention
• Boost Student Learning
• Inspire Collaboration
• Benefits for Teachers (Improving Communication, Save Time)
and more

METRICS
Excel compressed format xlsb 75MB (Binary)

6 mln formulas

60k nominated cells

54 Worksheets

250+ Charts

100+ Sparklines

45 VBA Program Modules

3,500 working hours for Design and Implementation

Workbook, Worksheets and VBA are pw protected except input fields.

Activation Key enabled by MS Office protection market leader http://www.excelsoftware.com.

Designed and developed by Crown Applications: https://www.eloquens.com/channel/gian-paolo-avanzo

This Best Practice includes
Two 30 days full Trial Versions (w/, w/o scenario), scenario files, User Manual PDF, ReadMeFirst!.txt.

Dr. Gian Paolo Avanzo offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

ProfitQube™ provides an all-in-one professional application enabling 360 degrees planning of an organization (services, trade, production or multi-business).

The User can depict complex integrated scenarios for hundreds of products and services to forecast:

Strategy and Balanced Scorecard

Link to historical data

Sales Order and Billing (domestic and export)

Production (discrete and continuous)

Capacity Planning

Production Personnel

Production Overheads & Absorption methods

MTO

MTS

Unit Product Cost

Purchasing and Vendor Capacity

Inventory Strategy and Safety Quantity

Overheads

Long Term Assets purchasing, depreciation and disposal/write off (Intangibles, Tangibles and Financials)

Banks

Human Resources

Tax Provision

Discounted Cash Flow

IFRS statements

BEP analysis

Charts & KPIs

and more


Click To Go, Hyperlink buttons, Export functionality (values and formats), User Friendly interface and colors, Quick Guide, Help and User Manual facilitate the use of this cutting edge application which required 2 years of design and implementation work.

___________________________________________________________________________________________________________________________

ProfitQube™ Release 1.2.8 - Update – June 17, 2020
USER MANUAL
Version: All
- Intra module navigation buttons colour corrected and aligned with colour of buttons in ProfitQube™ for Chapter(s):
8.1.5 STEP 1 - Settings
- Added “Chapter 11 – Strategy and Balanced Scorecard Add-In”

BUG FIXING
Version: All
- Output Module 710_BS (BALANCE SHEET) first month/period column of the first planning financial year (i.e. Jan-18) is now included in the Outline (group) to “Show Detail/Hide Detail”.
- Input Module PREVFY (PREVIOUS FINANCIAL YEAR) correct wrong numbers format.
- Output Module 700_IS (INCOME STATEMENT: corrected wrong Income Tax summarization for Quarters.
- Output Module 710_BS (BALANCE SHEET): corrected wrong VAT calculation for planning years 2 to 5 when there is no VAT for year 1.
- Output Modules 720_CFD (CASH FLOW DIRECT) and 730_CFI (CASH FLOW INDIRECT) VAT split for “Operating Activities”, “Investing Activities” and “Financing Activities” corrected.

OTHER IMPROVEMENTS
Version: All
- Function Modules 420_ALL&PROV - Customers Unpaid functionality has been added.
- Knowledge Module HELP section CAPACITY PLANNING (200_CP_PROD) improved with additional information on how “D - Q.ty Inventory Reduction for Allocation to Demand”, “B+C-D = Q.ty Demand Net”, “A + D - B - C = Q.ty +Over/-Under Capacity” and “Overcapacity
Make to Stock %” are calculated.
- Knowledge Module HELP section ALLOWANCES & PROVISIONES (420_ALL&PROV) improved with additional information on how to use Bad Debts Expense % functionality and Customers Unpaid.
- MENU Buttons “SET WORKBOOK INPUT TO ZERO - PREVIOUS FY” and “SET WORKBOOK INPUT TO ZERO - CURRENT FYs” now clear also Notes in each module.
- Function Modules 200_CP_PROD (CAPACITY PLANNING), 220_I_PROD (INVENTORY) and 230_P_PROD (PERSONNEL PRODUCTION) layout improved.
- Function Modules “STRATEGY” and “BALANCED_SCORECARD” have been added.
- Button “SET WORKSHEET INPUT TO ZERO” now clears also Notes.
- Function Module 640_ITAX (INCOME TAX) - Down Payment Instalments extended from 2 Periods to 12 Periods for First Financial Year.
- Input cells gradient effect applies when a value other than zero is populated to improve visibility of used ranges.
- Output Module “CHECK”: added Quarterly report for Income Statement, Balance Sheet and Cash Flow Direct.
- Added rows Auto-Fit method to “EXPORT FORMATS” button to improve visibility.

THE PROFITQUBE DEVELOPMENT TEAM

___________________________________________________________________________________________________________________________

Produce accurate and complete financial forecasts on the fly.

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

Evaluate customers business plan to support loan review process.

Prepare credible projections to win investors.

Standardize budget and planning exercise across subsidiaries.

N/A

Reviews

keyboard_arrow_downShow all


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™ - Enterprise Integrated Financial Planning For Production, Trade And Services (Excel/VBA, Release 1.2.8)?

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


4.6 / 5 (16 votes)

please wait...