About the Diocese Reports Page

Overview

The Diocese Reports page enables you to access reports required to support the information needs of the Development Manager staff

Report Menu

This list shows the names of the diocese reports you can generate.

Appeal Progress

The Appeal Progress report allows a diocese to view historical data for three selected funds. The report displays pledge and contribution data for the same period for each of the three years, covering those funds. A diocese can use the data to track fundraising progress by comparing the results from a base year against those achieved in prior years. 

To view setup options, go to Set up Options for the Appeal Progress Report.

Audit

The Audit report shows details for changes made to batches, contributions, and pledges after they are saved in the system. Two versions of the Audit report are available:

  • By User
  • By Type 

To view setup options, go to Set up Options for the Audit Report.

Contribution History by Donor

The Contribution History by Donor report allows a diocese to view a historical record of donor contributions made over four years. 

To view setup options, go to Set up Options for the Contribution History by Donor Report.

Contribution History by Fund

The Contribution History by Fund report displays the dollar amount of contributions made to selected funds by month, quarter, and year (for the specified year). Additionally, the report provides a contribution history of donations made during the same financial periods in each of the three years preceding the user-specified year.

To view setup options, go to Set up Options for the Contribution History by Fund Report.

Dollar Range

The Dollar Range report provides data that a diocese can use to identify donor giving patterns over time and determine possible future trends in giving.  

To view setup options, go to Set up Options for the Dollar Range Report.

Families Without Pledges

The Families Without Pledges report lists families that have not pledged to the selected fund within the selected organization.

To view setup options, go to Set up Options for the Families Without Pledges Report.

Parish Batch Summary

The Parish Batch Summary report lists batches containing pledges made on behalf of the selected organization. The report shows the dollar amount of pledges made to the organization and provides a running total of the dollar amount of pledges made as of the batch creation or default posting date.

To view setup options, go to Set up Options for the Parish Batch Summary Report.

Parish Summary

The Parish Summary report summarizes parish-wide pledge activity, including the total pledge goal, the amount of money pledged, and the total paid for each selected organization. Also provides pledge metrics, allowing organization administrators to understand the details behind the summaries. The report captures the number of participating families, the total number of pledges made, the number of fully paid pledges, and the number of outstanding pledges; the average pledge amount; and a distribution of giving, among other key metrics.

To view setup options, go to Set up Options for the Parish Summary Report.

Pledge Adjustment

The Pledge Adjustment report provides a detailed account of adjustments made to pledges to a fund during the date range you specify. 

To view setup options, go to Set up Options for the Pledge Adjustment Report.

Revenue Projection

The Revenue Projection report can be used to support your organization's multi-year campaigns. The report provides month-by-month and year-by-year cash flow projections, summing those amounts for each fiscal year within a projected six-year period. You can see cash amounts already received and the total amount pledged for the entire campaign. The data in this report can help you use past and current patterns of giving to make reasonable projections about the future.

To view setup options, go to Set up Options for the Revenue Projection Report.

Export Button

Click Export icon.png to export a report. From the menu, select the desired report format:

  • Excel: The Excel version utilizes the same data source as the PDF but contains more data, presented in a comma-separated format. The Excel version is an option to choose if you want to perform a mail merge or import the data from the selected report into a spreadsheet program, such as Microsoft Excel.
  • PDF: The PDF version is useful for most purposes because it extracts the most commonly needed data from the report and presents it in a well-designed layout. Note that the PDF contains less information than the CSV version and is a more suitable option when you need a document that is easily read.

Report Setup

The setup options for each report are described in the sections below.

Set Up Options for the Appeal Progress Report 

The Appeal Progress report allows a diocese to view historical data for three selected funds. The report displays pledge and contribution data for the same period for each of the three years, covering those funds. A diocese can use the data to track fundraising progress by comparing the results from a base year against those achieved in prior years. 

The options used to set up an Appeal Progress report are listed below.

Note: An asterisk (*) indicates required information.

Select Base Year Fund

Select the fund used for the most recent appeal. 

Select Fund minus 1 Year *

Select the fund used for the appeal in the year prior to the most recent one.

Select Fund minus 2 Year *

Select the fund used for the appeal two years prior to the most recent one.

For instructions on creating this report, go to How to Create an Appeal Progress Report.

Set Up Options for the Audit Report

The Audit report allows a diocese to view and monitor changes users make to their batch, contribution, and pledge data.  The options used to set up an Audit report are listed below. 

Note: An asterisk (*) indicates required information.

Audit Report Type

Select the type of report you want to create. You can select one or more of the following:

  • Batch: For the specified date range, tracks changes to batch records, showing what was changed, by whom, and when.  
  • Contribution: For the specified date range, tracks changes to contribution records, showing what was changed, by whom, and when. 
  • Fund: For the specified date range, tracks changes to fund records, showing what was changed, by whom, and when.
  • Pledge: For the specified date range, tracks changes to pledge records, showing what was changed, by whom, and when.
  • Sustaining Gifts: For the specified date range, tracks changes to sustaining gift records, showing what was changed, by whom, and when.

