Importing transactions

If you have many transactions to record, CSV import saves time. This guide explains the transaction CSV format and import process.

CSV format for transactions

Transaction imports require more fields than holdings imports:

Required columns

Column	Description	Example
symbol	Stock ticker	AAPL
type	Transaction type	buy, sell, dividend
date	Transaction date	2024-01-15
quantity	Number of shares	50
price	Price per share	150.00

Optional columns

Column	Description	Example
fees	Brokerage fees	9.95
currency	Transaction currency	USD
notes	Your notes	Quarterly buy

Date formats

Supported date formats:

• YYYY-MM-DD (recommended): 2024-01-15
• DD/MM/YYYY: 15/01/2024
• MM/DD/YYYY: 01/15/2024

Example CSV

symbol,type,date,quantity,price,fees
AAPL,buy,2024-01-15,50,150.00,9.95
MSFT,buy,2024-01-20,25,380.00,9.95
AAPL,buy,2024-02-01,20,155.00,9.95
AAPL,dividend,2024-02-15,0,0.24,0
MSFT,sell,2024-03-01,10,400.00,9.95

Transaction types

Use these values for the type column:

• buy — Share purchase
• sell — Share sale
• dividend — Dividend received
• split — Stock split (use ratio in price field)

Dividend transactions

For dividends, use:

• quantity: Number of shares at ex-dividend date (or 0)
• price: Dividend per share (or 0 if using total)

Alternatively, put the total dividend amount in a total column.

Split transactions

For stock splits:

• quantity: Your shares before the split
• price: Split ratio (e.g., 4 for a 4:1 split)

Importing your file

1. Ensure your portfolio is transaction-based (not cost basis)
2. Click Import > Import transactions
3. Upload your CSV file
4. Review the parsed transactions
5. Fix any errors shown in red
6. Click Import transactions

Preview and validation

The preview shows:

• Date — When the transaction occurred
• Type — Buy, sell, dividend, or split
• Symbol — Stock ticker
• Details — Quantity, price, fees
• Status — Valid, warning, or error

Fix any errors before importing. Common issues:

• Invalid dates
• Unknown symbols
• Selling more than owned
• Missing required fields

Importing from brokers

CommSec

1. Go to Activity > Trade confirmations
2. Export to CSV
3. Adjust columns to match our format

Stake

1. Account > Statements
2. Download transaction history
3. Format: date, symbol, type, quantity, price

Interactive Brokers

1. Reports > Activity
2. Select Trades
3. Export as CSV
4. May need to split into buys and sells

Note: Each broker exports differently. You may need to use a spreadsheet to reformat before importing.

After importing

Review your imported transactions:

1. Check the transaction history for each holding
2. Verify your cost basis looks correct
3. Confirm quantities match your broker statement

If something looks wrong, you can edit or delete individual transactions.

Handling duplicates

If you import transactions that already exist:

• Exact duplicates — Skipped automatically
• Similar transactions — Flagged for review

To avoid duplicates, only import new transactions not already in your portfolio.