Hello Tessitura friends,
This is our first Fiscal Year End in Tessitura. Since our conversion was fairly recently we don't have a ton of stuff in Tessitura yet. But we've got a fair bit.
Most of our year end stuff will be done in our old ticketing system which shuts down today (hooray!) and we've got that covered.
But I'm wondering what other organizations do at fiscal year end? What reports do you run? What tables do you update? Etc. Any info would be greatly appreciated.
Hi Beth
Take a look at the recorded webinar by Theran MacNeil on this topic - its an hour and a half long but well worth the investment of time if you're new to Tessitura:
http://www.tessituranetwork.com/network/Learning/Webinars%20Archive/Development/Year%20End%20and%20Season%20End%20Close%20Out%20Procedures.aspx
What it covers:
SEASON YEAR END
Ticketing
.. Close any open performances.
.. Check for unseated subscriptions, if you haven’t already.
.. Clean up on-account money.
.. On Account Tracking Report
.. Gift Certificate Expiration Utility
FISCAL YEAR END
Fiscal Year End is an accounting period of 12 months unrelated to the calendar year.
Power User
.. Build Batch Periods
Ticketing and Development
.. Build Campaigns
.. Close old Campaigns
.. Build new Appeals and Sources
.. Close Inactive Appeals and Sources
Development
.. Build Acknowledgement rules for new Campaigns
.. Update Membership Rules for Fixed Initiations
.. Reschedule Membership Update Utility
Tessitura Network Webinars – Year End and Season End Closeout Procedures 2
.. Solicitation Records
.. Clean up On Account money
.. Cancel / Write Off Pledges
.. Run Future to Current Batch
.. Run Restricted to Non-Restricted Batch
.. Understand how to:
.. Back-date a Post
.. Back-date a Contribution
IT / Web
.. Update T_DEFAULTS
.. FUTURE RECEIVABLE CUTOFF DATE
.. DEFAULT SOURCE CODE
.. Update Scheduled Jobs:
.. EIS_IMP_CHANGED_LOAD_NEW
.. LP_UPDATE_SUBS_HIST
.. LP_UPDATE_TKT_HIST
.. TP_CHECK_SEAT_STATUS
.. TP_CHECK_BASE_SEATS
.. Update programming that sets constituencies related to year or season
.. Update scheduled reports that have a campaign parameter
.. Update Membership Rule Override on your website, if applicable
.. Review ranking strategy specifically for web seating
.. Prepare for website relaunch, if applicable
I hope you find this useful.
The only thing we really do is to run the Future to Current process for the organizations that use a fixed Future Receivables Cutoff Date.
Other than that the only thing I would double check is that you have the fiscal periods set up for your coming year in TR_BATCH_PERIOD.