CoinTracking mobile

Live Demo


Roll Forward / Audit Report

This Roll Forward report provides the detailed asset data that you require for financial statements, tax reporting and period closing.
It includes the start and end balances for all assets, together with valuation movements and any new asset purchase and sell that occurred during the report period.

This calculation is for experienced users. Hover over the Info icons on the right for additional information.
In order to correctly display the values on this page, it is imperative that all data has been entered correctly and completely into CoinTracking. If you encounter any problems, please read and follow the FAQs.

What can be done on this page?

  • Create roll forward reports required for audits and tax reporting
  • Review your used purchase pools for every single sale by clicking on the PLUS icon next to a sale or outgoing transaction
  • Jump to a purchase by clicking on the CoinTracking Transaction ID in the sales details list
  • Expand / Collapse all rows
  • Set the calculation settings
    • Prices
    • Method
    • Cost basis
    • Currency filter
    • Filter all entries by type, exchange, group and date
    • Add deposits and withdrawals into the calculation
    • Group all purchases by day
  • Search and sort your entries
  • Export all entries as CSV, Excel or PDF

Possible problems and solutions

  • This page is empty or a coin is missing:
    Gains are calculated from the value at purchase and the value at sale. If you do not have sales in your account, no profit will be displayed.
  • Gifts, mined coins and income are not charged with 0 USD:
    All incoming transactions such as gifts, mined coins and other income are calculated by default with the cost basis at the time of the transaction. If you would rather calculate with a cost basis of 0 USD, open the "Filter" and click on the corresponding trade type twice.
  • The cost basis seems wrong:
    If the cost basis is off, the transaction values could be wrong. Open the Transactions page and correct the value of the asset, if necessary (instruction).
  • Warnings for realized gains: It is imperative that all purchases and sales are entered correctly and completely in CoinTracking. If purchased coins are missing, this will lead to warnings and incorrect values for all gains calculations! (read more).
  • Hover the info icon in the upper right corner of each box for more information. Please also read the Gains FAQs if you have issues on this page.
CoinTracking · Chart
info
Filter settings

Method:
Changes the calculation method.
You can find an explanation and examples on the Tax-Report page.



Currency Type:
Select between digital currencies (BTC, ETH...), commodities (Gold, Silver...), Fiat Currencies (USD, EUR...) or all together.
We are recommending "Only digital currencies".



Use depot separation:
By default, CoinTracking uses an overall method across all exchanges/wallets and calculates cost bases purely by date sequence. By activating the depot separation, all exchanges and wallets are treated as separate depots (tax lots).
Please ensure that all your deposits and withdrawals between exchanges/wallets are set completely and correctly in your CoinTracking account when enabling this setting.
This new depot separation automatically recognizes all deposits and withdrawals and assigns them to the respective exchanges/wallets.
  Conversion:
In order to calculate your gain and tax, all your trades that are not in your FIAT currency, must be converted into your FIAT currency at the time of the transaction.
We strongly recommend to use the 'Best Prices' setting.

Best Prices (recommended): will convert in this order:
1. FIAT currencies (USD, EUR, GBP...)
2. Crypto currencies and commodities based on their market cap
Transaction Prices: will convert the 1st part of your trade-pair into FIAT as cost base:
Counterpart Prices: will convert the 2nd part of your trade-pair into FIAT as cost base
Buy Prices: will always convert the buy part of your trade-pair into FIAT:
Sell Prices: will always convert the sell part of your trade-pair into FIAT

Example 1: Buy 1 BTC for 3000 USD (assuming USD is your FIAT currency)
- Best Prices: will use 3000 USD (no conversion here), since USD has a higher priority than BTC
- Transaction Prices: will convert 1 BTC into USD
- Counterpart Prices: will use 3000 USD (no conversion here)
- Buy Prices: will convert 1 BTC into USD
- Sell Prices: will use 3000 USD (no conversion here)

Example 2: Buy 60 ETH for 1 BTC (assuming USD is your FIAT currency)
- Best Prices: will convert 1 BTC into USD (as cost base and proceeds), since BTC has a higher priority than ETH
- Transaction Prices: will convert 60 ETH into USD as the ETH cost base and will convert 1 BTC into USD as the BTC proceeds value
- Counterpart Prices: will convert 1 BTC into USD as the ETH cost base and will convert 60 ETH into USD for the BTC proceeds value
- Buy Prices: will convert 60 ETH to USD (as cost base and proceeds)
- Sell Prices: will convert 1 BTC into USD (as cost base and proceeds)

