Accounting & AuditSMSF TechnicalData Export Instructions: SMSF Accountant Data Transfer

June 27, 2020by Grow SMSF0

This article outlines the documents and reports needed to be extracted by an accountant and sent via a data transfer to Grow SMSF upon receipt of an ethical letter. Accountants can follow these data export instructions to assist in quickly off-boarding their SMSF client.

Grow SMSF follows the same procedure when an SMSF client departs and is taken over by another accountant or SMSF administrator: We will always endeavour to quickly and promptly make the transition as easy as possible for the new provider to take over.

 

BGL 360

BGL 360 to Class Transition data export Grow SMSF

This section will provide guidance on what reports and files we need to be provided with to take over the ongoing administration of an SMSF client.

Prepare Data Files

BGL masks the TFN so you will need to ensure that you complete the following two sets of steps first before exporting your fund.

Display TFN on Annual Return

Ensure the “display TFN” on Annual Return is ticked

  1. Navigate to Settings
  2. Select Badges
  3. Select the relevant badge
  4. Select SMSF Annual Return PDF Options
  5. Tick ” Display member TFN in Section F/G”
  6. Select “Display fund TFN on return and schedules”
  7. Save
Ensure TFN shown on BGL360

Ensure the “hide TFN” setting in BGL360 is set to ‘NO’

  1. Navigate to Settings
  2. Select Badges
  3. Select the relevant badge
  4. General report settings
  5. Hide TFN > set this to ”No”
  6. Save
Export BGL Data File

You can get to this by navigating in BGL 360 to Fund > Fund Export > Export Fund.

Prepare Fund Specific Reports

Create a new report pack in BGL 360 and call it ‘Fund Specific Reports – PDF’. Add the below reports to the newly created report pack (PDF format):

Fund Specific Reports Required – PDF
– Member Statements
– SMSF Annual Return
– Unrealised Capital Gains Report (Detailed)
– Trial Balance
– Fund Summary (see below Note 1 for further instructions to troubleshoot common error)
– Detailed CGT Relief Schedule (only required where the fund had applied for transitional CGT relief)
– Total Super Balance (if records available in BGL 360)
– TBAR cancellations and pending cancellations (if records available in BGL 360)
– TBAR Events History (please use Manual data collection form for SMSF)
– For Wrap and Broker accounts, please provide either a Broker or Wrap statement that shows all of the assets held in the broker or Wrap account (please contact third party wrap/broker/trustee provider if not available in BGL 360)
– For bank account details, please provide either the bank statement with the BSB and Account Number clearly readable, or alternatively provide a list of BSB’s, account numbers, and fund codes that the bank accounts belong to. If you have multiple bank accounts in a fund, you should also include a means for the team to tell which account belongs to which BSB/Account Number.

BGL Simple Fund Desktop

BGL Simple Fund Desktop data export to Class Transition Logo Grow SMSF

To transfer BGL Simple Fund Desktop data you can provide the data files and reports to us. We will require 3 community files (one copy of each) and 5 fund specific files for the specific SMSF being transferred.

Provide Data Files

The below table will show what files we require and where on your local drive to find them.

Files RequiredLocating files via file explorer
  • office.nx1
  • people.nx1
These files are generally located in either:

  • <Drive>\SFUND\DATABASE or
  • <Drive>\CASWIN\CASDATA
  • bankaccounts.nx1
This file is generally located here:

  • <Drive>\SFUND
Fund Specific Files

In addition to the above files, we also require the Simple Fund Backup / Export (.ZIP) files for each fund we are transitioning.

To export the ZIP file at an individual fund level, follow these steps:

  • Make sure you are in the correct fund
  • From the Ribbon Toolbar, go to Data In/Out | Fund In/Out.
BGL Simple Fund desktop Fund Out Data Export
  • Click on the Fund Out tab. The Filename will be the same as the Fund Code.
  • Click  to select a location for the exported file. The default location is the SFUND/DATAIN folder.
BGL Simple Fund to Class data transfer fund out instructions


