| Feed Type | Cash Movements (Bank Transaction) | Investment Movements (Buy & Sells) | Income Movements (Dividends & Distributions) | Historical Data |
| Manual |
Overview
A BGL Import XML upload is available in Simple Fund 360. This XML will provide you investment, cash and income transactions and can be uploaded via the Wraps screen.
There are three main steps required to import transactions using this XML template:
- Open the downloaded XML template and fill the XML sheets with relevant transactions.
- Setup Simple Fund 360 to receive the XML file.
- Import the XML file into Simple Fund 360
BGL XML Import Template
To download the XML Import template, click here: BGL XML Import Template.xls
Setup XML Template
IMPORTANT: Unblocking the XML file is required for full functionality.
You may need to unblock the file before using the functions of the template.
To do this, you will need to right-click on the file > Properties > General > tick ‘Unblock’ > Click "OK" (see instructions below).
Editing the Template
Depending on your security settings, you may be asked to both:
- Enable Editing
- Enable Content
Answering affirmative is required for the XML template to function properly.
If creating XML files for multiple entities, it is recommended to copy the spreadsheet for each entity required. Creating a duplicate of the XML template is suggested at this point.
Two sheets are available for editing in this template, accessible in the bottom left-hand corner:
See the relevant tab below for instructions.
Transaction File Sheet
1. Clear the example data by clicking Clear ALL Transaction Data.
Clear All
Clicking Clear ALL Transaction Data will remove all data entered into the tab, including anything entered manually. This cannot be undone.
2. Hover your mouse over a red triangle in a tab in the top right corner to learn more about the column requirements.
3. Enter one transaction per line. Users can select the Security Type for a unitised investment by clicking on the tab and selecting it from the drop-down.
Validation
The XML file will constantly validate the information entered to ensure that each appropriate field has been completed correctly based on the Transaction type selected.
4. Foreign currency conversion is supported using The BGL XML importer (Bank Transaction type only).
Prior to uploading the file, in the currency column, select a currency for Simple Fund 360 to automatically convert the amount on the transaction date using the Foreign Currency screen information (end of day rate). If no currency is selected, AUD is the default currency. Refer to Foreign Currency for supported currencies. In the amount column record the foreign currency amount.
5. Click Create Transaction File.
6. You will be asked to confirm the ranges of the cells used to generate the XML file (this will be pre-filled) and where you would like to save the generated XML file.
7. Upload XML File.
Investment Opening Balances Sheet
Investment purchase parcel history when inputting opening balances can be recorded under the Investment_OpeningBalance tab. The Notional Gains column can be used for 30/06/2017 balances where Transitional CGT Relief was applied in an external software.
1. Clear the example data by selecting Clear ALL Transaction Data.
Note: Clicking Clear ALL Transaction Data will remove all data entered into the tab, including anything entered manually. Ensure only example data has been removed.
2. Input the following information for each parcel.
3. Select Create Transaction File
Setup in Simple Fund 360
To import an XML file, you will need to first set up a file import data feed within Simple Fund 360, please navigate to the Feed Management screen and follow the below instructions.
Within the Feed Management screen, click the "+ setup" button to create a new feed.
-
Entity Name - Ensure that the correct entity has been selected.
-
Feed Provider - Select ‘BGL File Import’.
-
Account ID - Keep account ID as ‘BGL’.
-
Bank Account - Select a Bank/Cash Account to link to this feed.
The XML file can import data for more than one bank account, however, if no bank details are listed for Bank Movements within the BGL XML File Import Template, these bank movements will be loaded to this default bank account selected in the feed set up. -
Do Not Import Data Before - Users can restrict the data that is imported by the feed by inputting a date. Clicking on the three dots will allow you to also enter a Do Not Import Data After date. If data has already been manually entered, this step will be necessary to prevent any duplication with manual work.
-
Account Mapping - Users are required to link asset accounts to the feed to ensure that data is allocated to the desired asset accounts. If this step is not completed, the system will create new accounts to allocate the data to. If this results in duplicate asset accounts, please refer to our help article Wrap Feed has created duplicate accounts?
-
Save - Click this button to ensure that any changes made are saved.
Once saved, you will be able to import the XML file (see 'Import XML File' tab).
Import XML File
Please Note
Transactions will not be imported for period where Create Entries have been processed.
You will be taken to the File Import page where you can drag and drop the XML file into the upload box, or click on the upload box to browse your computer for the XML file.
*Please note there is a size limit of 15MB,
**For larger files, the process may take up to 10 minutes. Users can check the uploading progress by checking the Transaction List, or Advanced Options & Reports > File History > a CSV report will be generated as data gets imported.
Reverse an XML Upload
| From the Main Toolbar, go to Accounting |
|
| Select Transaction List |
1. Next to the search bar in the top right-hand corner, click on additional filters:
3. Select the topmost checkbox in the Transaction List to select all transactions related to the transaction filter. This will select all the transactions from the XML File Upload.
4. Click on Delete, and then confirm OK:
Transaction Type Reference
| Bank Transactions |
|---|
|
Banking entries are any transaction that increase/decrease the bank's balance such as fees, non-unitised term deposit interest, and pension payments. Input the banking details next to each transaction and this will load transactions as follows: DR/CR 60400/BANKCODE DR/CR 91000 (Bank Data Clearing Account for Transaction Matching). Multiple banks can be supported in the one file. Ensure that the bank chart account and it's details (BSB/Acc Number) are recorded in Simple Fund 360. Imported transactions containing identical bank details will be matched with these bank accounts.
Expenses are recorded with a negative sign in front of the amount. Required fields: Transaction Date Amount |
| Income Transactions |
|
Record income transactions for unitised investments (such as share dividends). Tax data can also be recorded. Select the Security Type and record the security code (both listed and unlisted securities supported) to map the transaction to the correct income account.
Required fields: Transaction Date Amount Security type Security Code Example DR 60400/BANKCODE CR 23900/INVESTCODE |
| Investment Transactions (Unitised) |
|
Record unitised investment purchases and disposals with purchase/disposal parcel amounts. Select the Security Type and record the security code to map the transaction to the correct account.
Required fields: Transaction Date Amount [purchases = positive (DR) | disposals = negative (CR)] Security type Security Code Quantity Example: DR/CR 60400/BANKCODE DR/CR 77600/ASX |
Frequently Asked Questions
Yes, Cryptocurrency trades can be recorded within the Excel XML Template.
For these trades, make sure Cryptocurrency is selected as the Security Type. Upon import, these transactions will then be posted to the relevant cryptocurrency accounts in Simple Fund 360.
Yes, the BGL Excel XML Template supports all Security Types, including shares in companies listed on foreign stock exchanges.
Ensure that the correct security suffix is input in the Security_code column:
| Market | Security Suffix |
|---|---|
| New York Stock Exchange | .NYE |
| New York ARCA Exchange | .ARCX |
| NASDAQ | .NDQ |
| London Stock Exchange | .L |
| Hong Kong Exchange | .HKX |
| Singapore Exchange | .SGX |
| Cryptocurrency | .COIN |
|
Transaction Type
|
Matching Logic
|
|---|---|
| Bank Transactions |
Transactions will match one side to the bank and the contra side to the clearing account 91000. Transactions can then be matched via Transaction Matching. |
| Income Transactions | Income transactions will be matched to the correct account code during upload based on the Security Code column. Non Unitised investment income transaction cannot be input in this tab. This income is input in the Bank Transactions tab. |
| Investment Transactions |
Purchases and Disposals will be matched to the correct investment account during upload based on the Security Code column. |