TL;DR: The Roll Forward / Audit Report provides a complete breakdown of asset movements over a selected period. It shows opening and closing balances, cumulative cost per unit, sales prices, and realized gains or losses. The report is designed for audits, financial statements, and tax compliance, offering precise tracking of asset acquisition and disposal.
What is the Roll Forward / Audit Report?
The Roll Forward Report is an audit and reconciliation report that consolidates all incoming and outgoing transactions for each asset within a defined time range. Its purpose is to clearly document balances, cost bases, and realized gains or losses.
It is commonly used for:
Tax audits
Financial and annual statements
Internal reconciliation and compliance checks
How does the report work?
The report aggregates all relevant transactions and applies the selected cost basis method.
It:
Matches sales to prior purchases (e.g. FIFO, LIFO)
Calculates cumulative cost per unit
Determines sales prices
Calculates realized gains and losses using historical prices
When enabled, the “Best Price” logic is applied to ensure realistic valuation.
What settings and filters are available?
Cost Basis Method
You can choose from multiple methods, including:
FIFO, LIFO, HIFO, LOFO
HPFO, LPFO, HAFO, LAFO
OPTI, ZERO
Asset Type
Filter results by:
All currencies
Digital assets only
Commodities
Fiat currencies only
Pricing Model
Select how values are calculated:
Best Prices (recommended)
Transaction Prices
Counterpart Prices
Buy Prices
Sell Prices
Transaction Types
You can include or exclude specific transaction types such as:
Trades
Deposits and withdrawals
Rewards, income, mining
Fees
For gifts or income, a manual override can be applied to set a 0 EUR cost basis.
Depot Separation
When depot separation is enabled, wallets and exchanges are treated as separate tax lots.
This ensures correct attribution of deposits and withdrawals across different depots.
What does the table show?
Each row displays:
Transaction type (e.g. Buy, Sell, Deposit)
Amount and currency
Cumulative cost per unit
Sell price per unit
Sell value
Realized gain or loss
Exchange and transaction ID
Expandable rows reveal linked buy and sell pools and the exact matching transactions.
Common issues and troubleshooting
Missing coins: No profit is shown if the original purchase is missing
Gifts or mined coins: Default cost basis is 0 EUR unless adjusted
Incorrect cost basis: Review and correct values on the Transactions page
Gain warnings: Incomplete data may trigger errors
Additional guidance is available via the info icon in the filter area.
Can I export the report?
Yes. You can export the full report as:
CSV
Excel
PDF
You can also copy or print tables and filter or sort by date, exchange, transaction type, group, or ID.
Advanced usage
Additional features include:
Jumping directly to CoinTracking transaction IDs
Expanding or collapsing all transaction pools
Previewing lot exhaustion and lot-level matching
Summary
The Roll Forward / Audit Report is a key tool for audit-ready documentation.
It provides transparent tracking of balances, cost bases, and realized gains, making it ideal for tax audits, financial reporting, and internal compliance checks.