Switching from Sharesight

This guide walks you through exporting your transaction history from Sharesight and importing it into TrackMyShares.

Step 1: Export your transactions from Sharesight

1. Log in to Sharesight on a desktop browser
2. Go to Tax > All trades report
3. Set the date range to cover your full trading history
4. Click Export and select Spreadsheet

The export includes these columns: Trade Date, Instrument Code, Quantity, Price in Dollars, Transaction Type, Market Code, Brokerage, Exchange Rate, and Comments.

Step 2: Import into TrackMyShares

1. Open your transaction-based portfolio in TrackMyShares
2. Click Import > Import portfolio transactions
3. Upload the Sharesight export file (XLS or CSV)
4. TrackMyShares auto-detects the Sharesight format and maps all columns automatically
5. Review the preview and check for any validation errors
6. Click Import transactions

Note: If you don't have a transaction-based portfolio yet, create one first. Transaction-based portfolios are available on the Pro plan and are required for tax report generation.

Step 3: Verify your portfolio

After importing, check that everything looks right:

• Compare your holdings against what you had in Sharesight
• Verify cost bases and transaction dates
• Check dividend transactions if applicable

Step 4: Generate your tax report

1. Open your portfolio
2. Click Tax report in the portfolio menu
3. Select the financial year
4. Review your capital gains, losses, and dividend income

The tax report calculates your capital gains using the FIFO method (first in, first out) and applies the CGT discount where applicable.

What transfers automatically

• Buy and sell trades with dates, quantities, prices, and brokerage fees
• Market detection (ASX maps to AUS, NYSE/NASDAQ maps to US)
• Comments from Sharesight are imported as notes

Good to know

• Exchange rates are not imported. TrackMyShares uses its own exchange rate data, so the Exchange Rate column from Sharesight is safely ignored.
• Stock splits are auto-detected and imported correctly.
• Capital returns (return of capital) are auto-detected and imported as dividend transactions with the "Return of capital" distribution type.
• Opening balances are imported as transfer-in transactions, establishing your existing holdings.

Troubleshooting

Sell before buy error

Ideally, import your full transaction history so that every buy is recorded before any corresponding sell.

If importing your full history isn't possible, you can import the previous year's portfolio valuation first. This creates a TRANSFER_IN for each holding, establishing an opening balance. Then import the current year's transactions on top of that.

This approach gives you what you need for a tax report, but there's one caveat: the portfolio valuation import records transfer-in dates as the date of the import, not the original purchase date. This means shares held for over 12 months may appear as short-term holdings rather than long-term, which affects the CGT discount.

To fix this, go to the affected holding, click the transactions icon, and edit the transfer-in transaction date to reflect when the shares were originally purchased.

Next steps

After importing your transactions, explore these features:

• Generate tax reports for EOFY with capital gains and dividend income
• Track dividends with franking credits and yield calculations
• Calculate CGT for individual transactions