How do I import transactions?

Administrators only

You can import your transactions using the excel template or manually in 2 different ways:


  1. You can either upload a cash balance initially and then purchase instruments using that cash balance. If you do not do this, and you choose a settle currency that doesn’t have a cash balance in, it will result in a borrowing.
  2. Or you can use the position uploader/select transfer in the settlement currency box to upload a position, this will result in no opposing cash deduction or addition if you are uploading a short position

A few tips to help you import transactions easily:


  • After you populate the excel and upload it to illio, you will be taken to a review page. Before illio pulls the data through to your portfolio, you can check the correct information has been recognized from the excel
  • illio will highlight any transactions that have data gaps, which you can manually edit from the review page
  • Make sure your instruments are formatted correctly according to the instructions on the second sheet
  • Add an exchange code at the end of the ticker for a higher chance of immediate identification