How to Pull a Transaction Report

Standard One-Click reports can be used to quickly generate reports from common date searches.

Use the One Click drop down list and select a transaction report type: Today's, Yesterday's, This Month's, or Last Month's.

custom search image
Figure 1
If these "quick" reports do not fit your requirements, use the search fields on the left to produce a completely custom search.

Creating a Report with Custom Search

In the search fields panel, you will find several fields to help refine your search options, such as first and last name, transaction ID number, the last four digits of the card number, or Gift Dedication Name. These Search fields may be used in combination or alone. If used as a stand-alone query, we recommend you also include a date range for faster results.

date range fields
Figure 2

Selecting Transactions from a Specific Form

If your charity has more than one payment form, you can search for transactions by the specific form.

To pull a report for a specific form, use the "My Forms" drop down menu on the top left and select the form name. To retrieve a list of all transactions, regardless of form, leave the "My Forms" drop down menu blank.

For more information about naming your forms, see: Create a Campaign.

my forms
Figure 3

Selecting Transactions by Amount

As you look for new marketing strategies or ways to present information to your board you will probably want to consider donor segmentation.

  • In the custom search fields on the left, go down to Amount.
  • To the left of the Amount field is a drop down field to select the Operator.
    • The default value is equal to (" = "), but you can also select Less than or equal to (" <= "), or greater than or equal to (" >= "). (Figure 4)
      For example, if you want to find all donations that are $500 or more, select the " >= " operator and enter $500 in the amount field.
    • You also have the option of entering an Amount Range. Click the "Search Amount Range" checkbox. A new field will pop up with the From and To ranges. (Figure5)
    • Or use the slider bar. Click into one of the amount fields and move the slider bar left or right. (Figure 6)
Figure 4
my forms
Figure 5
my forms
Figure 6

Sorting Transaction Report Results

You will find sorting options for your transaction report at the bottom of the left-hand panel. You may select up to two pre-designated sort options. This may be done before or after the search is performed by clicking "Go."

There options are not "savable" and will revert to empty status when you logout.

custom search image
Figure 7

Finding and Creating a Gift Dedication Report

To find your Gift Dedication transactions use either the One-Click "Gift Dedications" option (Figure 1 above), or use the search fields in Transaction Reports screen.

In the Transaction Reports search fields, there are two options: 1) you may find dedication gifts by the dedication name or 2) search for all gift dedications.

  • Gift Dedication Name: Type the dedication name (first, last, or both) in the name fields and click "search."
  • Click the Gift Dedication check box (without anything in the name field) to pull a complete list of gifts within the specified date range. To see all transactions, regardless of date, leave the date range fields blank.
  • Both lists may be printed (summary info) or downloaded (selected custom database fields).
my forms
Figure 8

Note: The search results are only as reliable as the information submitted by your donor. If the name was misspelled or part of it omitted, the search may or may not produce accurate results.

Finding and Downloading Employer Match Donations

Locate your Employer Match gifts by clicking the Employer Match check box at the bottom of the Transaction Reports search fields.

Related content: Employer Match - the Match Process

my forms
Figure 9

Finding Transactions with a specific Custom Field Entry

Let's assume you have a custom check box for "Please keep my gift anonymous" and you want to find all transactions where the donor clicked that check box. Enter the text into the "Custom Field Entry" field and click search. Likewise, if you are using a dropdown menu, enter one of the options from your drop down list (make sure to enter it exactly as shown on your payment form) and search.

The same can also be done for a custom fill-in field, but since the response to a fill-in field will be random, it will be more difficult to obtain an accurate search.

my forms
Figure 10