This product is designed for Excel 2003/2007/2010. 

E-Mail Product Request

I operate an electronics supply company that has 5 branches scattered over the state. Do you have an analysis tracking system that can consolidate the financials of these stores onto one sheet while at the same time tracking each store? 

I would need it to reflect spans of either by 12 months or multiple years. This would allow me to track months and on a separate annual workbook, to track consolidated annual totals. 


This request is one of many that we have received asking for similar features. Most of our products are generated by repeated requests from our users. So, we went to work on this project and after many field tests our authors created The Consolidator™.

What is it?
The Consolidator™ is designed to combine the financial data of a company with financial data from multiple entities, such as profit centers, subsidiaries, or majority interests into one Consolidation Report.

Enter the finance details for each of your company's entities on each entry worksheet. You enter financial data for each of up to 10 profit centers and The Consolidator™ produces over 50 analysis reports for tracking your business.

When you modify, add, or delete the data in the cells of the entry worksheets, the Consolidator™ automatically calculates your company's consolidated financial statements.

Master Control for easy access to all analysis tools.
2 Linked PowerPoint Presentations
Business Plan Template
Business Plan Creator
Business Tools Library Volume I
Business Tools Library Volume II
Dynamic Strategic Planner
NeoPrice™ - Pricing Your Product or Service
Compatible with Excel 2007 and 2010

Free Bonus Analysis System:

Included FREE with The Consolidator™ is The Consultant Lite Version™ which is a streamlined version of The Consultant™ a $75.00 USD value.

The Consultant Lite Version
™ is in Excel 2003.

It was created for the professional who does not need all of the "in-depth" analysis tools of The Consultantand is set up for 12 reporting periods linked to all key analysis worksheets by a choice of Months, Quarters, or Years.

Minimum System Requirements:

Microsoft Office Excel 2003 system requirements
To use Microsoft Office Excel 2003, you need:
     1) Computer and processor Personal computer with an Intel
         Pentium 233-MHz or faster processor (Pentium III recommended)
     2) Memory 128 megabytes (MB) of RAM or greater
     3) Hard disk 150 MB of available hard-disk space; optional installation files
         cache (recommended) requires an additional 200 MB of available
         hard-disk space
     4) Drive CD-ROM or DVD drive
     5) Display Super VGA (800 × 600) or higher-resolution monitor
     6) Operating system Microsoft Windows 2000 with Service Pack 3 (SP3),
         Windows XP, or later

Apple Minimum System Requirements:
Microsoft  (Apple) Office Excel: Mac 2011
To use Apple Microsoft Office 2011, you will need:
     1) A Mac computer with an Intel 500 MHz or faster processor
     2) Operating system Mac OS X version 10.4.9 or later
     3) 512 MB of RAM or more
     4) 1.5 GB of available hard disk space
     5) DVD drive
     6) 1024 x 768 or higher resolution-monitor

NOTE: Since Microsoft chose to drop VBA (Macros) in Apple Excel 2008, a good alternative is to use Boot Camp found in Mac OS X or a 3rd party virtual desktop program. This allows you to have Windows XP or Vista on your Mac desk top.

This index is in workbook order.


Business Tools Library Index

This index is in alphabetical order.

Accounts Payable Aging
Accounts Receivable Aging
Annual Direct Labor Analysis
Approval To Hire Request
Auto Expense Report
Average Selling Price Analysis
Advertising Expenditures-Media
Backorder Control
Balance Sheet
Balance Sheet (2)
Balance Sheet (3)
Basic Invoice
Bill of Ladding
Break-Even Analysis
Break-Even (2)
Break-Even Chart
Break_Even CIA
Break_Even Units
Budget-5 Profit Centers
Buried Costs
Business Acquisition Worksheet
Business Indebtedness
Business Loan Proceeds
Business Plan Sample
Business Valuation
Cash Budget
Cash Flow 4 Yrs Quarterly
Cash Flow Forecast
Cash Flow Forecast (2)
Cash Flow Sensitivity Analysis
Commercial Loan Checklist
Commission Report
Company Property Receipt
Comparative Business Income
Comparative Contribution Income
Comparative Earnings Analysis
Comparative Taxable Income
Corporate Earnings Analysis
Credit Application
Credit Control List
Credit History
Customer Ledger
Daily Profit Tracking
Weekly Profit Tracking
Daily Production Report
Daily Services Rendered
Debt Ratios
Direct Advertising Response
Direct Marketing Analysis
Employee Change Record
Employee Orientation
Employee Performance Review
Employee Self Evaluation
Employee Termination
Employee Time Sheet
Employee Turnover Analysis
Estimating Start-Up Capital
Expense Budget
Expense Report
Financial Calculator
Financial Comparison Analysis
Financial Analysis Data Entry
Financial Analysis
Financial Statement Ratios
Five Year Projections
Fixed Asset Record
Flexible Budget
G&A Expense Budget
Income Statement
Income Statement 2 Years
Income Statement 12 Months
Income Statement 5 Years
Inspection Report
Insurance Coverage Report
Job Estimate
Liquidity Analysis & Ratios
Manufacturing Overhead Budget
Marketing Calculators
Marketing Personnel Expenses
Media Budget by Quarter
Media Forecast
Merchandise Plan
Merchandise Return
Monthly Sales Projections
Moving Average Sales Forecast
New Employee Record Chart
New Product Sales Forecast
One Year Project Process Report
Overdue Account File
Parts Inventory
Payroll Analysis
Perpetual Inventory Control
Personal Wealth Analysis
Personnel Activity Report
Present Value Mixed Stream
Price Estimate For Services
Price Line Sales Projections
Product Sales Goals
Production Reject Report
Profitability Ratios
Proforma Balance Sheet
Pro-Forma Balance Sheet
Proforma Income Statement
Pro-Forma Income Statement
Project Cost Summary
Projected Cash Flow
Puchases Log
Purchase Order
Quarterly Budget Analysis
Quarterly Cash Flow Projection
Quarterly Marketing Budget
Quarterly Sales Record
Quotation Evaluation
Quotation Record
Ratio Analysis
Receipt For Goods
Receiving Report
Request For Quotation
Sales Activity Report
Sales Budget
Sales Channel Analysis
Sales Promotion Expenses
Sales Quotation
Sales Revenue Report
Sales Seasonality by Month
Sales Trend Analysis
Service Invoice
Shipping Order
Small Business Valuation
Smoothing Forecast
Startup Budget
Startup Capitalization
Statement of Account
Statement of Cash Flows
Stock Balance Record
Stock Valuator
Store-To-Store Sales
Summary of Key Accounts
Vendor Cost Analysis
Vendor Evaluation Analysis
Vendor Master File
Wealth Accumulation Analysis
Weekly Cash Flow Projection
Weekly Work Schedule
Yearly Planner

The Consolidator Folder Contents

Screen Shots







© Copyright, 2013, JaxWorks, All Rights Reserved.   |   Privacy Statement   |   Terms of Use