How many funds do you have?

Currently, we have about 15 funds ("Individual General," "Individual Capital," "Foundation General," "Foundation Capital," "Gala ticket purchase," "Gala donation," etc.).  We organized the funds based on our GL accounts to make the translation from Tess to our accounting software as simple as possible.  This way, the "GL Summary Report" at the bottom of each posting report will tell our accounting dept. exactly where to enter the gifts.  Am I correct that the only way to direct a gift to a specific GL is through the fund?

Our finance department thinks of funds more broadly than the way we have them currently set up in Tess.  They would like to have only three funds: Annual, Capital, and Endowment.  This may just be the difference between the accounting definition vs. the development definition of "funds."  Our one concern is that if we limit the number of funds, we'd also be limiting the number of GLs.  Fewer GLs would make it harder for our accounting clerk to know from the posting report where to enter the gifts in the accounting software.

How many funds do you have?  If we were to cut back to three very broad funds, is there a way to direct a gift to the specific GL by using the campaigns?

Thanks in advance!



[edited by: Hannah Miller at 2:06 PM (GMT -6) on 20 May 2016]
  • We have MANY different funds – more than the 15 you mention.

     

    It sounds like the Annual, Capital and Endowment would translate to Campaigns within Tess.

     

    See if that adjustment gets you anywhere with your finance department and the reports they need.

     

    Marie

     

    ---

    Marie Kocher | Development Assistant

    Kansas City Ballet | Todd Bolender Center for Dance & Creativity

    500 W. Pershing Road, Kansas City, MO 64108

    816.216.5582 (D) | 816.931.2232 x1382 (O) | 816.931.1172 (fax)

    kcballet.org

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Hannah Miller
    Sent: Friday, May 20, 2016 1:07 PM
    To: Marie Kocher <mkocher@kcballet.org>
    Subject: [Tessitura Development Forum] How many funds do you have?

     

    Currently, we have about 15 funds ("Individual General," "Individual Capital," "Foundation General," "Foundation Capital," "Gala ticket purchase," "Gala donation," etc.).  We organized the funds based on our GL accounts to make the translation from Tess to our accounting software as simple as possible.  This way, the "GL Summary Report" at the bottom of each posting report will tell our accounting dept. exactly where to enter the gifts.  Am I correct that the only way to direct a gift to a specific GL is through the fund?

    Our finance department thinks of funds more broadly than the way we have them currently set up in Tess.  They would like to have only three funds: Annual, Capital, and Endowment.  This may just be the difference between the accounting definition vs. the development definition of "funds."  Our one concern is that if we limit the number of funds, we'd also be limited the number of GLs.  Fewer GLs would make it harder for our accounting clerk to know from the posting report where to enter the gifts in the accounting software.

    How many funds do you have?  If we were to cut back to three very broad funds, is there a way to direct a gift to the specific GL by using the campaigns?

    Thanks in advance!




    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!

  • Former Member
    Former Member $organization

    Yes, the way to tie a specific gift to a specific GL is indeed through the Tessy fund. But you can tie multiple Tessy funds to the same GL. So if your accounting department wants to use only three accounting “funds” (or GL accounts), you can still have many separate Tessy funds tied to those three funds. For example:

     

                   Tessy Fund                                                                       Accounting GL

                   Annual - Individuals                                                           4025

                   Annual – Corporate                                                           4025

                   Annual – Foundations                                                       4025

                  

                   Capital - Individuals                                                           4030

                   Capital – Corporate                                                           4030

                   Capital – Foundation                                                         4030

     

                   Endowment - Individuals                                                  4035

                   Etc., etc.

     

    It’s unclear to me from your note how your system works. Does someone enter the gift into Tessy and then someone else enters it into the accounting software? Or does Tessy talk directly to your accounting program? That could make a difference in how you set things up.

     

    I’m happy to talk off line if you like.

     

    ____________________________

     

    Julie P. Hamre

    Staff Accountant

    5301 Tuckerman Lane

    North Bethesda, MD  20852-3385

    www.strathmore.org

    301-581-5136

    jhamre@strathmore.org

    In office Monday-Thursday

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Hannah Miller
    Sent: Friday, May 20, 2016 2:06 PM
    To: Julie Hamre
    Subject: [Tessitura Development Forum] How many funds do you have?

     

    Currently, we have about 15 funds ("Individual General," "Individual Capital," "Foundation General," "Foundation Capital," "Gala ticket purchase," "Gala donation," etc.).  We organized the funds based on our GL accounts to make the translation from Tess to our accounting software as simple as possible.  This way, the "GL Summary Report" at the bottom of each posting report will tell our accounting dept. exactly where to enter the gifts.  Am I correct that the only way to direct a gift to a specific GL is through the fund?

    Our finance department thinks of funds more broadly than the way we have them currently set up in Tess.  They would like to have only three funds: Annual, Capital, and Endowment.  This may just be the difference between the accounting definition vs. the development definition of "funds."  Our one concern is that if we limit the number of funds, we'd also be limited the number of GLs.  Fewer GLs would make it harder for our accounting clerk to know from the posting report where to enter the gifts in the accounting software.

    How many funds do you have?  If we were to cut back to three very broad funds, is there a way to direct a gift to the specific GL by using the campaigns?

    Thanks in advance!




    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!

  • Hi Hannah,

    We have recently restructured our development model and have increased the number of funds but also introduced the use of Contribution designation due to a change in the way our Philanthropy department wants to report and promote the Annual Appeal.

    The fund is specific to the GL but you can have multiple funds per campaign

    I have a basic working spreadsheet we used when working through the change if that may help?

    Brenda

     

  • Hi Hannah,

    Just having a one to one relationship between the Funds in Tessitura and your finance system GL codes is a lost opportunity.  Tessitura acts as a sub-ledger to your finance system and can therefore house much more granular information that is very useful for analytics.

    You can have many different Funds all pointing to the same GL code, and the Tessitura Posting report will summarise all of these different Funds transactions into one row per GL code so that the posting into your finance system is at a highly summarised level.  Everyone wins.

    Cheers

    Dale