Skip to content
Nonprofit

5 Amazing Revenue Reports For Nonprofits in HubSpot

If you're a nonprofit, saas•hapily can help you report on your revenue! Here are five great examples!

Running a nonprofit organization can be tough! That’s why you’ll want to make things easier by grafting your revenue in HubSpot. And with some help from saas•hapily (formerly Zaybra),  you can easily accomplish this with some well made reports! 

But before I show you how saas•hapily can help you, you're going to need to create a few custom properties! Don't worry. I'll teach you how.

1. Donor Type: A Contact property with a Multiple checkboxes field type. Add One Time Donor and Recurring Donor as the options.

Zaybra Donor type property



2. Lifetime Donations Made: Another Contact property. Set the field type as Rollup and:
- Under Calculated property type select Sum.
- Under Number Format select Formatted Number.
- Under Choose the associated record type select saas•hapily Transaction.
- Under Choose the associated record property select Amount.

Zaybra Lifetime Donations Made Property



3. Subscription Lifespan: This will be a saas•hapily Subscription property with a field type of Equation.
- Under Calculated property type select Time between.
- Under Number format select Duration.
- For the Start Date select Created At.
- For the End Date select Billing End Date.

Zaybra Subscription Lifespan Property




And now without further ado, here are five great nonprofit reports to get you started!

How to make a Donations by Donor Type report

If you have multiple donor types and want to see how much revenue is coming in from each, you’ll definitely want to make use of this report! To create it:

1. Create a Custom Report.

2. Select Contacts as your primary data source and select saas•hapily Subscriptions and saas•hapily Transactions as your additional data sources.

3. Under the Configure tab, select Horizontal Bar as your chart type.

4. Add Lifetime donations made to the X-Axis.

5. Add Donor Type to the Y-Axis.

Zaybra Donations bu Donor Type Report



6. Under the Filter tab, add the filter Contacts Donor Type is known.

Zaybra Report



And you’re done!



How to make a Recurring Donations Over Time report

If you want to see recurring donation growth over time, this report will be indispensable! To create it:


1. Create a Custom Report.

2. Select saas•hapily Subscriptions as your primary data source.

3. Select Area for your chart type.

4. Add Created At to the X-Axis. It should be Monthly by default, but you can change this by clicking the little pencil on the field and changing the frequency.

5. Add MRR to the Y-Axis.

Zaybra Recurring Donations Over Time Report



And you’re done!


How to make a Donations Made Over Time report

This one sort of fuses the previous two, making it helpful if you want to see the bigger picture! To create it:


1. Create a Custom Report.

2. Select Contacts as your primary data source and saas•hapily Transactions as your secondary data source.

3. Select Area as the chart type.

4. Add Transaction Created At to the X-Axis. I have it set to Weekly, in my example but you can change it by clicking on it and changing the Frequency.

5. Add Amount to the Y-Axis.

6. Add Donor Type under Break Down By.

Zaybra Donations Made over Time Report



7. We’ll need two filters for this one! Under the Filters tab, add saas•hapily Transactions Created At is This year so far and saas•hapily Transactions Amount  is greater than 0.

Zaybra Donations Report




And you’re all done!


How to make an Average Recurring Donor Lifespan report

Getting a little worn out from all this report making? I’ll slow things down with an easier one. You may want to know how long your donors are sticking with you. That’s why you’ll want an Average Recurring Donor Lifespan report! To create it:


1. Create a Custom Report.

2. Choose saas•hapily Subscriptions as your primary data source.

3. Select KPI as your chart type.

4. Add Subscription Lifespan to Values.

5. Click on the Subscription Lifespan you just added and change the Aggregation to Average.

Zaybra Average Recurring Donor lifespan report


Zaybra Donor Lifespan Report




And you’re done! No filters necessary. Keep in mind you want to use just plain Subscription Lifespan and not Subscription Lifespan (Months).



How to make a Donors by Source report

It never hurts to know how your donors found you! Make finding out a breeze with the Donors by Source report. To create it:


1. Create a Custom Report.

2. Select Contacts as your primary data source and select saas•hapily Subscriptions and saas•hapily Transactions as your additional data sources.

3. Select Donut as your chart type (You can’t eat this one unfortunately).

4. Add Original Source to Break down by.

5. Add Lifetime Donations Made to Values.

Zaybra Donors By Source Report



6. Add the filter Contacts Donor Type is known.

Zaybra Filters



And you’re all done!


That was a lot to go over, but thanks for sticking with me! Now you have a handful of new reports for your tool belt to help you track revenue for your nonprofit!

Isn’t that better?

Want to see what else the app can do? Check out this blog post on How saas•hapily Manages Scheduled Stripe Subscriptions in HubSpot. And be sure to share this post with all of your friends!

 

David Staat

David Staat

Helping users HubSpot hapily!

Latest Articles

Simplifying Tax Breakdown for Subscription Services Quotes

Simplifying Tax Breakdown for Subscription Services Quotes

Learn the benefits of providing efficient tax breakdowns in quotes for subscription services. Enhance customer satisfaction and streamline ...

Organize Your SaaS Business: Managing Multiple Stripe Accounts

Organize Your SaaS Business: Managing Multiple Stripe Accounts

Discover why managing multiple Stripe accounts can help SaaS companies organize different services more effectively. Learn how this strateg...

Why Offering Multiple Payment Options Boosts Your Business

Why Offering Multiple Payment Options Boosts Your Business

Learn about different payment methods, their benefits, and how they can expand your customer base. Explore insights on increasing conversio...