• Replies 13 replies
  • Subscribers 417 subscribers
  • Views 185 views
  • Users 0 members are here
Related

Pledge payment reporting help needed

Alaina Smith
$organization

Normal 0 false false false MicrosoftInternetExplorer4

Hello. I’m new to Tessitura, only in my second month, and have encountered a reporting problem I’m not sure how to solve.

 

I have been using the “pledge gift” report to get information on who gave how much on what date. Last month this worked fine, but now that I have pledge payments in their second month, I realize that the report will not pull pledge payments received. (For example, if someone makes a $60 pledge in July and pays $10 of it, that shows on the July report. When they pay another $10 in August, I don’t see it on the August report because Tessitura counts it as a July transaction—when in fact that second $10 payment arrived in August.)

 

This is unacceptable for our financial reporting because I need to know the “who/how much/what date” for every gift, regardless of whether it’s part of a pledge. It’s also important that the report pull the date the payment was made (not the “transaction date,” i.e., whatever day I’m working in the computer, and not a posting date).

 

I would appreciate hearing how other people get around this problem. If you have created a custom report, would you be willing to share code that I could pass on to one of our more IT-knowledgeable staff? Any advice or guidance would be appreciated. Thanks!

Parents
  • $organization

    You might want to try using the New Contribution (though this is just another view of Pledge Gift)  - I consider the bible the Fund Activity report.  It shows when the gift was entered in the system so pulls by transaction date – (this is when we consider the payment or gift is made).    The Pledge Gift and New Contribution reports are pulling from contribution date and are why they do not show payments.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Alaina Smith
    Sent: Tuesday, August 31, 2010 4:11 PM
    To: McKinley, Leslie
    Subject: [Tessitura Development Forum] Pledge payment reporting help needed

     

    Normal 0 false false false MicrosoftInternetExplorer4

    Hello. I’m new to Tessitura, only in my second month, and have encountered a reporting problem I’m not sure how to solve.

     

    I have been using the “pledge gift” report to get information on who gave how much on what date. Last month this worked fine, but now that I have pledge payments in their second month, I realize that the report will not pull pledge payments received. (For example, if someone makes a $60 pledge in July and pays $10 of it, that shows on the July report. When they pay another $10 in August, I don’t see it on the August report because Tessitura counts it as a July transaction—when in fact that second $10 payment arrived in August.)

     

    This is unacceptable for our financial reporting because I need to know the “who/how much/what date” for every gift, regardless of whether it’s part of a pledge. It’s also important that the report pull the date the payment was made (not the “transaction date,” i.e., whatever day I’m working in the computer, and not a posting date).

     

    I would appreciate hearing how other people get around this problem. If you have created a custom report, would you be willing to share code that I could pass on to one of our more IT-knowledgeable staff? Any advice or guidance would be appreciated. Thanks!




    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 Leslie McKinley

    Alaina,

    I don't think the New Contributions report will work for your situation since it doesn't show pledge payments.  It only shows new pledges and new gifts.

    Dale

  • $organization in reply to Dale Aucoin

    Thanks both to Leslie and Dale.

    The fund activity report may have potential, but if it pulls on transaction date, then that's a concern because for us, transaction date (date working in computer) is not necessarily gift date. (In fact, the gift date received is more often than not a different date from today's date.)

    Say a pledge payment comes in during summer for a pledge made in January. The check for the pledge payment is deposited to the bank on 7/31. The data entry occurs on 8/1. While doing data entry, we consider the gift date to be 7/31 (date of deposit). So, the "contribution date" is 7/31 and the "transaction date" is 8/1. Since the fund activity report only pulls transaction dates, it would a sweep for certain contribution dates.  I'm wondering how to capture "contribution dates" even though I know Tessitura's technical definition for "contribution" doesn't include pledge payments.

    How would I find the above-style transaction? Thanks again!

Reply
  • $organization in reply to Dale Aucoin

    Thanks both to Leslie and Dale.

    The fund activity report may have potential, but if it pulls on transaction date, then that's a concern because for us, transaction date (date working in computer) is not necessarily gift date. (In fact, the gift date received is more often than not a different date from today's date.)

    Say a pledge payment comes in during summer for a pledge made in January. The check for the pledge payment is deposited to the bank on 7/31. The data entry occurs on 8/1. While doing data entry, we consider the gift date to be 7/31 (date of deposit). So, the "contribution date" is 7/31 and the "transaction date" is 8/1. Since the fund activity report only pulls transaction dates, it would a sweep for certain contribution dates.  I'm wondering how to capture "contribution dates" even though I know Tessitura's technical definition for "contribution" doesn't include pledge payments.

    How would I find the above-style transaction? Thanks again!

Children
  • $organization in reply to Alaina Smith

    Alaina,

    The only way I can think of doing what you want to do is to add a custom data element in Contributions for "deposit date" although I'm not sure how you would do that for multiple pledge payments.  Actually, I don't think that would work, it would be way too crazy, scratch that!

    In Tessitura there are really only 2 dates associated with a gift/pledge - contribution date which you can alter when you entering a gift or a pledge, and transaction date which is system generated.  When you make a pledge payment, you cannot change the transaction date, the date you process the payment is the transaction date and there is no gift date associated with a pledge payment, the gift date is associated to the pledge.

    Dale