All Collections
Portfolio Tracking
How does the Portfolio Tracker work?
How does the Portfolio Tracker work?

Learn how CoinLedger's Portfolio Tracker calculates your asset balances.

Benjamin Yoder avatar
Written by Benjamin Yoder
Updated over a week ago

CoinLedger’s Portfolio Tracker tracks the amount, price, market value, cost basis, percentage change, and unrealized return of the cryptocurrencies held across all of your imported wallets.

How does the Portfolio Tracker calculate my asset balance?

CoinLedger calculates your asset balances based on the imported transaction data across all of your wallets. If you do not import all of your historical transactions into the system, your tracked balances will not be correct.

Example:

Suppose you have the following transaction history imported into CoinLedger:

  • Deposit 1 BTC

  • Trade 0.5 BTC for 1 ETH

  • Withdrawal 0.25 BTC

In this example, your calculated balances would be 0.25 BTC and 1 ETH. CoinLedger sums together all of the debits and credits for each asset to arrive at the calculated balance.

Does CoinLedger use a Global Wallet for asset balance calculations?

Yes. CoinLedger sums the transactions across all of your imported wallets to arrive at a “Global Wallet” asset balance. This global asset balance is what gets reported on the portfolio tracker.

Does CoinLedger use “reported balances” from exchanges or blockchains to display asset balance?

No. All balances displayed in the portfolio tracker are calculated based on your imported transaction data.

Why are my asset balances incorrect?

CoinLedger calculates your asset balance based on your imported transaction data.

If your asset balances are incorrect, this means that the sum of the debits and credits from your imported transaction data do not add up to your current holdings. If this is the case, there is missing or inaccurate transaction data imported to your CoinLedger account. We also recommend double-checking that you have not ignored any transactions on your account, as ignoring a transaction would exclude it from the calculations our portfolio tracker uses to display your asset balances.

You can troubleshoot your asset balances in the Portfolio Tracker by using the Asset Balance Report. The Asset Balance Report allows you to view each of the transactions that CoinLedger uses to calculate your balances. To locate the Asset Balance Report, click on any underlined balance on your account, or click on any balance that is marked with a red Negative Balance Warning, as shown below. Both of these methods will take you to the Asset Balance Report.

From there, you can drill down into each of the transactions influencing your asset balance calculations, including taxable transactions such as trades and fiat sells, and nontaxable transactions like deposits and withdrawals.

Why am I getting a Negative Balance Warning?

If the debits and credits associated with your imported transaction data add up to a negative number for a particular asset, you will see a Negative Balance Warning reported on your asset holdings breakdown.

Example:

Suppose you have the following transaction history imported into CoinLedger:

  • Deposit 100 SOL

  • Trade 25 SOL for 1 ETH

  • Withdrawal 100 SOL

In this example, your calculated balances would be (-25) SOL and 1 ETH. In this case, CoinLedger will flag a Negative Balance Warning for your SOL holdings.

How can I fix a Negative Balance Warning?

As illustrated in the example above, Negative Balance Warnings are the result of inaccurate or incomplete imported transaction data. To fix them, you should review all of your imported transactions. Transaction data can be added, edited, and altered on the Transactions tab, but you can also view the transactions factoring into your asset balances on the Asset Balance Report.

As shown below, using the Asset Balance Report you can pull up the first instance of a negative balance for an asset on your account, making it easy to pinpoint the reason for that negative calculated balance.

Here we can see that Bitcoin on my account has a negative calculated balance. Using the Asset Balance Report, I was able to discover the first transaction with a negative calculated balance for that asset. I can see that the cause of this negative balance was a Fiat Sell on Crypto.com.

This likely means that I'm missing transaction history data for one of the platforms or exchanges I used to buy, sell and trade Bitcoin. I can resolve this Negative Balance by simply importing that missing data.

Why am I getting a Missing Cost Basis Warning?

CoinLedger calculates the cost basis for your assets based on your imported transaction data. If you have not imported data showcasing how you originally acquired some of your crypto, you will see a Missing Cost Basis Warning on your asset holdings breakdown.

Example 1:

Suppose you have the following transaction history imported into CoinLedger:

  • Deposit 1 BTC

In this example, you will have a Missing Cost Basis warning for 1 BTC flagged. A simple deposit does not tell CoinLedger how you originally acquired that 1 BTC. Thus, there is not enough information to set the cost basis for the asset.

Did you originally buy it with dollars? Did you earn it as income from a job? Did you receive it as a gift? If any of these are true, you need to edit the deposit transaction into its true transaction type (income, fiat buy, gift, etc.) on the Transactions tab. Doing so will properly set the cost basis for the asset.

Example 2:

Suppose you have 2 primary wallets with the following transaction history:

Coinbase Exchange:

  • Buy 10 ETH for $15,000 USD

  • Withdrawal 10 ETH

MetaMask Wallet:

  • Deposit 10 ETH

  • Trade 5 ETH for 0.5 BTC

For this example, let’s say you only imported your MetaMask wallet to CoinLedger. If this is the case, your ETH will be flagged with a Missing Cost Basis Warning. If solely the MetaMask transaction data gets imported, CoinLedger will be missing your original Fiat Buy of 10 ETH for $15,000 USD. This is the transaction needed to properly set the cost basis for your held ETH.

To learn more about how you can troubleshoot Missing Cost Basis Warnings, please review our Missing Cost Basis Warning help guide.

Why does the price of this asset on my account look incorrect?

Prices in CoinLedger's Portfolio Tracker are refreshed automatically on an hourly basis. The latest prices, grabbed directly from the market indexes we use for our historical pricing, should show up automatically when you first log into the app. If prices don't seem to be updated or accurate on your account, please hit the "Refresh Data" button in the top right corner of the screen. This should refresh the prices for you account.

Please not that, as our prices are refreshed on an hourly basis, it's reasonable to expect some small, slight variations in pricing from time to time.

What is market value, cost basis and unrealized return?

CoinLedger's Portfolio Tracker displays each asset in your account as well as the market value, cost basis and unrealized return for each. Here's a brief definition for each of those terms:

  1. Costs basis represents the original value of an asset for tax purposes. Put another way, it typically represents how much money you put into purchasing your crypto.

  2. Market value is the current fair market value of an asset, expressed in fiat currency.

    1. Ex: 1 BTC=$40,000 USD

  3. Unrealized return is the difference between the market value and cost basis fields. It's what your return would be if you disposed of the assets, given what you invested to acquire them.

Other questions?

CoinLedger’s Portfolio Tracker is still a new product. If you have other problems, suggestions, or questions, please reach out to our support team. We will be thrilled to hear from you!

Did this answer your question?