Sometimes, when reporting for multiple organisations, the results come out differently to what you are expecting. This article has some helpful ways to investigate what is actually included in the reports and resolve inconsistencies.
Review Consolidated Group
Consolidated Groups define a list of organisations you wish to report. You can have as many groups as you wish for reporting on different selections. Ensure that your naming conventions are clear so that selecting the correct group in the Report screen is easy.
Navigate to: Reports -> Report Tools -> Consolidated Groups -> Selected Group
Group name -> Overtype to update if required, this is just for selection in reports
Name Shown in Report -> Title name to be displayed in the reports
Set the Currency -> Exchange Rates -> Reporting Year End
Select the Organisations to be included -> Budget Version -> Alternative Budget Version
SAVE CHANGES
This will be the criteria that is used to report when the Consolidated Group is selected.
Comparison Reports for
Profit &Loss, Balance Sheet, Trial Balance and Cashflow
Calxa currently has the following comparison reports.
P&L Comparison (Multi-Column)
Balance Sheet Comparison (Multi-Column)
Trial Balance Comparison (Multi-Column)
Cashflow Forecast Comparison (Multi-Column)
Cashflow Statement Comparison (Multi-Column)
These run on the selected group and will automatically set to the number of columns required for your group, plus a Total Column.
To directly compare the numbers, ensure that you have the same parameters set in the Comparison report as the report you are trying to troubleshoot:
Consolidated Group
Business Unit Selection
Budget Version
Account Tree
Reporting Period
Report Month in Orange banner
These reports will then display the values for each organisation in turn as a column, and the total, to confirm which organisations data is being pulled from.
Check the Columns back to the individual organisation's data using the Original Account Tree to confirm. If the figures do not match at the organisation level, troubleshoot those individually, comparing the Group Account Tree result with the Original Account Tree.
In the same way, if you are using Business Unit Trees for your Group reporting, you can confirm each individual organisation total to the Business Unit Tree to ensure all the data is being included.
You can then review the columns presented and identify inconsistencies to resolve any problems in your other reports.
Further assistance
If you would like additional assistance with reviewing your reports or troubleshooting, please contact Calxa Support through the online Chat Icon at the bottom right of the screen and Chat with us.