ConsoXL

cxlbox

ConsoXL

$75

The quickest way to consolidate excel sheets. If you send out spreadsheets to affiliates, branches, departments…and later need to consolidate them all, or if you simply need to consolidate identical sheets, ConsoXL will save you hours of work.

Download Trial

Have a different approach to 
Consolidations and move out of the select, copy-paste hell! ConsoXL will do it for you. For most financial schedules you don’t even have to select a cell.
Never forget a cell anymore 
ConsoXL will take them all. It’s a fully automated process and all cells will be taken into account. The consolidation rules will be applied everywhere and if data are inconsistent it will let you know.
Look at the total and immediately
See the details without moving from one sheet to the other. Each total cell can have all its details attached.
Consolidation of multiple sheets, workbooks and forms at once
No need to run separated consolidations for each form. Combine P&L and assets and get them all consolidated into one workbook.
woman's photo

Use it for simulation and keep trackof the revision number with all files used.

Support all kinds of formats, no specific templates are required. Try it with your own files.

 
Few clicks consolidation
Step 1:
You are working on the plan for next year and you've build up an Excel file which contains 2 sheets:
  • P&L
  • Manpower
You send this file to all the departments/divisions/branches... They carefully fulfill it and send it back just on time ( it may happen! )
Step 2:
So, it's time to consolidate:
  • Click 1 start ConsoXL
  • Click 2 start Windows explorer (or click the  plus )
  • Click 3 select the Excel files you've received.
  • Click 4 on the Conso button:  
The consolidation works...
Step 3: Now you have an Excel file with:
  • The consolidated P&L and the sheets of all departments
  • The consolidated Manpower and the sheets of all departments
  • A ConsoXL sheet which is the consolidation report summarizing consolidation data.
If you've used the default options of the demo project, the P&L sheet may look like this:
With the total, the details and the links.
If we look at the percentage cell:
 The formula is still there.All the sheets are grouped in the same workbook :
onglets
 
 
ConsoXL approach
When you create an Excel file format to be fulfilled and want to consolidate all the files, you need to repeat over and over the same Excel operations, sheets and cells selection, copy etc. When a file is changed or updated the process has to start again. This is a time consuming activity and error-prone.
ConsoXL has a different approach. Instead of asking you to select each sheet and cell and apply a formula it will build the consolidation model by analyzing the content of the files. It uses by default the sum function for all numbers and keeps formulas. Therefore the only remaining thing to do is to determine how to group the sheets. Most often as they come from the same initial form they have the same name, the filename being the name of the department, branch etc. This is much faster than making manual selection and it’s safer in the sense that no cell will be left aside.
ConsoXL starts Excel, loads the files and does the full consolidation process. The outcome is one Excel workbook containing either:
  • The total for each group of sheet
  • The total and the details in the comments, so you don’t need to move from one sheet to another to see where the values are coming from.
  • The total and all the sheets from the different files. The sheets are linked to the total. This is handy for simulation.
A summary is added at the end so you always know which files where used for a specific consolidation.
screenshot ConsoXL
Main features:
  • Excel sheets consolidation without parameters.
  • Creates a workbook with consolidated sheets and details sheets.
  • Consolidated sheets may be linked with details sheets.
  • Add Excel files by drag and drop, or use the standard file dialog.
  • Get the Total and all the details on the same sheet.
  • Keeps formulas (see the help file).
  • Add or remove files and get the new result.
  • No need to select sheet by sheet and cell by cell.
  • Free format for the sheets, no template to follow.
  • No macros
  • Automatic grouping of sheets.
  • Built-in default consolidation rules (can be overridden)
  • Consolidation report including the list of files (date etc.).
  • Automatic revision number.
Platforms:
  • Works on a personal computer
  • Windows 8 (32 and 64 bits), Windows 7 (32 and 64 bits), Windows Vista (32 and 64 bits), XP (Home and Professional)
  • Microsoft Excel 2013 (Preview), Excel 2010, Excel 2007, Excel 2003, Excel XP (2002)
  • Unicode (support for a broad range of national character sets)
Windows 8:
screenshot Windows 8
Windows 7:
screenshot Windows 7
Windows Vista: 
screenshot Vista
Windows XP :
screenshot XP
Number of licenses / (Price USD)        
  • 1-9 / ($75.00)
  • 10-24 / ($71.51)
  • From 25 / ($64.36)
For quantities above 25 licenses please contact us at sales@unitedaddins.com, and we will be happy to provide you with the needed quote.