Have you recently switched to Simple Fund/Invest 360? Are you managing multiple entities of varying types? Well, say goodbye to the hassle of creating entities one by one and say hello to our new streamlined, hassle-free entity management.
Introducing Bulk Entity Setup
Simply upload a Excel file containing all your entity data, and our bulk entity setup function will take care of the rest!
Navigation
| From the Main Toolbar, hover the cursor over the Home icon. | |
| From the Home side-menu, select Bulk Entity Setup |
1. Reach out to your fund administrator and ensure 'Bulk Entity Setup' is toggled on for your user role.
This setting will be toggled on by default for Account Owner, Admin, and BGL Success. For more information, refer to User Roles.
2. Ensure that your license contains sufficient entities to enable you to proceed with the import.
Refer to the bulk entity setup screen, to view the number of entities remaining. To proceed with any upgrades, refer to MyBGL Products.
Currently, only SMSFs, Trusts, and Companies can be imported. The import of 'Individual' entity types is not supported at this time.
Step 1: Download the Excel template here.
Step 2: Fill out the spreadsheet. A maximum of 200 entities (SMSFs, Trusts, and Companies) can be entered here.
Field Mapping Guide |
|
| Entity Name | Mandatory for SMSF and other entities. |
| Entity Type | Mandatory for SMSF and other entities. Select between the supported entity types: SMSF, Trust or Company. |
| ABN | Mandatory for SMSF (optional for other entities). |
| Date Formed | Optional. If not selected, the system will default to last financial year start date. |
| Financial Year Start | Optional. If not selected, the system will default to last financial year start date. |
| Financial Year End | Optional. If not selected, the system will default to last financial year end date. |
Supported Date Format:
- dd/mm/yyyy
- dd-mm-yyyy
- yyyy/mm/dd
- yyyy-mm-dd
Step 3: Drag and Drop or Click to Browse the updated Excel file.
Step 4: The first 5 records from the selected file will preview. Map the relevant mandatory fields.
Scroll to the right to finish mapping.
Step 5: Select import to bulk import the entities, or select cancel to return back.
Step 6: As the entities are uploading, do not leave the Bulk Entity Setup screen. Once successful, your entities will appear under the Entity Selection screen.
The Bulk Entity Upload has failed. What do I do?
If the bulk entity upload fails, NONE of the entities recorded in the original Excel will be imported.
An error report (in CSV format) will be automatically downloaded. This report will clearly state the reason for the failure.
Users should address the 'Failure Reason' provided in the report and upload the entire file once again.
| Scenarios | Actions |
| Insufficient license | Please upgrade your license and upload the entire file once again. |
| Exceeded the 200 entities limit | A maximum of 200 entities is allowed per Excel file. Please split your entities into separate Excel files and try again. |
| Missing Entity Name |
The Entity Name field is missing. Please review, and upload the entire file once again. |
| Missing Entity Type |
The Entity Type field is missing. Please review, and upload the entire file once again. |
| Missing ABN |
A valid ABN must be entered for all SMSF records. Please review, and upload the entire file once again. |
| Invalid ABN |
Please ensure the entered ABNs are correct and then upload the entire file once again. |
| Invalid Entity Type |
Supported values are SMSF, Trust or Company. Please specify the Entity Type using the supported values and then upload the entire file once again. |
| Establishment date must be on or before FY start date |
The selected 'Date Formed' should be on or before the Financial Year Start Date. Please review, and upload the entire file once again. |
| FY end date must be after FY start date |
The selected 'Financial Year End' should be on or before the Financial Year Start Date. Please review, and upload the entire file once again. |