Do you need multi-company consolidation reports? Calxa gives you a way to do just that. Consolidating reports for several companies can be quite daunting and time consuming. On top of that, it’s difficult to track what reports will be needed. To help you, we’ve identified 6 top reports that will provide you a clearer picture of your organisation’s accounts to simplify the consolidation process.

 

Multi-Company Consolidation Reports with One Click

Before we get started, you’re probably wondering how you can access these reports. Within Calxa, you can schedule monthly emails containing your bundle of reports. Alternatively, you have the option to run your bundle at the click of a button.

 

 

1. Business Unit Comparison

Sometimes the easiest way to make comparisons is to view companies side-by-side. This report allows you to compare multiple companies across multiples columns. See each company side-by-side with a total to show the whole picture of the multi-company consolidation. If you would prefer your report to be less detailed, use Account Trees to group, summarise and re-order your accounts while maintaining the integrity of your report.

Comparison by Branch

 

 

2. Business Unit Income & Expense Summary

It is important to be aware which of your entities are profitable and which areas need addressing. You can use the Business Unit Income & Expense Summary to give you a simplified list of organisations (one line each). This report is a great way to get a view of your multi-entity consolidations. The Report Designer gives many options on the columns you can add and offers alternative display modes.

Branch Summary Report

 

 

3. Cashflow Forecast

Cashflow is crucial to success. Forecasting cashflow allows your organisation to examine different scenarios and evaluate the effects of cashflow. This feature simplifies the decision-making process (especially for anyone who isn’t an accountant). Spreadsheeting a multi-company consolidated cash flow forecast is probably one of the more time-consuming tasks you’ll come across. You will find it so much easier with Calxa.

Multi-Company Consolidations - Cashflow Forecast Chart

 

 

4. Comparing Actuals to Budgets

Budgets are important at all levels: from your cost centres or business units to each organisation and then at the consolidated group level. Calxa has many reports to compare actuals to budgets in different ways and all can be run at any of these levels.

You can optimise the reports to display KPIs: these reports can include built-in KPIs as well as any you have customised.

Actual vs Budget with Last Year Comparison

 

 

5. Bank Movement Waterfall Chart

Business owners and managers love to see the movement of funds through the business and the Bank Movement Waterfall Chart is a great way to do just that. The chart visually represents the cumulative effect of the positive and negative movements of your bank balance. Run at different levels, using Account Trees to group your accounts, to get a clear view of what’s driving your group.

Bank Movement Waterfall Chart

 

 

6. Detailed Consolidated Reports

OK, so this one isn’t a report, it’s the Report Bundle. By simply adding the individual reports into a Report Bundle, you have an automated multi-entity consolidation report. This can be done with any report in Calxa, from financial statements to budget comparisons, to balance sheet or cashflow forecasts. Then use a workflow to schedule delivery to your email as required.

 

 

Getting Started with Multi-Company Consolidations

So there you have the 6 reports (well, 5 reports and 1 Report Bundle) we recommend for anyone creating reports for multi-company consolidations. They can provide you with the insights you need to analyse your companies’ financial performance and make informed decisions for the future. Multi-entity consolidations can be tricky. Account Trees in Calxa are the key to creating a common reporting structure across all entities. Read this article 7 Uses for Account Trees to better understand how this works in Calxa. To find out more on how Calxa can help your group consolidations start with our multi-branch enterprises page.