Importing from SelfWealth

This guide walks you through exporting your trade history from SelfWealth and importing it into TrackMyShares to generate tax reports.

Step 1: Download your transaction history from SelfWealth

1. Log in to SelfWealth
2. Go to Settings > Trading Account > Reports
3. Under "Report Filters", tick Include Trades and Include Other
4. Under "Report Time Period", select Custom
5. Set the date range to cover your full trading history (e.g., from 01/01/2000 to today)
6. Click Export and select As CSV

Tip: If you've also traded US stocks through SelfWealth, download the US reports separately using the same steps.

Step 2: Prepare the CSV for TrackMyShares

TrackMyShares expects these columns for portfolio transaction imports:

Required columns

Optional columns

Formatting SelfWealth data

SelfWealth's CSV may need some adjustments:

• Market: SelfWealth doesn't include a market column. If all your trades are on the same exchange, set the market value in the column mapping UI during import (e.g., AUS for ASX trades). If you have a mix of ASX and US trades, add a Market column to the CSV with AUS or US per row, or import them as separate files
• Type: SelfWealth may use labels like "Buy" and "Sell" — both are auto-detected
• Fees: SelfWealth uses "Brokerage" — this is auto-detected
• Dates: SelfWealth typically uses DD/MM/YYYY format, which is auto-detected
• Numbers: Currency symbols ($), commas, and quotes are automatically stripped

TrackMyShares auto-detects common column name aliases. If auto-detection doesn't match a column, you can manually map it during the import process.

Example formatted CSV

Symbol,Market,Type,Date,Quantity,Price,Fees
CBA,AUS,BUY,2024-01-15,100,110.50,9.50
BHP,AUS,BUY,2024-02-20,200,45.00,9.50
VAS,AUS,BUY,2024-03-01,300,85.00,9.50
CBA,AUS,SELL,2024-06-10,50,115.00,9.50
CBA,AUS,DIVIDEND,2024-04-15,100,2.10,0

Step 3: Import into TrackMyShares

1. Open your transaction-based portfolio in TrackMyShares
2. Click Import > Import portfolio transactions
3. Upload your CSV or XLSX file
4. Review the column mapping — adjust any columns that weren't auto-detected
5. If prompted, select the correct date format
6. Review the preview — check for any validation errors or warnings
7. 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 4: Generate your tax report

Once your transactions are imported:

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.

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.

Separate AU and US files

If you downloaded separate files for ASX and US trades, import them one at a time. Make sure to add the correct Market column (AUS or US) to each file before importing. Exact duplicate transactions are skipped automatically.

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