• 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,

     

    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!

  • $organization in reply to T.C. Brown
    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
Reply
  • $organization in reply to T.C. Brown
    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
Children
No Data