🗂️ How to Keep Crypto Transaction Records for Taxes (A Simple Spreadsheet Method)

Crypto transaction ledger example with date, type, asset, quantity and price columns

Most crypto tax problems do not start at tax time. They start months or years earlier, when nobody wrote down what was bought, sold, swapped or received. Exchanges close, wallets get abandoned and old CSV files disappear, and then you are guessing your own cost basis.

The fix is simple and free: keep a single spreadsheet where every transaction gets one row. In this guide you will see exactly which columns to use, how to log each type of transaction, a worked example with real numbers, and the mistakes that leave gaps in your records.

Important: tax and record-keeping rules differ by country. This guide teaches a method that works as a base almost anywhere, but check what your country requires.

Last updated: October 2026.

💸 How to Estimate Your Crypto Taxes: Cost Basis, Gains and Common Mistakes

Chart comparing the taxable gain on the same crypto sale under FIFO and LIFO cost basis methods.

Crypto taxes feel complicated because almost every move can be a taxable event, and exchanges do not always keep the records you need. The good news is that the math behind most of it is simple: what you received minus what you paid. Once you understand that idea, the rest is bookkeeping.

In this guide you will learn the core formula, which actions are usually taxable, how your cost basis method can change your bill, and the mistakes that cost people the most. You will see worked examples with real numbers.

Important: tax rules differ by country and change often. This guide explains the logic behind crypto taxes, not the law where you live. Always check your local rules or ask a qualified tax professional.

Last updated: October 2026.