The Crypto Transactions page is where you can manually create transactions, run cost basis and the Crypto Journals processes, as well as review and filter the table of all created transactions.

 

Transaction Table Columns

The Transaction Table contains information such as Date and ID, but also breaks out transactions into the Sent, Received, and Fee pieces of any given transaction. For example, a Deposit Type transaction will have Received Coin information, but not Sent Coin information.

  • ID - This is the SoftLedger internal ID field. This ID field can be used to investigate any Cost Basis errors.
  • Type- There are four Types:
  • Hash ID - If this was a 'on-chain' transaction, this is the Hash ID of blockchain transaction.
  • Date - Transaction date and time, in "MM/DD/YYYY HH:MM:SS" Format, displayed in the UTC Timezone.

Received - Details about the Received end of the transaction:

  • rCoin - Symbol of the Coin received.
  • rQuantity - Total number of Coins received.
  • rWallet - Wallet Coin was received to.
  • rPrice - Per Coin Fiat price of the Coin received, currency is that of the currency column.

Sent - Details about the Sent end of the transaction:

  • sCoin - Symbol of the Coin sent.
  • sQuantity - Total number of Coins sent.
  • sWallet - Wallet Coin was sent to.
  • sPrice - Per Coin Fiat price of the Coin sent, currency is that of the currency column.

Fee - Details about the Fee end of the transaction:

  • fCoin - symbol of the Coin used to pay fee.
  • fQuantity - Total number of Coins used to pay fee.
  • fWallet - Wallet Coin used to pay fee is from.
  • fPrice - Per Coin Fiat price of the Coin used to pay the fee, currency is that of the currency column.

Sent Cost Basis - This is the per Coin cost basis of the sent Coin.

  • To view the cost layers of this Coin, click the (i) icon.
  • This will present the following list of cost layers used to calculate the cost basis:
  • ID - The transaction this cost layer is from.
  • Date - The date of the transaction this cost layer is from (UTC Time).
  • Amt. Picked - The number of Coins picked from this cost layer transaction.
  • Cost Basis - The Per Coin fiat price of this cost layer.

Fee Cost Basis - This is the per Coin cost basis of the fee Coin.

  • To view the cost layers of this Coin, click the (i) icon.
  • This will present the following list of cost layers used to calculate the cost basis:
  • ID - The transaction this cost layer is from.
  • Date - The date of the transaction this cost layer is from (UTC Time).
  • Amt. Picked - The number of Coins picked from this cost layer transaction.
  • Cost Basis - The Per Coin fiat price of this cost layer.
  • Ledger Account - For Deposits/Withdrawals, this is the Ledger Account used in the alternate side of the Journal Entry from the Coin Asset Account.
  • Customer - Customer this transaction relates to.
  • Vendor- Vendor this transaction relates to.
  • Currency - Currency of the Received, Sent, and Fee Price values.
  • Currency Rate - The Forex rate of this rows Currency to this systems Crypto Home Currency.
  • Reference - Reference text.
  • Notes - Longer form text field.
  • Source - Integration or 3rd party source that this transaction is referenced from.
  • Source ID - Reference ID for this transactions source.
  • Journal - Journal Entry ID created from this transaction (only populated once Create Crypto Journals button initializes the creation of the Journal).
  • Journal Current - Indicator of whether a Journal is current (up to date based on the data in the crypto transaction), where a green checkmark means Current and a red X means Stale.
  • System Job - Bulk Upload Job ID which created this transaction.
  • Locked - Locked Status of transaction, if locked it cannot be edited or deleted.
  • Edit - click to edit any values of this transaction.
  • Delete - click to delete this transaction.

 

Add Transaction

Click the +New button to add a new transaction. See the below articles for specifics on each transaction Type:

  • Trade
  • Transfer
  • Withdrawal
  • Deposit

 

 

Individual Crypto Transaction Actions

From the Actions column in the far right of the table:

  • Edit - Update Crypto transaction.
  • Delete - Delete this Crypto transaction (could fail if the transaction is in a closed accounting period).

Crypto Cost Basis

Cost Basis is a background process that calculates the cost basis and cost layers for all crypto transactions which involve a "Sent" coin and/or a "Fee" coin (trades, transfers and withdrawals). The Cost Basis function is triggered when clicking the Run Cost Basis button at the top of the Crypto Transactions screen:

For more information, see the Crypto Cost Basis support article.

 

 

Create Crypto Journals

The process takes the crypto transaction information to create Journal Entries that can be viewed in your Financial Reports like entries from other modules involving fiat currencies. Note: Check the Journals and Journal Current columns to confirm/review a Journal created for a crypto transaction, and to see if that Journal is Current or Stale. If Stale, it means this process needs to run again to make the Journal Current.

Crypto Bulk Actions

Select one or more transactions from the checkbox on the far left of each transaction row to bring up the bulk menu:

  • Delete - You can select up to 100 transactions at a time so long as they are not in a locked accounting period.
  • Update - You can select up to 100 transactions at a time. SoftLedger allows you to bulk update certain fields such as Ledger Account (must be for transactions of the same Type), Customer, Vendor, Reference, and Notes:

 

 

Merge Transactions

When bringing in transactions from multiple sources (e.g. two exchanges), a Deposit from one exchange and a Withdrawal from another can sometimes reference the same transaction. If you select one Deposit and one Withdrawal, you can merge the two transactions into one, so long as:

  • They have the same Coin.
  • They have different Wallets.
  • Sent quantity and received quantity is equal.
  • Transaction Hash ID is empty for both or equal.

The transactions can then be merged. This results in both transactions being deleted and a new transfer transaction being created. All metadata (Customer/Vendor/notes/reference) for the new transfer transaction will be pulled from the Withdrawal. This can always be edited after the merge if needed.

 

 

Crypto Table Actions

  • Filters - Filter what appears in the table based on one or more fields available in the table.
  • Saved Views - You can create a set of filters that you would like to save to be able to quickly filter a table.
  • Column Selector - Hide and reveal extra columns and the number of rows visible in the table per page.
  • Export - Table data can be exported using the export button at the top of the table.
  • Advanced Filter Transactions - Click the down arrow on the Coin or Wallet (see image below) to quickly filter the table to limit to either a specific Coin or specific Wallet, or both.