Calc Crypto Wash Sales With Claude: Workflow For Tax Preparers

Cryptocurrency taxation remains one of the most complex areas of compliance. While the IRS wash sale rule (26 U.S.C. § 1091) historically applied strictly to stocks and securities, prudent Tax Preparers often calculate these scenarios for security tokens, conservative filing positions, or future-proofing client portfolios. Using Claude, you can instantly parse thousands of transaction rows to model cost basis adjustments without expensive specialized software.

⏱️ Time to Complete: 10-15 minutes | 📊 Difficulty: Intermediate | 🛠️ Tool: Claude (Pro/3.5 Sonnet Recommended)

Why This Workflow Matters

Manually identifying wash sales requires cross-referencing every loss against every purchase within a 61-day window—a near-impossible task for active crypto traders using Excel alone. By automating this analysis with Claude, you shift from data-entry drudgery to high-value advisory work. This workflow empowers you to model tax liabilities under different regulatory interpretations in seconds, saving hours of billable time.

Prerequisites

Claude Key/Account: Access to Claude 3.5 Sonnet (recommended for high-accuracy reasoning).
Transaction Data (CSV): A clean export containing: Date, Asset Pair, Transaction Type (Buy/Sell), Quantity, Price (USD), and Total Value.
Data Privacy Check: Ensure all PII (Social Security Numbers, Client Names, Wallet Addresses) is removed before uploading.

Step-by-Step Guide

Step 1: Sanitize and Format Transaction Data

Claude processes structured text best. Ensure your client's crypto transaction log is clean. You need a chronological list of trades. If the data is scattered across multiple exchanges, combine them into a single chronological CSV file first.

Step 2: Input Logic and Data

Upload your CSV file to Claude. Then, use the following prompt to instruct Claude on the specific "Wash Sale" logic (the 30-day lookback and look-forward window). This prompt forces Claude to act as a strict auditor.

📋 Prompt You are a Senior Tax Analyst. I am uploading a CSV of cryptocurrency transactions. Your task is to identify potential "Wash Sales" based on the following logic: 1. **Identify Losses:** Locate all distinct "SELL" transactions where the Proceeds are less than the Cost Basis. 2. **Scan Window:** For every loss identified, check if a usage "BUY" transaction for the *same asset* occurred within 30 days BEFORE or 30 days AFTER the sale date. 3. **Calculation:** If a match is found, the loss is disallowed. Add the disallowed loss amount to the Cost Basis of the *replacement* tokens. **Output Requirements:** Create a table with the following columns: - Date of Sale - Asset - Original Loss Amount - Replacement Purchase Date - Disallowed Loss - Adjusted Basis of New Holdings Analyze the attached CSV and output the table. Do not summarize; show the line-item calculations. Note: Assume First-In-First-Out (FIFO) for basis tracking unless the CSV specifies otherwise.

Step 3: Verify the Logic Chain

AI can occasionally hallucinate math on large datasets. Ask Claude to explain its calculation for the first identified wash sale to ensure it is tracking the 61-day window correctly.

📋 Prompt Please isolate the first Wash Sale you identified in the table above. Step-by-step, explain the math and the dates used to determine that this was a wash sale. Explicitly state the date difference between the sale and the repurchase.

Step 4: Export to Excel/CSV

Once you have verified the logic, ask Claude to format the final adjusted list into a code block you can copy back into your tax software or Excel workpaper.

📋 Prompt Generate a CSV-formatted code block containing the final "Adjusted Cost Basis" report. Include headers. Only include the rows where an adjustment was made.

Pro Tips

Handle Partial Matches: If a client sold 1.0 BTC and rebought only 0.5 BTC, the wash sale rule only applies to the portion repurchased. You can ask Claude: "Adjust the calculations to account for partial replacement shares proportional to the quantity repurchased."
Token Swaps: Claude is excellent at identifying crypto-to-crypto swaps (e.g., ETH to SOL) which are taxable events. Ensure your prompt defines "Sell" to include swaps out.
Substantially Identical: Use Claude to flag "Wrapped" tokens (e.g., WBTC vs BTC) by asking it to treat them as substantially identical for conservative scenarios.

Common Mistakes to Avoid

Ignoring Gas Fees: Ensure your CSV includes transaction fees in the cost basis column before upload, or ask Claude to add the "Fee" column to the purchase price during calculation.
Overloading Context: If the client has 10,000+ transactions, Claude's context window might truncate data. Process data in quarterly or yearly batches for maximum accuracy.
Blind Trust: Always spot-check the highest value transactions manually. AI is an accelerator, not a certified signer.

Frequently Asked Questions

Q: Does the Wash Sale rule legally apply to cryptocurrency?

A: As of early 2024, the IRS treats crypto as property, not "stock or securities," so the rule technically does not apply. However, Tax Preparers often calculate it for security tokens, to apply "economic substance" doctrine, or to prepare clients for impending regulation changes.

Q: Can Claude calculate specific ID (Spec ID) basis?

A: Yes, but it is difficult. You must provide a dataset that includes unique Lot IDs for every purchase. Without Lot IDs, asking Claude to use FIFO (First-In-First-Out) or LIFO accounts is the most reliable method.

Q: Is my client data safe when uploaded to Claude?

A: Anthropic generally does not train on data from enterprise/Team plans, but you should always sanitize data. Remove names, wallet addresses, and Tax IDs. Use generic identifiers (e.g., "Client A") before processing.

Simplify Crypto Wash Sale Calculations

⚡ TL;DR

Why This Workflow Matters

Prerequisites

Step-by-Step Guide