Fund, Campaign, Designation Set-Up

Hi everyone,

We are getting ready to set-up our funds for next fiscal year and are thinking of REALLY simplifying things. Our funds would be the source of the money (individual, foundation, corporate, government) and the campaigns would be the program (gen op, production support, events, education, etc). Our thinking behind this is that it would easily allow us to pull reports either way - if we want to know how much money education programs have raised, we pull by campaign. If we want to know how much government support we had, we pull by fund.

Then we'd used designations for any more detailed information regarding the purpose of the gift (i.e. the specific play or program).

My questions are:

1) How do others do this?

2) What risks do we take completely restructuring this way as far as comparing contributed income to past years? Have others dealt with this?

Thank you so much for your thoughts!

Best,

Sara 

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

I agree with Levi.  Although, I am all for simplifying the campaign/fund structure, too much simplification could jeopardize the reconciliation process with your finance department, as well. 

The funds are the purpose restrictions associated with a GL code, while the designations are not associated with a GL code.  Designations can be very helpful to identify specific areas of a campaign when the fund is pretty generic.

Let us know how well your process works.

I have worked in one organization that has GL codes for everything. It was maddening to try to pull reports.  A lot of individual lists were created to identify specific campaigns and funds.  But, at the end of the month/year it was easier to identify those areas that were requested by auditors and others.

Michelle

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Levi Sauerbrei
Sent: Wednesday, May 07, 2014 10:13 AM
To: Michelle Wohlers
Subject: Re: [Tessitura Development Forum] Fund, Campaign, Designation Set-Up

Hi Sara,

The biggest risk with that setup (in my opinion) is that designations are tied only to the campaign and you run a risk of data entry errors causing your reporting to be wildly skewed.  There are 2 vectors for this.

1) The user chooses the wrong designation by accident during contribution entry.

2) The user does not have the same understanding of which designation to use that the folks looking at the reporting do.  In other words, the data entry user may spend a week or more putting things in the wrong designation and no one catches it until there are a large number of contributions with the wrong designation.  At which point you have to go back and figure out what it should have been and find a way to correct them all. (I've had to do this a few times).

Having said that, if you feel confident in the data entry folks and in your communication internally about what is expected, I don't think this is a bad way to go.  I wouldn't use designation reporting for anything related to finance.  But if all you are doing is tracking your progress towards your Development goals, I like this method.  I don't think finance should ever use designations to categorize the money.  For that, I'd create more funds with distinct GLs. 

Hi everyone,

We are getting ready to set-up our funds for next fiscal year and are thinking of REALLY simplifying things. Our funds would be the source of the money (individual, foundation, corporate, government) and the campaigns would be the program (gen op, production support, events, education, etc). Our thinking behind this is that it would easily allow us to pull reports either way - if we want to know how much money education programs have raised, we pull by campaign. If we want to know how much government support we had, we pull by fund.

Then we'd used designations for any more detailed information regarding the purpose of the gift (i.e. the specific play or program).

My questions are:

1) How do others do this?

2) What risks do we take completely restructuring this way as far as comparing contributed income to past years? Have others dealt with this?

Thank you so much for your thoughts!

Best,

Sara 

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!