Year End Rollover

Year End Rollover is the conversion of the general ledger from one fiscal accounting year to the next and occurs at the end of the fiscal year (not the calendar year). The following steps occur:
  • Current year monthly financial totals are moved into the previous year monthly totals.
  • Donations that were deferred for the next fiscal year are transferred from deferred revenue to earned revenue.
  • Passes and Gift Certificates that were deferred for the next fiscal year are transferred from deferred revenue to earned revenue
  • Hours attributed to volunteers/staff are rolled forward one year.
  • Marketing statistics are recalculated to reflect the new fiscal year
  • Optional Steps:
    • Ticket sales for the next fiscal year can all be transferred from deferred revenue to earned revenue based on accounting settings in Company Preferences
    • All events with dates in the past can be closed automatically to prevent any sales, exchanges or refunds from occurring.

The amount of time taken by the year end rollover is dependant only on the number of accounts and posting history. It should take only a couple of minutes to do the actual rollover once you have the reports you want.
Complete the final End Of Day for the current year before doing a Year End Rollover. This generates the final deposit, creates all sales entries, posts to the G/L and then you can run any G/L reports that are traditionally required for auditors.

Refer to timing to decide when to do the rollover.

Sales can continue on the web and at the box office while year end rollover is in progress. Just don't do your end of day until Rollover is complete.

Year End Backup

Making a year end backup of your database is important for audit purposes.

Almost all reports in Theatre Manager can be re-run with the exception of the receivables report. That changes when anything new is bought and/or paid for. Auditors like to see your receivables as of year end and reconcile it to your accounting program.

This audit backup generally coincides with when you run the year end rollover, especially if you do your rollover on the last day of the fiscal year or the first day of the next year. If you decide to delay the year end rollover, then you will have future G/L entries that are pending posting (after the rollover), which will affect receivable reports. In that case, you will also want to do a back up as at the end of the fiscal year.

Venues with databases on the AMS cloud should contact AMS support with message asking to make a special backup for year end.
You must manually create a backup at a time of your own choosing by following these instructions and saving the backup file.

Timing of Year End Rollover

Year End Rollover does not have to be done on the last day of the fiscal year (as determined in Accounting tab in Company Preferences). You can
  • wait until the first day of next fiscal year to run the rollover. This will capture internet sales through midnight and into the current year -or-
  • do it a day or so early. Any sales occurring after rollover will be allocated to the next fiscal year.
  • Generally speaking, a good accounting practice is that year end rollover should be run as soon as possible after the actual end of year

If you have not run a Year End Rollover and the last day of the fiscal year has now passed:

  • the user will receive a message when trying to post G/L entries at end of day. This message indicates that some sales or deposit postings were not done because they are in the next fiscal year. This still gives time to print the G/L reports for prior year and make adjustments.
  • any donations entered after the start of the new fiscal year default to the past fiscal year. If the intention of a donation is to be in the NEW fiscal year, then change the fiscal year on the donation entry window manually -or- do Year End Roll Over and the fiscal year default will change.

If the organization does a Year End Rollover and still needs to make manual adjustments to the G/L, they can be done to the prior year. Then print a G/L report for the prior year (because of the roll over, the current year moved to the prior year). This means the user can still get any financial information needed.

Year End Rollover and Extended Break Settlements

Fiscal Year End Roll Over
If your offices will be closed during the time of your Fiscal Year End (such as over December 31, for example), you may want to make Year End Roll Over (YERO) preparations before you close for the season that need to occur prior to transacting any business in the new fiscal year.

Why is this important?
The primary reason Theatre Manager needs a YERO performed is to appropriately move donation funds into the correct fiscal year. Typically, future campaign funds are kept in a separate General Ledger account (deferred) until the first day of the new fiscal year. The YERO process moves these funds from the deferred account to the earned account. New donations, intended for the upcoming fiscal year, will need to be appropriately allocated according to the ACCOUNTING tab of the campaign setup. The YERO also advances the default fiscal year setting when entering a donation. If the YERO has not been performed, the funds will not be allocated to the correct fiscal year. Season and event ticket income may also be affected depending on the settings in your database.