Example 3: Buy 1 BTC for 60 ETH (assuming USD is your FIAT currency)
- Best Prices: will convert 1 BTC into USD (as cost base and proceeds), since BTC has a higher priority than ETH
- Transaction Prices: will convert 1 BTC into USD as the BTC cost base and will convert 60 ETH into USD as the ETH proceeds value
- Counterpart Prices: will convert 60 ETH into USD as the BTC cost base and will convert 1 BTC into USD as the ETH proceeds value
- Buy Prices: will convert 1 BTC into USD (as cost base and proceeds)
- Sell Prices: will convert 60 ETH into USD (as cost base and proceeds)

Filter (46/46)
  • Transaction Types (44/44)
  • select all | unselect all | 0 costbase
  • Incoming Transactions
  •  
  • Outgoing Transactions
  •  
  • Exchanges (1/1)
  • select all | unselect all
  • Groups (1/1)
  • select all | unselect all
  • Period of Time (all)
  • remove date filter
  • Start date:
  • Start time:
  • End date:
  • End time:
Use the 'half checked' state for Trade Types,
to calculate them with a cost basis of 0 USD.
info
Roll Forward Report

This table contains all incoming and outgoing transactions. Click on the PLUS icon next to a sale (or outgoing transaction) to display the list of purchases related to this sale.
  • Type: Can be any incoming (buy, income, mining...) or outgoing (sell, spend, donation...) transaction.
  • Amount: The transferred amount.
  • Cur.: The transferred currency.
  • Cumulated Cost per Unit:(*) The calculated average purchase price per unit from all purchases before this transaction (value of all purchases till this date / amount of all purchases till this date). Should the purchase amount be negative, no change and realized gain will be calculated.
  • Sell Price per Unit:(*) The calculated sell price per unit for this trade at the time of your transaction (sell value / amount). Only for outgoing transactions.
  • Change: The difference between your sale and the cumulated cost in percent. Only for outgoing transactions.
  • Cumulated Cost:(*) The calculated purchase value (Cumulated Cost per Unit * Amount).
  • Sell Value:(*) The sell value of this transaction (Sell Price per Unit * Amount). Only for outgoing transactions.
  • Realized Gain / Loss: The gain or loss you have achieved with this sale (Sell Value - Cumulated Cost). Only for outgoing transactions.
  • Date: The day and time of this transaction.
  • Exchange: The exchange name of this transaction.
  • CoinTracking Transact. ID: The internal CoinTracking ID for this transaction (not the exchange tx-id). Used to match incoming transactions to outgoing transactions.

Additional details for incoming transactions (click on the PLUS icon):
  • Buy Transaction-ID: The tx-id of the exchange. "none" if no tx-id is set.

Additional details for outgoing transactions (click on the PLUS icon):
  • Type: The type of input (buy, income, mining...) to be offset against the output.
  • Initial Buy Amount: The full value originally purchased/received.
  • Remaining Buy Amount: The remaining purchased/received value, in case parts of the purchase pool have already been sold.
  • Cost per Unit: The calculated purchase price per unit for this single transaction at the time of the transaction (cost / inital buy amount).
  • Cost: The calculated purchase price in total for this single transaction at the time of the transaction.
  • Date: The day and time of this transaction.
  • Exchange: The exchange name of this transaction.
  • CoinTracking ID: The internal CoinTracking ID for this transaction (not the exchange tx-id). Click on it to find the incoming transaction in the table (only if the transaction is on the same table page).
  •  
  • Buy amount prior sale: The amount of the purchase pool, prior the sale.
  • Buy amount after sale: The amount of the purchase pool, after the sale.
  • Sold amount: The amount that could be sold from the remaining purchase pool.
  • Remaining sell amount: The sales amount that remains at the end and must be offset against the next purchase pool.
  •  
  • Sell Transaction-ID: The sell tx-id of the exchange. "none" if no tx-id is set.
  • Buy Transaction-ID: The buy tx-id(s) of the exchange. "none" if no tx-id is set.
Export: You can export this table by clicking on the export buttons.
Column Sorting: Click on a column name to change the sorting. Shift-Click another column to sort multiple columns.

Prices and values for columns marked with (*), can be changed with the counterpart/transaction filter at the top of the page.

Roll Forward Report

This table contains all bought and sold currencies. Click on the PLUS icon next to a sale (or outgoing transaction) to display the list of purchases related to this sale.

Note: Please make sure that your account does not contain any missing transactions. It's best to check the Missing Transactions report for this.
Additionally, check the Balance Check report to ensure your account is in good condition.



Type Amount Cur. Cumulated Cost
per Unit
Sell Price
per Unit
Change Cumulated Cost Sell Value Realized
Gain / Loss
Date Exchange CoinTracking
Transact. ID