This article explains how to use Donor Reports in Offering to review family names and addresses, so your contribution statements (US) or tax receipts (Canada) are accurate before you mail them.
Why Audit Family Data?
Contribution statements (US) and tax receipts (Canada) summarize all gifts given during the year and let you thank donors. These documents are only accurate if your contribution and family data are correct. Before sending statements, audit your family records to find and fix empty or incorrect fields.
Export the Donor Report
- On the dashboard, select Offering.
- In the navigation menu, select Reports to expand the section.
- Select Donor. The Donor Reports page opens.
- Open the Select a Donor Report dropdown.
- Choose Contribution Detail Statement Report (US) or Tax Receipt (Canada). The report options appear.
- In Run Report For, choose Families, Members, or Family (include Member Gifts).
- Enter the Start Date and End Date for the statement period.
- Under Select one or more Funds, check each fund to include.
- Under Select one or more Family Groups, check each family group to include.
-
Review any other filters you need. For help, see Configure Filters for Donor Reports.
Note: You do not need to change design fields such as Signature, Letterhead, or Body of Statement for this audit.
- At the top right, select the Export icon.
- Select Excel.
Review the Report in Excel
- Open the downloaded Excel file.
- Sort by the address columns (City, State, and Zip Code) to find blanks or visibly incorrect data.
- Note each record that needs an update.
Update Family Records
- At the top left, select Offering to open the app menu.
- Select Families. The Family List opens under Family Directory.
- Find and update each record you noted. For details, see View or Update a Family Record.
Updated