• Replies 12 replies
  • Subscribers 414 subscribers
  • Views 165 views
  • Users 0 members are here
Related

Fund Activity Report & Pledges

Phil Petch
$organization
As most of us are aware Fund Activity Report is the holy grail for all things donations reporting. This year, I am reporting donations activity based on contribution dates, not transaction dates as in years past. This is fine. EXCEPT that pledges negatively impact the accuracy of the report. This is because the Fund Activity Report recognises all of the instalment payments within the payment schedule that have been transacted to date attributing them to the overall contribution date of the pledge, not their individual transaction dates, which could be in separate months / quarters etc. Utilising both transaction date & contribution date when running this report would have further impact particularly based around EFT gifts where the transaction date and contribution date are very rarely one and the same. Has anyone encountered this problem, and how have you overcome it? Please note that I cannot extract and manipulate the Fund Activity Report in a program like excel to achieve my desired outcome - it's all about maintaining the report's integrity - and I cannot go back to utilising transaction date as the sole parameter for reporting donations activity, it must be contribution date - but pledges are making my work life very challenging at the moment. Thanks, Phil (also, I had this typed up in paragraphs, but upon posting the message board has clumped my query together in one hideous block of text. Sorry for having to navigate one hideous block of text).


[edited by: Phil Petch at 8:48 PM (GMT -6) on 31 Jan 2017]
Parents
  • $organization

    Hi Phil,

     

    I guess it depends on your business practices.  We post pledges, gifts and payments to the day they were received, not the day they were entered.  We often enter a contribution/payment after the day it was received.  Here is an example that I have with running the report.

     

    I have a pledge of $50 received Nov. 30, but it was entered on Dec. 2 and a payment of $30 toward the pledge received Dec. 27, but entered on Dec. 29, and we posted the pledge to Nov. 30 and payment to Dec. 27.

     

    Contribution date is Nov. 30

    Transaction date1 is Dec. 2

    Transaction date2 is Dec. 29

    Posting date1 is Nov. 30

    Posting date2 is Dec. 27.

     

    When I run the report using only Contribution Dates for month of Nov., the $50 pledge and the $30 payment pull into the report.

    When I run the report using only Transaction Dates for month of Nov., this contribution doesn't pull

    When I run the report using only Posting Dates for month of Nov., the pledge appears, but no payments.

     

    Likewise if I run the report for dates for month of Dec. I get the following:

    Contribution Dates, nothing pulls for this contribution in the report.

    Transaction Dates the $50 pledge and the $30 payment pull into the report.

    Posting Dates only the $30 payment pulls into the report.

     

    So if I am looking for what actually came into our organization for any period, I can easily find it by using posting date instead of any of the other dates.

    Hope that clarifies.

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Phil Petch
    Sent: Wednesday, February 01, 2017 7:43 PM
    To: TC Brown <TBrown@pittsburghsymphony.org>
    Subject: RE: [Tessitura Development Forum] Fund Activity Report & Pledges

     

    Hi T.C., thanks for you response. I've obviously misunderstood what you've said because what you've described is exactly the outcome you get when using transaction date as your report criteria. What does using posting date as your parameter do differently / exclude / include that transaction date doesn't? Cheers, Phil

    From: T.C. Brown <bounce-tcbrown4438@tessituranetwork.com>
    Sent: 2/1/2017 9:23:03 PM

    Hi Phil,

     

    We post everything to the date that the cash/pledge comes in.  So if I run the Fund Activity report and use posting date for the parameters, I only see what came in during that date period, as opposed to contribution date that can pull in payments on pledges that fall outside of the dates.

     

    Hope that helps.

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Phil Petch
    Sent: Tuesday, January 31, 2017 8:45 PM
    To: TC Brown <TBrown@pittsburghsymphony.org>
    Subject: [Tessitura Development Forum] Fund Activity Report & Pledges

     

    Dear All, I work in Development, and as most of us are aware Fund Activity Report is the holy grail for all things donations reporting. This year, I am reporting donations activity based on contribution dates, not transaction dates as in years past. This is fine. EXCEPT that pledges negatively impact the accuracy of the report. This is because the Fund Activity Report recognises all of the instalment payments within the payment schedule that have been transacted to date attributing them to the overall contribution date of the pledge, not their individual transaction dates, which could be in separate months / quarters etc. Utilising both transaction date & contribution date when running this report would have further impact particularly based around EFT gifts where the transaction date and contribution date are very rarely one and the same. Has anyone encountered this problem, and how have you overcome it? Please note that I cannot extract and manipulate the Fund Activity Report in a program like excel to achieve my desired outcome - it's all about maintaining the report's integrity - and I cannot go back to utilising transaction date as the sole parameter for reporting donations activity, it must be contribution date - but pledges are making my work life very challenging at the moment. Thanks, Phil




    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!




    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!

