Inventory Views


Q. How to delete transactions in bulk ?

🅰️:

Steps to delete transactions in bulk:

  1. Go to Administration tab on the left hand side menu

  2. Click on system jobs, then create job.

  3. In actions dropdown click delete transaction.

  4. Then select the wallet and time period and hit run.

Q. How to get pricing link of any token

🅰️ Bitwave takes pricing mainly from two sources that are:

  • Coingecko
  • CryptoCompare

Steps:

Q. Ways to ignore Transaction

🅰️

  1. How to ignore transaction from transactions UI

(Suitable for ignoring few random transactions)

-> Go to the Transactions tab on the left hand side menu.
-> Click on the box on the left side of the transaction you want to ignore. ( You can select multiple as well)

-> On the above tab click ignore

***

Q: How to get monthly unrealized gain/loss from inventory?

🅰️:

Ensure Inventory View is Updated:
Before downloading the report, ensure your inventory view is current by navigating to Inventory and clicking on "Update Now" in the top-left corner. Please note that the last update in your org was in March, so updating will provide you with the latest data.

Download Actions Report:
1.Go to Inventory.
2.Click on Actions.
3.Add the preferred date range or submit date filters.
4.Once filtered, click on "Download Actions" to export the report as a CSV file.

Perform Pivot Table Analysis:
1.Open the downloaded CSV file in a spreadsheet application such as Excel or Google Sheets.
2.Create a pivot table to summarize the data by month or any other desired criteria.
3.Utilize the pivot table to analyze gain/loss data specifically for each month.


Q: What does this error mean on the update inventory tab: Errored: More than one imputed fee found. This is not supported.

🅰️ It means you are trying to do an internal transfer and the in/out amounts don’t align— the difference goes to Fees…but the error you have is telling you that in/out imbalance exists on two different assets, and the system only allows one.


Q: How to update the Inventory views?

🅰️:

  • Go to "Inventory"
  • Go to updates
  • Click on "Update Now"
  • Click on the blue rounded arrows to update the status.
  • The status will be "Complete" once the Inventory views got updated.


Q: What is the difference between IFRS and IFRS Revalued (both are options when setting up inventory views)?

🅰️:

"IFRS:
1.acquisition recorded at cost basis

  1. if price drops below cost basis-> impairment expense
    3. if price goes back up ->reverse impairment expense BUT NEVER ABOVE original cost basis

**IFRS Revalued:

  1. **acquisition recorded at cost basis

  2. if price drops below cost basis-> impairment expense

  3. if price goes back up ->reverse impairment expense BUT NEVER ABOVE original cost basis

    • Additional adjustment upward if market price rises above original cost basis"
  4. How to ignore transactions using rules

( Suitable when ignoring multiple transaction from particular wallet for a specific period )

 -> Go to the Transactions tab on the left hand side menu.
-> Click on rules, then create rule
-> Fill the details, hit save
-> Select the rule created
-> Click on actions, then click run
  1. How to ignore transactions Via system Jobs

( Suitable when ignoring multiple transaction from particular wallet for a specific period )

-> Go to Administration tab on the left hand side menu
-> Click on system Jobs
-> Then create job
-> In actions dropdown click ignore transaction
-> Then select the wallet and time period and hit run.


  1. Click on Actions then delete


Q: How to find inventory view run ID?

🅰️ :

To get Inventory view run ID:

  1. Go to Inventory


  2. Go to updates


  3. There you can find a column as Run Id, copy that ID.



Q: How do I Identify Errors in Inventory Views?

🅰️:

To find a list of errors in Inventory Views, follow the steps below:

  1. Navigate to Inventory > Views
  2. Click on the Actions tab
  3. Click the Three Box logo on the right side of the Inventory Views Actions table
  4. Check "Line Error" to add the Line Error column to the table
  5. View the error for the specific Inventory View run

Q.: What is inventory view?

🅰️ :

Inventory View” was born out of Bitwave’s engagement with clients involved in some of the most complex and high-volume digital asset use cases with transactions ranging from hundreds of thousands to millions of transactions a year. The data tables in inventory views are highly responsive and performant.

Users can at a glance, access important balance, lot, and roll-forward information for their digital asset inventory (e.g. cost basis acquired, cost basis disposed, impairment, carrying value, FMV, unrealized G/L, and more…) through an “Inventory View”.

