Import CommSec trades

Content also available for tax entities or on our global site.

Import historical trades

Import your historical buy and sell trades to Sharesight directly from your CommSec account.

Note: This only imports your trade history, once you have imported your history, set up the Trade Confirmation Emails feature to automatically import future trades.
You will require a CSV file export out of Commsec to import your trading history into Sharesight. You can do this by following the below steps.

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 account that you’d like to import into Sharesight from the dropdown list

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

5 - Select your desired date range and click the search button

6 - Click the Download CSV link

Once your file is downloaded, you can import it into Sharesight through the below steps

1 – Login to Sharesight.

2 - On the ‘Let’s get you started with Sharesight’ page, select the ‘Import from a Broker’ tile.

Frame 1 (1)

3 - Click on the ‘CommSec’ tile on the ‘Import from a Broker’ page.

Frame 2

4 - From the ‘Import your CommSec trade account with Sharesight’ click the ‘import from a file’ button

5 – Select the ‘Confirmations’ file downloaded to import

6 - Click import.

Note: If you have changed brokers and transferred the holdings to CommSec these trades will not be imported into Sharesight. Due to a chess transfer.

7 – The ‘Trades to import into Portfolio:’ page will show an itemised list of all trades imported from your CommSec trading account. Verify and edit the trade data as required.

If trades appear in red, this means that Sharesight can’t upload the trade or the trade will cause errors in your portfolio.

A common error issue when importing from a Broker is:

Saving this trade would result in a negative number of Shares being held

This means you are importing more sell shares of a stock than bought shares. It happens if you have transferred stock from another broker or have any off-market trades.

Click ‘Import anyway’ for each of these stocks. Then handle them later in Sharesight.

The solutions to other common errors can be found here.

8 – Once you have verified the trade data, click ‘Save all transactions’.

Frame 3

9 - 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 by Sharesight’s performance calculation methodology which is a money-weighted return methodology, meaning the investment performance takes account of the size and timing of cash flows.

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

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 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 - Set up the Trade Confirmation Emails feature to automatically import future trades.

4 - Share access of your portfolio with your accountant.

5 - Add your other investments to Sharesight.

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

## Automatically keep your portfolio up-to-date

Embedded content:

Please refer to Commsec support for more information.

  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 confirmation for market buy & sell. If you have any off-market trade or corporate action i.e SPP, IPO, right issue, M&A, demerger etc, you need to manually update your portfolio.

Last modified on December 30, 2022 UTC

Try Sharesight today
Track 10 holdings for free.
Sign up for Free