[Bonnie Alkire]

This past week I was hit with a request to provide the dollar amount of "new money" for this FY. I needed to have this info within a couple of hours, and I found that RE really doesn't have a report that provides this information! The Blackbaud website>Knowledgbase suggests the Campaign Progress report for this, but it only provides a list by constituency. It's really difficult to know if the total is correct, because there are no reports to compare it to!

Sooooo, to all my guru friends out in RE-Land, how do you go about getting this figure? Maybe there's a report somewhere that I haven't found that will do this, or perhaps, some of you might be able to provide a formula that can be used. Thanks for any and all help!

[Don Sabo]

Bonnie: What do you mean by new money? If you are interested in gifts given in this calendar year then create a query and use the Date Added field as a qualifier. If you are interested in new constituents this calendar year then create a query and use Date Added field under the Constituent Information as a qualifier.

[Bonnie Alkire]

Hi, Don and thanks. By new money (it seems to be buzz word for the decade at D&E), I mean pledges and gifts that are not connected to pledges from prior fiscal years. IOW, if someone made a pledge 2 years ago for $20,000 and sets up $5,000 installments to be paid annually, the installments paid this FY are not new money. In essence, I need to eliminate payments applied to previous years pledges. I was under such pressure on Thurs, I couldn't even think thru this!

[Jo Ward]

Bonnie,

In the Gift Detail and Summary report, you can choose your gift types and dates. If you choose the gifts types of cash, stock, and pledges (also MG pledges if you count them) and date this fiscal year it should give you what you want. Caution: When choosing Pledges as gift type, in this case, you want to take off the check beside Use gift balannce instead of gift amount.

Since your gift date is this FY, it will not pick up any old pledges, and since you are not picking any pay-* gifts, you won't pick up payments on old pledges. Since you aren't looking at thee pledge balance, you'll get the full amount of pledges for the FY, so you don't have to worry about pledge payments received on the new pledges either.

Hope I understood your question and that this helps.

Jo

[Bonnie Alkire]

I think we are the same wave length, but, I need to include pay-cash, because we have pledges this FY, too. Could it be that I should use one of those boxes for "Calculate balance based on, etc...."? I am coming up with a way to get to the figues, but, so far, it's a query and three reports!!

[Jo Ward]

Bonnie,

Your pledges for this FY will be picked up as pledges in the full amount of the pledge if you uncheck the box for using pledge balance instead of pledge payment. So if you have, say, a $5,000 pledge and someone makes a $1,000 pledge payment for it in the same year, this method will show $5,000 in "new money". It will all come from the pledge, rather than from the pledge with its reduced balance plus the pledge payment.

Jo

[Bonnie Alkire]

Jo,
What you are saying is correct, but, my problem is that I have to eliminate any payments that are made this FY that apply to pledges from last fiscal. I've got the pledge and pledge balance counting down pat, but the trustees want to see the total "new money" - gifts that have come in this FY that has been applied to old pledges.

[Jo Ward]

Bonnie,

I'm missing something, I guess. If you don't choose pay-cash (or pay-*) as a gift type at all, you won't be getting ANY pledge payments - not for this year or for prior years. By pulling the FULL AMOUNT of the pledges for this year, you are getting ALL of the new money (both pledges and payments toward THOSE pledges) that has come in this year. What am I missing?

Jo

[Bonnie Alkire]

I know you are trying and I certainly appreciate it; however, I do have the current totals, cash, pledges and balances down pat - so, to further explain: Here's a scenario. We have current fiscal year total of all commitments (as listed above) of !00,000. Part of that is a $5,000 payment on a pledge that was made two years ago, so the $5,000 gift is not considered new money - because it is connected to an old pledge. When counting new money, then the total is reduced to $95,000. There really should be a report for this because the "new money" concept is the basis for a lot of fund-raising goals these days. Thanks for any further suggestions!!

[Bonnie Alkire]

Oops - to further complicate, I made a typo - It's supposed to be $100,000 > $5,000 is old money > $95,000 is new money.

[Bonnie Scarborough]

For future reference: one way to eliminate the problem is to use the campaign field to indicate the year in which the gift was "new". If you entered an multi-year pledge in 2006 and add a campaign that reflects that, e.g. 2006 Capital Campaign, then all the payments will automatically carry that campaign information. If you then add 2007 Capital Campaign to all new gifts in 2007, you can run a financial report with a filter for that campaign year and pick up only "new" money for the year for which you filtered. It will also allow you to see how much has come in on pledges from prior years, if you filter by the campaigns for those prior years,and run a summary report by campaign using current year dates.

[Bonnie Alkire]

I had to see it to believe it! Thanks to Jo for staying with me until I "got it"!! The numbers are close - very, very close, so I'm going with her suggestion!