Disclaimer: The information in this article provides a general overview and does not claim to be exhaustive. It cannot replace a detailed, individual consultation. TX-Partner assumes no liability for the accuracy, timeliness, or completeness of this information.
Key Takeaways
- ✓ Negative balances mean more of an asset flowed out than in — always a sign of missing transaction history
- ✓ Scam tokens using real tickers (USDC, SOL) are the most common cause of extreme negative values in the millions
- ✓ DeFi aggregators (Cowswap, Jupiter, 1inch) often record only the outflow, leaving the inflow unrecognized
- ✓ Diagnose with Analysis → Checks → Transaction Flow Report; the transaction before going negative is usually the cause
- ✓ CoinTracking treats sales with negative balance as "Short" with 0 EUR cost basis, creating inflated taxable profits
You open CoinTracking and see: ~139 million euros in the negative. That can't be right - and it isn't. But the underlying problem is real and can be solved. This article shows you why CoinTracking displays negative balances and how to fix them.
01 The Problem: Negative Balances
Negative balances in CoinTracking mean: According to the tool, more of an asset has flowed out than ever flowed in. This is technically impossible - and indicates gaps or errors in your transaction history.
Good to know:
Negative balances affect tax calculation: CoinTracking interprets sales without purchase history as "Short" with a cost basis of 0 euros. This means the entire sales proceeds are calculated as taxable profit - regardless of whether a profit actually occurred.
02 The 5 Most Common Causes
1. Dust Attack / Airdrop Scam
The most common cause of extremely high negative values: Scam tokens with real tickers. Fraudsters send worthless tokens to your wallet that carry the same ticker as real coins (e.g. "USDC", "SOL").
CoinTracking only recognizes the ticker - not that it's a worthless scam token with a different contract. The result: It looks like millions in USDC are leaving your wallet.
2. DeFi Aggregator Problems
Swaps via aggregators like Cowswap, Jupiter, 1inch are often not fully recognized. The outflow is recorded (you give away token A), but the inflow is missing (token B doesn't arrive).
The result: Token A goes negative because according to CoinTracking, more flowed out than was available.
3. Manual User Entries
An often overlooked factor: Unintentional "corrections" by users themselves. If you manually add or edit transactions without fully understanding the connections, gaps can unintentionally arise.
Typical example: You delete a transaction you think is "duplicate" - but it was the missing inflow for a later sale.
4. Bridge Transactions
When you bridge tokens from one chain to another (e.g. ETH from Ethereum to Arbitrum), CoinTracking must correctly record both sides. If one side is missing, a negative balance arises.
5. CEX Exchanges without Complete History
Some exchanges provide only limited histories via API. If you bought on Binance in 2019 and sold in 2024, but only data from 2022 was imported, the purchase history is missing.
Quick Reference: Identify the Cause by Symptom
| Negative Balance in | Probable Cause | Solution |
|---|---|---|
| USDC/SOL/ETH with values in the millions | Dust attack or scam token with real ticker | Mark contract as scam or rename ticker |
| Token after DEX swap (Jupiter, 1inch) | DeFi aggregator: inflow not recognized | Manually add missing inflow |
| Asset after manually deleting a TX | Manual user correction removed inflow | Restore deleted transaction |
| ETH/token after bridge | Bridge only imported one side | Import destination chain as separate source |
| Altcoin purchased years ago | CEX API doesn't provide complete history | Re-import complete CSV export |
03 Diagnosis: Transaction Flow Report
CoinTracking offers a specific tool for diagnosing negative balances. You can find it under Analysis → Checks → Transaction Flow Report.
How to find the cause:
- Go to Analysis → Checks → Transaction Flow Report
- Filter by warnings, this shows you the affected assets and when negative balances occur
- You'll see the timeline of your balances per asset
- The transaction directly before going negative is usually the cause
04 Step-by-Step Diagnosis
Systematic analysis of negative balances follows a structured process. Here's how to proceed:
Step 1: Balance Per Exchange
Start with the "Balance Per Exchange" view. Here you identify on which wallet address a negative balance exists. Not every negative balance is equally relevant - prioritize by value and context.
Prioritization by relevance:
- High priority: ETH, BTC, USDC, USDT - relevant assets with real value
- Medium priority: Altcoins depending on portfolio context
- Low priority: Obvious scam tokens, dust
Prioritization depends on the respective activity profile. Someone trading heavily on Solana prioritizes differently than someone focused on Ethereum DeFi.
Step 2: Determine Actual Difference
"Balance per exchange" only shows the difference to 0 for negative balances. To know the actual deviation, you must check the real on-chain balance - for example via Etherscan, Arbiscan, or the respective block explorer.
Compare: What does CoinTracking show? What is actually on-chain? The difference shows you the extent of the problem.
Step 3: Transaction Flow Check
Filter the transaction flow by the affected asset and the exchange/wallet where the negative balance occurs. This way you see all relevant inflows and outflows.
Step 4: Balance Over Time
Analyze the balance progression over time. The goal: Identify where the balance first goes negative and at which transaction this happens.
Typical patterns:
- Sudden jump to negative: Single transaction is missing or wrong
- Gradual decline: Multiple missing inflows over time
- Extreme spike: Scam token with high fake value
Step 5: TX-by-TX Comparison with On-Chain
Sometimes you find the error quickly - an obviously missing transaction. In more complex cases, you must compare the balance transaction by transaction from the beginning with on-chain data (e.g. Etherscan).
05 Preventive Measures
Negative balances can often be avoided. These measures help:
Regular Checking
Don't check your balances only when filing taxes. Conducting a brief check quarterly or after major activities saves extensive corrections later.
Combine API + CSV
API connections often provide only limited historical data. Supplement them with CSV exports directly from exchanges to obtain complete histories.
Caution with Manual Changes
Before making manual changes:
- Understand the change's impact on overall balance
- Don't delete transactions you don't fully understand
- Document what you're changing and why
- After each change, check if new negative balances have appeared
Mark Scam Tokens Early
When you recognize a scam airdrop, immediately mark the contract as scam or change the ticker. This prevents the fake values from distorting your balances.
06 What Happens in the Tax Report: "Short (Warning)"
The actual problem shows up in the tax report. CoinTracking marks sales without purchase history with "Short (Warning)" and sets the cost basis to 0.00 euros.
In the example you see: Trades are calculated with cost basis 0.00 euros, resulting in fictitious taxable profits of 4,106 euros, 855 euros, 575 euros - per trade.
07 Tax Consequences of Negative Balances
Negative balances are not just a technical problem - they lead directly to incorrect tax calculations. Every "Short (Warning)" with a cost basis of 0 EUR means: Your tax return contains wrong numbers.
| Risk | Impact |
|---|---|
| Short Warning with cost basis 0 EUR | Entire sales proceeds are calculated as taxable profit - even if you actually made a loss |
| Scam token as real position | Worthless tokens appear as real assets with fictitious profits in the tax return |
| Many negative balances across multiple assets | FIFO chain (DE) or average cost method (AT) is systematically flawed, every subsequent trade is calculated incorrectly |
| Uncorrected discrepancies | During a tax audit or inquiry by the tax office, the seamless documentation is missing |
With the upcoming DAC8 directive, crypto platforms will report transaction data directly to tax authorities. Discrepancies between your reported numbers and the platform data will become automatically visible. Clean documentation is no longer optional but becomes mandatory. Faulty balances also cause problems when providing proof of funds to banks or exchanges.
08 Fix CoinTracking Negative Balances: Solution Approaches
Depending on the cause:
For scam tokens:
Two options: 1. Mark the contract as scam - CoinTracking will then automatically delete all tokens with that contract. 2. Change the ticker to a unique name (e.g. "USDC-SCAM") to separate it from the real asset.
For DeFi aggregators:
Check the missing inflows and add them manually. CoinTracking doesn't recognize every aggregator automatically.
For manual errors:
Reconstruct the original transaction. Often an inflow was accidentally deleted or misclassified.
For bridges:
Both sides of the bridge must be recorded. Often the incoming side must be added manually.
When Professional Help Makes Sense
For simple cases (a few scam tokens, an obvious DeFi error), correction is manageable. For more complex portfolios with:
- Dozens of negative balances
- Multiple DeFi protocols
- Historical data spanning multiple years
- Multi-chain activity
...correction can become time-consuming. TX-Partner specializes precisely in these cases.
Co-Founder & Documentation Specialist
Robert Thorn is Co-Founder of TX-Partner, specializing in complex crypto documentation for tax advisors and private investors in Austria and Germany.
