The Year-Over-Year report will allow you to quickly and easily compare Giving between years and easily spot patterns or trends amongst your donors.
With the new Year-Over-Year report, you can...
- See how giving has changed per year per donor over time.
- See who has not given in a particular year.
- Quickly see highest donors for each year.
- Quickly see your church's grand total that was given for a particular year.
- Easily see a given donor's total donations for a particular year.
From the main Reports page click ‘Start Report’ via the ‘Year-Over-Year Giving’ report tile.
Default Report set-up
Once you enter each report page, you will note that the results table is already pre-populated with your real-time results based on the pre-set (and changeable) values in the Parameters sidebar.
More info on the various sections and options in the sidebar is available in our Report Parameters document. There you will see how easy it is to change the preselected report parameters and see customized results with a click of a button!
For the YoY report, the three primary parameters are Who, Funds and Years. In its default state, the report will initially display All Profiles (People & Organizations, if Orgs product is enabled) that have given to to tax-deductible Funds for up to three calendar Years where Giving data is available, including this year.
- Who: all profiles
- Funds: all tax-deductible funds
- Years: up to the last 3 years in which there is Giving data
Note: The report table will show the last three years of giving side by side for comparison. If less than three years are available, then only one or two will show.
In the above report there is both a Total row and Total column which allow you to easily see the sum total of previous donations across your entire organization, along with the total donations for any given donor over the designated period.
If you scroll over to the right in the table, you will also see demographic columns as follows:
- Postal Code
- Tax ID (Organization only)
- Contact Note (Organization only)
The Profile column contains the first/last or organization name in a clickable button that will redirect to that profile’s detail page, along with the clickable dollar sign icon to redirect to the Transactions page filtered to that profile’s giving history.
Revising/Running the Report
You are able to update any of the three existing parameters as desired. It’s important to note that the table data will not automatically update as you make different filter selections. If you want to see new results after changing any filters from the default, click the Run button to re-run the report with the new set of filters.
Sharing the Report
Click on the “Share Report” button (or link icon, in collapsed view) in order to copy the URL link containing your parameter selections and paste to save or share with another admin.
Downloading the Report
Click on the “Download Results” button/menu in order to download a CSV file containing all the data in your report. You will have an option to download your results by Individual or by Household. The filename will include the date and time the report was created.
Note: you will need to have the Household product enabled to see/allow this type of download
Check out our short video on Year-Over-Year Giving Reports below!