How do I report on totals given per donor in a specific date range?

You may need to pull a report that shows totals given per donor in a specific date range, rather than listing out each individual donation.  Since the query preview will always list out each journal entry, a report has to be used in conjunction with your query in order to get the data formatted to one line per donor.
Create a query to find all donors in the date range:
  1. Click Queries
  2. Select a category that you want to store this query in (Ex: Base)
  3. Click New Query under the Tasks menu
  4. Name the query
  5. Starting Query select Category: Base and Query: All Constituents
  6. Data Return Type select Journal Entries
  7. Criteria Matching select Match Each Criteria
  8. Criteria select 'Individual Transaction Received'
  9. Enter greater than or equal to .01
  10. In criteria select Journal Entry Date and enter your date range
  11. Save and Run Report

Next, you will create a report to use with your query.  Step 4 is the key step that determines the format of your report. Choosing to group by Accounts and then selecting Collapse Groups means that you are condensing it down to one line per account, which will then show a total for each account in the Received column.
  1. Select a Category to store this report in (Ex: System)
  2. Click New Report under the Tasks menu
  3. Name your report
  4. Set the Group By to Accounts and in the drop down beneath that select Collapse Groups
  5. For Report Columns > Commonly Used Fields > Click Account Name, Received, and any other information you would like to include in the report
  6. Click Save and Run
  7. Select your query
  8. Scroll down and select your preferred report format
  9. Click Submit
​(Note: Due to collapsing the report, if you include any journal entry type fields such as date, fund, campaign, etc. it will choose one at random for any donor who gave multiple times. If you want to see the date, fund, campaign, etc. on the last gift they gave in that date range, you could click the icon to the left of each of those fields and select Last for the Aggregate so that it will not choose one at random)
 

Environment

 eTapestry

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.