I have posted this to the Finance Forum and received one response. I'm hoping can get broader input from the dev folks as well. We are setting up a system for tracking multi-year annual gifts. We would like to see the gift land in the fiscal year the funds are meant for rather than putting in the total amount of the gifts in one fiscal year and tracking as pledge payments.
We are thinking of creating all the campaigns through 2020 and entering a gift for each year. It was recommended we enter the gift date in the future for additional tracking. This way the gifts could be tracked by either transaction date or by contribution date for reporting purposes.
Is there a mechanism in Tessitura that will automatically transfer a gift in a deferred fund to a current fund from the future year it is assigned to? (future to current) Our financial software is not Tessitura, we need something that tracks the gifts and that we can extract to our financial department clearly and easily for the auditors. Please let us know how you track these types of (deferred) annual gifts and offer any advice, thank you!
Example: Donor is pledging support at the $2000 level through 2020.
Campaign: FY15 Individual, Fund: Individual Fund, Appeal: FY15_2000 Donor, Source: FY15 5-year solicitation
Campaign: FY16 Individual, Fund: Individual Fund, Appeal: FY16_2000 Donor, Source: FY15 5-year solicitation
Campaign: FY17 Individual, Fund: Individual Fund, Appeal: FY17_2000 Donor, Source: FY15 5-year solicitation
Campaign: FY18 Individual, Fund: Individual Fund, Appeal: FY18_2000 Donor, Source: FY15 5-year solicitation
Campaign: FY19 Individual, Fund: Individual Fund, Appeal: FY19_2000 Donor, Source: FY15 5-year solicitation
Campaign: FY20 Individual, Fund: Individual Fund, Appeal: FY20_2000 Donor, Source: FY15 5-year solicitation
Kristin Murphy
kmurphy@nashvilleopera.org
When you say future to current, I assume you mean restricted gl to non-restricted gl. If that is the case, you can also setup the campaigns so that if the contribution date is before the campaign start date, it will automatically post to the restricted gl. Then there is a special batch type that you can run at the beginning of each year that will transfer the money from the restricted gl to the non-restricted gl. There is also a report under finance that will allow you to see all restricted money in Tessitura.