The complete YERO steps can be reviewed and followed at Year End Rollover as it provides you the step-by-step instructions to complete the process.

Special notes:

  • Be sure to make a backup of the database prior to running the YERO.
  • Be sure to read the section on the optional step carefully. Although most organizations do not use this option - review them with your accountant to see if they do apply to you.
  • Do not interrupt the YERO process. It may take from several minutes to several hours to complete and the computer may look "stalled" during that time. Do not stop the process or interrupt the computer at any time. If you are unsure, contact Arts Management Systems Support first. If you quit the process, you may need to restore to a backup copy of the database before you can continue.

End of Day over an Extended Break
In addition, you may need to take into consideration your End Of Day process over an extended break, such as the upcoming holidays. Ideally, you need to keep the Deposits and Sales Entries portion of the End Of Day going on a regular basis over the break - bearing in mind that even though there is no one in the office selling tickets, if you have web sales, it will continue to run. Please refer to strategies to keep your system running smoothly over an extended break.

Steps in the Year End Rollover Process

Only run the Year End Rollover routine when your venue is ready and/or if the user is prompted to by the End Of Day Wizard, which indicates that Theatre Manager is unable to post 'next' year's sales and deposit entries.
  • We suggest making a backup of your database before starting year end rollover. The purpose is in case the auditor wants you to go back to an old database for some reports.
  • Please find your most recent backup and save it in the monthly or annual backup folder.
  • For those venues on the AMS Cloud, please contact us and we will save a year end database for you.
Do not interrupt the year end rollover process once you start it and it should finish in a few minutes.

If you do interrupt it, please contact Arts Management Support and it may be possible for us to re-run it for you

  1. Use the Accounting >> General Ledger >>Year End Rollover menu.

  2. Check off all items in the 'check list' section to confirm that you completed them and/or have the data and that you are ready to continue the Year End Rollover.

      The check box in the 'Optional Steps' at the bottom of this window to transfer events from deferred to earned revenue can ONLY be checked if your company preferences are set to defer revenue only from one "season" to another "season". (Other settings should prevent use of this option).

      The check box to 'Close Past Events' will take all events that are completely in the past fiscal years and close them - so that ticket sales, exchanges and refunds can no longer occur. This can be reversed by editing the event and re-opening it.

  3. Click the Perform Year End Rollover button to continue.
  4. A window opens confirming you are ready to run the Year End Rollover.

  5. A confirmation window opens stating the Rollover is complete.

Changing Fiscal Year End

If you are changing your fiscal year end, you can run a year end rollover:
  • in the middle of the old fiscal year if making your fiscal year shorter
  • a few months after later if making your fiscal year longer
    • This is such a rare situation, that we suggest you contact the support team.

Making a shorter fiscal year

If, for example, your current fiscal year ends in October and you want to change the fiscal year end to be July of the same year, then you are making your fiscal year shorter. The current fiscal year will not be 12 months, it will only be 9 months and then the fiscal year will go from August to July moving forward.

At End of Day on July 31st of the shortened fiscal year

  • Stop all sales in Theatre Manager
  • Complete the final End Of Day for the shortened fiscal year on the day that you want to be the new year end.
  • Make a backup of the database. If you are using AMS cloud, ask support team to make one for you to file away
  • Alter the fiscal year end in Company Preferences to indicate the new end month of the fiscal year.. it will be 'JULY' in this example.
  • Do the year end rollover to set the new fiscal year. In the example above, you will be doing a year end rollover on July 31st (instead of Oct 31st)

