Don't see your question listed here? Hit the "Suggest Edits" button in the upper right and add a question for our Support Team!
Send us your questions! We're happy to help!
Q. How do I run a report for just the specific token?
🅰️.
In order to run a report for just a specific token, you can do the same with the help of a register report. Here are the steps to run a register report:
Login to bitwave
Select 'Transactions' and click on 'Register'
Put in the 'Wallet name', Date, and the 'Ticker'
Click on 'Load register' and the report will run for that particular token
Q: How to check the Transactions having negative balances in Actions Report?
🅰️
You need to go through the Actions report to check the transactions which are causing the negative balances.
Steps to download the Actions Report.
In the left-hand corner of your Bitwave app,
Navigate to Inventory.
Click on Update Now
Wait for few minutes to update the Inventory view (you can check the update status in the Updates.
Go to Actions
Run the Actions report on the desired date.
Then Click on Download Actions of (desired date).
Filter the "assetBalance" in the report to get the transactions causing the negative balance.
Be make sure that all the transactions are categorized before doing all these steps."
Q: How to check the variance of specific token in a wallet?
🅰️
Go to Register under Transactions tab on the left hand side menu
Select the Wallet under the Wallet Name dropdown.
Choose the desired date.
Fill out the Token name in the Ticker Box
Click on "LOAD REGISTER".
Q : What causes the balance report not to pull in pricing?
🅰️: The balance report doesn't pull pricing when there is no pricing for the asset on the day selected from the pricing source configured for that org.
Q: What is the difference between Journal Entry Report and Journal Entry (Expanded) Report
🅰️ Journal Entry Report: This report provides the detailed transaction by transaction view of the rolled up journal entry report. It can be exported to a CSV file.
The Report Total for Debit and Credit at the bottom of the report is the net asset change to Digital Assets only. Journal Entry Report (Expanded): This report provides an expanded detailed transaction by transaction CSV download that can be saved and accessed on a future date.
Q : Does Bitwave have a feature to show block numbers?
🅰️: To get block numbers from Bitwave, simply :
Login to Bitwave.
Go to Reports.
Click on Balance report.
Select a date for which you want to get the block number.
Click on group by and select wallets and select any wallet.
The number that show here are the block numbers of that specific date.
Q: Why is an Unknown Wallet Appearing in My Balance Reports?
🅰️: One reason an unknown wallet could be appearing in your balance report would be that a wallet was deleted, but the transactions associated with the deleted wallet still remain in Bitwave. This can be resolved in one of two ways:
Adding the deleted wallet back into Bitwave
This option makes the most sense if it becomes apparent that the deleted wallet should not have been deleted.
Deleting the transactions with the associated wallet
This option makes the most sense if the associated transactions with the wallet need to be deleted. The process for this involves creating a system job to delete transactions with the associated wallet.
For this process of deleting these transactions, follow the steps below:
Navigate to the System Jobs page (Administration > System Jobs)
Click “Create Job"
Select “Delete Transactions” for the Action
Select the unknown wallet for the wallet
Select the desired date range
NOTE: It is recommended to start with a small date range to ensure the job is correctly implemented and only deletes the transactions that need to be deleted.
If the unknown wallet issue occurs from a scenario other than a deleted wallet with transactions remaining, please reach out to your Bitwave solutions expert for further assistance.
Q: How do I view the FIFO layers on Actions Report?
🅰️: The bitwave actions report can be sorted by column N lotAcquisitionTimestampSEC and then by column D timestamp. This will sort the buys as of the first lot acquired and sort disposals in FIFO order by lot.
Q: How do I extract data from bitwave for form 8949?
🅰️: The bitwave actions report provides all the detail required to produce your 8949. Each tax and accounting preparer has different requirements on the level of aggregation preferred or required (lot level, Asset level etc) and as such aligning with your technical tax / accounting expert will drive how you use the actions report to populate the 8949
Q: How do I extract data from bitwave for form 1099?
🅰️: The bitwave actions report provides all the detail required to produce your 1099. Each tax and accounting preparer has different requirements on the level of aggregation preferred or required (lot level, Asset level etc) and as such aligning with your technical tax / accounting expert will drive how you use the actions report to populate the 1099
Q: How to Download Actions Report:
🅰️: Go to Inventory.
Click on Actions.
Add the preferred date range or submit date filters.
Once filtered, click on "Download Actions" to export the report as a CSV file.
Q. Why does the balance check report show some third-party balance fields as empty?
🅰️ Currently, the balance check report in Bitwave displays third-party balances for major tokens. In the meantime, we recommend validating tokens using the balance report in Bitwave and comparing it with the on-chain balance.
Q. Is it possible to build own reports through API? like to pull data from the account into PowerQuery?
Q: Why sometimes there is a discrepancy in the coin balances between the number of open lot positions and the balances shown in the wallet balance report?
🅰️
The tax lots report is generated based on categorization, so if there are un-categorized transactions, or categorized transactions where the quantities do not match the actual transaction, this is what causes the difference.
Q: Which is the alternate report that can be used if balance report is showing error while generating?
🅰️
If balance report shows error while generating , you can use " Balance report (Expanded)" report to get the results.
Following are the steps to get balance report (Expanded)
Go to reports on left side menu.
2.Click on Balance report (expanded).
3.Fillout the date and the group by (whether by wallet or none)
4.Hit run and keep refreshing until the status says succeeded.
5.Once the status says suceeded, click on download button in front of the report to download the report.
Q: Do we have any report that gives summary of all the fees for tax purposes?
🅰️
If the bitwave environment is configured to capitalize fees on trades. and you only want fees that were expensed (not capitalized)
Then, you should use the Journal Entry report and filter it to your fee category(ies).
Q: How to get the Bitwave SOC report?
🅰️
To get the Bitwave SOC report you can reach out to us via in app chat support with following details
Org Name
Org ID
Q: How Do I Integrate Snowflake with Bitwave?
🅰️
To integrate Snowflake, please follow our setup guide here : Setup Snowflake
Q: The Gain/Loss report isn't working—how can I still get my data for book closing?
🅰️:
If the Gain/Loss report is not functioning, we recommend using the Inventory Views instead. Be sure to specify your report settings (e.g., FIFO method, capitalize fees, ignore NFTs) and request the data for the needed periods. You can also provide your Organization Name, Organization ID, and any other relevant details to support a quicker response.
Q: How can I export a report of all uncategorized transactions?
🅰️:
You can download the Actions report, then filter the “Status” column (Column F) for “Uncategorized.” If the numbers still seem off, try removing duplicate rows to align with what’s shown in the Transactions page. Make sure to update the Inventory View before download the Actions Report.
Q: Why do categorized fees still appear as “uncategorized” in reports?
🅰️:
If only part of the transaction (like the main asset) remains uncategorized, the report may still show all associated lines including the already categorized fee as “uncategorized.” Make sure all components of the transaction are fully categorized.
Q: Why do I see different numbers of uncategorized transactions in different reports (e.g., Actions report vs. Transactions page)?
🅰️:
The difference is usually due to how Bitwave displays transaction lines. For example, a single transaction with both a fee and an asset may show as two uncategorized lines in the Actions report, but only as one transaction on the Transactions page. To reconcile the numbers, try removing duplicates from the Actions report after filtering for “Uncategorized.”
Q: Why is there a -0.01 balance in my balance check report for a "null" account, and will this impact my reallocation?
🅰️:
Yes, a -0.01 balance showing for a "null" account can affect reallocation and may lead to errors. We recommend you finding that speicifc transactions of that null acocunt as the null account here simply means a deleted wallet. So, you may find those deleted wallet's transactions and delete those from UI and then update the inventory views
Q: What does "incomplete transaction" mean in the Actions Report?
🅰️:
"Incomplete transaction" usually indicates that a transaction is uncategorized. If a transaction appears as "incomplete" even after categorization, try uncategorizing and recategorizing it, and update your inventory view to the current date. If the issue persists, contact support with the transaction ID for further assistance.
Q: What should I do if I receive a "Problem generating report" error when running a Balance Report?
🅰️:
If you encounter an error while generating a Balance Report, try running an expanded version of the report. This often provides the needed results. If the issue persists, please contact our support team with your Organization ID and Organization Name and a description of the issue.
Q: How can I run a Cost Basis Roll Forward Report for a specific date range?
🅰️:
You can generate a Cost Basis Roll Forward Report by navigating to the “Reports” section under the appropriate view (e.g., Test View) and setting your desired date range (e.g., 01/01/2024 to 12/31/2024). If the report does not populate, please notify our support team.
Q: Where can I download a report that includes unrealized gains and losses for all transactions?
🅰️:
You can view unrealized gains and losses by downloading the Dashboard Summary from the Inventory view. For detailed transaction data, try downloading the Actions Report from the Inventory > Actions section. If you're unable to download it, let us know the specific date range, and we can assist you.
Q: How can I compare cost basis to Fair Market Value (FMV)?
🅰️:
You can use the Cost Basis Roll Forward Report. Go to the Inventory section → Reports → Cost Basis Roll Forward Report, and make sure to check the Include FMV option before running the report.
Q: Does the FMV section in Bitwave balance report show the value as of today or the transaction date?
🅰️:
The FMV shown of the assets are based on today's date.
Q: Why am I getting a "problem generating report" error when downloading the balance report?
🅰️:
This can occasionally happen due to cached data or a temporary system hiccup. Please try refreshing your browser, clearing cookies and cache, and then attempting the download again. If the issue persists, it may resolve after waiting a short while. If not, please contact support.
Q: How do I generate a gain/loss report or check the cost basis applied to transactions?
🅰️:
Download the Actions Report after categorizing your transactions and updating inventory views. This report includes cost basis and gain/loss information for each transaction.
Q: How can I view and compare cost basis against FMV in Bitwave?
🅰️:
Use the "Cost Basis Roll Forward" report available under Inventory > Reports. Be sure to select the option "Include FMV" before running the report to view FMV alongside cost basis.
Q: How can I trace which transaction turned a coin balance negative?
🅰️:
Use the Register Report filtered by token to track changes in balance over time. Alternatively, the Actions Report can also help, though it may be less efficient for pinpointing specific issues.
Q: Can I run the Register Report across all wallets in Bitwave?
🅰️:
No, the Register Report must be run per wallet. To analyze balances across multiple wallets, repeat the process for each with significant activity.
Q: Can adding old wallets after unlocking periods affect reconciliation?
🅰️:
Yes. Adding wallets with historical data can introduce uncategorized or unignored transactions into previously reconciled periods. This can disrupt locked balances and reconciliation statuses. To prevent this, consider applying ignore jobs before unlocking or consult support before taking such steps.
Q: What does it mean when the transaction exchange rate shows as 0 but FMV or cost basis seems correct?
🅰️:
The “transaction exchange rate” is a calculated display value. If it’s extremely small (less than $0.01), it may appear as 0 due to UI rounding. However, the correct rate was used in calculations. You can confirm by reviewing the FMV or CostBasisAcquired in the Actions Report.
Q: What should I do if I encounter an error when trying to generate a Balance report?
🅰️:
If you experience issues generating a Balance report, try running the "Expanded report" instead, which may provide the results you're looking for. If the problem persists, please reach out to our support team with your organization and wallet details so we can assist further.
Q: Where can I download a report that shows unrealized gains and losses for all transactions?
🅰️:
To view unrealized gains and losses, download the Dashboard summary within the Inventory view. If you need transaction-level details, try downloading the "Actions report" from the Actions section in Inventory. Let us know the date range if you need help pulling a specific report.
Q: How can I view and compare cost basis with FMV?
🅰️:
Use the Cost Basis Roll Forward Report. Go to Inventory Views > Reports > Cost Basis Roll Forward, and be sure to check the "Include FMV" option before running the report.
Q: Why is there a difference between the FMV shown in the dashboard and the balance report?
🅰️:
The dashboard and balance report should reflect the same Fair Market Value (FMV) for each asset. If you notice discrepancies, please report the specific assets and time periods to our team so we can investigate and resolve the issue promptly.
Q: How can I run a gain/loss report for the 2024 tax year in Bitwave?
🅰️:
To generate a gain/loss report for 2024, we recommend running the Cost Basis Roll Forward Report. This report provides realized short-term and long-term gains and losses, as well as unrealized gains and losses, using your selected cost basis method (e.g., FIFO or Cost Average). You can follow our Cost Basis Roll Forward Report Guide for step-by-step instructions.
Q: What information does the Cost Basis Roll Forward Report include?
🅰️:
"This report summarizes your transaction activity between any two dates. It provides:
Realized short-term and long-term gains/losses
Unrealized gains/losses (when ""Include FMV"" is selected)
Token-level breakdowns of gains/losses
Look for columns like “stGainLoss_fiat_decreases” (short-term) and “ltGainLoss_fiat_decreases” (long-term) in the exported file for detailed figures."
Q: How do I get proceeds and cost basis specifically for short-term and long-term gains?
🅰️:
"In the Cost Basis Roll Forward Report, you’ll see total proceeds and cost basis for your transactions. To isolate short-term vs. long-term gains:
Refer to the columns labeled for realized short-term and long-term gains.
These values represent the difference between proceeds and cost basis, broken down by term.
You can export this report to see the detailed cost basis and proceeds per token."
