Record-Keeping · September 30, 2026 · 13 min read · By CryptoTaxCalc Team

I Spend 15 Minutes a Week on Crypto Tax Records. Here's the Exact System.

My first crypto tax year took a brutal reconstruction weekend in January. My last one took an evening on the sofa. Nothing changed about my trading — what changed was a plain spreadsheet and a Friday routine. Here's the whole system, including the one column each of the seven countries actually cares about.

Image: Illustrative purposes. Record-keeping expectations drawn from IRS Publication 551 and Form 8949 instructions, HMRC Cryptoassets Manual record-keeping guidance, §23 EStG documentation practice, CRA folio S5-F3-C1, ATO CGT record-keeping rules, NTA cryptoasset reporting and Indian VDA/TDS provisions.

January 2022, I sat down to do my first ever crypto tax return and made the classic discovery: I had a portfolio screen that told me I was up 40%, and approximately zero documents that told a tax office how. Eleven months of trades across two exchanges, one coin-to-coin phase I'd forgotten, a wallet transfer, and a handful of staking drips. I spent a weekend piecing it together from email receipts and squinting at exchange dashboards that had since redesigned themselves.

I never want that weekend back. So I built the least glamorous piece of infrastructure in crypto: a boring spreadsheet and a recurring calendar event. It takes about fifteen minutes on a Friday evening, an hour at month-end, and filing season now takes one evening.

This isn't a template sales pitch. It's the exact system, free, and it's deliberately country-agnostic at the collection stage — because whether you file in Austin, Aberdeen or Adelaide, crypto tax record keeping starts with the same five facts.

The five facts every record needs

A tax office doesn't care about your P&L chart. For each event it needs to answer five questions: when did it happen, what moved, how much moved, what was it worth in real money, and what did it cost you. Everything else — FIFO, the British pool, Canadian averaging — is just a different way of slicing these five facts later.

Two rules about the sheet itself. Timestamps stay in UTC, every single row — mixing timezones will quietly corrupt holding-period buckets. And the sheet is append-only. I never delete a row; if something turns out to be wrong, I add a correction note. Tax records are a ledger, not a whiteboard.

Friday evening: fifteen minutes

Every Friday, phone timer on, I do five things:

1. Append the week's fills. I open each exchange app and email the weekly activity statement to myself, then add any rows the export won't capture cleanly. This is usually two or three rows — buys, a sell, maybe a swap. If it was a wild week, ten. The point of doing it weekly is that I remember what each trade was. In January I won't.

2. Label the non-trades. Wallet-to-wallet moves, exchange-to-hardware-wallet deposits, bridge transfers get marked SELF-TRANSFER with the receiving address. This row is the most valuable documentation in the whole system — it's what stops coins arriving at a new venue from looking like free income. More on that in the transfer guide.

3. Log anything that arrived for free. Staking reward, airdrop, learn-and-earn, a referral kickback, card cashback paid in bitcoin — fair market value on arrival, in my currency, no exceptions. That number is income this year and basis next year, and the platforms paying them report them. An unlogged airdrop is the single dumbest letter you can invite.

4. Note the gas. If I was on-chain, I write down the fee amount and the coin it was paid in. A heavy DeFi week generates a surprising number of tiny disposals, and India especially gives almost nothing back for these — but you can't claim or ignore what you didn't record.

5. Screenshot the weird one. Anything a CSV can't explain — an OTC deal, a lost recovery, a manual settlement, a fork snapshot — gets a screenshot in that week's folder with a one-line note. Weird events are maybe 2% of activity and 90% of audit questions.

Month-end: one hour, reconciliation

The weekly routine records events. The monthly routine catches lies I told myself.

I export the month's CSV from every venue and reconcile it against the sheet: does the ending balance on the exchange match my running holdings? Are there any rows on their side missing on mine? Gaps usually come from three places — dust sweeps, staking auto-compounding, and trades I made on my phone while "not trading." I fill the gaps while the month is fresh.

