Back to brokers & apps

CommSec

Import all of your buy and sell history from CommSec into Sharesight with the spreadsheet file importer. You can also automatically sync all future trades into your Sharesight portfolio.

Import your Commsec trade history

Setup automatic sync for ongoing trades

Import trades history

1 - Log into your Commsec Account.

2 - Visit the Trading tab and select Confirmations from the menu on the left.

Frame 5 (1)

3 - Select the right account from the dropdown list.

4 - Make sure that both Buy and Sell order types are selected.

5 - Set the correct date range and click search.

6 - Click the Download CSV link.

7 – Login to Sharesight.

8 - On the Let's get you started with Sharesight page, select the Import from a Broker tile.

Frame 1 (1)

9 - Click on the CommSec tile.

Frame 2

10 - Click the Upload a file button.

11 – Select the CSV of trades you wish to import.

12 - Click import.

Note: If you have changed brokers and transferred the holdings to CommSec these trades will not be imported into Sharesight, and will need to be added manually.

13 – The ‘Ready to Import’ page will show an itemised list of all trades imported from your CommSec trading account. Verify and edit the trade data as required.

Trades appear under 'Rejected trades' page contains some errors that needs to be fixed, please refer to common errors page on how to fix them

14 – Once you have verified the trade data, click ‘Finish and Import all’.

Frame 3

15 - Once the trades are saved, your Sharesight portfolio will be populated and the Portfolio Overview Page will load.

Frame 4

Your holdings will be calculated with Sharesight’s performance calculation methodology, which is a money-weighted return methodology, meaning the performance figures take account of the size and timing of cash flows.

Sharesight will automatically create dividends and corporate actions for the holdings you have imported.

Setup automatic sync for ongoing trades

Embedded content: https://www.youtube.com/watch?v=sofy6i95kGg&t=134s

  1. In Sharesight, from any page click on the Settings tab.

  2. Under Connection, click the Trade Confirmation Emails side tab.

  3. Select Copy next to the email address.

  4. Log in to your CommSec account

  5. Go to Settings

  6. Click on View or edit details and follow the security prompts

  7. Scroll down to the Contact details section and select Edit

  8. Click +Add new email

  9. Paste email address > Select Add email > Save updates

  10. Go to Portfolio

  11. Select Accounts and then use the dropdown to choose the relevant account

  12. Click on View or edit account details

  13. Scroll down to the Trade confirmations section and click Edit

  14. Select the portfolio email address under Copy to

  15. Click Save

CommSec will send a copy of all future buy or sell to your portfolio going forward.

Note: Keep in mind Commsec only send trade confirmations for market buy & sell trades. If you have any off-market trades or corporate action i.e SPP, IPO, rights issue, M&A, demerger etc, you need to manually update your portfolio.

Please refer to Commsec support for more information.

Now that you have populated your portfolio we recommend you:

1 - Review the trades imported:

a – Handle any negative holdings - Holdings with less buy trades than sell trades (occurs when you have transferred stocks from another broker).

b - Check fractional share trades for rounding differences.

c - Exchange rates are generated by Sharesight using the end of day exchange rate. These can be edited within the trade.

d - Handle any non automated corporate actions such as mergers etc.

2 - Verify and confirm automatically generated data (dividends and corporate actions).

3 - Share access to your portfolio with your accountant.

4 - Add your other investments to Sharesight.

5 - Use Sharesight to help you complete your tax return.