Note
: Tick Export database files only if you do not wish to export reports, PDFs, ELS and other attached documents.

  • Click Export Fund. Simple Fund will create a file with the Fund Code as the filename to the location you have selected in Step 3. Once the file has been exported, you will get the following message:Warning: If the fund out process freezes, ensure you have rights to write to the folder you are exporting the file.
BGL simple fund export complete
  • You can then click OK.
Manual BGL Simple Fund file data export
Files RequiredLocating files via file explorer
  • chart.nx1
  • disphist.nx1
  • firm.nx1
  • taxdata.nx1
  • transact.nx1
  • transfercap.nx1
For example, the files for the AJK001 fund are located in:

  • <Drive>\SFUND\AJK001
Only required if you applied for CGT relief

  • costbasereset.nx1
  • notionalgain.nx1
This file is generally located here

  • <Drive>\SFUND\AJK001
Prepare Your Reports
  • Create a Folder for each fund using the BGL Code as the folder identifier
  • Add the following reports (in pdf format unless stated otherwise) into each separate folder for each fund:
    – Member Statements
    – Trial Balance
    – Detailed Projected Investment Disposals Profit (Loss)
    – Annual Return
    – Investment summary
    – CGT Cost Base Reset Report (only required where the fund had applied for transitional CGT relief)
    – Total Super Balance (if records available in BGL)
    – TBAR cancellations and pending cancellations (if records available in BGL)
    – TBAR Events History (please use Manual Data Collection Form for SMSF)
    – For Wrap and Broker accounts, please provide either a Broker or Wrap statement that shows all of the assets held
    – For bank account details, please provide either the bank statement with the BSB and Account Number clearly readable, or alternatively provide a list of BSB’s, account numbers, and fund codes that the bank accounts belong to (in csv format). If you have multiple bank accounts in a fund, you should also include a means for the team to tell which account belongs to which BSB/Account Number.
  • Once all reports have been added for each fund folder, place the fund folders into a batch folder
  • Zip your batch folder ready for uploading.

Class Super Data Transfer

Class Super to Grow SMSF transfer

Grow SMSF also uses Class as its accounting software, so providing relevant reports and data files should be quick and seamless if a client is moving the administration of their SMSF to Grow.

The following instructions can also be found in the Class Help Centre here: https://support.class.com.au/hc/en-au/articles/360001428476-Class-SMSF-

Generate Data Export Files

Navigate to Fund Level > Reports > Run Report

  1. Search ‘Fund Transfer Data’
  2. Click on the report ‘Fund Transfer Data
  3. Select the Closing Balance for Period using the drop-down
  4. Select Run
    Class Fund Data Transfer Class to Class

A zipped files will be downloaded and saved in your Downloads Folder. Ensure that the five files remain in this zipped folder.

The Closing Balance for Period selected, should be the financial-year close you are bringing across to your Class business. The 30 June period update has been completed and finalised for the last financial year.

Generate Fund Specific Reports

Create a new Report Pack in the transferring Class business and call it ‘Transition Report Package’. Add the below reports to the newly created report pack:

Fund Specific Reports Required
– Member Statement
– Trial Balance
– Unrealised Capital Gains Report 
– Annual Return – SMSF

Once all reports have been added for each fund folder, place the fund folders into a batch folder. Zip your batch folder ready for uploading. 

To run the report package:

Navigate to Fund Level > Reports > Run Report Package

  1. Select the pack ‘Transition Report Package’
  2. Change the Report Date Range fields to the year-end close being transitioned as at date
  3. Select Run
    Class Super fund transfer report package

 

SuperMate

SuperMate Class Super Grow SMSF

This section will provide you guidance on how to successfully transition your funds onto Class from Supermate using a data export.

Prepare Data Export Files

