After syncing your wallet via API, you may see a yellow warning sign next to some of the assets, informing that the reported and calculated balances don't match in the wallet. This article explains what the two balances mean and what to do to fix an issue like this:
When syncing your wallet/exchange via API, Koinly will download two sets of data:
Your activity (full transactions history)
A snapshot of asset balances (assets currently held, as reported by the API). We call those ๐ Reported balances
Koinly will then import & process all the transactions provided and arrive at balances of your assets as the outcome. These are your ๐งฎ Calculated balances. We will report any difference between the two balances as:
Difference = Koinly Balance - API Balance
๐ Comparing reported and calculated balances
| ๐งฎ Calculated balances | ๐ Reported balances |
Source | Based on transactions imported | Self-reported by the API |
Tax Reports | Used in all generated reports | Not used in reports at all |
Purpose | Confirmation if data is complete, to generate EOY balances in reports | Only to cross-check if imported data is complete |
Accuracy | Will be correct only if the imported data is complete | Correct most of the time (which is why they're a good reference) |
The "important" balances are the ๐งฎ Calculated balances as those are the balances that are based on transactions imported and will show in your reports. These are the balances that need to match reality.
If ๐งฎ Calculated balances are wrong:
Transaction history imported is wrong or incomplete
This issue needs to be fixed as data in Koinly doesn't match reality
If ๐ Reported balances are wrong:
API may be providing outdated information
API may be providing information in a different way than Koinly (e.g. limit orders, see common reasons below)
If ๐งฎ Calculated balances are correct, then the issue with ๐ Reported balances doesn't need to be fixed as it doesn't affect your tax reports.
You can even hide reported balances altogether by toggling Ignore reported balances
๐งโ๐ง How to fix wrong balances
To fix the wrong balances in Koinly you need to fix the underlying issue - incomplete transaction history imported. Most common solutions include:
Trigger a full resync of the wallet
Delete the wallet and add it again using the same API
Delete the wallet and add it again using CSV files only
For more detailed troubleshooting, check:
โ๏ธ Not all balance errors need fixing
Some imbalances are due to differences in how data is reported and, in fact, your ๐งฎ calculated balances are correct and everything is accounted for. It depends on what the issue is and what's the reason for the imbalance warning - check some common issues below.
โณ๏ธ Common reasons for balance mismatches
1. Rounding
๐ข Not necessary to fix
Data provided by the API may be rounded, so the calculated balances don't match the reported once exactly but minor errors below 6th decimal don't need to be fixed.
โ
2. Open Orders
๐ข Not necessary to fix
Exchanges may report your "available" balances only, as some assets are locked in limit orders. Koinly will import your trades once they actually happen.
โ
3. Staked assets
๐ข Not necessary to fix
An exchange may exclude staked assets in their ๐ reported balances, but Koinly will include them in the ๐งฎ calculated balances because we skip staking transactions. If the staked assets are accounted for in Koinly in your balances (in your totals or in your pool wallet) this warning can be ignored - see Staking and Farming Tokens.
โ
โ
4. Delayed update
๐ข Not necessary to fix
The API may already provide the most recent transactions (so the ๐งฎ calculated balance is correct) but the ๐ reported balance is still old. This usually happens if you sync the wallet in Koinly right after the transaction took place and this issue will self-resolve the next time you sync the wallet.
โ
โ
5. Reflection/taxed tokens
โ ๏ธ Needs to be fixed
These are not reported as transactions on the blockchain so Koinly cannot import them automatically. See Reflection, Taxed and Rebase tokens.
โ
โ
6. Spam
โ ๏ธ Needs to be fixed
Some spam transactions (especially due to address poisoning) may show as imbalances in your wallet - you can fix such imbalances by marking all spam transactions as such. See Spam tokens, worthless NFTs, rug pulls.
โ
โ
7. Other missing transactions
โ ๏ธ Needs to be fixed
Not all transactions may have been imported, resulting in wrong ๐งฎ calculated balances. This may be caused by Exchange API limitations and needs fixing, as your transaction history in Koinly doesn't match reality. See ๐ Some transactions are missing.
โ
8. Errors in manual data entry
โ ๏ธ Needs to be fixed
Manual changes made in the account (adding transactions, merging transactions, editing transaction timestamps, etc.) may have been in fact incorrect, causing errors on the ledger. Unfortunately, often the easiest way to revert all manual changes is by recreating the wallet (deleting it and adding it again).
Can I use reported balances in my tax reports?
โ No, reported balances cannot be used in tax reports as they do not reflect transactions in those reports.
Reported balances are just a snapshot of balances reported by the API (e.g. exchange). Koinly will only keep the last reported balances (from the last sync) and won't have the reported balances for any particular date (e.g. end of year).
As such - if there is a mismatch between reported/calculated balances and calculated balances are wrong, the solution is to find the source of the issue (e.g. missing transactions) and fix it, so that the calculated balances match reality.