|From the Main Toolbar, go to Connect.|
|Select Manage data feeds from the list.||
Under the Banks section, select Get Started.
From the Import CSV screen you can map and import Bank Statement transactions (using CSV files) into SF 360.
The CSV import function is available from the Bank Feed Management screen.
All transactions within the CSV file will need to use the dd/mm/yyyy format. If transactions from the start of the month are using the format d/mm/yyyy, they will not upload. The CSV file will need to be edited and the date formats amended.
Import into SF360
- From the Bank Feed Management screen, under the Actions column, select Import CSV File (for the bank account you are uploading transactions to).
- The Import CSV screen will appear.
- Select the CSV file from your server or computer. Select Choose File...
The transactions contained within the CSV file will appear below.
DR vs CR
Please ensure that the DR and CR columns are shown from Simple Fund 360's point of view.
If an amount is received by the bank account, this will be shown as a CR in the CSV file and will need to be swapped to a DR in the Simple Fund 360 CSV preview window.
The CSV file may be a double sided CSV file (the file contains separate Debit and Credit columns instead of a single amount column) and the column headers will need adjusting before the file can be uploaded to SF360.
In the example above, the Debit and Credit column headers will need to be selected before the file can be uploaded. To adjust the column headers, click the Please Select field and from the drop down list, input the correct header.
Once the column headers have all been selected, you can proceed to step 5.
- To upload transactions between a specified date range, input dates to not load before and after.
- Select Import.
Once the CSV file has been imported into SF360, you will be directed to the Smart Matching screen to reconcile any unmatched transactions from the CSV upload.
If no transactions are appearing after the successful upload, ensure the fund is in the same financial year as the CSV file is intended for. See Fund Details to review the current financial year.