CoinTracking mobile

Demo ao Vivo


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
    • Precos
    • Método
    • 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).
  • Passe o mouse sobre o ícone info no canto superior direito de cada box para mais informações. Please also read the Gains FAQs if you have issues on this page.
CoinTracking · Chart
info
Filtrar as configurações

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



Tipo de Moeda:
Select between digital currencies (BTC, ETH...), commodities (Gold, Silver...), Fiat Currencies (USD, EUR...) or all together.
Estamos recomendando "Somente moedas digitais".



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

Exemplo 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)

Exemplo 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)

Exemplo 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.
  • Tipo: Can be any incoming (buy, income, mining...) or outgoing (sell, spend, donation...) transaction.
  • Quantidade: The transferred amount.
  • Cur.: The transferred currency.
  • Custo Cumulado por Unidade:(*) O preço médio de compra por unidade calculado a partir de todas as compras antes desta transação (valor de todas as compras até esta data / quantidade de todas as compras até esta data). Se a quantidade de compras for negativa, nenhuma mudança e ganho realizado serão calculados.
  • Preço de Venda por Unidade:(*) The calculated sell price per unit for this trade at the time of your transaction (sell value / amount). Only for outgoing transactions.
  • Mudança: The difference between your sale and the cumulated cost in percent. Only for outgoing transactions.
  • Custo cumulado:(*) O valor de compra calculado (Custo Cumulado por Unidade * Quantidade).
  • Valor de venda:(*) The sell value of this transaction (Sell Price per Unit * Amount). Only for outgoing transactions.
  • Lucro / Prejuízo Realizado: The gain or loss you have achieved with this sale (Sell Value - Cumulated Cost). Only for outgoing transactions.
  • Data: 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):
  • Tipo: 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.
  • Custo por Unidade: The calculated purchase price per unit for this single transaction at the time of the transaction (cost / inital buy amount).
  • Custo: The calculated purchase price in total for this single transaction at the time of the transaction.
  • Data: 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.
Exportar: Você pode exportar esta tabela clicando no botão exportar.
Seleção de Coluna: Clique no nome de uma coluna para mudar a seleção. Clique e Shift outra coluna para selecionar múltiplas colunas.

Preços e valores para colunas marcadas com (*), podem ser alterados com o filtro contraparte/transação no topo da página.

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.



Tipo Quantidade Cur. Cumulated Cost
per Unit
Preço de Venda
por Unidade
Mudança Custo cumulado Valor de venda
Lucro / Prejuízo Realizado
Data Exchange CoinTracking
Transact. ID