Overview
The Consolidated Reporting screen allows you to combine Investment, Tax, and Financial data across multiple entities into one consolidated view.
A group of entities can consist of SMSFs, Trusts, Companies, and Individual portfolios from within Simple Fund 360 and Simple Invest 360. The consolidated view will include Investment Holdings, Investment Performance, Asset Allocation, Taxation information, and Financials, all of which can be exported to a PDF or Excel file.
Instructions
| From the Main Toolbar, go to Reports. | |
| Select Consolidated Reporting from the list. |
- To begin, select an existing group or click New Group:
- If creating a new group, choose a name and click to add any entity from your BGL subscription (up to a total of 20 entities can be selected). Then select Create group:
Tip: Use the filter to search by SMSFs, Trusts, Companies, or Individuals.
- A set of consolidated reports will now be generated.
Select the Reporting Period for the reports, or input the Start and End Date as required:
- Click on any of the headings to preview sections of the consolidated report:
Cover
Click on the Cover tab to open the cover page section. Here you can edit the name of the consolidated report by clicking the Pencil icon:
Settings:
Click the Settings button to choose whether or not to ignore inter-entity investments when generating the consolidated reports. This will be switched on by default.
Summary
The Summary tab displays an overview of the information displayed in each other tab:
Item |
Description |
|---|---|
| Change in Value | Total Net Opening Balance - Total Net Closing Balance. |
| Return | Return on Investments as displayed in the Performance tab. |
| Investment Income | The sum of Income for Investments as per each entity. |
| Tax Movement | The difference between the current year and prior year tax. |
Click the above image to expand.
Asset Allocation
The Asset Allocation tab displays a Pie Chart based on the asset allocation type selected.
Settings:
Click the Settings button to change the asset allocation type to either:
- Grouped by Asset Type
- Grouped by Defensive vs Growth
- Grouped by GICS Code - The Investment Summary Report can be sorted by Global Industry Classification Codes (GICS) codes.
- Grouped by Control Account
These pie charts can be reconciled further on an entity level using the Investment Strategy Comparison Report.
Click the above image to preview a gallery of available pie charts.
Tax
The Tax tab provides a summary of tax payable/refundable in the current and prior financial year.
- These figures can be reconciled using the Statement of Taxable Income on an entity level.
Note:
Tax data will only be available for entities that have completed the create entries/year-end process as this is when tax is calculated in the software.
Click the above image to expand.
Reports
Three Financial Reports are available on the Consolidated Reporting screen. These reports can be customised for better reporting and analysis. The three reports available are:
- Consolidated Statement of Financial Position
- Consolidated Operating Statement
- Consolidated Investment Report
Select the relevant tab to access the desired report:
Features of the Consolidated Financial Reports Screen
The Edit Layout feature lets you fully customise the appearance and structure of your reports:
Click the Edit Layout button to access the customisation screen.
| 1. Templates | Select the Base template with no changes, or create a template to save your preferred reporting layout. Templates can be copied, renamed, and set as default. | |
| 2. Edit Titles | The reporting title can be renamed for clarity. | |
| 3. Show Totals | Enable options to display Heading Totals or Subheading Totals in the report. | |
| 4. Rearrange Headings | Drag and drop headings to adjust their order. | |
| 5. Add Headings | Click Add Heading to create custom headings. | |
| 6. Delete Headings | Remove unwanted headings. (Only custom created heading can be deleted) |
|
| 7. Set Headings and Subheadings | Use the arrows in each row to adjust headings between Heading, Subheading or a Subrow. | |
| 8. Consolidate Accounts | 2-4 accounts can be selected and consolidated so they appear as one account in consolidated reports. |
Reordering accounts can lead to Sub-Accounts being misplaced within the report.
- To help identify accounts, hover your cursor over specific Sub-Accounts to view the associated Control Account category:
Note: 8. Consolidate Accounts
Please note that the name displayed for consolidated accounts is based on what accounts are selected:
- If there are multiple accounts with identical account names, the most common name will be used.
- If no account name is most common, the first account name will be used.
Perfect in situations where one entity provides a loan to another entity or one entity sells something to another entity in the same group.
Easily switch between two viewing options:
- Entity View: This shows a breakdown of values across all entities.
- Period View: Displays the total value for all entities, with a comparison to the previous financial period.
Once you’ve customised the report, use Generate Report, then select PDF or Excel to Print and/or Save the report.
Print the Full Consolidated Report
To print the full consolidated report, click Generate PDF.
Customise the report by selecting which sections will be included in the full consolidated report, then click generate.
The Summary, Asset Allocation, and Tax reports can also be printed/downloaded individually using the icon in the top right-hand side of each section: