Learn where the financial data is pulled from when running financial reports. We’ll help you to recognize the proper reports you need to get the information you are looking for. Financial reports will range from individual totals to categorizing income and giving trends.
**You can find the handout for the webinar here:
Categories: Foundation Series, Training Webinars
Financial Reporting TranscriptPrint Transcript
Good afternoon, everyone. Today’s presentation and webinar is financial reporting in DonorPerfect. My name is Arlene Berkowitz. I’m a member the training team here at DonorPerfect. When this particular webinar, we’re going to talk about Read More
Good afternoon, everyone. Today’s presentation and webinar is financial reporting in DonorPerfect. My name is Arlene Berkowitz. I’m a member the training team here at DonorPerfect. When this particular webinar, we’re going to talk about identifying your reporting needs. What does that entail? What do you have to keep in mind, part of those reporting needs will be, again, the genre, if you want to call it have reports. So we have today to present to you reports under the category or type of donor giving, even though it’s in financial reports, there are also reports that might be more financial oriented. And they would be under this group called categorize giving totals. And if you are a director, or want to provide information for a director, you probably would like to look at and understand reports that show trends. In addition, I would say that goes hand in hand with taking a snapshot of the database to understand the picture of the health or areas of a call it weakness or opportunities to grow and expand your database and improve conditions. So these are the kinds of things we’re going to be looking at. So you may have seen this report, maybe you’ve already been introduced to it and use it called gifts by date. Anybody want to give me your comment in terms of could it be useful to you have you found that to be the bee’s knees the perfect thing, anybody have anything to say about this particular report.
And keep in mind, or while I’m waiting, what we’re focusing on in this webinar is the output or the layout, in terms of which gifts or which donors appear, that is addressed either with the sidebar, or with a filter. And that is covered in our selection filters webinars. Okay, so I like this, this is this report is short, sweet. And to the point, it gives me the name of the donor, notice that there is a blue hyperlink here, so you can drill down into the donors file or record, the date of the gift and the oldest gift or the first of the month would be at the top. And the most recent would be at the bottom. The amount with a hyperlink allows you to drill down should you need to enter the gift, what we call the payment method or gift type. The reference number either the transaction ID or a check number, the solicitation being the appeal or event, the general ledger being the fund or account on the accounting software, where the money is going. And if you were using the receiving feature, then the specific receipt number and how much the receipt was for. So this I’m like because it’s again, short, sweet to the point, just enough information, it also totals and sums of money and doesn’t give you everything about the donor and everything about the gift. Okay? But you might say, Hey, it’s okay, but I need another field on here, or I don’t need certain columns. Okay, well, that’s what we’re gonna do today, we are going to explore finding, hopefully a report that DonorPerfect has already built that is going to fit your needs. Or if that’s the case, and and I’m sorry, and we don’t find it then there are other options. Okay, trying to advance this slide. There we go. So when you identify your need, or the person who was asking for this information, whether it’s your finance person, your accountant who works off literally off site, or not part of your organization, or it’s the board, or it’s the directors who whichever is what I call the consumer of the data. If that person is wanting to know who’s given how much and when, then I put them in the category of meeting, a donor giving report. If you want to look at, in total, I don’t need to see every gift. But let’s summarize how much each account or income account is doing. Or how each effort or solicitation is doing, then that’s in the group of giving total reports. And last but not least, if you want to know, how are we doing over time, and assuming that your organization has been around maybe a couple years, maybe a couple of decades, and you want to kind of gleam? Are there any trends? Or what direction are we headed in? Or maybe we want to change the trend. And we need to adapt a certain strategy to either stop a trend or to bring in more that have a trend? All right. So these are the kinds of questions you may want to frame the initial request when somebody needs a report. Okay, so that being said, we have these categories, I’m going to present some reports. Now the good news is, we’ve got lots of reports, if you haven’t noticed, there’s about four dozen reports available for you in the Financial Report folder. I’m going to go over approximately a dozen 15 or so reports today. And hopefully, the some of these will catch your eye or pique your interest and you say, perfect, you may not need to run that report every month or every quarter. But maybe there’s a situation where once or even twice a year, it’s the perfect fit. So again, this is like looking at all of the inventory, trying each one on for size to see, yes, this would work or not, it’s not appropriate. That’s okay. So in no particular order, we’re going to present these different names of reports. And then I will go into DonorPerfect with within each category and show you how these reports are run. So the top donor listening, if I want my top 10 donors, my top 100 donors or top 20% of donors based on what we call a calculated field. So we’ll explain that but this report will rank your donors depending on how many you want to see. We also have a report about monthly giving. Now this report will I’ll say work or was intended for those donors who have a pledge where the usually monthly but it doesn’t have to be just monthly, but where the payments are taken by credit card or a checking account. But they’re done automatically by DonorPerfect what we call save save payments gateway. If you have monthly giving donors who are in authorize that net or Paypal or some other platform, they would not appear on this monthly giving report. Okay, just are still a perfect safe safe gateway. Okay. We’re coming off of the urine. Hopefully, your annual report. For many of you with your fiscal year ended December 31, you were able to produce a report that looks like this donors by giving level. If your fiscal year is coming up June 30, then you might need to produce this report. And you’ll see how easy it is to get what you need using this particular report. And we also have under this, we have the transaction listing. This is the only report in this webinar that is not a financial report folder. It’s in the area of receipts, but this will show every single gift or pledge etc. That has entered into the system. Usually this report is run in conjunction with the acknowledgement Processing feature. But this is also a way to just look at every single gift in a certain time period or with a filter. So let me now go into DonorPerfect. And just so that I’m going to go into receipts and then stay in financial reports for the remainder of the webinar, I’m going to go into that first on your receipts. Now here, I might not necessarily want to look at the current batch, I might want to look at gifts that were entered in DonorPerfect with the date of gift between February one and February 28. If they’re not in the current batch, then we can uncheck that box. If they’ve already been acknowledged, through the receiving area or via the gift screen, then you will need to check include already processed. There are three reports here, but the one I want to share with you right now is this transaction listing, you can put it on the screen to review it, you can print it directly. Or if you put it in Excel, I like this option if you want to delete some of the columns. But let’s just put it on the screen. And this has pretty much everything you would need to know. This is again, that time period, the dollar amount, if you include pledges and receipts, then they would appear as a column, the name of the donor, etc, we have a fair market value, your general ledger solicitations, payment type, the thank you letter assigned to it, a reference field, etc. What’s also great about this report
is at the bottom, we have this nice table that captured the gift type and tells you how many and the subtotal per payment method or gift type. Right? You like this fantastic. Use those other buttons to either print it directly as is, or download to excel and hide or delete any columns that you don’t need. Right. Now, let’s go into our report center. And the rest of the reports we’re going to show are here in the Financial Reports folder. Should you happen upon a report and maybe you want to get an idea of what it does, feel free to hover over the information bubble. And it will explain what the report that’s okay, or simply click on the name of report, send it to the screen, and then either take a snapshot of it or download it. Okay, but in no particular order. Let’s go with the top donor. Now what if I put in the word top, this is the only report title or the only report that has T O P in its description. So you may enter that if you don’t find it in the list anywhere, click on the name or in the actions choose Open. Now, as I mentioned, this report is unique because it wants you to provide the field that needs to be analyzed or recognized in terms of ranking. So here we see that this was last saved with the with the field of gifts underlying total, that is the lifetime giving. But if you want to look at donors and rank them based on how much they gave, maybe last calendar year, that would be the l-y underlying. And if you’re wanting to know what these field names mean, then I would recommend that you go to your settings, screen designer. These calculated fields will be on the main screen not necessarily visible. But many of you will have an area called giving an engagement and that’s where these fields are defined. If, and if I want to show the top 100, I will get 100 lines, even if there are more than one donor who have the same exact total giving last calendar year, I’m going to always ensure that I put clear values, and that there’s no other filter applied unless it would be relevant, I’m just going to run the report right now and put it on the screen. So here we see the field last year total giving my top or number one donor is John jet, we see the numbers get smaller and smaller. And we go down in this case 100. And the $100. That is, and the entity with in position number 100 is down here, Bank of America. Okay. So that is your top donor report. Back to Report Center. Always try to say no here, just so that filters or any other values used on that report are not saved for the future. And if I want donors by giving level, maybe I’m going to type in the word level, because that might not be used in that many reports. Great. I landed on this donors by giving level. Now there would be a little bit of setup involved. And to use this report, I’m going to suggest that you pull a previous year’s annual report, someone in your organization should hopefully have that and you will see the appropriate captions that they use it not always used. But for the most part, there will be these dollar levels. And when you’re setting it up, make sure that you go 99 cents on this side, and then a penny more is here. So that I don’t want to have 100 to 1000. And then the next row be that same dollar amount. So always make sure that guy going away speaking that they are a penny different. Okay, so these captions may have names that are specific to the services that you provide or your mission statement. And again, clear values, I make sure there’s no filter. And there is usually a date range, usually a year, but it could be other than that. Now I run the report. And it’s going to look at every gift and get the aggregate of the gifts, and then put the donors alphabetically into the respective group. Wow, pretty amazing, isn’t it? Usually the top group, the Top Banana is going to be literally at the top and the bottom is going to have your, in this case, donor level. Do we have anybody there? Yes, we have several in the donors. Awesome. Now when you run this, I’m going to recommend the first time you do you make sure to include gift amounts and totals to the extent you want to validate and check out some of the data and then if you want to display the optional line depending on how that’s used, you might want to do that for the final one for sure. Okay, make sure after you check some of these out, you want to make sure that you don’t have duplicates, I don’t want to have Justin Aquent here and then have him also as a different donor ID somewhere else. If that were the case, I would recommend that you use the do the Remove Duplicates under merge duplicates here okay. And then make if this is accurate, great. Make sure that for the final version, you remove the gift amounts and totals and you might want to export it to either Excel or Word so that if the font or anything needs to be manipulated, then you will be able to do that. All right, so that is your donors by giving level and last but not least is your monthly giving
underfoot financial here I’m going to type in a monthly and I do have a monthly giving report. Nothing is needed unless you were interested in those pledges that are under a certain campaign, or general Ledger’s, etc. So right now, I’m not going to look at the sidebar. Wow, these would be the names. And if the donor has more than one, in this case, Betty has multiple pledges. The zero in this case means it is a recurring gift. There is no end point. In this case, though, Callie has a fixed pledge of $1,500. When the pledge when that has been fully satisfied, the charges to her credit card or bank account will stop as opposed to the ones with zero, they will keep on going indefinitely, unless the donor lets us know or if there’s a problem with the credit card. Great question Molina is asking about the top donor report or the authority the giving level, the giving level does not include soft credits. To that, I’m going to say you probably would use the the top donor report to produce it, or using an export to file. So if you’re not sure which method or how to use either, I would say work with support to make sure that you have the calculated field that includes soft credits. But thank you for asking that. All right, back to our slides. The next type of reports in our financial reports are giving totals over time. And Sadie you’re saying your which report gives you a no results found is that the monthly giving okay, then that unless there’s something on the sidebar, or you have a filter there that might conflict with all of these pledges. So we can click on the clear values and make sure there’s no filter, then try running the report. Again, if it still says no records found, then that means that you do not have any pledges set up where they are charged through the safe safe payments gateway. Okay. If that doesn’t sound right to you, then I would say reach out to support and they will troubleshoot it. Okay. So solicitation analysis is a great report, to look at all of the ways your organization brings funds in, meaning all the different appeals and events cetera. But it does more than that. Not only does it show the income, but it shows the response rate. If you went to expenses, it’ll show you the net income. And how did you do visa vie a goal? Wow, lots of good stuff there. Okay, we also have something called a segmented gift and pledge summary. This report has gifts and pledges, month to date, year to date and total to date. Very summarized info, this is not going to give you you know all of the donors than all of the pledges on the top level. Just like the solicitation analysis, it won’t show you all the gifts, it will summarize by the solicitation code. When you have a report, I love this report, the gift pledge detail. This is the only report in the system where if you want to see what we call straight gifts are non pledge payment gifts, pledge payments as well and pledges as well as the balance on one combined report per donor. This is your answer. Fantastic report. And you’ll see that shortly. And last but not least, I actually use this earlier today, the cross tabulation, I can look at any two coded fields. And I want to see let’s say How do my solicitations do per state? If you raise money across the country, for instance or across, you want to look at different states or provinces. How can I compare how they Step up, or donor type, by campaign, etc. So that’s what the crosstab would allow you to do. So let’s check these out reports back to My Report Center. Open up financial data solicitation is in this, it is stored as a favorite report. I’m going to click on the name. Want to pick any time period, I’m going to go back a couple years, so that we can see some things together. Again, I’m going to make sure I click Clear values, make sure I see no filter selected. Now I’m gonna run the report. Okay, so the reason why I wanted to expand beyond the current year is for you to see this exactly, or Gala. Okay. Now, it’s a recommended convention, that you name your solicitation codes, if they do, or these events or appeals have been every year that you’d call it, Gala, 21, Gala. 22, gala 23. That way on this report, they will show up one under another, it looks like we didn’t do too well with our galleries. But we can see how they stack up. And yeah, maybe the revenue was increasing. But if the revenue is increasing at a pace that is I’ll say, outpaced by the expenses. In other words, are the expenses growing faster than the revenue is or at a higher rate, and the revenue is that would not be good. And therefore, if we had expenses here, our net income, which is here, net revenue, would not be as good from year to year. So that’s why, if you’ve ever seen us recommend this convention, that’s this is the report that I’ll say is the reason for that convention. Okay. Same with golf tournament, etc, monthly giving, giving Tuesday, 21, giving duvet, 2223, etc. Lots of good stuff here. If I collapse the sidebar, then you will see how many pieces were mailed our response rate, the number of gifts, total revenue, which you can drill down to identify all these gifts. Okay, but then we’ve got expenses, and therefore if I have expenses, I could calculate a net revenue, then it can put everything on an even playing field and calculate the total revenue per dollar spent. Because I think you would agree that if we spend $1, where am I getting my biggest bang for that buck? Right? So that’s what this column is about. The cost per 1000, gift, revenue per 1000 gifts. And the goal, and then the variance from the goal. And in case any of you were wondering, Where did you put that goal? And where did goals go and DonorPerfect? Or where do the expenses go? Eileen? Well, you can either go directly into code maintenance, or take a little shortcut and go here by clicking on the code. Here’s the number of pieces mail. If that were the total printing, plus other maybe we put postage or maybe some graphic designer or something we needed. Okay, so you can have those two buckets and here’s where the goal wow that is a very lofty goal with only 100 pieces mailed that means we would need $1,000 on average per gift. Wow. But when you put those pieces of info in and hit Save, then they will appear on this report.
Okay, so if the mailed is zero, that means that nothing was entered. Here include maintenance in the total mail and it very well could be zero. But if this report is something that you feel is really valuable, then Then I’m going to encourage you to either put those items in by going in through the report, or going through code maintenance. And go to the field that begins with the letter S, called solicitation, click go
edit the code. And this is another way of getting the data and all right. Back to our list of other reports, segmented gift, then pledge summary. Well, you could type the whole name, or we’ll just start with the word segment. Great, it narrows it down. Notice there’s no word segment here in the title. But that may means that the information bubble includes the word segment. I’m gonna click on this one. And this is one of several reports that uses this segment by that’s where the name of this report came from. This segment BI is referring to what field should be the rows on the report? Or another way of saying it is, what field do you want to see the sub totals for? Ah, great. I want to see sub totals of revenue for each general ledger, maybe, or for each campaign code, or for each solicitation, etc. And let’s just check this out. Okay, so per general ledger, we see the gifts here. And if you check the box to include pledges and rerun the report. Then you see, if pledges were counted as if they were income based on the field of the total on the pledge that they will be reflected in here. And anything you can drill down. Can anybody tell me what does this first row mean? The 525 and the 625. Anybody want to guesstimate what that represents? And this shows the value in running these reports before the end of your fiscal year. Exactly, Rachel, thank you. That means that there are two gifts and or pledges or four of them that don’t have a what, in this case General Ledger assigned to them. So what you would do is drill down, look at each of them. Fix them by filling in a general ledger. I’m just picking one and save it. So one down, three to go. If it’s a gift, that’s a pledge payment, make sure that it is fixed on the pledge. So you’ll continue to get gifts without a general ledger in this case, if the pledge didn’t have a general ledger. Okay, beautiful. So this is one example of a report that you might want to run at the end of every month to be on top of anything that’s got blanks in the general ledger. And another report that could do that is the cross tabulation.
If the two
most frequently used fields on your gift screen or general ledger and solicitation, fantastic, also make sure we start out with clear values. And any date range will work. I’m looking at my fiscal year here. Okay, notice this column. This is the blank solicitations my solicitations are along the top or my columns and other words. So I’ve got some things for things to clean up in terms of blank solicitations. In terms of my rows. These are my general Ledger’s that are showing along the left, and I have some blank. General Ledger’s where is it? Let’s see All the way over well, wow, well, the total of five, and I need to clean them up, okay. But also looking at this, you might say, Hmm, the money from the black tie blue jeans event should only go to unrestricted or annual fun. But if there’s something black tie blue jeans event and it went to membership, or something else, you might say, I think we have to fix it. So that’s why looking at a report like this, to show you the combinations, you can say, yep, that’s probably a data entry issue that we need to correct. And you can drill down and fix them right here. All right. And our last report in this category is our gift pledge. Now, if you type gift, slash, it’s the only report that has a gift word and then the slash immediately after it.
do not have any pledges at all, not as helpful. But if you have pledges, especially let’s say, from a capital campaign, where you have donors who pledged 1000, or 10,000, or 25,000, and you have those fixed pledges, then this is really helpful. So you can look at any date range, let’s say, Okay, let’s look at the activity in terms of gifts were pledges made in this current fiscal year, if you want to group by General Ledger, great, maybe you want to look at the camp per campaign, if you use that
this report is a little different. In its setup, or output here, notice the arrows to get to the next page or the last page. Or you could type in here a particular donors name or a particular campaign if you wanted to find it. But what it has, let’s see what we got here, we have one time gifts, meaning that these are the gifts not connected to a pledge. Here, though, is from Erica and Steven, a pledge made of $500. Therefore, under some accounting principles, they might count this as income, we could say that the income from the atoms is I’m sorry, I take that back. The total fundraise is only 150. If we’re looking at a cash basis, on an accrual basis, one would say that it’s 500 plus 150. But then this shows if there were any pledge payments made, and the balance do. You might say, wait a second, Eileen, it shows a pledge total. But it chose a balance to a 400. That would lead me to believe that there was a pledge payment outside of this period. All right. But very helpful to look at pledges, and pledge payments and non pledge payments. Especially if you have a capital campaign, and you could filter this report to say you’re only looking for the capital campaign, for instance. All right, our next category is giving trends. Beautiful. Raise your hand if you’re familiar with the light bulb or sideband. Term or acronym. Have any of you come across that before? Okay, back. Yes. Great. Great. Excellent. Excellent. All right. So this acronym is spelled out for you last year, but and the EU, if it’s used, has been used in some places as but unfortunately not this year. This is a list of donors who gave last fiscal year but not this fiscal year. This is donors who have given it some time in the past, but not the current fiscal year. Okay. We want to look at trends. How much money comes in each month, over how many years looks at the average amount. This can show you kind of the seasonality of your giving And Todd are one of my two favorite reports in the financial reports, I would share with you that this is one of the reports if you had not yet ever run, this will be your best friend, the gift comparison by time period. Again, it’s using segments because it allows us to create or show subtotals per something on the report. But I love this report because I can tweak it or twist it into so many different stories, because I can look at the weekly trend, monthly, quarterly, or excuse me, and know trend over several years. And I can subtotal based on donor type or based on campaign or based on the gift type, et cetera. All right, so let’s check these out.
If I couldn’t Lydd or you need a three characters to find a report, and yes, here’s my live bunt. Now, this is hard coded to say they gave last fiscal year but not this fiscal year, should you need this in October, November, for calendar year, then we do have a saved filter. That is the live bucket filter on a calendar basis. I’m not going to put in anything on my sidebar just to run it to show you what it looks like. So these are the donors who have a gift or their total giving last fiscal year was more than zero. Okay, in alphabetical order. So if you would like to get a gift before your fiscal year ends, if your fiscal year ends June 30, and you maybe want to send an appeal out in May, then this would be the group that would get that appeal. All right. And very similar to that. But there is a little catch to it. The s YB the some year but not this and just run it. Now, if your database or your records only go back a few years, not a problem. But for some of you if your organization has decades of records in terms of gifts, I’m going to suggest that this is one report that will be significantly better. If you use a filter, such as on the main screen, last gift date is between and I’m going to throw out maybe one 120 18 through 1231 2020. Because without this filter, you might have deceased donors, you might have severely lapsed donors, meaning the last time they gave was 15 years ago, et cetera. So try and use some filter, this would be an example. It’s not the only thing. Okay, that narrows it down they given in the past, maybe not last year, but they gave two or three or four years ago. So I’m trying to get some mid range in terms of recency. Okay, all right, that is your some year but not this fiscal year. And this is as we continue on our journey to look at the inventory of financial reports. Donations by month and year. I would say the most number of years you want is five could you go beyond and do seven? Yes, it just might be a little bit challenging on the ice. I’m going to recommend. This was my previous filter that I used in the last report. So in this case, there’s no filter name, but this tells me there is a filter at For every filter in memory, so we’re going to remove it by clicking on the circle. Great. And again, always make sure you clear values. Do you want to see five fiscal or five calendar? Your choice on the report? Okay, so here’s my 8019 fiscal year at cetera, et cetera, and getting ready for the approach of the next fiscal year. Okay, so you could see if we did seven years, or more than that, it might be really hard to read. But this report, you could put in Excel, and either use formulas to sum up by quarters, for instance, or hide columns, but I’m just giving you an idea. So what it does is, presents the number of gifts in that specific month, so July of 18, that total dollars from those gifts, and therefore gives you the average amount. So you can look and see. And you might say, well, the number of gifts is higher, but and the average Wow, increased 100%. So you could make certain analyses and I would expect that December would be higher for most of you. Okay, and last but not least in this category
the gift comparison by time period, this will be pre selected as a favorite for a reason.
What is the total in the summary the total for all five years? Yes, sorry, I didn’t point it out. But at the bottom of that report, it would be the grand total. So if you all you need from that report, if all you need is the total dollars, the total number of gifts and the average gifts, then that is one way to get those three statistics you got it, Rachel. Okay, gift comparison by time period. For those of you who want to win, I would encourage you to reconcile your DonorPerfect to the accounting system, you’re on going to uncheck this to remove that temporary filter. This I recommend you do to look at the monthly revenue for the current fiscal year, in my case, by General Ledger, put this on the screen for now. Beautiful, your totals per month, hopefully agreed to what’s in accounting, then again, that’s why you’re going to have a discussion to reconcile each month. And then within each month, you want to reconcile the minimum, these line items reconcile the different income accounts. As we saw earlier, if there’s something that’s either blank, or it says no code here on the top row, that is what you want to chase down and clean up the gifts by identifying what is the general ledger or a reasonable guess that okay, we’re going to put this in and you will find for instance. Right, and I think I just came off of that report. So let’s go back in
all right. So this is fantastic. I can use it by General Ledger. Maybe somebody wants to look at the responses per appeal or event. So you can segment by the solicitation whether it’s weekly, monthly, quarterly, or one lump sum for the year. Now speaking of year, this is where I love this report. I don’t want to go too far in the past but maybe in the last few years and probably not using solicitation if you use campaign or maybe by the donor tight
on the main screen
okay, so this can give you trends is your corporate giving Hmm, what can what’s going on with the corporate giving? Maybe you’re gonna say your golf outing hasn’t happened. And that’s what drives most of this money in terms of corporate sponsorships, foundations, while maybe we got a tremendously large brand last year, so they would have an explanation. And then individuals, how are we doing in terms of the bulk of your fundraising, which is going to be from individuals in most cases, right? So pretty sweet. If you also want to do this, this is kind of interesting. For those of you who have donors outside of the state where your office is based. I can use the state field here not on the gift screen, but the DEP state. Okay, lots of rows here, right, at least 50? If not even the provinces? If you click on the some column twice? Uh huh. Pennsylvania, no surprise, because we are in Pennsylvania. But then I had my neighboring states of Delaware, New York, etc. are what do you know, California is number four. Pretty sweet. Okay, really nice. And a question came up? Where do you set the date or confirm? So everybody system was created or shipped with something in your fiscal year. And that’s set in settings parameters. And when you land on general parameters here, this means the seventh month, or in this case, July is the first month of your fiscal year. So that’s a place to confirm or change a fiscal year, should it change? Not too often. But that does happen. All right. And are you are very welcome. In our final set of reports, how are we doing? Well, my first most favorite report is this one, but comprehensive donor revenue analysis. And then similar to what is the Association of Fundraising Professionals, if any of you are or your directors are members of AFP, then they will be familiar with this report or at least understand where it came from. They are similar of the two this one has more statistics. It also allows you to look at three years, whereas the AFP report is two years at a time. What AFP does is it looks at internet in in tax and get the words out individual donors versus all other types of organizations lump together, and then everyone or every entity combined. Whereas comprehensive donor looks at every entity, it doesn’t make that distinction of individual versus organizations. But this has more things to I’ll say, reveal, explore or explain. So let’s look at these two reports. All right, reports Report Center. Let’s start out with AFP. Association of Fundraising Professionals.
Click on that.
If you want to leave it on today’s date, fine, if you want to kind of fast forward to the end of the quarter. First quarter of 2023 is about to end Wow.
Okay, so this looks at 12 months or four quarters in my case of data versus the same period, the prior year. Okay. And it looks at individuals versus organizations and puts them all together in one pot, the largest gift, etc. These I think are going to be clear, but if the terminology is not clear, simply look in the knowledge base and put in AFP key donor metrics, and it will explain so right It’s got red and green. Red is usually not good. Green would be good in terms of the revenue from donors who upgraded has increased almost 54% All right. While that is great But I personally, am very, very fond of something that’s also going to be a favorite, your comprehensive donor revenue analysis. Okay. When you want to find your retention rate, yes, it’s on the dashboard. But this is used when you want to know the retention rate. And it’s not necessarily today. So what you might want to do is go back in time, oops, this will be backwards. Again, I’m not going to use a doctor for now and put it on the screen to say, Okay, give me three calendar years 2022 2021 and 2020. These are your statistics. Cool, we did not have a good year, the number of active donors who gave in that year, only 203, anything that is blue, and you can see my cursor turned into a hand means it’s a hyperlink, to drill down and see who goes in this case retained donors
Active donors, meaning donors who gave in that period, and all the related statistics, retained donors, donors who gave this year and last year. Keep in mind, we are not doing well at all. The retention or at least average for us nonprofits is 43%. Something’s wrong with our picture here. Right? We need to step up or efforts maybe we’ve been without a development director for a long time. Maybe that development director just came on board in February, new donors, that should be clear, reactivated what does that mean? If you hover over and non bolded row, it gives you the definition here of donors who gave two or more years ago, didn’t give in this previous year, but came back this year. We need to recapture more donors, right. And the attrition rate is in brass is simplified that the rate at which you’re losing donors, not good. We are essentially losing three out of four donors that we get. attrition is what I call the flip side of retention. Wow, wow, wow. All right. So hopefully, you found something at least one report that you never encountered before. And then I’m sorry, the organization dashboard. So let me do a quick look at the organization dashboard. So you have three dashboards. And I’m going to say the organization dashboard is another area full of information, where you can set the goal for all monies to be raised. These statistics, all of these are explained in the knowledge base when you search organization dashboard, and here is an O our retention rate fell off. And that might be when our development director left us.
so therefore, I’m going to go right to my recap slide. So financial reports, it’s not only for the accounting person, they allow you to view your fundraising performance. They can show you past performance and trends to help you make decisions and make concerted strategic actions for the future. And of everything we showed you, maybe everything doesn’t apply to you. But hopefully, if a couple caught your eye, great. Identify them in your database, make them your favorites. And we hope you’ll be thrilled with the ability to pull the information in DonorPerfect. So I want to thank you. It’s been my pleasure having you today in our webinar, and we may have a question or two so I’ll take them for a brief few minutes. Otherwise, thank you so much, everybody have a wonderful afternoon and evening and I look for noticing you went upcoming webinar.
You are very, very welcome.
Thank you, everybody.Read Less