NOTE: For best results, please use a desktop browser to reconcile Needs Review flagged transactions instead of mobile web browser or the mobile app.
Note: For more info on how wallet balances are calculated and how to spot which wallets/exchanges might be missing transactions, see this help doc: https://support.cointracker.io/hc/en-us/articles/16035089047185
Introduction:
CoinTracker users may see the their transactions marked with the Needs Review message: Insufficient balance in wallet
CoinTracker uses this message primarily to indicate that some transaction history for that wallet or exchange is missing or inaccurate within CoinTracker. This can happen if:
- CoinTracker was unable to obtain the full transaction history for a wallet address.
- An exchange API does not provide the full transaction history to CoinTracker.
- An imported CSV file is missing or has incorrect transactions.
- CoinTracker is treating certain types of transactions, such as transfers, DeFi, or NFTs, incorrectly (i.e., illiquid staking, unmatched transfers, unsupported tokens such as new ERC standards, etc.).
- Asset quantities with a lot of decimal points are rounded up, causing small discrepancies.
Let’s look at an example of what these insufficient balance flags look like, here we have a disposal (Outgoing) of AVAX that resulted in an insufficient balance in wallet flag:
CoinTracker doesn't have records of receiving the AVAX, so the transaction history may be incomplete or inaccurate. CoinTracker assumes a cost basis of $0 for either a partial amount or the entire disposal quantity due to the absence of recorded cost basis.
How do I resolve this error?
Here is a step-by-step checklist to follow to help resolve this error:
[ ] Confirm you have added all of your wallets and exchanges reflecting your entire, cryptocurrency transaction history
We would like to stress the significance of providing your complete transaction history for cryptocurrency. Your entire transaction history ensures that we have all the necessary data to accurately calculate cost basis and proceeds for each transaction. It is important to include all exchanges, self-custody wallets, coins/tokens, ICOs, trades, DeFi transactions, transfers, withdrawals, and deposits. Leaving any transactions out can skew your portfolio and cause incorrect tax calculations.
👉🏽 See this guide for common scenarios users may run into that could affect complete transaction history: I am missing transactions from a wallet or exchange and/or my balances are incorrect. What should I do?
[ ] Sort your Needs Review transactions by Oldest to Newest
Sorting your Needs Review flagged transaction from Oldest to Newest allows you to view your transactions in chronological order. Focusing on the oldest transactions may have cascading effects on future errors so we encourage working your way from the oldest insufficient balance flagged transaction to the newest.
Here is how you filter by Needs Review:
Status: Needs review
Here is how you order by your oldest transactions:
Sort by: Oldest
[ ] Review your first Insufficient balance in wallet flagged transaction
Users will see the following error:
Users can select the
Review purchase historylink, this will open a new tab with a filtered transactions page for all AVAX (or specified asset) transactions prior to the flagged transaction. Users should compare these transactions to their wallet or exchange records to confirm accuracy and missing transactions.
[ ] Review the negative balance quantity, what is the balance discrepancy?
Users will have access to our
Remaining Balancefeature by selecting the wallet icon next to their transaction:
The quantities displayed in the wallet balances reflect the quantities after that transaction is complete. Let's look at a few examples:
Example #1, in the image above, the user transferred ~25 SOL from a self-custody SOL wallet to Coinbase and after the transaction was complete the user had an ending balance of negative ~25 SOL indicating they sent more SOL than they are holding. This is an example of an insufficient balance that is likely due to missing or incorrect transaction history because of the size of the negative quantity. User's can compare their transaction history from their Solana wallet with the transaction history on a block explorer or wallet history.
Example #2, here is a stETH transaction with a partial / smaller discrepancy:
In this example, you can see that CoinTracker is flagging this transaction resulting in a missing balance of negative ~0.048XXX stETH. This is an example partially missing data due to the nature of staking. In this case, LIDO staked ETH increases in quantity on-chain but is not reflected as received staking rewards.
👉🏽 There can be a range in discrepancies when seeing an Insufficient balance in wallet flagged transaction. There are occasions in which a user may see flagged transactions due to rounding decimals by CoinTracker, as well as minor data sync issues but there are also occasions when CoinTracker may be missing transactions that are not yet supported and missing entirely. Regardless of the size of the discrepancy, CoinTracker assigns a cost basis of $0 to negative quantities disposed.
[ ] Make manual edits or add a manual transaction to adjust for the discrepancy or missing transaction history
If you notice discrepancies such as a missing or inaccurate transaction, you can manually add missing transactions or edit existing transactions using these guides:
Once you have added the missing transactions, CoinTracker will re-compute your cost basis—you'll see a yellow banner at the top of the page.
When the yellow banner is gone, users will know the re-computation is complete, refresh the page. You should see the red error removed from your flagged transactions.
I've added the missing transactions, but I still see errors. What should I do?
We understand that these errors can be confusing. We strive to improve our integrations and tooling to empower users to address flagged transactions and achieve quality and accuracy, so we want to hear from you!
If you have lingering flagged transactions that are not resolved, please visit our public Transaction Error forum and upvote any posts that reflect the behavior you are experiencing or create a new post. This will subscribe you to updates so you will be alerted as soon as there is a fix or more information. Our forum is a great resource to identify known gaps in data for some of our wallets or exchanges, so your feedback is heard and appreciated!
Please reach out to us directly if you need additional support!