Order By *

Select the type of audit report you want to generate:

  • User: displays changes made by the selected staff user to the funds for which they have permission to make changes. For easier review, the information in this report is organized to consolidate all changes made by the selected user.
  • Type: includes all changes made to one or more of the following: batches, contributions, and pledges. For easier review, the information within a report is organized by information in the Type column, which indicates the type of change made to a record.

Selected User *

If you select the User option, click Magnifier spyglass.png to open the Staff Search window. Use the Search filters (for example, First Name or Email) to find the user you want to audit. Click Blue search icon.png to locate the record.

Start Date *

Set a date range for the report by selecting a start date from the calendar and an end date from the End Date calendar (see next option). To find changes made on the same date, select the same date from both the Start Date and End Date calendars.

End Date *

Set a date range for the report by selecting an end date from the calendar and a start date from the Start Date calendar (see previous option). To find changes made on the same date, select the same date from both the Start Date and End Date calendars.

Select All Funds

Select this option to view change activity for all funds.

Choose Funds Individually

Selecting this option displays a list of funds. Select the checkbox next to each fund you want to include in the report. The report displays change activity only for the selected funds. 

For instructions on creating this report, go to Create an Audit Report.

Set up Options for the Contribution History by Donor Report

The Contribution History by Donor report enables a diocese to view a historical record of donor contributions made over a four-year period. The options used to set up a Contribution History by Donor report are listed below.

Note: An asterisk (*) indicates required information.

End Year *

The last year of the four-year reporting period. For example, if you want to generate a report for 2017 through 2020, enter 2020 for the end year.

Report Type *

Select the type of report you want to create:

  • All Donors: includes all donors in the selected organizations who donated to the selected funds.
  • LYBUNT (Last Year But Unfortunately Not This Year): includes all donors who made contributions in the year before that entered into the End Year field, but not in that year. For example, if 2020 is entered for the end year, the report includes donors who made contributions in 2019 (the year prior) but not in 2020.
  • SYBUNT (Some Year But Unfortunately Not This Year): includes donors who made contributions in one or more years before the year entered in the End Year field, but not in that specific year. For example, if 2020 is entered for the end year, the report includes donors who made contributions in any previous year but not in 2020.
  • New Donors: includes donors who made contributions in the year entered into the End Year field but not in any of the three years prior (includes donors who pledged in prior years but never made payments). For example, if 2020 is entered for the end year, the report includes only those donors who made contributions in 2020.
  • Pledge Report: provides a view of donors' pledge data over the specified four-year period.
  • Org Summary: On a separate line, shows the total contribution amount for each selected organization.

Fund Name

In the list, select the checkbox next to each fund you want to report on. To select all funds, select the checkbox next to the Fund Name header.

Organization Name

This section contains a list of organizations you can select to include in the report.

To include an organization, select its checkbox. To include all organizations in the list, select the All Organizations checkbox. This checkbox is to the left of the Organization ID header. 

If you want to include most but not all organizations, select the All Organizations checkbox to select all organizations. Then, deselect (select the checkbox again to remove the checkmark) the organizations you want to exclude.

Note: Selecting more than 10 organizations can slow processing of this report.

For instructions on creating this report, go to Create a Contribution History by Donor Report.

Set up Options for the Contribution History by Fund Report

The Contribution History by Fund report enables a diocese to track giving patterns to funds over a specified period. The options used to set up a Contribution History by Fund report are provided below. 

Note: An asterisk (*) indicates required information.

End Year *

Enter the report end year in this field. For example, if you want to obtain contribution totals for months, quarters, and the year 2019, enter 2019 into the field.

One Fund Per Page

Prints a separate page for each selected fund.

Multiple Funds Per Page

Prints a single page displaying the total contributions for all selected funds.

Fund Name

In the list, select the checkbox next to each fund you want to report on. To select all funds, select the checkbox next to the Fund Name header.

Organization Name

This section contains a list of organizations you can select to include in the report.

To include an organization, select its checkbox. To include all organizations in the list, select the All Organizations checkbox. This checkbox is to the left of the Organization ID header. 

If you want to include most but not all organizations, select the All Organizations checkbox to select all organizations. Then, deselect (select the checkbox again to remove the checkmark) the organizations you want to exclude.

Note: Selecting more than 10 organizations can slow processing of this report.

For instructions on creating this report, go to Create a Contribution History by Fund Report.

Set up Options for the Dollar Range Report 

The Dollar Range report provides data that a diocese can use to identify donor giving patterns over time and determine possible future trends in giving. The options used to set up a Dollar Range report are provided below. 

Note: An asterisk (*) indicates required information.

From *

Specify a start date for contributions to be included in the report.

To *

