Payment Reports

The “Payment Details” report in Reports module of Retention CRM provides Nonprofits, Associations and Chambers of Commerce with a detailed breakdown of individual Payments made by their contacts. It allows you to filter and analyze donations based on various criteria, providing valuable insights into your donor base and fundraising efforts.

General Functionality of “Payment Details” report

• Donor Name: Name of the individual or organization who made the Payment.
• Donor Email: Email address associated with the donor.
• Payment Date: Date on which the Payment was received.
• Donor Phone: Phone number associated with the donor (if provided).
• Financial Type: Category of the Payment (e.g., Membership Dues, Event Donation, General Donation).

Nursing Association Context:

• Donor Name: This could be the name of an individual nurse member, a healthcare institution, or a pharmaceutical company that supports the association.
• Donor Email: Email address used by the donor for communication.
• Payment Date: Tracks when the donation was received, helping identify trends in giving behavior (e.g., seasonal spikes).
• Donor Phone: While not always relevant, it provides an alternative contact method.
• Financial Type: This helps categorize donations for specific purposes within the nursing association. Examples include:
  • Membership Dues: Annual or monthly fees paid by nurse members.
  • Conference Registration: Fees for attending educational conferences or workshops.
  • Scholarship Fund: Donations dedicated to supporting nursing students financially.
  • Advocacy Fund: Payments used for lobbying efforts or political campaigns promoting nursing interests.

Additional Options and Filters:

The Payment Details report offers various filters to narrow down the results based on specific criteria. Here’s how these options can be utilized in the context of a nursing association:

Column	Order	Section Header / Group By	Page Break	Description (Nursing Association Context)
Contact Source	Optional	Filter	No	Identifies how the donor learned about your association (e.g., website, event, referral from another member).
Campaign	Optional	Filter	No	Allows filtering by specific fundraising campaigns (e.g., campaign to raise funds for new educational resources for nurses).
Payment Status	Optional	Filter	No	Shows the status of the Payment (e.g., Completed, Pending, Refunded).
Custom Fields	Optional	Group By	Optional	Enables grouping by custom fields you created for specific information (e.g., member type, area of nursing specialty).

Using “Payment Details” report in Association Management

A hypothetical scenario showcasing how a nursing association can leverage the Payment Details report:

The association wants to analyze donations received during their annual fundraising campaign for scholarships. They use the report with the following filters:

• Financial Type: Scholarship Fund
• Payment Date: Filter for the campaign duration

This report provides details on:

• Donor Names: Names of individuals or organizations who donated to the scholarship fund.
• Payment Amounts: Shows the specific amount donated by each contributor/donor.
• Donor Emails: Allows sending personalized thank you emails to each donor.

By analyzing this data, the association can:

• Identify major donors for potential future solicitations.
• Recognize and appreciate Payments from all supporters.
• Track the success of their fundraising campaign and identify areas for improvement in future efforts.

More Use Cases for Associations, Chambers of Commerce and Nonprofits

Nonprofit Fundraising Analysis

Imagine a non-profit that runs a homeless shelter. They can use the Payment Details report to analyze donations received throughout the year. By filtering the report by Financial Type (e.g., “General Donation”) and Payment Date, they can identify seasonal trends in giving. This helps them plan fundraising campaigns strategically, focusing their efforts during times when donations are historically lower. Additionally, they can use the report to identify major donors and personalize thank-you messages (using Donor Email).

Chamber of Commerce Membership Analysis

A Chamber of Commerce can leverage the Payment Details report to understand their membership base better. By filtering the report by Financial Type (e.g., “Membership Dues”) and Payment Status (e.g., “Completed”), they can create a list of current members. This allows them to target specific demographics with membership renewal campaigns or send out exclusive member benefits information.

Association Event Sponsorship Analysis

An association that organizes conferences can utilize the Payment Details report to assess sponsorship revenue. By filtering the report by Financial Type (e.g., “Conference Sponsorship”) and Payment Date (e.g., time frame surrounding the conference), they can identify sponsors and the amount of their Payment. This helps them understand the return on investment (ROI) for sponsorships and potentially reach out to high-value sponsors for future events.

The Payment Details report empowers Nonprofits, Associations and Chambers of Commerce to gain valuable insights into the payer base within their contact database in Retention CRM and optimize their membership management, event management and fundraising management strategies, ultimately supporting their mission.

The ‘Payment Summary’ report in Reports module of Retention CRM provides Chambers of Commerce, Nonprofits and Associations with a way to group and analyze Payments based on various criteria. This helps member-based organizations understand their payer base and financial trends.

General Functionality of ‘Payment Summary’ report

Payment Amount Stats