In the accounting data in TM, you will see the following effects.

  • The prior year fields in accounting will show 9 months containing data and 3 months without data (since that represents August, September and October which have not happened yet.
  • The title on the month columns in history will not reflect correctly. This is because TM simply calls the accounting periods - period 1 to period 12. For convenience, TM displays the month based on the value in default data - which is now meaningless since you adjusted the year end period. . Think of months as period 1 to period 12.
  • The new year will start as expected, in the new month, starting in a new period 1 in the new fiscal year fields.

 

Making a longer fiscal year

For example, if you are changing your fiscal year from July 31 to October 30, (which means 15 months in the fiscal year), then you are trying to have more than 12 months in the current fiscal year. Theatre Manager only recognizes 12 motnhly periods, even if your accotning system recognizes more.

To make the change in TM, on July 31st of the current fiscal year:

  • Alter the current fiscal year end in Company Preferences to indicate the new end month of October
    • The effect you will see in the accounting data for TM is that:

      • TM puts the monthly totals into the last periods in reports and on screen. They will contain totals for multiple months. This means:
        • Month 10 (now named August, but formerly called May before you changed the fiscal year end month) will have accounting totals for both May and August.
        • Month 11 (now named September) will contain totals for June & September
        • Month 12 (now named October) will contain totals for July and October
      • You will defer the year end rollover to the month that it should now occur, which is Oct 31st.
      • The financial totals for the 15 months of the prior year will be correct -- and ther appear in the monthly columns adjusted by 3 months, with the last 3 months (Aug, Sept, Oct) each containing two months of financial data as described above.

Fixing EOD Imbalance created because of Year End Rollover

Please read carefully and fully understand the ramifications of this one time only feature before using it.

It will make a historical balancing entry and should only be used if your most recent Year End Rollover resulted in an End of Day imbalance.

DO NOT use this process to correct and EOD imbalance in the middle of the year. It is only to be used if the EOD imbalance occurred directly after running Year End Rollover

 

Why did I get an imbalance in the first place?

This issue should only arise if you:

  • just ran your year end rollover -and-
  • discovered that your first end of day after that was out of balance,
The likely cause of the issue is:
  • The year end rollover process was redesigned in Mid 2018 to make it a much faster process. It now rebuilds annual GL totals from all past GL entries. The added benefit is that year-end-rollover to be rerun (please contact the support team to if you need this).
  • Your venue has been using TM for a long time (most likely from version 6 era decades ago) -AND-
  • A consolidated GL entry might not have been created properly - so this will address this missing data in the database

 

When NOT to use this process

DO NOT use this process if you just discovered and EOD imbalance in the middle of the year. Instead use the Troubleshooting End of Day imbalance checklist to find your issue.

Otherwise, we suggest to contact the support team to get assistance and to verify that the process should be used.

 

Who can do this process?

Only a master user or outlet administrator can make this entry. It is not visible for any other user.

 

What is the process and rules surrounding this feature

If you discover an EOD imbalance after your first end of day after year end:

If, after involving the support team and the End of Day Imbalance is still present, then:

  • Force the EOD to balance by creating the adjusting entry under your normal user account.
  • Do not post this force balanced GL entry.

    If you posted it in TM, the next step you take depends on whether you passed this GL entry to your accounting system:

    • If you just posted in Theatre Manager and have not created your end of day G/L report to pass to your accounting staff, please unpost this GL entry immediately.
    • If you have already passed the Adjusting entry to your accounting staff, then:
      • reverse the GL entry in TM.
      • Create another force balance Adjusting Entry. The totals should be the same as the one you just reversed.
  • Log in as the Master User or Outlet Administrator for your outlet. The feature is not available to anybody else
  • Find the EOD adjustment GL entry you just created. It must not be posted and it must be of type 'GL'
  • Click the Convert to Historical Entry
  • Confirm that you want to convert this GL entry to historical by clicking the Convert button.

 

What does this process do

Converting a GL Entry to historical will:

  • Change the source of the GL entry from GL to CO, meaning that it is a historical consolidation accounting entry from years ago.
  • Add text to the notes indicating that that it was a force balance after year end rollover
  • Change the date on the GL entry to 10 years ago to the date
  • Mark the entry as posted so that it will not be posted again
  • It will back date the posting date to 10 years ago. This means it will not show up in today's end of day.
  • Mark the GL entry as exported - meaning it cannot be exported and passed to your accounting system if you have automated that process
  • Adds a flag to the GL entry to mark this a a special GL entry. Once you have created this one-time GL entry for a Year End Rollover problem, you will never be able to create another one.
  • Theatre Manager will then rebuild the account balances as if it were ding year end rollover to bring TM's A/R account into balance. Since this GL entry is now 10 years old, it make it appear as if the force balance never occurred.