Crypto records
What FIFO cost basis actually means for your crypto records
FIFO means “first in, first out.” When you sell a coin, the units you are treated as selling are the oldest units you still hold. The cost of those old units is your cost basis. The difference between what you sold them for (minus fees, in most simple models) and that cost basis is a realised gain or loss.
That sounds small until you have bought the same asset five times, sold twice, received a staking reward, and the tax year does not start on 1 January. A portfolio app that only shows “current price minus average buy” is not the same thing as a lot-matched gain by tax year.
What you actually need to record
- Each buy: date, asset, quantity, cost in your currency, fees.
- Each sell: date, asset, quantity, proceeds, fees.
- Income (staking, airdrops, interest, being paid in a token): date, quantity, fair value when you received it. In many places that value also becomes the cost basis of those units.
Transfers between your own wallets are usually not sales, but they are where records get messy. Keep them in the notes so you do not treat a transfer as a disposal.
Limits of a FIFO spreadsheet
Some countries do not use plain FIFO. The United Kingdom, for example, has pooling rules and same-day / 30-day matching that a simple FIFO sheet will not apply for you. Some places split short-term and long-term gains. Some treat crypto-to-crypto swaps as disposals. A FIFO tracker is a way to keep organised figures and a lot history you can check with an authority or an adviser. It is not a tax return.
A private sheet, no wallet connection
The Crypto Portfolio & Tax-Lot Tracker matches sales FIFO down to 8 decimals, tracks up to 50 coins, and summarises realised and unrealised gains plus income for eight tax years, with a tax year that can start on any date. No API keys, no subscription. $9; code HODOYOKU25 is 25% off until 31 January 2027.
Tax rules differ by country. This is not tax, financial or investment advice. Check with your tax authority or an adviser before you file.