Trail Blazer Knowledge Base

 

Home : Queries : Query and Report for Monthly Recurring Donations - Nonprofit Only

Knowledge Base







User:

Password:



Article ID: KB1380
Keyword Name: Recurring, Report, Monthly, Pivot, Giving History, Break Down
Created: August 24, 2017
Viewed: 11649

Query and Report for Monthly Recurring Donations - Nonprofit Only




Click Here to view this article as a PDF.




Author: Kristenson, Joel

Last Updated: 2017-08-24





Overview


This article walks through the steps to find recurring *donation* records in the Contributions List,and how to build a monthly donation report using the format and pivot tools to show what donors have given month-by-month.


As of the time this article was written there are two merchant gateways that you can use with Trail Blazer that support recurring credit card donations, they’re Authorize.Net and Vanco Services.


Example monthly recurring donation report:




http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip: this article provides a variety of useful SQL queries you can utilize to filter your data.  Most of the examples in this SQL tutorial are requests that customers have had over the years, which require using the SQL tab.






Steps


Open the Contributions list.



Under the General tab click the Recurrence drop-down, select Monthly & Monthly / Sustaining, click [OK], and then click [Search] to populate the list with all the recurring monthly donations in your database.  In this example there were 222 monthly recurring monthly donations.




http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip: you can filter this report further by things like date-range if necessary:




After generating the list of recurring donations, click the [Format] drop-down and select Columns…



Make sure that these columns are selected, and then click [OK]:

- First Name

- Last Name

- ContributionYearMonth

- DonorID (not show, but included by default)

- Amount



After the columns listed above are added to the grid, click the Pivot button.



Under the Row Label tab select Donor ID, First Name, and Last Name.



Under the Column Labels tab select Contribution Year Month.



Under the Data tab select Amount, and then click [OK] to generate the pivot report.



The report will display your recurring monthly *donors* with the total amount they’ve donated each monthMy finished example is below (only the first 15 months display in the screenshots as my report goes all the back to 2012 when my monthly recurring donations started).



You can export, print, and graph the pivot report using the buttons on the top tool strip.


Return back to the contribution list you built in the previous steps in order to save both the format and the search query for future use.



To save the search query as a favorite, expand the Advanced Functions tool strip, and click blue the [Save] button.



Create a descriptive name, and then click [Save]My example is below which I called “Recurring Monthly Donations”.



You can reload the saved search in the future under the Favorites tab.



To save the format click the [Format] drop-down > Save As…



Give the format a descriptive name and click [Save]In this example I called it “Ready for Pivot”.



You can reload the format in the future by clicking the [Format] drop-down > Select Saved…



Choose the format you previously saved, and click [Select and Close].



Take a look at the related resources below for a wide variety of other articles and videos related to this topic.














Related Resources


Article: Advanced Queries – the SQL Tab

Article: SQL Wildcards

Article: Creating and Saving Default Formats for Reporting with the Grid

Article: Search Query – New Donors This Month, and This Year (Primarily for Nonprofits)

Article: How to Create a Donor LYBUNT Search Query (Donors Who Gave Last Year But Unfortunately Not This Year) and How to Save and Load it as a Search Favorite

Article: Building a Search Query for ‘First Time Donors’ THIS Year – Save and Load it as a Favorite & Add it to your Dashboard

Article: Save and Load a Search Query as a (Dynamic) Search Favorite

Article: How to Delete or Rename a Search Favorite (Query)

Article: What Donors Have Increased Giving Over Last Year

Article: How to Use the New Dashboard Features – Adding Graphs and Metrics with Drag-and-Drop

Video: Reporting 105 – Pivots – summary reporting

Video: Getting Started 105 – Queries with an AND condition

Video: Reporting 102 – Quick Reports and Export

Video: Getting Started 104 Queries with wildcards

Video: Favorites Deleting Saved Queries

Video: Getting Started 102 Beginning Queries - Nonprofit

Video: Reporting 104 – Joined tables

Video: Search – Contribution AndOR (donated in 1 time period but not another)





Trail Blazer Live Support


http://www.somebodysattic.org/images/phone%20icon_lower%20rez.jpg  Phone:  1-866-909-8700

http://sisyphus-js.herokuapp.com/assets/email_icon-0f32f4da45c2822cbb02fb36f9b9429e.png   Email:  support@trailblz.com

   Facebook: https://www.facebook.com/pages/Trail-Blazer-Software/64872951180

   Twitter: https://twitter.com/trailblazersoft



* As a policy we require that you have taken our intro training class before calling or emailing our live support team.


Click here to view our calendar for upcoming classes and events.  Feel free to sign up other members on your team for the same training.


* After registering you’ll receive a confirmation email with the instructions for how to log into the GoToMeeting session where we host our live interactive trainings.


* This service is included in your contract.



 

Are you ready to learn more? Contact Us