View, search, and export transaction data in the Donations app

You can view, search, and export data for transactions made through the Donations app or added manually in the administrator. Information is available for all one-time transactions, initial recurring transactions, and subsequent recurring transactions.

To view, search and export data, go to the Transactions view of the Donations app. Once viewing the Transactions table:

• To sort data by a given column, click the column heading or choose the desired option from the Sort By drop down
• To search transactions by name or email of the donor, enter the string to be searched in the Search by Name or Email field and click enter or mouse out of the field
• For advanced search options, click the filter icon to expand the filter pane contained the following parameters:
  • Created Date
    Search All Transactions, Today's Transactions, Last Month's Transactions, This Month's Transactions or enter in a specific date range to zero in on exactly the time frame in which you're interested
  • Payment Amount
    Search for transactions of an exact amount, up to a maximum, above a minimum, or between two values 
  • Frequency
    Search All Frequencies, One-time, Monthly, or Annual transactions.
  • Payment Method
    Search All Payment Methods, Apple Pay, Bank Transfer, DAFpay, Credit Card or PayPal
  • Payment Occurrence
    Search All Occurrences, One-time, Initial recurring, Subsequent recurring, or All recurring.
  • Recurring Upsell Conversion
    Search Any, Upsell displayed and converted, Upsell displayed and not converted, or No upsell displayed
  • Transaction Id
    Search for a specific Transaction Id or for all transactions without a Transaction Id
  • Subscription Id
    Search for a specific Subscription Id or for all transactions without a Subscription Id
  • Donation Form
    Search for transactions processed through a specific form. Just start typing the name of the form and Soapbox will help you auto-complete the name you're after.
  • Designation
    Search for transactions with a given Soapbox Designation selected by the donor.
  • Transaction Description
    Enter a text string to find a transaction description you're seeking
  • Salesforce Lead Record Id, if Salesforce integration is enabled for your site
    Search for a specific Salesforce Lead Record Id or for all transactions without a Salesforce Lead Record Id
  • Donation Import Record Id, if Microsoft integration is enabled for your site
    Search for a specific Donation Import Record Id or for all transactions without a Donation Import Record Id
  • Id
    Search for a specific Soapbox Id
  • Fraud Status
    Search All Transactions, Valid Only, or Fraud Only. The default for the view is set to Valid Only.
  • Refund Status
    Search for Not Refunded Only, All Transactions, or Refunded Only.
  • Transaction Source
    Search for Both By Soapbox and Offline, By Soapbox Only or Offline Only
• To restore the defaults for the filter pane, click the Clear All link at the bottom of the form and click Save

To export all transactions as a CSV file, click the Export icon.

To view further details of any Transaction, click the hyperlinked name in the Name column.