CoinTracking mobile

You're seeing a live demo. Register For Free to get started.

arrow

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

  • The amount of a coin does not match the value on the dashboard:
    The remaining amount of a coin can deviate from the values in the dashboard, because deposits and withdrawals will not be included in gains calculations.
    Enable the "Add Deposits & Withdrawals to remaining amount" checkbox to add them into the gains calculation (not recommended, as it does not make sense to calculate gains from zero cost basis items like deposits or withdrawals).
  • 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:
    Please ensure you are using the "Unsold Assets as Cost Basis" setting, because "All Assets as Cost Basis" will calculate with average prices and is not recommended (read more).
    If the cost basis is still off, the transaction values could be wrong. Open the Enter Coins 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

These filters apply to all three tables.

Prices:
This setting decides at which price your coins will be converted into your selected currency.

Counterpart Prices:
The counterpart price of your trade will be taken.
When you buy 1 BTC for 500 USD, we will convert 500 USD into your selected currency according to the trade price.
This setting is realistic, as it contains the spread and the fee. That's why your "Cost per Unit" will be slightly higher than the "Sell Price per Unit".
Shown in BTC, the above example may result in something like: Buy 1 BTC for 1.02 BTC (assuming 2% spread or fee).
Only if you did a perfect trade, without any spread and fee (what's nearly impossible), both values will be equal.

Transaction Prices:
The transaction price of your trade will be taken.
When you buy 1 BTC for 500 USD, we will convert 1 BTC into your selected currency according to the trade price.
This setting contains only the actual transaction price. Spreads, fees and other additional costs will be ignored. Your "Cost per Unit" will be exactly the same as the "Sell Price per Unit".
Shown in BTC, the above example will result exactly in: Buy 1 BTC for 1 BTC.

Best Prices: (recommended)
The currency with the lowest conversion difference (spread) is used in this order:
1. Fiat currencies (USD, EUR, GBP...)
2. Bitcoins (BTC)
3. Altcoins and commodities (ETH, LTC, XAG...)
  Method:
Changes the calculation method.
You can find an explanation and examples on the Tax-Report page.



Cost Basis:
Changes the method for the cost basis calculation.
Average of unsold Assets as Cost Basis is recommended. But use it only, if all your purchases and sales are set correctly.More details.



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



Add Deposits & Withdrawals to remaining amount:
Disable: Calculates all gains and the costs basis from trades only. (recommended)
The remaining amount of a coin can deviate from the values in the dashboard, because deposits and withdrawals will not be included.

Enable: Includes all deposits and withdrawals into the calculation.
Gains and the cost basis will change as deposits and withdrawals do not have a cost basis.
Filter (16/16)
  • Trade Types (9/9)
  • select all | unselect all
  • Exchanges (6/6)
  • select all | unselect all
  • Groups (1/1)
  • select all | unselect all
  • Period of Time (all)
  • remove date filter
  • Purchase date start:
  • Purchase date end:
  •  
  • Sale date start:
  • Sale date end:
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.



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