Portfoli.au
Start free

Guide

Import file guide

How to write a file of trades that Portfoli.au can import. Use it for a broker we don't recognise yet, or to type up trades by hand.

The file

Start from the import template.

  • CSV (comma separated, UTF-8) or Excel (.xlsx), up to 10 MB.
  • The first row is the header, with the column names below. Their order doesn't matter, and other columns are left out.
  • One row per trade. Each row is matched by its contents, so importing the same file twice doesn't add the trades twice.

Columns

Trade Date
The day of the trade. 2026-03-16 is best. 16/03/2026, 16 Mar 2026 and Mar 16 2026 also work; slashed dates are read day first unless the file proves otherwise.
Ticker
The code the market lists it under, such as BHP, VAS, AAPL or BTC. Leave off any suffix such as .AX.
Type
BUY or SELL. Bought, sold, purchase and sale are also understood. A column headed Buy or sell, Side or Action is also recognised.
Quantity
Units bought or sold, always positive. Fractions are fine.
Unit Price
Price per unit in the trade's currency, without brokerage. $ signs and commas are ignored.
Brokerage (optional)
The fee for the trade, GST included, in the trade's currency. Blank means none.
Currency (optional)
Three-letter code such as AUD or USD. Blank means AUD.
Exchange (optional)
One of the exchange codes below. Blank means the exchange chosen on the import page.
Note (optional)
Anything you want to keep with the trade.

Example

Trade Date,Ticker,Type,Quantity,Unit Price,Brokerage,Currency,Exchange,Note
2026-03-16,BHP,BUY,250,40.85,9.50,AUD,ASX,
2026-05-02,AAPL,BUY,10,212.40,3.00,USD,US,Through Stake
2026-06-29,BHP,SELL,40,44.10,9.50,AUD,ASX,

Exchange codes

  • ASX: Australian Securities Exchange
  • US: Any US exchange. NASDAQ, NYSE, AMEX, NYSEARCA, ARCA and BATS are also accepted and filed as US
  • NZX: New Zealand Exchange (Plus)
  • LSE: London Stock Exchange (Plus)
  • TSX: Toronto Stock Exchange (Plus)
  • HKEX: Hong Kong Stock Exchange, four-digit codes such as 0700 (Pro)
  • SGX: Singapore Exchange (Pro)
  • XETRA: Xetra, Germany (Pro)
  • EPA: Euronext Paris (Pro)
  • AMS: Euronext Amsterdam (Pro)
  • SIX: SIX Swiss Exchange (Pro)
  • CRYPTO: Crypto, on any platform (Plus)

Overseas trades are converted to Australian dollars at that day's exchange rate. Markets other than the ASX need the Plus or Pro plan.

Broker files read as they are

Upload these as they come from the broker. There's no need to use the template.

  • CommSec (beta): ASX trades in AUD. Brokerage is worked out from the amount debited or credited; cash transfers and dividends are left out.
  • Stake (beta): USD trades are US-listed, AUD trades are on the ASX. Brokerage is Stake's fee plus its GST. Exchange rates are filled in from the day's rate.
  • Selfwealth (beta): ASX trades in AUD, dates day first.
  • Raiz: ASX trades and Bitcoin, in AUD. Raiz charges a monthly fee rather than brokerage, so no fee is recorded on each trade.
  • CoinSpot (beta): AUD markets only, filed as crypto. The fee in AUD, GST included, is the brokerage.

Importing

Sign in, open Import, and upload the file. You see what was read before anything is saved. A row that can't be read is left out and listed with its line number.