Individual Transaction Categorization

1. Individually Categorizing a Transaction

   "Categorization" is the process of coding your transactions in Bitwave or applying the general ledger account to the transaction. The following categorization types are available when individually categorizing a transaction:  

   •Standard  

   • Trade  

   • Internal Transfer  

   • Account Transfer  

   • Invoice/Bill Payment


2. Standard: Most frequently used option. This transaction type is used for most simple inflow and outflow transactions where the current wallet is interacting with another wallet that does not belong to the client.

Example: Deposit Transaction

Example: Withdrawal Transaction

  1. In order to SAVE a transaction, you must select the "Contact" and "Category"as they are required fields.
    Contact:
    • Select your customer or vendor. If you have synced Bitwave to your ERP, this contact list will
    be populated for your selection. If you have not connected your ERP, these contacts will need to
    be manually created under Accounting > Contacts.
    Category:
    • Select the general ledger account that applies to the transaction line. This list will be synced
    in from your chart of accounts if you have connected your ERP. If you have not connected your
    ERP, these categories will need to be manually created under Accounting > Categories.

  2. Categorization Actions
    There are additional categorization functions that a user may find helpful, including:
    • Add/Delete Line
    • Add/Delete Split
    • Collapse
    • Update Pricing
    • Descriptions and Memo

  3. Add/Delete Line: This action spreads the total value of the transaction across multiple categories for the SAME contact.

  4. Add/Delete Split: This action spreads the total value of the transaction across MULTIPLE contacts and categories (if desired).

  5. Collapse: This actions sums the movements of the same token together and feeds only the NET amount to the categorization lines.

  6. For example, a deposit of 3.339 ETH and a deposit of 4.5 ETH would net to a single inflow of 7.839 ETH for categorization purposes.

  7. Update Pricing
    • The "Suggested Rate" displays the exchange rate Bitwave identified based on the transaction time. The default pricing source that Bitwave uses is CryptoCompare.
    • The "Using Rate" shows the rate actually being used to calculate the fiat value which can be overridden by using the pencil icon to edit the rate.

  1. In order to edit the rate, select the pencil icon, update the value in the "Using Rate" field.

  2. Use the checkmark icon to save the rate adjustment.

  3. Descriptions and Memo
    The "Description" and "Memo" fields allow the user to add notes or other transaction details that will pass through to the ERP when the transaction is reconciled.

  4. The "Memo" line can be added to the transaction without requiring that the transaction be saved.

  5. Trade: Used when the transaction activity involves an exchange of one asset for another. For example, buying BTC using USD, or trading BTC for ETH.
    Use the transaction type dropdown to select "Trade"

  6. When categorizing a trade transaction, you must enter a "Fee Contact" in order to SAVE your categorization.

  7. Click "SAVE"

  8. Internal Transfer: Used when the transaction activity involves the movement of an asset from one wallet to another wallet that are both in the same Bitwave org (i.e. owned by the same client).

  9. When categorizing an internal transfer transaction, you must enter a "Fee Contact" in order to SAVE your categorization.

  10. Click "SAVE"

  11. Account Transfer
    Used when the transaction activity involves:
    • Moving a digital asset from a client owned source NOT connected to Bitwave into a Bitwave so you can set a cost basis.
    • Moving a digital asset from Bitwave to a client owned source NOT connected to Bitwave.
    • Requires that the "External Cost Basis" be set up for assets disposed under Accounting > External Cost Basis.

  12. When categorizing an account transfer transaction, you must select a "Transfer To" (i.e. a bank account) and "Fee Contact" in order to SAVE your categorization.

  13. When using the Account Transfer transaction type, you must ensure that you set the "External Cost Basis" by going to Accounting > External Cost Basis.

  14. Invoice/Bill Payment
    This type is used when the transaction involves:
    • An outflow of digital assets as a bill payment(A/P)
    • An inflow of digital assets as an invoice payment (A/R)
    By connecting to your ERP, Bitwave will sync in all of your outstanding invoices and bills from your ERP system. Each invoice/bill that is synced in is associated with a customer or vendor.

  15. To begin categorizing an Invoice/Bill Payment transaction, select the "Contact."

  16. Next, select the "Invoice" which will populate all outstanding invoices/bills for that customer/vendor from your ERP.

  17. A row will be created for each digital asset movement and the user will need to indicate how much of the invoice/bill is being satisfied by the digital asset movement in or out under the "Payment Amount."
    If the value of the digital assets sent/received (price at time of transaction x # of tokens moved) is different than the "Payment Amount" then the user will be presented with an option to categorize the forex gain/loss.
    In this example, 50 USDC was received to satisfy a $25 invoice. The USDC received is worth $50 so there is a difference of $25 between the "Payment Amount" and the value of the digital assets received, which is accounted for as a foreign exchange gain in the "Forex Gain/Loss" category.

  18. Use the the drop down to search for the Forex Category.
    (Note: If you do not see an appropriate category, set up a "Forex Gain/Loss" account in your ERP and sync in your chart of accounts prior to categorizing the transaction).

  19. Click "SAVE"