Create a New Fiscal Year that Does Not Have an End Date Within Its Calendar Year

Solution:
This article explains one method of changing the fiscal calendar when the ending date does not fall within its calendar year. For example, the current fiscal calendar year is 2004 which runs from February 1, 2003 to January 31, 2004 and has twelve periods. The new fiscal calendar for 2005 must be created such that it runs from January 1, 2004 to December 31, 2004 and has twelve periods.

This cannot be done via any standard procedure. Working with the example above, the earliest the 2004 fiscal calendar can be closed is January 1, 2004 in order for the end date to fall within the fiscal year 2004. Therefore, the earliest beginning date for the new fiscal calendar year 2005 is January 2, 2004 and ending on January 1, 2005.

The following is a possible workaround.
1.Create a new company.
2.Setup the new fiscal calendar. The beginning date will be the start of the new three year fiscal calendar.
3.Add the General Ledger (GL) module for the new company. (Do not copy the data from the original company when adding GL; this will overwrite the new fiscal calendar with the old dates.)
4.Copy accounts, types and groups from the original company.
Post beginning balances. These should be done as of the beginning date for the new three-year fiscal calendar window.
5.Import GL transactions in summary format starting with the first month in the new three-year fiscal calendar window. (This will be one transaction per GL account for each month.)
6.Add all appropriate modules to the new company and copy the data over from the original company.
7.Ensure the GL is linked to each of the modules in the new company. (This is set in each module’s Change Setup Information screen.)
8.Close each fiscal period until the fiscal calendar is in the current period.

© Copyright Sage Software

Leave A Comment?