Import trades from your broker's file

These brokers' files are recognised on upload, with no changes needed:

• CommSec (beta, so check the preview): ASX trades in AUD. Brokerage is worked out from the amount debited or credited; cash transfers and dividends are left out.
• Stake (beta, so check the preview): 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, so check the preview): 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, so check the preview): AUD markets only, filed as crypto. The fee in AUD, GST included, is the brokerage.

Any other broker works too, as long as its file has a header row and a row per trade with a date, code, buy or sell, units and price. You match the columns on screen, or fill in the import template. The import file guide lists every column and format.

1. In your broker's website, download your trade history (sometimes called transactions or confirmations) for as far back as it goes.
2. In Portfoli.au, open Upload a file from the Holdings page, the Dashboard or the menu, and choose the portfolio under Adding to.
3. Drop the file in. CSV or Excel (.xlsx), up to 10 MB.
4. If the file is recognised, you see which broker and what was assumed. Otherwise, check the column each heading was matched to, and change any that are wrong.
5. Check the dates. If the file could be read either way, choose day first or month first.
6. Choose the exchange for rows that don't say, usually the ASX.
7. Import. Your holdings, cost base and gains are worked out again straight away.

• The result lists rows recognised from an earlier import and not added again.
• Rows that couldn't be read are listed with their line number and what was wrong, so you can fix the file and upload it again.
• Lines that aren't trades, such as cash transfers and dividends, are left out of a recognised file.
• Compare the units of each holding with your broker's holding statement.

• Free: the last 12 months of a file are imported, and older rows are listed so you can see what was left out. ASX shares and ETFs only, up to 12 investments held at once.
• Plus and Pro: your full history, every market and crypto, with no limit on investments.

"That file has a header but no rows"

The file is empty below the headings, or isn't a CSV at all. Open it in a spreadsheet to check, and save it as CSV.

Dates are in the wrong month

The file was read month first. Switch to day first before importing, or delete the trades and import again.

An investment says something needs attention

A file is imported even if a sale comes before the purchase it used, because files list trades in every order. If, once everything is in, a sale is still more than you held, the investment's page says what needs attention. The purchase is usually missing because it is older than the file or was made at another broker. Add it, by hand or from an older file, and the figures are worked out again.

US trades show the wrong price

Make sure the currency column says USD and the exchange is US, so the trade is converted at that day's rate.

My broker's file isn't recognised

Match the columns by hand, or copy the trades into the template. Email support@portfoli.au with the broker's name if you'd like it added.

• Getting started with Portfoli.au: Create an account, get your first trades in, and find your way around.
• Email import: forward your contract notes: A private address for contract notes, how to forward them, and confirming each trade.
• Add, edit and correct trades: Type a trade in, change or delete one, and fix the usual mistakes.
• Understanding your returns and figures: Market value, cost base, gains, total return, yearly return and the benchmark line.
• All help, or the guides to investing and tax.

Still stuck? Email support@portfoli.au. New to Portfoli.au? Create a free account, with no credit card needed.