To query on the original transactions that have been reversed (those with a positive value), follow the steps below:
  1. Click Queries in the menu
  2. Click Manage Queries
  3. Click on a category to store the query under (ex: Base)
  4. Click New Query under Tasks
  5. Give the query a name “Reversed transactions”
  6. Set the Starting Query to Base>All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Select Commonly Used Fields in the Browse Fields section and click on Journal Entry Date
  9. Fill in the date range you’d like to use
  10. Select Journal in the Browse Fields section and click on Transaction Reversal Status
  11. Check off ‘Reversed
  12. Click Save And Preview


To query on the negative transactions that are reversing the original donations (those with a negative value), follow the steps below:

  1. Click Queries in the menu
  2. Click Manage Queries
  3. Click on a category to store the query under (ex: Base)
  4. Click New Query under Tasks
  5. Give the query a name “Reversed transactions”
  6. Set the Starting Query to Base>All Constituents
  7. Set the Data Return Type to Journal Entries
  8. Select Commonly Used Fields in the Browse Fields section and click on Journal Entry Date
  9. Fill in the date range you’d like to use
  10. Select Journal in the Browse Fields section and click on Transaction Reversal Status
  11. Check off ‘Reversing
  12. Click Save And Preview