- Click Queries
- Click Manage Queries
- Select a category that you want to store this query in
- Click New Query under Tasks
- Name the query "2016 donations that are not reversed"
- Set the Starting Criteria to Category: Base and Query: All Constituents
- For Data Return Type select Journal Entries
- Below the Criteria Matching heading, select Match Each Criteria
- Select Commonly Used Fields from the Available Fields drop down menu and click Journal Entry Date
- Fill in 1/1/2016-12/31/2016
- Select Commonly Used Fields from the Available Fields drop down menu and click Individual Transaction Received
- Fill in Greater Than or Equal To .01
- Select Journal from the Available Fields drop down menu and click on Transaction Reversal Status
- Check off the box next to Non Reversed
- Click Save and Preview
Please note that the Transaction Reversal Status field can also be used to isolate the original donations that have been reversed (by checking off Reversed), along with the transactions with a negative value that are offsetting the original donations (by checking off Reversing).