Navigate to SuperMate > Task Bar > Multi-fund > Data Analysis > Extract Tool > Double click All Active Funds

  1. Where there are tick boxes, you will need to tick all the boxes except for “Account Balances”

    Note: You are able to run multiple extracts at the same time but you will need to run separate extracts for each different year-end.

  2. Extract the following data files:
    – Fund Status
    – Fund Data
    – Member Balances
    – Member Data
    – Summary Pension Data
    – TBAR Events (please run report for each financial year from 30/6/2017)
    – Account Balances
    – Asset Data
    – View Tax Parcels
    – Broker Reference Balances
    – Bank Account Balances
  3. Once you have run all the extracts, go to My Work > My Jobs and hit Refresh. Select the extract at the top of the screen, then double click on the attachment at the bottom of the screen. This should then open up as an excel spreadsheet. Please save this, and repeat for all extracts above.
Prepare Fund Specific Reports
  1. To load your funds we will require the following reports from SuperMate for each of your funds;
    – Consolidated Member Statements
    – Trial Balance
    – Annual Return
    – Accrued Capital Gains Report (PDF and XLS)
    – Fund Relation Detail Report
    – Investment Summary
    – Total Super Balance (if records available in SuperMate)
    – TBAR cancellations and pending cancellations (if records available in SuperMate)
    – TBAR Events History (please use Manual data collection form for SMSF)
    – For Wrap and Broker accounts, please provide either a Broker or Wrap statement that shows all of the assets held in the broker or Wrap account
    – For bank account details, please provide either the bank statement with the BSB and Account Number clearly readable, or alternatively provide a list of BSB’s, account numbers, and fund codes that the bank accounts belong to. If you have multiple bank accounts in a fund, you should also include a means for the team to tell which account belongs to which BSB/Account Number
  2. Prepare a folder for each of the funds you wish to transition
  3. Place a copy of the reports above in to the corresponding folder for each fund
  4. Once all files have been added to each of your folders, move folders into a BATCH Folder for Zipping
  5. Zip your Batch Folder

Leave a Reply

Your email address will not be published. Required fields are marked *

https://growsmsf.com.au/wp-content/uploads/2020/08/grow-inline-w950-e1597903176158.png
Contact

Suite 247 / 10 Albert Avenue

BROADBEACH QLD 4218

1300 651 263

07 5665 9979

contact@growsmsf.com.au

Twitter
@GrowSMSF – 17 hours

Can I buy shares in an unlisted company via an SMSF? Yes – just not from yourself or a related party

@GrowSMSF – 1 day

We’ve received a lot of interest in our Stake SMSF offer. Although this is not the official Super by Stake solutio…

Copyright © 2020 by Grow SMSF Pty Ltd. All rights reserved.

General Information Warning & Disclaimer

All information contained on this website is provided as an information service only and, therefore, does not constitute, and should not be relied upon as, financial product advice. None of the information provided takes into account your personal objectives, financial situation or needs, and you will need to make your own decision about how to proceed. Alternatively, for financial product advice that takes account of your particular objectives, financial situation or needs, you should consider seeking financial advice from an Australian Financial Services licensee before making a financial decision.

Grow SMSF does not hold an Australian Financial Services Licence (AFSL) and we are not authorised representatives of a AFSL. We do not provide financial product advice or recommend any financial products either expressly or implied.

From time to time Grow SMSF may produce information or content about specific financial products or services that enable access to specific financial products however we do not recommend, endorse or confirm as suitable any financial product or service featured on the Grow SMSF website or social media assets. This condition specifically applies to any financial product where Grow SMSF provides services at a discounted or preferential fee due to the use of those products, services or accounts. It’s not compulsory to utilise a specific account or service provider to be a client of Grow SMSF however the types of accounts, investments and service providers you use for your SMSF will determine the fees your SMSF is charged.

Where Grow SMSF provides information in relation to a financial product or service supported by or integrated with Grow SMSF the information is factual information only about the operation of the account or service and how data or reporting information is made available to us. Before making a decision on any financial product for your SMSF you should obtain a Product Disclosure Statement (PDS) relating to that product and consider the PDS before making any decision. As financial product and solution providers are frequently making changes to their products and services Grow SMSF cannot accept any responsibility for any outdated or inaccurate information provided on this website or via social media assets.

Grow SMSF Gold Coast based accountants looking after SMSF trustees from around Australia.

Liability limited by a Scheme approved under Professional Standards Legislation.