Document note only. Field Ledger is not a tax firm, cloud reseller, dental office, or insurer. Read your own form and confirm it with the preparer, billing desk, carrier, or another licensed professional.
This guide walks through reconciling mismatched line items between crypto exchange 1099 forms and corresponding CSV export files. Discrepancies between these two documents are extremely common, often stemming from timing differences, partial transaction reporting, formatting inconsistencies, or differing accounting methods used by exchanges vs individual filers. This process is designed for use with your Field Ledger crypto tax records folder to systematically document every discrepancy before you share documentation with your tax preparer or submit any filings to tax authorities. This page is for educational purposes only, and does not constitute tax advice; always consult a licensed tax professional before adjusting reported amounts or requesting corrected tax forms from an exchange.
Mismatched 1099 line box
Start by isolating the exact line and box on your official, final exchange 1099 form that does not align with your CSV export totals. Only use the final filed version of the 1099, not a draft preview available in your exchange account, as draft versions often include unadjusted estimates that are corrected before official filing. Common mismatched boxes include 1099-B Box 1d (gross proceeds from asset dispositions), 1099-B Box 1e (cost basis of disposed assets), 1099-B Box 1f (accrued market discount on disposed assets), 1099-MISC Box 3 (other income from staking, airdrops, or interest payments), and 1099-NEC Box 1 (non-employee compensation for services paid in crypto). Note if the 1099 is marked as a corrected form (via the pre-printed “CORRECTED” box at the top of the form) as you will need to cross-reference with the original 1099 if you received both. Record the exchange’s EIN, the 1099 serial number, and the exact reported amount in the mismatched box on a printed or annotated digital copy of the form to avoid confusion later in the reconciliation process. Do not edit the 1099 form itself; all notes should be added as separate annotations or in your reconciliation log.
CSV export entry column
Next, pull the full, unedited CSV export from your exchange for the exact tax year referenced on the 1099. Do not use a filtered, edited, or third-party CSV for this reconciliation, as modified files will not be accepted as supporting documentation if you need to request a corrected 1099 or justify adjustments to tax authorities. Locate the column in the CSV that directly maps to the mismatched 1099 box: for example, 1099-B Box 1d maps to the “total_proceeds” column in most standard exchange CSV exports, 1099-B Box 1e maps to the “cost_basis” column, and 1099-MISC Box 3 maps to aggregated “staking_rewards”, “airdrop_rewards”, and “interest_income” columns. Filter the CSV to only include transactions that fall within the exchange’s reported tax period, taking care to note time zone differences: most exchanges report transaction times in UTC, which can cause transactions executed late on December 31 in your local time zone to be reported in the following tax year. Calculate the total of the relevant column for the filtered time period, and flag any individual rows that are excluded from the 1099 total but appear in your CSV, or included in the 1099 total but missing from your CSV. Save a read-only copy of the full unedited CSV in your tax records folder before making any annotations or highlights.
Reconciliation log entry note
Every mismatch you identify requires a dated, specific entry in your crypto tax reconciliation log, which can be stored as a spreadsheet or plain text document in your tax records folder. You may use Field Ledger log templates to standardize your entries if you have access to them, but any consistent formatting is acceptable as long as all required details are included. Each entry should include the date you completed the reconciliation, the full name of the exchange, the 1099 serial number, the mismatched box number, the exact amount reported on the 1099, the exact total you calculated from the CSV, and a clear, factual root cause note for the discrepancy. Common root cause notes include: Illustrative example: exchange excluded cost basis for 4 assets transferred to the platform from an external cold wallet; Illustrative example: 2 trades executed at 23:57 UTC on 12/31/2022 are included in the 2023 1099 but appear in the 2022 CSV export; exchange reports staking rewards on accrual date, while CSV reports rewards on the date they were credited to the user account; and exchange included proceeds from a lost transfer that was never completed in the 1099 total. Attach a screenshot of the annotated 1099 line and the relevant CSV rows to the log entry, and label each screenshot with the date of the reconciliation and the mismatch ID number assigned in your log.
Cross-reference filing folder
Organize all supporting documentation for each mismatch in a dedicated subfolder within your main tax year records folder, labeled clearly as “1099-CSV Mismatches [Tax Year] [Exchange Name]”. This subfolder should contain a read-only copy of the full official 1099 form, a read-only copy of the full unedited CSV export with mismatched rows highlighted, the completed reconciliation log, copies of any supporting transaction receipts, wallet transfer confirmations, on-chain transaction records, or correspondence with the exchange about the discrepancy, and a one-page summary sheet listing all mismatches and total adjusted amount for quick reference by your tax preparer. Cross-reference this subfolder in your main tax filing checklist with a note of the number of mismatches, the total adjusted dollar amount, and the location of the folder, so you do not forget to share the documentation with your preparer. Retain a full copy of this subfolder for a minimum of 7 years, per standard federal tax record retention guidelines, in case of an audit or request for additional documentation from tax authorities.
Adjustment submission cover form
If you intend to request a corrected 1099 from the exchange, or justify an adjustment to the reported 1099 amount on your tax return, you will need a standardized cover form to accompany your request or submission. The cover form should include your full legal name, your tax ID number, your exchange account number, the relevant tax year, the exchange’s EIN, the 1099 serial number, a line-item list of each mismatched 1099 box, the amount reported on the 1099, the adjusted amount per your CSV reconciliation, and a brief factual root cause for each mismatch. The form should also include a clear request: either a request for the exchange to issue a corrected 1099 with the adjusted amounts, or a statement explaining the discrepancy for your tax preparer to include with your filing. Sign and date the cover form, and attach a full copy of the reconciliation log and supporting documentation from your cross-reference folder when submitting. Keep a signed copy of the submitted cover form in your cross-reference folder, along with any confirmation of receipt from the exchange or your tax preparer. This cover form is for documentation purposes only, and you should always consult a licensed tax preparer before submitting any adjustments to the IRS or your exchange.
The table below outlines common mismatch types, corresponding form and CSV fields, root causes, and required supporting documentation to include in your records:
| Mismatch Type | 1099 Form Box | Corresponding CSV Column | Common Root Cause | Recommended Documentation Add-on |
|---|---|---|---|---|
| Gross proceeds underreport | 1099-B Box 1d | total_proceeds | Exchange excludes proceeds from trades of assets transferred from external non-custodial wallets | Screenshot of external wallet transfer confirmation to the exchange, on-chain transaction record of the transfer |
| Cost basis underreport | 1099-B Box 1e | cost_basis | Exchange only tracks cost basis for assets purchased directly on the platform, not for assets transferred from external accounts | CSV export of all on-chain purchase transactions for the transferred assets, dated purchase receipts from third-party platforms |
| Staking income overreport | 1099-MISC Box 3 | staking_rewards_total | Exchange reports staking rewards on the accrual date, while user CSV reports rewards on the date funds are credited to the account (UTC timing difference) | Screenshot of staking reward credit timestamp in exchange account, confirmation of reward lock-up period from exchange terms of service |
| Airdrop income mismatch | 1099-MISC Box 3 | airdrop_rewards | Exchange includes airdropped assets that were never claimed or liquidated by the user in reported income totals | Screenshot of unclaimed airdrop status in exchange account, on-chain record of non-receipt of the airdropped tokens |
| Non-employee compensation mismatch | 1099-NEC Box 1 | crypto_service_payments | Exchange reports gross payments before platform processing fees, while user CSV calculates net received amounts after fee deductions | Copy of exchange fee schedule for service payment processing, screenshot of individual payment transactions showing fee deductions |
Your next practical step is to pull your most recent crypto exchange 1099 form and full unedited CSV export for the same tax year, and document any initial mismatches in your reconciliation log within 7 business days of receiving both documents.
Filed by Field Ledger.