Crypto Reporting & Audit
Audit-proof preparation of your transactions: CoinTracking, Blockpit and Koinly configured, verified and documented correctly.
Every crypto tax return is only as good as the report behind it. CoinTracking, Blockpit and Koinly are powerful tools, but they compute what they are fed: a missing wallet turns a transfer into a sale. A missing acquisition price creates a phantom gain. Wrong depot settings break the holding periods. I work with these tools daily, know their typical failure modes and turn your raw data into a report that does two things: state the correct tax and survive a review by the German tax office.
The typical errors in crypto tax reports
- Phantom gains from missing wallets: the tool knows only half the history and treats moves between your own wallets as taxable sales.
- Wrong wallet separation: holding periods and FIFO order must be determined per wallet according to the Federal Ministry of Finance circular of 6 March 2025. Wrong tool settings produce systematically wrong results here.
- Missing acquisition data: coins without purchase history run with acquisition cost zero, and the entire sale proceeds appear as gain.
- Misclassified events: staking rewards as trades, airdrops as purchases, internal exchange transfers as disposals. Every misclassification shifts the tax.
- DeFi blind spots: liquidity pools, wrapped tokens, bridges and restaking are not mapped fully automatically by any tool. This is where manual work with real understanding is needed.
How an audit-proof report is built
- Inventory. Which exchanges, wallets and activities existed? We collect all sources: API access, CSV exports, wallet addresses.
- Import and reconciliation. All data goes into the tool, then the decisive step: reconciling the computed balances against your real balances. Differences show where data is missing or misassigned.
- Correction and documentation. Transfers are matched, events classified correctly, gaps closed. Every correction is documented so the derivation stays traceable for the tax office.
- Report and handover. The result is a tax report with a clean gain calculation, separated into private sales under Sec. 23 EStG and other income. I use it for your tax return, or you hand it to your own advisor.
Reconstruction: when data is missing
Closed exchanges, deleted accounts, lost exports: the normal case for long-term investors. Much can be recovered, because the blockchain forgets nothing, bank transfers to exchanges prove deposits and withdrawals, and many platforms still hand out archive data on request. Whatever is gone for good gets closed with documented, comprehensible assumptions. The goal: a history you can explain to the tax office, instead of an estimate the tax office dictates to you.
Audit: review of your existing report
You maintained your tool yourself and want to know whether the result holds? The audit answers exactly that: I check completeness of sources, wallet separation, transfer matching, classification of events and plausibility of the results. You either get confirmation that your report is solid, or a concrete list of issues with priorities. Particularly useful before filing or when larger amounts are at stake. And if the review shows that earlier years were under-declared, there is an orderly way to fix it: the voluntary self-disclosure.
What it costs
The effort depends on transaction count, platform variety and DeFi share, so the offer follows the free initial consultation and a look at your data situation. For orientation: auditing a well-maintained tool account costs considerably less than a full multi-year preparation. In both cases you know the price beforehand.
The methodology: wallet-based FIFO done right
The order of disposal for crypto follows the FIFO method, wallet-based per the current Federal Ministry of Finance circular. That sounds like a tool setting but is the most common source of error: anyone moving balances between wallets does not change the order but must flag the moves as internal transfers. If that does not happen, the tool treats the transfer as a sale and the FIFO chain breaks. A solid report maps the FIFO order correctly per wallet and shows holding periods to the day, the basis for separating tax-free and taxable shares.
What we need for a clean report
- Exchange access: either a read-only API key or complete CSV exports over the whole period.
- Wallet addresses: all public addresses across all chains used, so on-chain activity can be evaluated directly.
- Records of deposits and withdrawals: bank transfers to exchanges help close gaps and make balances plausible.
- Information on special cases: staking, lending, liquidity pools, airdrops, hard forks and old, now-closed platforms.
A read-only access is enough; I never need trading or withdrawal rights, and your private keys stay with you.
NFT and DeFi reporting in detail
Standard imports often capture NFTs and DeFi wrongly or not at all. For NFT trading, purchase, sale, gas fees and any royalties must be allocated correctly. For DeFi, each interaction must be checked for whether a taxable swap occurred, for instance when entering a liquidity pool, and how ongoing rewards flow in. Wrapped tokens, bridges and restaking create extra events no tool maps fully automatically. This needs manual work with technical understanding and a documented derivation so the classification holds in an audit.
Data quality: how we ensure completeness
The decisive quality step is reconciling the balances calculated by the tool against your actual balances on the cut-off date. If a balance does not match, either a source is missing or an allocation is wrong. This difference analysis surfaces exactly the gaps that otherwise lead to phantom gains or under-declaration. Only when calculated and real balances match is the report reliable. This is what separates a reviewed report from a mere tool export.
Audit checklist: how to recognize a solid report
- All exchanges and wallets are captured, not just the main ones.
- Internal transfers are flagged as such, not counted as sales.
- Every balance matches the actual balance on the cut-off date.
- Staking and lending inflows are valued individually at the daily rate.
- Holding periods are shown wallet-based and to the day.
- Corrections and assumptions are documented comprehensibly.
If the review shows that earlier years were under-declared, there is the orderly route via the voluntary disclosure.
As of June 2026. This text is general information and does not replace individual advice.
Typical Clients
The Tool-Frustrated
Your CoinTracking shows gains you never made or balances that do not exist. I find the error sources and bring the report down to your real numbers.
The Gap Owner
Old exchanges closed, wallets forgotten, CSV files lost. I reconstruct your history from blockchain data, bank statements and archives, as far as technically possible.
The Self-Manager with Doubts
You maintain your tool yourself and want certainty before filing that everything is correct. That is what the audit is for: I review your report and you get a clear verdict.
FAQ about Crypto Reporting & Audit
Your Next Step. Free.
15 minutes via MS Teams. No sales pitch, no fine print. Just talk, clarify your situation, explore options.
Or write to us: m.ernst@tax-sparrow.de
