Free crypto trade log template
Type a name, the year, and how many exchange accounts and wallets there are. The page builds an Excel workbook for logging buys and sales: a Trades sheet with one row per transaction, an Accounts sheet, a Log sheet with the name and year, and an instructions sheet that says what each column holds.
The workbook is built in your browser. Nothing you type is uploaded.
What the workbook will hold
The workbook is a layout to fill in. It holds values only and has no formulas, so it does not calculate. Once the Trades sheet is filled in, the capital gains worksheet opens the workbook and matches each sale to the lots it came from, and the proceeds tie-out adds up its sales and compares them with the totals typed from a broker statement.
What gets checked
- Before the download starts, the finished workbook is read back in your browser: its sheet names, each header row, and each row count are compared with what was asked for.
- The Accounts sheet has the number of blank numbered rows that was typed, and the Log sheet carries the name and the year as typed.
- The Trades sheet is the first sheet in the file, the one the tools open, and its header row, as read back from the file, is matched the way the capital gains worksheet and the proceeds tie-out match it: date, type, asset, quantity, total, fee, cost basis, and account are each found in a column of their own.
- The Trades sheet is run through the same row reader the tools use and reads as a trade list with nothing entered yet.
- The workbook holds values only. No cell contains a formula.
How it works
- Answer three questions. Type a name, the year, and the number of accounts and wallets. The name and the year can be left blank; the count sets how many numbered rows the Accounts sheet starts with.
- Build the workbook. The Excel file is put together in the browser, read back to confirm its sheets, header rows, and row counts, and downloaded. There is no sign-up and no limit.
- Fill in the Trades sheet. One row per transaction: the date (and time when there is one), Buy or Sell, the asset, the quantity, the total in dollars before the fee, the fee, and the account. Rows can be typed, or pasted from an exchange export column by column.
- Calculate with the tools. The template does not calculate. The capital gains worksheet opens the filled-in workbook and matches each sale to the lots it came from under the method picked there; the proceeds tie-out adds up the sales and compares them with totals typed from a broker statement. Both show their checks.
Worked example
For a made-up person, Sam Example, with 3 accounts and wallets, logging 2026, the workbook has these sheets.
| Sheet | Columns | Rows to fill in |
|---|---|---|
| Trades | Date, Type, Asset, Quantity, Total USD, Fee USD, Cost basis USD, Account, Notes | One per transaction, under the header row |
| Accounts | Line, Account or wallet, Kind, Notes | 3 numbered |
| Log | Item, Value | Name and year filled in |
| Instructions | Where, What goes there | What each column holds |
The Log sheet arrives with Sam Example and 2026 already filled in. The Accounts sheet has rows numbered 1 to 3, all blank, and the Trades sheet has its header row and nothing under it. The file downloads as crypto-trade-log-sam-example-2026.xlsx.
The example uses made-up names and numbers.
Questions
Does the template work out gains or cost basis?
No. It is a clean layout with values only and no formulas. The tools on this site do the calculating: the capital gains worksheet matches each sale to its lots and shows proceeds, cost basis, and gain or loss per row, and the proceeds tie-out compares the sales with the totals on a broker statement.
Is it really free?
Yes. There is no sign-up and no limit on how many templates are built.
What goes in the Type column?
Buy or Sell. Rows of any other type, such as a transfer between wallets, a reward, or a conversion of one coin into another, can be kept in the log; the tools list each one by row number and do not use it in a result.
What is the Cost basis USD column for?
It is only for a sale whose cost basis is already listed on a statement or an export. It can be left blank on every row. The capital gains worksheet works out cost basis from the buys and does not read this column; the proceeds tie-out adds it up when a basis total is typed from the statement.
Which exchanges does it work with?
None in particular. The columns are generic: date, type, asset, quantity, total, fee, and account. Rows are typed in, or copied in from whatever export an exchange or wallet produces.
This tool calculates and checks numbers. It is not legal, tax, or medical advice.