Hi All,

Long term adagio user has had a corporate year end change from Dec 31 to Nov 30. I searched the forum to see if there is any automated way to do the change, and it doesn't appear to be possible.

Without any additional feedback, my approach would be as follows:

Export all MTD balances out of the GL for all possible years
Duplicate the GL into a new company with a new GL
Do a JE per period (net changes) from the beginning until the current month.
Move the existing GL data files into a backup folder.
Copy the new GL data files into the company folder with the rest of their subledger data.

How does that sound? Effective or disasterous?

Garry:
As of which fiscal year is the new year ending Nov 30? (2011? 2012? ...)

From your description it sounds like you want to reset past years as well to a year-ended Nov (since you indicate that you are working with all possible years).
Is this really what you want to do?

Hi Garry

Disastrous. You will lose all detail.

If the fiscal year change went into effect last December, and you have run the year-end steps using December as the year-end date, that's the worst case scenario. Let us know. You will probably want to restore from a backup done before running year-end and then merging subsequent detail into the backup.

If the fiscal year change went into effect last December, and you have NOT run the year-end steps using December as the year-end date, my suggestion would be to unpost every batch that has activity posted in December or beyond. Then I can give you fairly easy instructions.

If the fiscal year change goes into effect next December, that's easier but still not easy, for now just close period 12 and when it's time to post December activity, the instructions will be similar to the second scenario above.

This is where consultants earn their pay.

Steve

Hi Steve,

Yup, the full year end has been completed (accountants are never told this stuff until it is too late).

when you say 'disasterous' you are referring to the lack of detail, right? In my opinion, as long as they have access to the 'pre' year end change database, they could use summary information now and refer to the copy of the 'pre' for details.

In your post, it sounds like restoring from December 31 (pre-year end) is the only starting point if the customer wants detail for the current year, right? If I can get that, what is the plan for prior year comparisons?

I'll be happy to contract with you for the project - just let me know what information you need and what the results will look like and I'll run it by my client.

I am out most of the day but will be back in the late afternoon - you can reach me at 902-442-3892 if you think we should discuss.

Hi Garry

With the pre-year end backup and a current GL, I could re-create the GL and preserve the detail. My method will work assuming no account details are consolidated because I need the details to re-create the original batches.

There is always the issue of prior year comparisons when there is a fiscal year change. For purposes of prior year comparisons, is Nov 2011 period 12 or period 11? When comparing to Nov 2010 you would want it to be period 11, but when comparing to Nov 2012 you would want it to be period 12.

There is no right answer. Although most of the time users decide that prior year comparisons are worthless and don't really care.

I'll contact you by phone, or you can start the conversation by emailing me at steve@sschwartzcpa.com

Steve