CoinTracking mobile

Você está vendo um demo ao vivo. Cadastre-se de Graça para iniciar-se.

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
    • 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

  • 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).
  • 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

Estes filtros se aplicam a todas as três tabelas.

Precos:
Esta configuração decide a que preço as suas moedas serão convertidas para a sua moeda selecionada.

Preços da Contra-Parte:
Será tirado o preço da sua contraparte.
Quando você compra 1 BTC por 500 USD, converteremos 500 USD para a sua moeda selecionada de acordo com o preço do mercado.
A configuração é realista, já que contém o spread e a taxa. É por isso que o seu "Custo por Unidade" será levemente maior do que "Preço de Venda por Unidade".
Exibido em BTC, o exemplo acima pode resultar em algo como: Compre 1 BTC por 1.02 BTC (presumindo um spread ou taxa de 2%).
Somente se você fez uma troca perfeita, sem nenhum spreak ou taxa (o que é quase impossível), ambos os valores serão iguais.

Preços das Transações:
O preço da transação será tomado.
Quando você comprar 1 BTC por 500 USD, converteremos 1 BTC para a sua moeda selecionada de acordo com o preço de mercado.
Esta configuração contém somente o preço real de transação. Spreads, taxas e outros custos adicionais serão ignorados. Seu "Custo por Unidade" será exatamente igual ao "Preço de Venda por Unidade".
Exibido em BTC, o exemplo acima resultará exatamente em: Compre 1 BTC por 1 BTC.

Melhores Preços: (recomendado)
A moeda com a menor diferença de conversão (spread) está usada nesta ordem:
1. Moedas fiduciárias (USD, EUR, GBP...)
2. Bitcoins (BTC)
3. Altcoins e commodities (ETH, LTC, XAG...)
  Método:
Changes the calculation method.
You can find an explanation and examples on the Tax-Report page.



Base de Custo:
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.



Tipo de Moeda:
Selecione entre moedas digitais (BTC, ETH...), commodities (Outro, Prata...), moedas reais (USD, EUR...) ou todos juntos.
Estamos recomendando "Somente moedas digitais".



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.
  • 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