Then I download the monthly CSVs into a folder structure like 2026/09/coinbase.csv and leave them alone forever. This is the cheap insurance against the thing that actually destroys crypto records: platforms. Exchanges prune old exports, APIs change, and exchanges occasionally die. If the worst case arrives, the basis reconstruction guide is the emergency room — my monthly downloads are the gym membership that keeps you out of it.

One more monthly job: check for coins or platforms at risk. If an exchange is making the news for the wrong reasons, I export its entire history that day, not after the withdrawals freeze.

The one column your country secretly demands

The raw five facts are universal, but each filing country slices them differently. I keep a small "method" note at the top of the sheet so I never collect the wrong granularity:

Notice what this means for the weekly buy. A Londoner and a Torontonian mostly need totals; a Berliner and a New Yorker need every individual date. Same spreadsheet, different columns doing the heavy work. If you ever move countries — and plenty of people do — having all five facts at full granularity means the sheet survives the move. The tax-residency piece is mapped in the moving-abroad guide.

The three supporting files that sit beside the sheet

Income ledger. Every token that arrived without being bought, on its own tab. Airdrops are where people get caught, because the temptation is to wait until the token is sold. Wrong twice over: the income event happens on receipt at that day's value, and the same value becomes basis. I also keep referral bonuses and crypto cashback here.

Basis-receipts folder. Anything that wasn't a normal exchange buy lives here: P2P trades, OTC purchases, coins bought with cash at an ATM, gifts received, inherited coins. Each gets a file with date, amount, price, source and the counterparty record. Without this, such coins have a one-way ticket to zero basis.

DeFi and NFT notes. A plain sentence per position: what I put in, when, what token I got back, when I unwound. Liquidity entries, LP tokens, wrapping and bridging are the events software mislabels most, and a human note written the week it happened beats forensic reconstruction by a mile. The event taxonomy is in the DeFi guide.

How long to keep all this

Longer than feels reasonable, because crypto gets held for years and the purchase evidence only matters at sale. My rule of thumb, by filing country:

Digital storage costs nothing. I keep the entire folder encrypted, duplicated in two places, and I re-export anything stranded on a platform I've stopped using. Acquisition records for a coin you still hold should be kept until the retention window for the year you sell it closes — which for a five-year hold is a six-year-plus minimum by itself.

January: the payoff

When filing season opens, my sheet is already complete. The work splits into two: getting the official exports one more time, and running the math. I reconcile the year's disposals to the platform statements, check that each SELF-TRANSFER landed somewhere, and make sure the income ledger total matches what staking platforms say they paid.

Then the CSV goes into the batch calculator on the homepage. It parses the file locally in my browser tab — nothing is uploaded, which matters to me precisely because this sheet contains my entire financial life — and automatically buckets every disposal into short- and long-term for US/Australian-style rules, or into the inputs the pooled and averaged countries need. Spot-checking a handful of rows by hand against the single-trade calculator is my final sanity check. The full walkthrough from CSV to filed return is the reporting guide.

If the numbers are simple, that's the whole job. If they're not — DeFi-heavy year, cross-border move, a 1099-DA that doesn't reconcile — the same organized folder is what makes a professional's quote a few hundred instead of a few thousand. Specialists charge for reconstruction, not review.

Start tonight with three rows

You don't need to backfill five years this evening. Open a blank sheet, put the five columns in, and log this week's activity before Friday. Download one exchange's full history while you're logged in. That's fifteen minutes, and it closes the barn door before any more horses wander off.

Records are the only tax strategy that works in every country, survives every reform, and never gets retroactively denied. The best tax-loss harvest in the world is worthless if you can't prove what you paid.

What's the messiest part of your own records — old exchanges, DeFi, or the wallet hops? Tell me and I'll fold the best questions into the system.

General information, not tax advice. Retention windows are practical minimums and can be longer for unfiled years, business activity or foreign assets. When in doubt, keep it and ask a professional in your filing country.

FAQ