Bank Statement → .XLSX for Crypto Tax
Crypto tax reporting requires matching every fiat deposit and withdrawal to a specific exchange and transaction. These appear as bank entries — but only in PDF format. Upload any bank statement PDF and get a fully formatted Excel workbook. Columns auto-sized, dates normalised, amounts clean and ready for analysis.
Loading converter...
Secure Financial Data Processing
Excel for Crypto Tax — Why It Works
Crypto investors and traders who need to reconcile fiat bank transactions (deposits to and withdrawals from exchanges) for crypto tax reporting. Convert your bank statement to CSV or JSON, then cross-reference exchange deposits and withdrawals against transaction hashes. Clean structured data makes crypto tax reconciliation tractable. Compatible with Microsoft Excel, Google Sheets, LibreOffice Calc, Numbers.
Example Excel Output
| Date | Description | Debit (USD) | Credit (USD) | Balance |
|---|---|---|---|---|
| 2024-03-15 | Chase ATM Withdrawal | 2,000.00 | — | 48,500.00 |
| 2024-03-18 | Salary Credit | — | 75,000.00 | 1,23,500.00 |
How It Works
Step 1
Download bank statement PDFs for the tax year
Step 2
Upload to MintConvert and download as CSV or JSON
Step 3
Filter transactions by exchange names (Coinbase, Binance, Kraken) in the Description column
Step 4
Match fiat deposit/withdrawal amounts against exchange records
Step 5
Import into your crypto tax software (Koinly, CoinTracker, TaxBit)
Why MintConvert
- Excel — Upload any bank statement PDF and get a fully formatted Excel workbook. Columns auto-sized, dates normalised, amounts clean and ready for analysis.
- Crypto Tax — Convert your bank statement to CSV or JSON, then cross-reference exchange deposits and withdrawals against transaction hashes. Clean structured data makes crypto tax reconciliation tractable.
- 23 banks supported — Auto-detected — no configuration per bank.
- Compatible with — Koinly, CoinTracker, TaxBit, Excel
- Privacy first — PDFs deleted immediately after conversion.
- Free to start — 5 free conversions/month. No credit card.
By Bank
Oman
Germany
Ireland
Sweden
Norway
Denmark
Portugal
South Africa
Kenya
Ghana
Bangladesh
South Korea
Taiwan
Thailand
Vietnam
Sri Lanka
Nepal
Cambodia
Ethiopia
Tanzania
Zambia
Argentina
Chile
Colombia
Frequently Asked Questions
Why is Excel the right format for crypto tax?
Upload any bank statement PDF and get a fully formatted Excel workbook. Columns auto-sized, dates normalised, amounts clean and ready for analysis. For crypto tax: compatible with Koinly, CoinTracker, TaxBit.
How does the Excel output support crypto tax workflows?
Convert your bank statement to CSV or JSON, then cross-reference exchange deposits and withdrawals against transaction hashes. Clean structured data makes crypto tax reconciliation tractable. The output includes consistent columns (Date, Description, Debit, Credit, Balance) across all 23 supported banks.
Which banks are supported for Excel for crypto tax?
23 banks across 8 countries: HDFC Bank, ICICI Bank, State Bank of India, Axis Bank, Kotak Mahindra Bank, Chase, and more.
Is the Excel output compatible with Koinly?
Yes — The .xlsx file opens natively in Microsoft Excel and Google Sheets. All amounts are numeric — no text-to-columns conversion needed.
How many conversions does a crypto tax workflow typically need?
MintConvert's Starter plan ($9/month, 100 conversions) suits small practices. Pro ($19/month, 500 conversions) for mid-size firms. Scale ($49/month, unlimited) for large firms.
Crypto Tax — Other Formats
Excel — Other Use Cases