Subscriptions

Register for Training


 

Overview


Analytical Insights takes Simple Fund 360 to the next level by providing you with the ability to globally search and query your Simple Fund 360 database real-time.

This is the first phase of this project with more search and query capabilities to come.

The Analytical Insights feature provides you with pre-set filters and labels to make it easier and faster to search.

Getting real-time information within a few keyboard strokes will result in hours of productivity saved producing reports and finding the right information in a timely manner.

Screen Access


Select Analytical Insights at the top of the screen.

Search Options


Simple Fund 360 will display search results based on the search term(s) you have entered.

Select the arrow icon (More Information) to expand the search result. 

Search Simple Fund 360 globally based on the following:

  1. Fund Name
  2. Fund Code
  3. Fund ABN
  4. Fund Label
  5. Fund Current Financial Year
  6. Member Name, Email, Mobile
  7. Contact Names (e.g. auditor, accountant)

The following sets of filters are also available for you to use (left hand menu):

    • Fund Labels
    • Current Financial Year
    • Trust Deed Last Modified Date
    • Insurance status of funds (refer to SMSF Insurance provided by AIA/AGI through BGL)
    • Lodgement Status
    • Concessional Contribution Cap as at FY selected
    • NCC Cap as at FY selected
    • Member Age as of Today
    • Pension Funds
    • Pension Account Types
    • Pension Funds Status (minimum met)
    • TBAR Frequency (quarterly or annually) 
    • Total Super Balance as at 30/06/17
    • Total Pension Balance as of today
    • Total Member Balance as of today
    • Member Age as of today
    • Funds with Unmatched Transactions
    • Last Transaction Modified Time
    • Last Create Entries Time

Selecting any one of the above checkboxes will filter the results based on your selection.

Auto Complete and Suggestions 

As you start typing in the search box, a list of suggestions will display to make it easier and faster for you to find the information you are looking for.

You can press on the downward arrow key to highlight one of the suggestions. Press Enter to select it and Simple Fund 360 will display the search results based on the selected suggestion.

Fund Selection


From the Analytical Insights screen, start typing the name of the fund and press on the downward arrow on your keyboard to navigate to that fund.

Press Enter to select the fund.

Concessional Contribution (CC) and Non-Concessional Contribution (NCC) Caps


You can view and track the CC and NCC amounts for all your members and across all the funds from a single screen.

You can also check for which fund(s) the Bring Forward Rule has been triggered.

A set of filters will display for you to use based on the circumstances of your members.

Select one of the checkboxes to display only those fund(s) information meeting the chosen criteria.

Pension $1.6 Million Cap


Use the Pension Current Balance search function to filter which pensions balances are:

  • Under $1M
  • From $1M to $1.5M
  • Over $1.6M

Select the checkbox to the left of the filter to view the resulting funds. 

Please note that you will need to consider super balances outside of this SMSF (e.g. Industry Fund balance), which are not included in this filter.

Pension Payments/Drawdowns


The Analytical Insights screen now allows you to search pension payment (drawdown) amounts for a selected financial year. The following search options are available: 

FilterExplanation
Minimum MetCombined minimum pension drawdown for all pension accounts within the fund has been met.
Minimum Not MetCombined minimum pension drawdown for all pension accounts within the fund has not been met.
Above MaximumCombined maximum pension drawdown for all pension accounts within the fund exceeds the maximum amount.

 

After you have selected the relevant filter above, you can search and select the fund for more information:

 

This will provide a pension account specific breakdown of the pension drawdowns for the year. Each member will be listed and their respective accounts will appear below. 

Export as CSV


Select Export to CSV to generate a file from the following export options:


ExportExplanation
Full CSV All of the below.
Fund CSV

The following information will be downloaded for all funds:

  • Fund Code
  • Fund Name
  • Financial Year
  • SuperStream
  • Trust Deed Last Modified Date
  • Fundhaspensionaccount
  • Fund combined pension minimum
  • Fund combined pension drawdown
  • Unallocated Pension Amounts
  • Fund Pension Position
  • Last Year Lodgement Status
  • Transaction Last Modified Date
  • LastCreate Entries Date
  • Tags
  • Suggested Match Transactions
  • Unmatched Transactions
Contribution CSV

The following information will be downloaded for all accumulation members of all funds:

  • Fund Code
  • Fund Name
  • Tags
  • Accumulation Member Code
  • Contribution Cap as at
  • Concessional Contribution Cap and Concessional Contributions Made
  • NCC Cap and NCC Made
  • NCC Position (Cap Remaining) and Status
  • Bring Forward Rule triggered
  • Member Name
  • Birth date, age, age at end ofyear, additional details
Pension CSV
  • Fund Code
  • Fund Name
  • Tags
  • Pension Member Code
  • Age As Of 01/07/2018 Or Pension Commencement
  • Pension Type
  • Pension Start Date
  • Tax FreePercentage
  • Pension Opening Balance
  • Pension Current Balance
  • Pension Account Minimum (Rate)
  • Pension Account Maximum
  • Pension Account Drawdowns
  • Pension Account Position
  • Birth date, age, age at end ofyear, additional details
Member CSV
  • Fund Code
  • Fund Name
  • Tags
  • Member Accumulation Balance
  • Member Pension Balance
  • Member Total Balance
  • Member TSB (across funds)
  • Accumulation Member Code
  • Fund Combined Minimum
  • Fund Combined Drawdowns
  • Unallocated Pension
  • Fund Pension Position
  • Member Has Active Life Insurance
  • Life Insurance Last Update Time
  • Birth date, age, age at end ofyear, additional details

Transactions


The Transaction tab allows you to filter transactions based on account type and

The number of transactions will show next to in the Transaction tab.

As you drill down through the accounts and transactions, the Transaction count will update.

You can use Transaction Date to display transactions for a specific period.

On the left-hand side, you have a breakdown of the accounts and transactions and on the right-hand side, you have a list of your funds with the balances on and before Today's date and another column showing balances on and before a year from Today's date.

To get the number of transactions and balances for a specific account, select the account by ticking the box next to it.

Account Classification

This section allows you to have a quick snapshot of the balance and number of entries for each account type.

To drill down the accounts, you can tick the checkbox next to that account.

Transaction Information

You can drill down the balances using Transaction Status, Transaction Source and User.

For example, selecting Auto Matched will display the number of transactions that have been auto-matched by Simple Fund 360 and the corresponding funds on the right-hand side.

You can further filter the list by ticking another option on the left-hand side panel. For instance, selecting BGL Bank Data, will display the number of transactions from the BGL Bank Data service that have been automated by Simple Fund 360 and the corresponding funds on the left.

You can view the transactions by clicking on the View entries >> link.

Instructions


To export the query displayed in the Transaction tab, click Download Excel then select either of Balance Sheet or All Funds.

  • Balance Sheet: Exports a CSV file that will aggregate all the funds in your Simple Fund 360 database into a single balance sheet. If applicable, the accounts displayed will correspond to the accounts selected in the Account Classification tab.

  • All Funds: Exports a CSV file that will list the balances for each fund in your Simple Fund 360 database. The balances shown for each fund will correspond to the accounts selected in the Account Classification tab.

Upcoming Developments


The following information will be available in the near future for you to search real-time through Analytical Insights:

  • Corporate Actions
  • Investments