Wealth
Crypto portfolios
Track coins and cash at each exchange from its export files, valued at market prices, with a capital gains report for each financial year.
A crypto portfolio holds the coins and cash you have at one exchange. It’s valued at market prices and counts in your net worth at what it’s worth today.
Adding a portfolio#
- Open Investments and choose Add a portfolio.
- Set Holds to Crypto.
- Give it a Name and the Exchange it’s held with, then choose Add.
Add one portfolio per exchange.
Cash at the exchange#
An exchange keeps your cash itself, so a crypto portfolio holds it too. Deposits add to it, buying coins spends it, and selling fills it back up.
Cash is kept for exchanges whose files show money going in and out: BTC Markets, Swyftx, Independent Reserve, Kraken and Binance. CoinSpot, Coinbase and Crypto.com files don’t show it, because coins are bought by card or from a separate cash wallet. Those portfolios don’t keep cash.
Importing from an exchange#
Drop the exchange’s file on the portfolio’s Import tab and check the preview. These are read straight in:
| Exchange | File | Where to get it |
|---|---|---|
| BTC Markets | Transaction report (best), tax transaction report, wallet report | Account › Reports |
| CoinSpot | Buys/Sells CSV, and Send/Receive CSV | My Account › Order History |
| Swyftx | Transaction report (CSV) | Transactions › Transaction reports |
| Independent Reserve | Transaction history (leave “rollup trades” off) | Transactions › Download |
| Kraken | Ledgers (ledgers.csv) |
History › Export › Ledgers |
| Coinbase | Transaction history (CSV) | Profile › Reports |
| Binance | Transaction history (“Generate all statements”), or spot trade history | Wallet › Transaction History › Export |
| Crypto.com | App transactions (crypto_transactions_record) |
Accounts › History › Export |
Bringing in a file twice, or two files that overlap, never doubles up.
Other exchanges#
Any other exchange works by picking its columns once: coin, amount, date, and a type column (buy, sell, deposit, withdrawal, reward and so on). Price, fee and what prices are in are optional. Give the layout a name under Remember as and it’s used for files with the same columns.
Typing one in#
On the Trades tab, choose Add a trade. Pick Bought, Sold, Received, Sent, Deposited cash or Withdrew cash.
With the Sync extension#
The Sync extension works here the same as with a bank. Record the export on the exchange’s site once, and each sync brings in the new file. It goes to the portfolio you link the site to. Without a link, it goes to your only crypto portfolio, or the one held with that exchange.
How things come in#
- Coin for coin (BTC for ETH, or anything for USDT): a sale of one and a buy of the other, both at that day’s market value. That’s how a swap is taxed in Australia.
- Rewards, staking, interest and airdrops: income at what the file says they were worth, or that day’s market price. An airdrop from a chain split (like ETHW) comes in at no cost.
- Times: most exchanges give UTC times, which are dated in your pool’s time zone. CoinSpot and Swyftx give local times, kept as the file has them.
- Left out: futures and margin, moves between an exchange’s own wallets (to staking and back), and anything the reader doesn’t know. These are listed in the preview.
BTC Markets wallet reports#
A wallet report doesn’t say which year it’s for, so the import asks. It suggests the last financial year to end. Your trades are checked against it, cash included. What it says each coin was worth becomes that day’s price.
Prices#
Each pool picks its crypto price feed in Settings › Pool, under Crypto prices.
- CoinGecko (the default). Free, no key, thousands of coins in most currencies. A free Demo API key from coingecko.com lets prices update more often. CoinGecko’s history only reaches back a year, so older daily prices come from Coinbase, in US dollars converted at that day’s rate.
- Yahoo Finance. Free, no key, but only well-known coins.
Coins in a portfolio are priced in its account’s currency. Prices update every 15 minutes, day and night. A coin both feeds miss (rare ones, airdropped forks) is valued at its last trade, or what a wallet report said it was worth.
What’s worked out#
- Cost base: what the coins you hold cost, fees included, on average. A sale takes its share of the cost. The difference is the gain locked in.
- Gain: what your holdings are worth now, less their cost.
Tax time#
The portfolio’s Tax tab shows one financial year at a time, using your pool’s financial year start. It opens on the last year to end.
- Net capital gain or loss, with gains split into coins held 12 months or less and over 12 months.
- Each sale, matched against the units it used up, oldest first (first in, first out), with its cost base, proceeds and gain. Coin-for-coin swaps count as sales.
- What was held at the year’s end, at that day’s prices.
For an Australian pool, the 50% CGT discount comes off gains on coins held over 12 months. Losses come off the other gains first. The rules follow Capital gains rules in Settings › Pool, which starts from the pool’s language and region. Elsewhere no discount is worked out. Losses carried in from earlier years aren’t known here.
Three downloads match BTC Markets’ own year-end files, for a tax agent or tax software: Year-end balances, Year’s transactions and Capital gains, with its totals.
The tax report is a record of what happened, not tax advice.
Stopping tracking#
Stop tracking on the Setup tab removes the portfolio’s trades and holdings, and it leaves your net worth. The account and its transactions stay.