Hello all!
We've been on Tess for several years now and always set up our campaigns to be tied to a single fiscal year. It's typically not an issue other than the odd unusual reporting request that can be met using one method or another. However, we have recently begun a large capital campaign to cover the costs of our renovation and expansion. This campaign will be spanning several fiscal years and has some very specific requests around it. We are investigating the option of having one campaign encompass the entirety of this endeavour but are not quite clear about the ramifications of that. Has/Does anyone do this and do you have any advice? I'll probably think of more questions as we explore this but initially my questions are:
1) I found the Help document a bit unclear, can you enter a fiscal year onto the campaign and then simply change the fiscal year to the next year at fiscal year end while keeping the same physical campaign? There was something on the website that implied this but it didn't go into detail so I may have been misreading it. 2) If the answer to #1 is yes, does that have any ill effect on historical data or reporting? If it is no, how do any contributions made get tied to a fiscal year for financial and general ledger purposes?3) What kinds of reports have been most helpful to you with these kinds of campaigns? I suspect we will either need a custom report or a series of dashboards to achieve the reporting requests that have been sent my way but I'd like to see what others are doing first.4) Do you have any words of wisdom or hindsight/gotcha's that you'd like to share about this method?
If you were in a similar boat and decided against the single multi-year campaign to stick with several tied to specific fiscal years, may I ask why you chose to do that? How do you handle reporting requests that span multiple fiscal years? The leadership team has been clear that they want to be able to run a report in Tessitura for any time frame they wish (could be 1 month, 1 year, or 10 years) that will give them total data without having to be manipulated in a spreadsheet afterwards. The out of the box reports all seem to break out data by fiscal year instead of simple totals. I do have the technical skills to write a report that will do what they want if I need to but I'm hoping to avoid the custom route if possible.
Thanks for any advice you might be able to provide!
Beth Hawryluk said:This campaign will be spanning several fiscal years and has some very specific requests around it.
I'd recommend creating annual Capital campaigns as usual and then tying them together via a new, specific Campaign Category.