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 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 date range desired at the top of the screen:
- 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 icon:
Settings:
Click the 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 open as a larger size in a different tab.
Performance
The Performance tab displays the combined Investment Performance for all entities as per the Investment Dashboard for each individual entity.
Note:
If multiple entities hold the same investment, these figures will be consolidated into a single line.
- For more information on how these figures are calculated, see: Investment Simple Dietz Performance screen.
Settings:
Click the button to change how the Investment Performance Line Graph displays.
This can currently be changed to show the S&P/ASX 200 Performance Benchmark.
Click the above image to open as a larger size in a different tab.
Asset Allocation
The Asset Allocation tab displays a Pie Chart based on the asset allocation type selected.
Settings:
Click the 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.
Both of these Pie Charts can be reconciled further on an entity level using the Investment Strategy Comparison Report.
Click the above images to open as a larger size in a different tab.
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 open as a larger size in a different tab.
Financials
The Financials tab displays the consolidated Opening and Closing net assets along with the total Contributions, Withdrawals, Income, Expenses, and Other Movements determining these figures.
Item |
Description |
| Opening Net Assets | Consolidated Opening Assets figure for all entities selected. |
| Contributions | Total of all Contributions recorded. |
| Withdrawals | Total of all Member, Beneficiary, or Shareholder payments. |
| Income | Total of all Investment Income as per the Operating Statements. |
| Expenses | Total of all Expenses as per the Operating Statements. |
| Other Movements | All other movements causing the difference in Opening and Closing Net Assets. |
| Closing Net Assets | Consolidated Closing Assets figure for all entities selected. |
Click the above image to open as a larger size in a different tab.
Clicking on a column will display a pop-up of all consolidated accounts that make up the total figure.
Users will have the option to tick/untick the accounts they want to include/exclude from consolidation.
Reconciliation
The following Accounts, Reports, and calculations can be used to reconcile sections of the Financials Tab for each individual entity:
Item |
Description |
| Opening Net Assets | Report - Statement of Financial Position. |
| Contributions | Account - 24200/Contributions (SMSF Entities only). |
| Withdrawals |
Accounts depend on the type of Entitity. SMSF:
Trusts:
Companies:
|
| Income |
Report - Operating Statement > Income less contributions. This is required as the Report figure includes contributions. |
| Expenses |
Report - Operating Statement > Expenses less withdrawals. This is required as the Report figure includes withdrawals. |
| Other Movements | Total = Closing Net assets less [Opening Net assets, Contributions, Withdrawals, Income, and Expenses combined] |
| Closing Net Assets | Report - Statement of Financial Position. |
Reports
The Reports tab provides access to the Consolidated Operating Statement and Statement of Financial Position, which can be customised for better reporting and analysis.
Click the above image to open as a larger size in a different tab.
To access, hover over reports and select either the Operating Statement or Statement of Financial Position
Features of the Consolidated Financial Reports Screen
Edit Layout
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. Edit Titles | The reporting title can be renamed for clarity. | |
| 2. Show Totals | Enable options to display Heading Totals or Subheading Totals in the report. | |
| 3. Rearrange Headings | Drag and drop headings to adjust their order. | |
| 4. Add Headings | Click Add Heading to create custom headings. | |
| 5. Delete Headings | Remove unwanted headings. (Custom created heading can only be deleted) | |
| 6. Set Headings and Subheadings | Use the arrows in each row to adjust headings between Heading, Subheading or a Subrow. | |
| 7. Reset Layout: | Click Reset Template to revert the layout to its original default settings. |
Eliminations
Perfect in situations where one entity provides a loan to another entity or one entity sells something to another entity in the same group.
Entity View / Period View Toggle
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.
Generate Report
Once you’ve customised the report, use Generate Report to Print and/or Save the report.
Print the Full Consolidated Report
To print the full consolidated report, click Generate PDF.
After a short moment, the PDF will be ready. Click Preview to view the report:
Alternatively, All sections can be printed/downloaded individually using the icon in the top right-hand side of each section: