How to run Consolidated reports via Focus Professional ?

Consolidated reporting is one of many features available within Focus Professional, which can be purchased through a Farm Focus Workspace.

Consolidated reports bring together financial information from multiple farms, making it easier to compare results using a consistent reporting structure.

The following consolidated reports are currently available:

• Consolidated Profit and Loss

• Consolidated Cashflow Summary

Consolidated Economic Farm Surplus (EFS) is planned for future development 

Before you begin

Before running a consolidated report, ensure that:

• You have purchased Focus Professional through your workspace.

• Your workspace has been validated by the Farm Focus team.

• The farms you want to include are part of your workspace.

• You have created a workspace code list and mapped the relevant farm codes to it.

The workspace code list provides a consistent reporting structure across all selected farms. Each farm's codes must be mapped to this list so that the consolidated results can be compared meaningfully.

You can copy an existing farm code list to use as a starting point for your workspace code list. Once copied, it becomes the workspace-level reporting structure used for consolidation.

Step 1: Open Workspace reports

1. Log in

2. Navigate to your workspace.

3. Open the reports page.

4. The available reports are Consolidated Profit and Loss and Consolidated Cashflow Summary.

5. Select the consolidated report you want to run. 

    

   Step 2: Select your report settings

   Selecting a consolidated report opens a settings drawer. The options depend on the report you have selected.

   Choose the relevant settings, which may include:

   • Workspace code list: Select the reporting structure to use.

   • Farms: Choose the farms to include in the consolidated report.

   • Financial year: Select the financial year you want to report on.

   • Cash or accrual view: Choose how cashflow information is calculated and displayed.

   • Adjustments: Apply available adjustment options to the consolidated Profit and Loss report.

   • Ownership share: Apply relevant ownership percentages where required.

   The report includes only the farms selected in the settings and the data available to you through your workspace permissions.

   Step 3: Run your consolidated report

   Once you have selected your settings, generate the report.

   The report combines the financial information for your selected farms using the workspace code list and the chosen financial year.

   Review the consolidated results to understand the combined financial position or performance of the selected farms.

    

   Step 4: Understand your consolidated reports

   Consolidated Profit and Loss

   Combines the Profit and Loss information from the selected farms using your workspace code list. Available adjustment options and ownership shares can be applied to the reported totals.

   Consolidated Cashflow Summary

   Combines cashflow information across the selected farms. You can choose between cash and accrual views, depending on how you want to review the information.

   The report also includes opening and closing bank balance rows to help you understand the group's overall cash position.

   ---

   Important notes

   • Code mapping: Farm codes must be mapped to the workspace code list for the consolidated results to be meaningful. Incomplete mapping may affect the report.

   • Farm access: You can only report on farms you have permission to access. Workspace members can view consolidated reports without necessarily having permission to manage the workspace code list.

   • Consolidated EFS: This report is not yet available.

   • Cashflow exports: Printing, saving and CSV export options for consolidated cashflow are not yet available.