Users can now easily maintain separated tax and accounting books by creating multiple views of their inventory (Note: creating 2 or more inventory views requires the purchase of an upgrade).


Q : How to delete current inventory view?

🅰️: To delete the current view, please follow the steps below :-

  1. Go to inventory views
  2. Select Settings.
  3. Click on expand
  4. Click on " Delete View "
  5. Enter the name of the view in the name box
  6. Click " Yes, Delete " .


Q: How to get single token transactions?

🅰️ :

To get single token transactions, we have two options :

A. Using register report ( Limited to specific wallet )
B. Using Export Report

Using Register Report :

  1. Go to Bitwave.
  1. Go to Transactions.

  1. Click Register.

  1. Enter wallet name, Dates and Token Ticker.

  1. Hit load Register.

Q. Are trade transactions shown in the Journal Entry Report

🅰️:

Trade transactions are not reflected in the journal entry report because trades reflect the exchange of one digital asset for another. In other words your Digital asset account has an “inflow” and an immediate “outflow” of the same amount. This in and out is often referred to as moving assets from your left pocket to your right pocket. The net impact of a JE would be 0 and so no journal entry is created.


Q: How can I check which inventory view versions I am currently using in Bitwave?

🅰️:

To check Inventory view versions, follow the steps below:

  1. Go to inventory views.
  2. Click on settings.
  3. Here you can see all the details of inventory view that is created with the version

Q : Where can I find the option to add a new view on the Inventory Views page?

🅰️: To add a new view, simple click on create view and follow the steps accordingly.


Q : How do I determine which view I am currently using in the Inventory section?

🅰️: The black box on the name of the view represents the currently used inventory view.


Q : How to Filter by Month in the Gain/Loss Inventory View

🅰️:

  1. Ensure Inventory View is Updated:
  • Navigate to the Inventory section.
    • Click on "Update Now" located in the top-left corner to ensure your inventory view reflects the latest data.
  1. Download Actions Report:
  • Go to the Inventory section.
    • Click on "Actions".
      • Add your preferred date range or submit date filters to specify the time period you want to analyze.
        Once filtered, click on "Download Actions" to export the report as a CSV file.
        Perform Pivot Table Analysis:
        • Open the downloaded CSV file using a spreadsheet application such as Excel or Google Sheets.
          Create a pivot table to summarize the data by month or any other desired criteria.
          • Utilize the pivot table to analyze gain/loss data specifically for each month or the selected time period.

Q: What timestamp will be used when combining multiple transactions that occur at different times?

🅰️:

When you combine a series of transactions in Bitwave, the resulting combined transaction will use the earliest timestamp of any of the original transactions that were combined.

Q: " I am getting negative coin balance errors in inventory views, what should i do? "

🅰️ :

Here are the steps to follow when you encounter a negative coin balance error in your inventory views dashboard:

  1. Ensure that your Bitwave token balances match your on-chain balances.
  2. Verify that no important transactions are ignored in your Bitwave instance. ( Set the transactions filter to "Ignored" to check all ignored transactions )
  3. Try uncategorizing and re-categorizing the specific transaction showing a negative coin balance.
    Note: Please update your inventory views after performing any actions (categorizing, resyncing) related to transactions in Inventory Views.
  4. If the negative amounts are less than $0.01 (likely due to rounding errors), you can resolve this by downloading the actions report and sorting the asset balance column from smallest to largest. Then, create a reversal transaction for the same amount 1-2 minutes before the original transaction. This will effectively eliminate the negative balance caused by rounding errors.

Note: Please update your inventory views after performing any actions (categorizing, resyncing) related to transactions in Inventory Views.

Q: Does BW associate lots with wallet ID's (prior to 1/1/25)?

🅰️ :

Yes bitwave consider lots as wallet id's if the Wallet Level Inventory (WLI)is turned on for your org. The transfer from wallet A to wallet B is also transferring the original lots if WLI is turned on. If you don't have WLI turned on and this is more about moving from universal inventory to WLI then that is a little more nuanced. However, engineering is currently working for a solution to be ready by end of November for this situation

Here is a documentation on wallet level inventories - https://docs.bitwave.io/docs/setup-inventory-groups#method-1-wli-wallet-level-inventories