Donors over X Amount

The Donors over X Amount report lists the donors that meet the specified amount criteria for the date range, funds and people selected.

To run this report:

1. Expand the Contributions menu.
2. Click on Reports.
3. Click Donors over X Amount on the left sidebar.
4. From the criteria tab, select the date range that you wish for this report.
5. Next enter the amount that you are searching for. The report will search for those folks who gave exactly that amount or greater over the date range.
6. Next under the Who tab, select the donors you wish to see on the report. Do you wish to see all donors, or certain associations or certain groups, etc.? Once you’ve chosen who, click on the What tab. From here, select the funds you are interested in including on this report.
7. Click on the Columns tab. Choose the columns you wish to view on the report. There are default fields already set up for this report, but you can drag additional fields from the left side to the Selected column. You can rearrange the ordering in the Selected column by dragging and dropping in the order you wish to see them in the report.
8. If you’d like to change the sort order, move the columns from the Selected column to the “Sort” column.
9. Click GENERATE.

As an example, lets say we’d like to view people who have given over $250 this year. We want to evaluate everyone in the database and we want to consider giving to all funds.

1. Highlight Donors over X amount on the left sidebar.

2. From the Criteria tab, select “This Year” from the date range drop down.

3. Enter 250 as the Amount.

4. Click on the Who tab. Leave “Everyone” selected.

5. Mark the box for Combine Families if you want contributions from families lumped together.

6. Click on the What tab. Click the double arrow to move all funds to the Selected column.

7. Mark the box to include non-cash gifts if you want to include property gift amounts in the report as well.

8. Click on the Columns tab. Drag the address, city, and state fields from the left side column to the Selected column on the report.

9. Click GENERATE to produce the report.

On the right side of the Report Output Window are actions that can be performed for the report.

1. Click on PAGE SETUP to set your printer and paper size and orientation.
2. Click on PREVIEW to preview the output. Do not send the report to the printer from this preview window, it will only send the first page to the printer.
3. To change fonts, column sizes etc., click CUSTOMIZE. The report will be displayed in 4D View, Roll Call’s spreadsheet program. Make your modifications here.
4. Click on PRINT to send the report to the printer.
5. Click ZOOM IN to make the font in the report larger on your screen.
6. Click ZOOM OUT to make the report font smaller on your screen.
7. To save the report as a tab delimited file or html document, click SAVE. Enter the location and name of the file to be saved.
8. Click SAVE SET to save the list of people for use later within Roll Call.
9. Click CREATE LABELS to create address labels (3 across 10 down size) for this list of people.
10. Click WRITE LETTER, to compose a mail merge letter to this list of people.
11. Click EMAIL to send an email to this list people or to email the report to another individual. If you choose Email people, it will send the email to everyone listed in the report.