Stock and Cryptocurrency: Reporting

As soon as an Express Giving form is submitted with a stock or cryptocurrency donation, you will see a record of it in the transaction report in Giving Admin. 

 

Stock and Crypto Transaction Report

In the left sidebar navigation, click Reports, then click Transactions. 

This report shows all giving transactions, so pay close attention to the Source column, which lists either Stock or Crypto. The columns on this report will update as the stock or crypto donation is processed 

Note: This report can be filtered based on the Source column.  You can update the filters to see only stock or crypto donations.

 

Stock and Crypto Transaction Report Columns

On the Transaction Report, you can include some columns specific to stock and crypto transactions. To add those columns, click the 3-column icon at the top-right corner of the report data area.

giving-reports-transactions-columns-icon.png

Select the columns you would like to include:

  • Crypto Asset: The type of cryptocurrency coin donated (ie., Bitcoin or Ethereum)
  • Crypto Quantity: Number of coins donated. 
  • Crypto/Stock Gross Amount: The dollar amount of the donation after it was converted to USD.
  • Crypto/Stock Payout Amount: Gross amount minus fee amount.
  • Crypto/Stock Fee Amount: 4% of the gross amount
  • Crypto/Stock Payout Currency: USD (United States Dollars) for all transactions.
  • Crypto Value at Donation: The value of the crypto donation at the moment the donor submitted the donation form.
  • Crypto/Stock Conversion Status: Either Converted or Awaiting Conversion. This tells you whether the crypto or stock donation has been converted to USD.
  • Crypto Transaction Hash: A unique transaction ID for the crypto transaction.
  • Crypto/Stock Transfer Date: The date the donation was made.
  • Stock Ticker: Short code made of letters and numbers used to uniquely identify a publicly traded company on a stock exchange.
  • Stock Shares: The number of shares that were donated.

 

A Donation is Started on an Express Giving Form 

When a stock or crypto donation has begun (the amount, fund, and donor info have been filled in, and stock/crypto has been selected as the payment type), but the donor is still filling in their stock or crypto transaction information, these columns will be populated:

  • Source: Type of donation. In this case, it will say either Stock or Crypto.

  • Status: Pending

  • Donor: The name of the person donating the stock or crypto. This field is a link, so you can click the name to view more details about the person.

  • Fund: The name of your giving system fund that is being donated to.

Note that you don't yet know the donation value. This will come later.

 

The Donation is Submitted

The donor has finished entering details about their stock or crypto donation and clicked the submit button. The status column will change.

 

The Stock or Crypto Has Been Transferred

The asset has been liquidated, and Modern Philanthropy Foundation is processing the donation. More details will appear on the transaction report.

  • Status: Approved

  • Crypto/Stock Gross Amount: Total cash value of the donation

  • Crypto/Stock Fee Amount: 4% of the gross

  • Crypto/Stock Payout Amount: Gross - Fee. This is the amount paid to your ministry.

Canceled or Declined Transactions

Occasionally, a donation may be canceled by the donor or otherwise declined, rather than approved. You don't need to do anything with these transactions. This will be reflected in the status column:

  • Status: Canceled or Declined

 

Deposit/Funding Report 

Stock and crypto donations will not appear on the deposit or funding report because they aren't batched like traditional donations. Instead, you will receive a check or direct deposit from our partner, Chariot.

Updated