Reply
  • $organization

    Hi Phil,

     

    I guess it depends on your business practices.  We post pledges, gifts and payments to the day they were received, not the day they were entered.  We often enter a contribution/payment after the day it was received.  Here is an example that I have with running the report.

     

    I have a pledge of $50 received Nov. 30, but it was entered on Dec. 2 and a payment of $30 toward the pledge received Dec. 27, but entered on Dec. 29, and we posted the pledge to Nov. 30 and payment to Dec. 27.

     

    Contribution date is Nov. 30

    Transaction date1 is Dec. 2

    Transaction date2 is Dec. 29

    Posting date1 is Nov. 30

    Posting date2 is Dec. 27.

     

    When I run the report using only Contribution Dates for month of Nov., the $50 pledge and the $30 payment pull into the report.

    When I run the report using only Transaction Dates for month of Nov., this contribution doesn't pull

    When I run the report using only Posting Dates for month of Nov., the pledge appears, but no payments.

     

    Likewise if I run the report for dates for month of Dec. I get the following:

    Contribution Dates, nothing pulls for this contribution in the report.

    Transaction Dates the $50 pledge and the $30 payment pull into the report.

    Posting Dates only the $30 payment pulls into the report.

     

    So if I am looking for what actually came into our organization for any period, I can easily find it by using posting date instead of any of the other dates.

    Hope that clarifies.

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Phil Petch
    Sent: Wednesday, February 01, 2017 7:43 PM
    To: TC Brown <TBrown@pittsburghsymphony.org>
    Subject: RE: [Tessitura Development Forum] Fund Activity Report & Pledges

     

    Hi T.C., thanks for you response. I've obviously misunderstood what you've said because what you've described is exactly the outcome you get when using transaction date as your report criteria. What does using posting date as your parameter do differently / exclude / include that transaction date doesn't? Cheers, Phil

    From: T.C. Brown <bounce-tcbrown4438@tessituranetwork.com>
    Sent: 2/1/2017 9:23:03 PM

    Hi Phil,

     

    We post everything to the date that the cash/pledge comes in.  So if I run the Fund Activity report and use posting date for the parameters, I only see what came in during that date period, as opposed to contribution date that can pull in payments on pledges that fall outside of the dates.

     

    Hope that helps.

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Phil Petch
    Sent: Tuesday, January 31, 2017 8:45 PM
    To: TC Brown <TBrown@pittsburghsymphony.org>
    Subject: [Tessitura Development Forum] Fund Activity Report & Pledges

     

    Dear All, I work in Development, and as most of us are aware Fund Activity Report is the holy grail for all things donations reporting. This year, I am reporting donations activity based on contribution dates, not transaction dates as in years past. This is fine. EXCEPT that pledges negatively impact the accuracy of the report. This is because the Fund Activity Report recognises all of the instalment payments within the payment schedule that have been transacted to date attributing them to the overall contribution date of the pledge, not their individual transaction dates, which could be in separate months / quarters etc. Utilising both transaction date & contribution date when running this report would have further impact particularly based around EFT gifts where the transaction date and contribution date are very rarely one and the same. Has anyone encountered this problem, and how have you overcome it? Please note that I cannot extract and manipulate the Fund Activity Report in a program like excel to achieve my desired outcome - it's all about maintaining the report's integrity - and I cannot go back to utilising transaction date as the sole parameter for reporting donations activity, it must be contribution date - but pledges are making my work life very challenging at the moment. Thanks, Phil




    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!




    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!

Children
No Data