Generating a Year-End Report
These steps will help you efficiently and accurately generate a report to analyze and track your donors' contributions.
This guide walks you through creating a custom report to capture all donations made in a calendar year. You can also apply additional filters, such as donor email, to generate giving history for individual donors.
Creating a Custom Report
- Navigate to Reporting.
- Click + New Report.
- Name Your Report.
- Choose the Transaction focus.
- Click + Add Filter and use the following query:
- Where Created (UTC), greater than or equal, 01/01/xxxx (the previous year).
- Click + Add Filter and use the following query:
- And Created (UTC), less than or equal, 12/31/xxxx (the previous year).
- Click Save Report.
- Choose your report Visibility from the dropdown and click Save Report.
Your organization now has a saved report for all donations in the previous calendar year. For donor-specific reports, continue to the next steps.
(Optional) Filter by Donor
To narrow the report to a specific donor’s giving history:
- Click the Customize Report icon.
- Select Filters and click + Add Filter.
- Choose the Email field from the drop-down menu and the equals operator.
- In the input field, paste the donor's email address exactly as it appears (no erroneous spaces), then click Apply.
- Download your report as CSV or Excel.
Use the Columns tab in the Customize Report menu to add or remove fields to further customize the information you need.