This cross-reference resource maps standard crypto exchange CSV columns to required gain-and-loss tax sheet fields. Most popular crypto exchanges export transaction history CSVs with non-standard column naming conventions that do not directly align with IRS or state tax reporting requirements for digital asset disposals. You can use this guide to manually map or import your CSV data to a standardized gain-and-loss sheet without manually retyping every transaction line. This resource is for educational use only, and you should consult a licensed tax preparer before submitting any official tax filings.
Transaction Date Column Alignment Between Exchange Exports and Gain-and-Loss Sheets
The transaction date is one of the most critical fields for accurate gain-and-loss calculation, as it determines which tax year a disposal is reported in, and the correct fair market value to use for proceeds and cost basis calculations. Exchanges use a wide range of date labeling and formatting conventions, including UTC timestamps, local user time, epoch timestamps, and separate date and time columns. Some exchanges may list the order initiation date instead of the order execution date, which can lead to misclassification of transactions across tax years.
Always prioritize the execution date (the date the trade, sale, spend, or transfer was fully completed) over the order submission date for your gain-and-loss sheet. If your exchange uses epoch time (a 10-digit numeric timestamp representing seconds since January 1, 1970 UTC), you can use a free public epoch time converter tool to translate the value to a standard MM/DD/YYYY format for your sheet. If a transaction spans midnight UTC across two calendar years, use the date of the final execution to assign the transaction to the correct tax year. Illustrative example: a trade initiated at 11:58pm UTC on December 31, 2023, executed at 12:03am UTC on January 1, 2024, counts as a 2024 transaction for U.S. tax purposes. If you have transactions that cross tax years, flag them for extra review to avoid reporting errors.
Digital Asset Column Standardization for Consistent Gain-and-Loss Calculations
Exchanges frequently use inconsistent naming conventions for digital assets, including truncated tickers, missing chain identifiers, and prefixes or suffixes for reward, staking, or airdrop transactions. For example, “ETH” may refer to native Ethereum on the Ethereum mainnet, wrapped Ethereum on the Solana network, or a staked Ethereum derivative, all of which are treated as separate assets for tax reporting purposes if you dispose of them individually.
To avoid mismatching cost basis lots when using FIFO, LIFO, or specific identification accounting methods, standardize all asset entries in your gain-and-loss sheet to include the asset ticker, full asset name, and host chain (if applicable). If your exchange lists a transaction as “Reward: SOL” or “Staking Distribution: DOT”, edit the entry to match your standard naming convention so you can assign the correct cost basis (the fair market value on the date of receipt) to the asset. If you transact with wrapped or pegged assets, add a “w” prefix or chain suffix to the asset name to distinguish it from the native version of the asset, to avoid incorrectly matching lots across different asset types.
Gross Proceeds Column Cross-Reference for CSV and Tax Sheet Alignment
Gross proceeds are the total fair market value of the disposed asset at the time of the transaction, before any fees, exchange cuts, or network gas costs are deducted. Exchanges often label this column with non-standard names, and may automatically net out fees from the listed proceeds value, which requires manual adjustment to meet U.S. tax reporting requirements. For crypto-to-crypto trades, some exchanges may list the value of the received asset instead of the disposed asset, which also requires correction to ensure accurate gain calculation.
To simplify the mapping process, use the reference table below to match common exchange CSV column labels to the required fields for a standard U.S. digital asset gain-and-loss sheet:
| Standard Gain-and-Loss Sheet Column | Common Crypto Exchange CSV Column Labels | Required Data Format | Verification Step |
|---|---|---|---|
| Transaction Execution Date | Transaction Time, Order Filled At, Disposal Date, Completed Timestamp | UTC timestamp formatted as MM/DD/YYYY | Cross-reference with order confirmation email to confirm fill date matches CSV entry |
| Digital Asset Disposed | Asset, Currency, Coin, Token, Ticker | Ticker + chain suffix (e.g., BTC-Bitcoin, ETH-Arbitrum) | Confirm asset name matches the cost basis lot you are matching to for the transaction |
| Gross Proceeds (USD) | Total Received, Sale Value, Fiat Proceeds, Disposal FMV | Rounded to nearest cent USD | Cross-reference with crypto price index data for the transaction date to confirm FMV accuracy |
| Cost Basis (USD) | Cost, Purchase Value, Lot Basis, Acquisition FMV | Rounded to nearest cent USD | Match to the original acquisition transaction CSV entry to confirm basis includes all applicable acquisition fees |
| Transaction Adjustments | Fees, Gas Cost, Network Charge, Adjustment | Positive or negative USD value rounded to nearest cent | Confirm all adjustments are supported by exchange receipt or on-chain transaction record |
All gross proceeds values must be converted to USD using the fair market value of the disposed asset at the exact time of the transaction, per IRS guidelines. If your exchange does not provide a USD value for proceeds from a crypto-to-crypto trade, you can use a reputable crypto price index to pull the USD value of the disposed asset at the time of the trade. Illustrative example: If your exchange CSV lists a $1,000 BTC sale with $15 in fees, showing a net received value of $985, you will need to pull the pre-fee $1,000 value as gross proceeds, and list the $15 fee as an adjustment or expense separately where required.
Cost Basis Column Mapping to Reconcile Exchange CSV Values With Tax Requirements
Cost basis includes the total amount you paid to acquire the digital asset, including purchase price, exchange fees, network gas fees, and any other applicable acquisition costs. Exchanges often only list the raw purchase price in their default “Cost” column, omitting additional fees that you are allowed to include in your cost basis to reduce taxable gains. If you transferred an asset to the exchange from an external wallet, off-ramp service, or separate exchange, the CSV may list a $0 cost basis for the asset, which you will need to manually update using your off-exchange acquisition records.
If you use specific identification for cost basis accounting, you will need to link each disposal transaction to the exact acquisition lot in your gain-and-loss sheet, using the asset name and acquisition date to confirm the correct lot is selected. For airdrops, staking rewards, and fork assets, the cost basis is equal to the fair market value of the asset on the date and time you received control of the asset, per U.S. tax rules, even if the exchange lists a $0 cost for these assets. Note that Settlement Desk provides standardized folder templates for storing acquisition transaction records to simplify cost basis reconciliation, but you should confirm all basis calculations with a licensed tax professional before filing.
Adjustment Note Column Inclusion for Discrepancies Between CSV and Sheet Entries
You will almost always encounter minor discrepancies between exchange CSV data and your gain-and-loss sheet requirements, including missing cost basis for off-exchange acquisitions, fee netting by the exchange, date mismatches between local time and UTC timestamps, and inconsistent asset naming. The adjustment note column is where you document the reason for any changes you make to the CSV data when entering it into your gain-and-loss sheet, so you can provide supporting documentation to the IRS if your return is audited.
Each adjustment note should be specific enough that you or a tax preparer can locate the supporting documentation for the change without additional research. For example, instead of writing “adjusted basis”, write “Cost basis updated from off-exchange purchase record #472 dated 03/14/2022, including $7.25 in acquisition fees”. Common adjustment notes include “Gross proceeds adjusted to pre-fee value per exchange order confirmation”, “Transaction date adjusted to UTC fill date from local time CSV entry”, and “Cost basis added for ETH transferred from external Metamask wallet, acquired 09/01/2021”. You should also attach a copy of the supporting document (order confirmation, on-chain transaction receipt, off-exchange purchase record) to your gain-and-loss sheet, or store it in a labeled subfolder linked to the corresponding transaction line. This page cannot file your tax return or confirm the accuracy of your adjustment entries, so you should always review all changes with a licensed tax preparer before finalizing your gain-and-loss sheet.
Before you begin mapping your exchange CSV to your gain-and-loss sheet, export a second unedited copy of your full transaction history and store it in a password-protected folder with your corresponding tax year records for audit support.
Filed by the Settlement Desk.
