I have discovered an issue with reporting our multi-year pledges in regards to the contribution date that was automatically applied when the pledges were processed. We have hundreds of multi-year pledges that all hold the same contribution date as the date the pledges were entered. For instance John Smith on 3/1/2009 pledged $10,000 for the next three years. All three pledges were processed to the future campaigns but the contribution dates for all three remained as 3/1/2009. When the future pledge payments begin to come in the contribution dates remain the same as the original date the pledge was created.
I would like to know if any organizations adjust the contribution dates to the future year so when running reports by contribution date these pledges will show up in the correct campaign year? If you do adjust the contribution date do you do it when processing the original pledge or when the pledge is paid?
Hi Terry,
We keep the original pledge date and book the future funds to the applicable fiscal years. Many of our reports have been altered to run based on either the fiscal year campaign or transaction date to allow us to report on pledge payments. I agree with Leslie in that you probably don’t want to change the contribution date as that is one of the only unifying factors to indicate that this is a multi-year pledge, or payments belonging to the same pledge.
Good luck!
Amber
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens Sent: Thursday, January 06, 2011 7:07 AM To: Albert, Amber Subject: [Tessitura Development Forum] Multi Year Pledges
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
_______________________________________________________________________
I also agree with the others that it is probably best to retain the original contribution date.Once you start doing multi-year pledges you quickly learn that contribution date is pretty much useless in reporting and list building, but it is possible to survive without it. There are a lot of reports out there that offer additional criteria to contribution date that will help you get the information you need, but if you are dealing with hundreds you may also want to do as Amber's Org. does and alter some reports to make life a little easier. Just be sure to leave the contribution date open ended if it is available as a criteria option on a report.
Cheers!