Cryptocurrency investors face a unique challenge when tax season rolls around: accurately calculating their cost basis and capital gains. With transactions spread across multiple blockchains, wallets, and decentralized platforms, keeping track of every trade, transfer, and token swap can feel overwhelming. Fortunately, there’s a smarter way to simplify crypto tax reporting—without relying on expensive accountants or outdated tools.
GoldRush has developed a powerful, free, and open-source solution that automates the entire process. Whether you're managing Ethereum-based ERC20 tokens or Bitcoin transactions, this tool helps you calculate your adjusted cost basis (ACB), monitor capital gains, and maintain accurate records—all in minutes.
👉 Discover how easy crypto tax tracking can be with a streamlined, data-driven approach.
How the Crypto Cost Basis Calculator Works
Using the calculator is simple and intuitive. It's built as a customizable Google Sheets template powered by GoldRush’s Unified API, which pulls real-time and historical blockchain data from over 150 networks.
To get started:
- Open the Crypto Cost Basis and Capital Gains Calculator.
- Go to File → Make a copy to create your own editable version.
- Enter your Ethereum or Bitcoin wallet address (ENS domain names are supported too).
- Click the "Analyze my wallet" button and follow the prompts.
Once processing completes, several sheets provide comprehensive insights into your crypto activity:
- The Activity sheet identifies all blockchains where your wallet has interacted.
- The Balances sheet breaks down your current holdings across native and ERC20 tokens on each chain.
- The Transfers sheets log every incoming and outgoing transaction.
- The Transfers Balance Sheet summarizes total inflows and outflows, cross-referenced with on-chain balances for accuracy verification.
This level of detail ensures transparency and minimizes discrepancies—giving you confidence in your tax reporting.
Why This Tool Was Created
Calculating crypto taxes isn’t just time-consuming—it’s complex. Decentralized finance (DeFi) transactions, NFT trades, staking rewards, and cross-chain swaps introduce layers of accounting difficulty that traditional tools aren’t equipped to handle.
Individual investors and professional accounting firms alike struggle with fragmented data sources, inconsistent pricing models, and incomplete transaction histories. Recognizing these pain points, GoldRush built a solution rooted in reliable blockchain data.
Powered by the Covalent Unified API, the calculator accesses granular, standardized data across more than 150 blockchains. It captures not only basic transfers but also intricate DeFi interactions and historical price data—essential for accurate cost basis calculations.
Our mission? To make crypto tax compliance accessible, transparent, and stress-free for everyone.
👉 See how real-time blockchain analytics can transform your financial tracking experience.
Key Features That Set This Tool Apart
Balance Sheet Accuracy
One of the standout features is the balance reconciliation function. By comparing calculated token balances against actual on-chain data, the tool achieves near-perfect accuracy—often within 0.001%. This level of precision is crucial for audit-ready reporting.
Token-Level Filtering
You can filter results by individual tokens, allowing you to analyze the performance and cost basis of specific assets like DAI, USDC, or WETH independently. This granularity supports informed decision-making and targeted tax strategies.
Real-Time Portfolio Summary
Located at the top right of the input sheet, the summary displays key metrics: total portfolio value, API credits used, and analysis cost—all typically just a few cents. This transparency helps users manage usage efficiently.
Bitcoin Wallet Support
Unlike many crypto tax tools focused solely on Ethereum and EVM chains, this calculator supports Bitcoin addresses. Simply input your BTC wallet, and it will process transaction history with the same depth and accuracy.
Cross-Chain Activity Detection
Thanks to a proprietary endpoint—address activity detection—the tool automatically discovers which chains your wallet has interacted with. No manual chain selection required.
Adjusted Cost Basis (ACB) Method
The spreadsheet uses the Adjusted Cost Base (ACB) method, widely accepted in Canada for tax reporting. ACB calculates the average purchase price of an asset over time, factoring in all buys and sells. This method smooths out volatility and simplifies long-term tracking.
Example: If you bought 1 ETH at $2,000 and another at $3,000, your ACB would be $2,500 per ETH. Selling one means your cost basis is $2,500—regardless of which ETH you sold.
Alternative Cost Basis Methods You Can Customize
While ACB is ideal for Canadian taxpayers, other jurisdictions use different approaches:
- FIFO (First-In, First-Out): Commonly used in the U.S., FIFO assumes the oldest assets are sold first.
- LIFO (Last-In, First-Out): Less common, but allowed in some cases.
- Specific Identification: Allows you to choose exactly which units were sold—offering maximum control but requiring detailed recordkeeping.
Since the tool is open-source, you can modify the underlying script to implement any of these methods based on your tax requirements.
Important Considerations & Future Enhancements
While powerful, the current version has some limitations:
- Internal Transactions: Support for internal contract calls (e.g., smart contract interactions without direct token movement) is still in development. Currently relies on Etherscan API for partial coverage.
- Historical vs. Spot Prices: The tool uses daily closing prices instead of real-time spot prices updated every five minutes. While minor differences may occur, daily pricing aligns well with most tax authority guidelines.
Future updates aim to include native handling of internal transactions, expanded NFT support, and automated report generation for tax filing.
Frequently Asked Questions (FAQ)
Q: Is this tool really free?
A: Yes. The calculator is completely free to use and open-source. You only consume minimal API credits during analysis—usually costing just a few cents.
Q: Can I use it for U.S. tax filing?
A: Absolutely. While it defaults to ACB (used in Canada), you can customize the script to support FIFO or other IRS-compliant methods.
Q: Does it work with cold wallets?
A: Yes. As long as the wallet has on-chain activity, the tool can analyze it—regardless of whether it's hot or cold storage.
Q: How secure is my data?
A: Your wallet address is public by nature. Since the tool runs inside your personal Google Sheet and doesn’t store private keys or sensitive info, your data remains under your control.
Q: Can I track DeFi yields and staking rewards?
A: Yes. The Unified API captures yield farming rewards, liquidity pool deposits, and staking payouts—critical for complete tax reporting.
Q: What if I have multiple wallets?
A: Just run the analysis separately for each address. You can consolidate results manually or build a master sheet for portfolio-wide reporting.
👉 Start simplifying your crypto tax workflow today with accurate, automated insights.
Final Thoughts
As crypto adoption grows, so does regulatory scrutiny. Staying compliant doesn’t have to mean hiring expensive professionals or drowning in spreadsheets. Tools like GoldRush’s cost basis calculator empower users with accurate, transparent, and customizable solutions.
By leveraging robust blockchain data and intuitive design, this open-source resource makes tax season less daunting—and even a little empowering.
Whether you're a casual investor or managing complex portfolios, having reliable tools at your fingertips is no longer optional—it's essential.
Keywords: crypto cost basis, capital gains calculator, cryptocurrency tax tool, blockchain transaction tracker, ACB method crypto, DeFi tax reporting, open-source crypto calculator