Skip to content
hapily

5 Amazing Revenue Reports For Nonprofits in HubSpot

If you're a nonprofit, Zaybra 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 Zaybra,  you can easily accomplish this with some well made reports! 

But before I show you how Zaybra 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 Zaybra Transaction.
- Under Choose the associated record property select Amount.

Zaybra Lifetime Donations Made Property



3. Subscription Lifespan: This will be a Zaybra 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 Zaybra Subscriptions and Zaybra 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 Zaybra 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 Zaybra 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 Zaybra Transactions Created At is This year so far and Zaybra 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 Zaybra 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 Zaybra Subscriptions and Zaybra 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 Zaybra 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

Unleashing Profit Power: Using Custom Quotes to Handle Dynamic Pricing In HubSpot

Unleashing Profit Power: Using Custom Quotes to Handle Dynamic Pricing In HubSpot

Ever wondered how custom quotes handle dynamic pricing and streamline sales processes? Read on to find out.

Unlocking the Secret to Effective Subscription Management

Learn how to optimize customer experiences, improve retention, and maximize revenue with the right tools and strategies to power your subsc...

How to Navigate Monthly Revenue Reporting with Metered Billing

Learn how to navigate monthly revenue reporting with metered billing and understand the financial impact and benefits of this pricing strat...