This section displays overall statistics about the Payments included in the report. These might include:

• Total Amount: The sum of all Payments in the selected timeframe.
• Average: The average amount of each Payment.
• Minimum: The smallest Payment amount.
• Maximum: The largest Payment amount.
• Number of Payments: The total number of Payments included in the report.

Report Options & Filters in the Context of a Nursing Association

Now, let’s explore the report options and filters with a specific example: a nursing association.

Filters:

• Contact Name: Search for Payments from specific members of the nursing association.
• Contact Source: Identify how members learned about the association (e.g., event, website).
• Gender: Analyze Payment patterns by gender.
• Birth Date: Segment Payments based on member age groups.
• Contact Type: Filter by member types (e.g., registered nurses, nursing students).
• Contact Created/Modified: Track Payments from new or existing members.
• Deceased/Do Not Contact: Exclude Payments from deceased members or those who opted out of communication.
• Preferred Language: Generate reports for specific language groups.

Payment Details:

• Payment Date/From-To: Track Payments by date range (e.g., identify seasonal giving trends).
• Receipt Date/Thank You Date: Analyze how quickly acknowledgements are sent for Payments.
• Payment Status: See how many Payments are completed, pending, refunded, etc.
• Currency: Track Payments in different currencies used by members.
• Financial Type: Categorize Payments by type (e.g., membership fees, donations for a specific program).
• Payment Page: Identify which donation pages are most successful.
• Payment Recurring: Track recurring memberships or donations.

Monetary Analysis:

• Payment Amount: Analyze individual Payment amounts.
• Non-deductible Amount: Track Payments that aren’t tax-deductible for the donor.
• Payment Aggregate/Count/Avg: See total Payments, number of Payments, and average Payment for a particular group (e.g., by state, membership type).

Additional Details:

• Campaign: See how Payments relate to specific fundraising campaigns.
• Batch Title: Identify groups of Payments processed together.
• Soft Credit: Track Payments where credit is shared with another organization.
• Credit Card Type: Analyze preferred credit card methods for donations.
• Payment is a pledge payment: Identify payments made towards previously pledged Payments.
• Tag/Group: Filter Payments by tags or groups assigned to members.

Address Information:

• Location Analysis: Analyze Payments by member location (city, state, country).

Using ‘Payment Summary’ Report in Association Management

Let’s consider a scenario where the nursing association wants to understand their membership donation trends:

1. Filter by Contact Type: Select “Registered Nurses” to focus on this specific member segment.
2. Payment Date (From-To): Set a date range for the past year to analyze annual giving trends.
3. Financial Type: Group by “Membership Fees” to understand membership revenue.
4. Payment Aggregate/Count/Avg: Analyze total fees collected, number of members who paid fees, and average fee amount.
5. State/Province: Analyze Payments by location to identify areas with high membership concentrations.

More Use Cases for Associations, Chambers of Commerce and Nonprofits

Association – Analyze Membership Renewal Rates

Goal: Understand membership renewal rates and identify trends

The alumni association can use the Payment Summary report to track membership fee renewals. By filtering by “Contact Type” for “Alumni” and “Financial Type” for “Membership Fees”, the association can see the total amount of membership fees collected, the number of members who renewed their memberships, and the average renewal amount. They can also analyze trends over time by using the “Payment Date” filter. This data can help the association identify any declines in renewal rates and develop targeted campaigns to encourage renewals.

Chamber of Commerce – Identify Sponsors for Events

Goal: Identify potential sponsors for upcoming events

The business chamber can use the Payment Summary report to identify businesses that have a history of supporting the chamber through financial Payments. By filtering by “Financial Type” for Payments related to sponsorships or events, the chamber can see which businesses have sponsored events in the past and the amount of their Payments. They can also use the “Payment Date” filter to identify businesses that have consistently sponsored events. This data can help the chamber target potential sponsors for upcoming events and develop sponsorship packages that meet the needs of different businesses.

Nonprofit – Track Donations for Specific Programs

Goal: Track donations for a specific program (e.g., tree planting initiative)

The environmental protection organization can use the Payment Summary report to track donations for their tree planting initiative. By filtering by “Financial Type” for donations designated for the tree planting program, the organization can see the total amount of donations received, the number of donors who contributed, and the average donation amount. They can also use the “Payment Date” filter to track donation trends over time. This data can help the organization measure the success of their fundraising campaigns for the tree planting program and identify areas for improvement.

This report allows Associations, Chambers of Commerce and Nonprofit organizations to identify membership, event and other kinds of payers, target specific member segments for future campaigns, and assess the effectiveness of different financial initiatives. They can use this data to tailor their communication and outreach strategies to different payer groups in your contact database in Retention CRM.