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!
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?
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.
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!
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?
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
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