Specify an end date for contributions to be included in the report.

Amount Ranges

Specify the dollar range of contributions to report on by entering a minimum amount into each line.

  • To add a new minimum amount, click Add icon.png and then type the amount into the field.
  • To remove a minimum amount, click trashcan icon.png.

Fund Name

In the list, select the checkbox next to each fund you want to report on. To select all funds, select the checkbox next to the Fund Name header.

Organization Name

This section contains a list of organizations you can select to include in the report.

To include an organization, select its checkbox. To include all organizations in the list, select the All Organizations checkbox. This checkbox is to the left of the Organization ID header. 

If you want to include most but not all organizations, select the All Organizations checkbox to select all organizations. Then, deselect (select the checkbox again to remove the checkmark) the organizations you want to exclude.

Note: Selecting more than 10 organizations can slow processing of this report.

For instructions on creating this report, go to Create a Dollar Range Report.

Set up Options for the Families Without Pledges Report 

The Families without Pledges report enables a diocese to view the names of families that do not have pledge records for a selected fund. The options used to set up a Families without Pledges report are listed below. 

Note: An asterisk (*) indicates required information.

Select a Fund *

This dropdown list contains all of your organization's funds. Select the fund for which you want to view the names of families that have not made pledges to it. 

Organization Name 

This section contains a list of organizations you can select to include in the report.

To include an organization, select its checkbox. To include all organizations in the list, select the All Organizations checkbox. This checkbox is to the left of the Organization ID header. 

If you want to include most but not all organizations, select the All Organizations checkbox to select all organizations. Then, deselect (select the checkbox again to remove the checkmark) the organizations you want to exclude.

Note: Selecting more than 10 organizations can slow processing of this report.

For instructions on creating this report, go to Create a Families Without Pledges Report.

Set up Options for the Parish Batch Summary Report

The Parish Batch Summary report enables a diocese to view pledged amounts and to-date batch totals for batches associated with a selected fund. The options used to set up a Parish Batch Summary report are listed below. 

Note: An asterisk (*) indicates required information.

Fund *

Type the first few letters of the fund in the textbox. A list of funds matching the text you enter is displayed. Select the desired fund from the list.

Organization

Type the first few letters of the organization in the textbox. A list of organizations matching the text you enter is displayed. Select the desired organization from the list.

Set up Options for the Parish Summary Report 

The Parish Summary report summarizes parish-wide pledge activity. The report also provides key pledge metrics, allowing a diocese to view the details behind the summaries. The options used to set up a Parish Summary report are listed below. 

Select a Fund

This dropdown list contains all of your organization's funds. Select the fund for which you want to view a summary of the selected organization's pledge activity.

Group by Region

If you have organizations assigned to regions (this is done in the Organization Management section in the Administration module), select the checkbox to sort information in the report by region.

Organization *

This section contains a list of organizations you can select to include in the report.

To include an organization, select its checkbox. To include all organizations in the list, select the All Organizations checkbox. This checkbox is to the left of the Organization ID header. 

If you want to include most but not all organizations, select the All Organizations checkbox to select all organizations. Then, deselect (select the checkbox again to remove the checkmark) the organizations you want to exclude.

Note: Selecting more than 10 organizations can slow processing of this report.

For instructions on creating this report, go to Create a Parish Summary Report.

Set up Options for the Pledge Adjustment Report

The Pledge Adjustment report provides a detailed account of adjustments made to pledges to a fund during a specified time period. The options used to set up a Pledge Adjustment report are listed below.

Note: An asterisk (*) indicates required information.

Select a Fund

This dropdown list contains your organization's funds. Select the fund for which you want to view pledges that have been modified during the date range you specify. 

Start Date *

Set a date range for the report by selecting a start date from the calendar and an end date from the End Date calendar (see next option). To find changes made on the same date, select the same date from both the Start Date and End Date calendars.

End Date *

Set a date range for the report by selecting an end date from the End Date calendar and a start date from the Start Date calendar (see previous option). To view adjustments to pledges made on the same date, select the same date from the Start Date and End Date calendars.

For instructions on creating this report, go to Create a Pledge Adjustment Report.

Set up Options for the Revenue Projection Report

The Revenue Projection report supports multi-year campaigns. The report provides month-by-month and year-by-year cash flow projections, summing those amounts for each fiscal year within a projected six-year period. The options used to set up a Revenue Projection report are listed below.

Fund

This dropdown list contains all of your organization's funds. Select the fund for which you want to forecast revenue. 

Show Non-Performing Pledges

Select the checkbox if you want the report to show amounts pledged that were not included in the forecast due to non-payment.

Show Non-Forecastable Pledges

Select the checkbox if you want the report to show amounts pledged that cannot be included in the forecast due to insufficient data in the pledge records. 

For instructions on creating this report, go to Create a Revenue Projection Report.

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

If you have an issue that requires help or feedback, please Contact Support.