Importing from Stake

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

Step 1: Download your transaction history from Stake

Stake provides your full transaction history as a downloadable report.

Using the Stake app

1. Open the Stake app
2. Go to More > Tax & documents
3. Select Account summary report
4. Choose the financial year or date range you need
5. Select CSV as the export format
6. The report will be emailed to you or available for download

Using the Stake website

1. Log in at hellostake.com
2. Navigate to Profile > Tax & documents
3. Select the report covering your desired period
4. Download the CSV file

Tip: If you only see PDF as an option, check under Account summary report for CSV export. You can also find trade confirmations under Tax & documents > Trade confirmations.

Step 2: Prepare the CSV for TrackMyShares

TrackMyShares expects these columns for portfolio transaction imports:

Required columns

Column	Description	Example
Symbol	Stock ticker	AAPL
Market	Exchange or market	US, AUS, CRYPTO
Type	Transaction type	BUY, SELL, DIVIDEND
Quantity	Number of shares	50
Price	Price per share	150.00
Date	Transaction date	2024-01-15

Optional columns

Column	Description	Example
Fees	Brokerage or commission	9.95
Withholding Tax	Tax withheld at source	15.00
Franking Credits	Australian franking credits	0.32
Amount	Total transaction amount	250.00
Notes	Additional notes	Quarterly buy
External ID	Broker trade reference	12345

Mapping Stake columns

Stake's export may use different column names. TrackMyShares auto-detects common aliases like "Ticker", "Stock Code", "Side", "Action", "Trade Date", "Qty", "Units", "Commission", and "Brokerage". If auto-detection doesn't match a column, you can manually map it during the import process.

Formatting tips

• Transaction types: Both uppercase (BUY, SELL) and lowercase (buy, sell) are accepted. Common aliases like "Purchase" and "Sale" also work
• Dates: Multiple formats are supported including YYYY-MM-DD, DD/MM/YYYY, and MM/DD/YYYY. The system auto-detects the format, or you can select it manually if the detection is ambiguous
• Symbols and markets: Use a separate Market column instead of a suffix. For example, use Symbol = CBA with Market = AUS rather than CBA.AX. Accepted market values include US, AUS (also ASX, AU), and CRYPTO. If all your transactions are for the same market, you don't need to add a column to the CSV — just set the market value in the column mapping UI during import
• Fees: Stake offers zero brokerage on US trades, so this column can be 0 for most transactions
• Dividends: Use type DIVIDEND with the number of shares held at the ex-dividend date in Quantity and the per-share dividend amount in Price. Alternatively, provide the total dividend in the Amount column
• Numbers: Currency symbols ($), commas, and quotes are automatically stripped from numeric values

Example formatted CSV

Symbol,Market,Type,Date,Quantity,Price,Fees
AAPL,US,BUY,2024-01-15,10,185.00,0
MSFT,US,BUY,2024-02-20,5,410.00,0
AAPL,US,SELL,2024-06-10,5,195.00,0
AAPL,US,DIVIDEND,2024-05-10,10,0.25,0
CBA,AUS,BUY,2024-03-01,100,110.50,9.50
CBA,AUS,DIVIDEND,2024-04-15,100,0.75,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

Symbol not found

If a stock symbol isn't recognised, check that:

• US stocks use the standard ticker (e.g., AAPL) with Market set to US
• ASX stocks use the ticker without a suffix (e.g., CBA) with Market set to AUS

Missing transactions

If some rows fail to import:

• Check the date format is consistent across all rows
• Verify required columns (Symbol, Type, Quantity, Price, Date) are present
• Verify there are no extra spaces in column headers

Sell before buy error

Ideally, import your full transaction history from Stake so that every buy is recorded before any corresponding sell. This avoids balance issues entirely.

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 including US withholding tax
• Calculate CGT for individual transactions