Reporting on Board Giving

I'm trying to find what our Board giving was for any given fiscal year.  The campaign doesn't matter.  It could be a sponsorship, subscription add-on contribution, gala ticket purchase, or annual gift.

I've created lists showing anyone who might have been on the board during the time frame of the season.

What report will tell me this? 

The Donor FY Giving Summary works great BUT doesn't give anything to me before the 2005-2006 season.  (Bummer!)

The Fund Activity report gives me the lifetime giving for the list.

Other ideas?

Thank you,

Chris

Parents
  • The original name of the “Current Constituent Giving by List” report was named simply “Board Giving Report”.  It was designed to report what you are requesting.  It’s under the Development category.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christopher Zello
    Sent: Wednesday, March 24, 2010 1:07 PM
    To: Ryan Creps
    Subject: [Tessitura Development Forum] Reporting on Board Giving

     

    I'm trying to find what our Board giving was for any given fiscal year.  The campaign doesn't matter.  It could be a sponsorship, subscription add-on contribution, gala ticket purchase, or annual gift.

    I've created lists showing anyone who might have been on the board during the time frame of the season.

    What report will tell me this? 

    The Donor FY Giving Summary works great BUT doesn't give anything to me before the 2005-2006 season.  (Bummer!)

    The Fund Activity report gives me the lifetime giving for the list.

    Other ideas?

    Thank you,

    Chris




    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 looked that over yesterday and the other one suggested on the list.

     

    The report is quite clumsy, if I may be frank, for my purpose.  I have to pick a start date, but have no control over the campaign or end date.  It is definitely date oriented.

     

    The Pledge Gift report is better, but is limited by the fact that I can only choose ONE campaign.  Since we have board members that might choose to different projects in a given year as well as their annual gift, I’ll have to run this report several times to get the total of the giving during any one given season.

     

    I’m close, at least,

    Chris

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Thursday, March 25, 2010 10:55 AM
    To: czello@florentineopera.org
    Subject: RE: [Tessitura Development Forum] Reporting on Board Giving

     

    The original name of the “Current Constituent Giving by List” report was named simply “Board Giving Report”.  It was designed to report what you are requesting.  It’s under the Development category.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christopher Zello
    Sent: Wednesday, March 24, 2010 1:07 PM
    To: Ryan Creps
    Subject: [Tessitura Development Forum] Reporting on Board Giving

     

    I'm trying to find what our Board giving was for any given fiscal year.  The campaign doesn't matter.  It could be a sponsorship, subscription add-on contribution, gala ticket purchase, or annual gift.

    I've created lists showing anyone who might have been on the board during the time frame of the season.

    What report will tell me this? 

    The Donor FY Giving Summary works great BUT doesn't give anything to me before the 2005-2006 season.  (Bummer!)

    The Fund Activity report gives me the lifetime giving for the list.

    Other ideas?

    Thank you,

    Chris




    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!

  • If the Donor FY Giving report only goes back to '05, check the table TR_BATCH_PERIOD - you may need to add some rows that refer to dates prior to 2005. 

    This report looks to this table to identify what gifts should fall into which fiscal years. 

    If the table overwhelms you - click the question mark/help system button. There is a document on System Tables and this will help you understand how to set this one up particular.

  • FYI with the pledge gift report you can leave the Campaign parameter blank and it will select all campaigns.

    Dale

  • Thank you!  I’ve passed the page of documentation to Michelle here to add the additional rows to the System Table.  I’ll be up and running in no time.

     

    Chris

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Barnett
    Sent: Thursday, March 25, 2010 11:25 AM
    To: czello@florentineopera.org
    Subject: Re: [Tessitura Development Forum] RE: Reporting on Board Giving

     

    If the Donor FY Giving report only goes back to '05, check the table TR_BATCH_PERIOD - you may need to add some rows that refer to dates prior to 2005. 

    This report looks to this table to identify what gifts should fall into which fiscal years. 

    If the table overwhelms you - click the question mark/help system button. There is a document on System Tables and this will help you understand how to set this one up particular.

    From: Christopher Zello <bounce-chriszello1793@tessituranetwork.com>
    Sent: 3/25/2010 11:21:11 AM

    I looked that over yesterday and the other one suggested on the list.

     

    The report is quite clumsy, if I may be frank, for my purpose.  I have to pick a start date, but have no control over the campaign or end date.  It is definitely date oriented.

     

    The Pledge Gift report is better, but is limited by the fact that I can only choose ONE campaign.  Since we have board members that might choose to different projects in a given year as well as their annual gift, I’ll have to run this report several times to get the total of the giving during any one given season.

     

    I’m close, at least,

    Chris

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Thursday, March 25, 2010 10:55 AM
    To: czello@florentineopera.org
    Subject: RE: [Tessitura Development Forum] Reporting on Board Giving

     

    The original name of the “Current Constituent Giving by List” report was named simply “Board Giving Report”.  It was designed to report what you are requesting.  It’s under the Development category.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christopher Zello
    Sent: Wednesday, March 24, 2010 1:07 PM
    To: Ryan Creps
    Subject: [Tessitura Development Forum] Reporting on Board Giving

     

    I'm trying to find what our Board giving was for any given fiscal year.  The campaign doesn't matter.  It could be a sponsorship, subscription add-on contribution, gala ticket purchase, or annual gift.

    I've created lists showing anyone who might have been on the board during the time frame of the season.

    What report will tell me this? 

    The Donor FY Giving Summary works great BUT doesn't give anything to me before the 2005-2006 season.  (Bummer!)

    The Fund Activity report gives me the lifetime giving for the list.

    Other ideas?

    Thank you,

    Chris




    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!




    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
  • Thank you!  I’ve passed the page of documentation to Michelle here to add the additional rows to the System Table.  I’ll be up and running in no time.

     

    Chris

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Barnett
    Sent: Thursday, March 25, 2010 11:25 AM
    To: czello@florentineopera.org
    Subject: Re: [Tessitura Development Forum] RE: Reporting on Board Giving

     

    If the Donor FY Giving report only goes back to '05, check the table TR_BATCH_PERIOD - you may need to add some rows that refer to dates prior to 2005. 

    This report looks to this table to identify what gifts should fall into which fiscal years. 

    If the table overwhelms you - click the question mark/help system button. There is a document on System Tables and this will help you understand how to set this one up particular.

    From: Christopher Zello <bounce-chriszello1793@tessituranetwork.com>
    Sent: 3/25/2010 11:21:11 AM

    I looked that over yesterday and the other one suggested on the list.

     

    The report is quite clumsy, if I may be frank, for my purpose.  I have to pick a start date, but have no control over the campaign or end date.  It is definitely date oriented.

     

    The Pledge Gift report is better, but is limited by the fact that I can only choose ONE campaign.  Since we have board members that might choose to different projects in a given year as well as their annual gift, I’ll have to run this report several times to get the total of the giving during any one given season.

     

    I’m close, at least,

    Chris

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Thursday, March 25, 2010 10:55 AM
    To: czello@florentineopera.org
    Subject: RE: [Tessitura Development Forum] Reporting on Board Giving

     

    The original name of the “Current Constituent Giving by List” report was named simply “Board Giving Report”.  It was designed to report what you are requesting.  It’s under the Development category.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Christopher Zello
    Sent: Wednesday, March 24, 2010 1:07 PM
    To: Ryan Creps
    Subject: [Tessitura Development Forum] Reporting on Board Giving

     

    I'm trying to find what our Board giving was for any given fiscal year.  The campaign doesn't matter.  It could be a sponsorship, subscription add-on contribution, gala ticket purchase, or annual gift.

    I've created lists showing anyone who might have been on the board during the time frame of the season.

    What report will tell me this? 

    The Donor FY Giving Summary works great BUT doesn't give anything to me before the 2005-2006 season.  (Bummer!)

    The Fund Activity report gives me the lifetime giving for the list.

    Other ideas?

    Thank you,

    Chris




    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!




    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