₿

Documentation

Everything you need to know about using Spend Sats Bitcoin capital gains estimator

📄 CSV Upload Format

Upload your Bitcoin transaction history as a CSV file with the following columns. The calculator is flexible and will map common column variations automatically.

Required Columns

Column Name	Description	Example
Date	Transaction date	2024-01-15
Sent Currency	Currency being sent	BTC, USD
Sent Amount	Amount being sent	0.005, 1000
Received Currency	Currency being received	BTC, USD
Received Amount	Amount being received	0.005, 1000
Fee Amount	Transaction fees paid	0.0001, 2.50
Fee Currency	Currency of the fee	BTC, USD
Tag	Transaction type	Buy, Sell, Transfer, Receive

Optional Columns

Column Name	Description
Notes	Transaction description or memo
Transaction ID	Unique transaction identifier or hash

📝 Column Name Flexibility

The estimator automatically recognizes common column name variations. For example, 'Date', 'Created', 'Timestamp' will all be mapped to the date field.

Example CSV Format

Date,Sent Currency,Sent Amount,Received Currency,Received Amount,Fee Amount,Fee Currency,Tag,Notes,Transaction ID
2024-01-15,USD,1000,BTC,0.023,2.50,USD,Buy,Initial Bitcoin purchase,TXN-001
2024-02-10,USD,2000,BTC,0.039,5.00,USD,Buy,Second Bitcoin purchase,TXN-002
2024-03-15,BTC,0.015,USD,950,0.00001,BTC,Sell,Sold Bitcoin for expenses,TXN-003
2024-04-20,BTC,0.01,,0,0.00002,BTC,Transfer,Transfer to cold storage,TXN-004
2024-05-05,,0,BTC,0.001,0,BTC,Receive,Received Bitcoin from friend,TXN-005

✅ Supported Wallet Formats

The estimator automatically detects and converts these wallet export formats:

Sparrow Wallet CSV exports
Standard exchange formats (Coinbase, Kraken, etc.)
Custom CSV formats with proper column mapping

📥 Available Downloads

After processing your transactions, you can download comprehensive transaction reports in multiple formats for your records and analysis.

📊 CSV Reports

• Transaction Details - Complete transaction history with cost basis and gains
• Capital Gains Summary - Annual totals by year and method (FIFO/LIFO/HIFO)
• Lot Allocations - Detailed cost basis allocations for each sale
• Remaining Holdings - Current Bitcoin holdings with cost basis

📄 PDF Reports

• Professional Report - Formatted for professionals and analysis
• Capital Gains Summary - Estimated capital gains analysis
• Method Comparison - Side-by-side FIFO vs LIFO vs HIFO analysis
• Transaction Documentation - Complete transaction trail for your records

🔍 What's Included in Reports

Capital Gains Information:

Short-term vs long-term gains
Cost basis calculations
Holding periods
Net gain/loss totals

Transaction Details:

All buy, sell, transfer activity
Mining fee tracking
Exchange fee accounting
Transaction IDs and dates

🔒 Privacy & Network Usage

Your Data Stays Private

✅100% Client-Side Processing - All calculations happen in your browser
✅No Data Storage - Your transaction data is never sent to our servers
✅No Account Required - Use the calculator without creating an account
✅Secure Processing - Advanced encryption protects your data

Limited Network Requests

The calculator only makes network requests for one purpose:

🔗

Bitcoin Price Data

We fetch historical Bitcoin prices from CryptoCompare API (primary) and Blockchain.info API (fallback) to calculate the fair market value of your transactions. This is required for accurate cost basis and capital gains calculations.

Only dates of transactions are sent (no amounts, addresses, or personal data).

What We Don't Track

❌ Bitcoin addresses or wallet information
❌ Transaction amounts or values
❌ Personal identification data
❌ Your calculated gains or losses
❌ Usage analytics or tracking cookies

🚀

Quick Start

Get started with Bitcoin capital gains estimation in just 5 simple steps

Export your Bitcoin transaction history from your exchange or wallet as a CSV file

Upload the CSV file to the calculator - it will automatically detect the format

Review and edit any transaction details if needed

Estimate capital gains using FIFO, LIFO, or HIFO methods

Download your transaction reports in CSV format

Start Estimating →