I see the following topics:
Mid Month Accounting Close
3954539 Member Posts: 80
Oct 17, 2016 12:03PM edited Oct 18, 2016 8:17AM
I'm curious to see if anyone has tried to create a period mid month to close for acquisition purposes. We are constantly buying companies and of course the deal never closes on the last day of the month and it is a huge pain creating balance sheets and income statements in excel and I wanted to see how I could use Netsuite to reduce the pain. Thanks in advance!
Answers
- Olivier Gagnon NC Member Posts: 4,524 Green Ribbon
- Oct 18, 2016 8:17AM
- Well your period will already exist. So you'll need to edit your existing period and reduce the date range (say 1st to 22nd), then create a second period for the remaining (23rd to 31st). That will allow you to close them seperately and report on only up to the 22nd, or up to the 31st depending on which As Of period you pick.
AND
Can NetSuite have more than one FY in a CY to support an acquisition
3969028 Member Posts: 8
Jul 24, 2018 8:57AM edited Jul 26, 2018 12:37AM
My company was sold and will need to be able to report pre & post acquisition results separately. Has anyone been through this scenario and how was it handled?
Olivier Gagnon NC Member Posts: 4,524 Green Ribbon
Jul 25, 2018 12:46AM
Yes you can set up multiple FY in one calendar year, so long as the FY and periods do not overlap.
BUT
We have years defined out to 2026 and have Amortization schedules created out through 2026.
After being acquired, our fiscal years change to 05/01/xxxx to 04/30/xxxx from our current Calendar year 01/01/xxxx to 12/31/xxxx.
I want to leverage the base NetSuite functionality re: relative dates/periods while reporting ( fiscal half before last, fiscal half before last to date, fiscal quarter before last, fiscal quarter before last to date, fiscal year before last, fiscal year before last to date, last business week, last fiscal half, last fiscal half, one fiscal year ago, last fiscal half to date, last fiscal quarter, last fiscal quarter one fiscal year ago, last fiscal quarter to date, last fiscal quarter two fiscal years ago, last fiscal year, last fiscal year to date, last month, last month one fiscal quarter ago, last month one fiscal year ago, last month to date, last month two fiscal quarters ago, last month two fiscal years ago, last rolling half, last rolling quarter, last rolling year, last week, last week to date, last year, last year to date, month after next, month after next to date, month before last, month before last to date, next business week, next fiscal half, next fiscal quarter, next fiscal year, next four weeks, next month, next one half, next one month, next one quarter, next one year, one year before last, previous fiscal quarters last fiscal year, previous fiscal quarters this fiscal year, previous months last fiscal half, previous months last fiscal quarter, previous months last fiscal year, previous months same fiscal half last fiscal year, previous months same fiscal quarter last fiscal year, previous months this fiscal half, previous months this fiscal quarter, previous months this fiscal year, previous one half, previous one month, previous one quarter, previous one year, previous rolling half, previous rolling quarter, previous rolling year, same day fiscal quarter before last, same day fiscal year before last, same day last fiscal quarter, same day last fiscal year, same day last week, same day month before last, same day week before last, same fiscal half last fiscal year, same fiscal half last fiscal year to date, same fiscal quarter fiscal year before last, same fiscal quarter last fiscal year, same fiscal quarter last fiscal year to date, same month fiscal quarter before last, same month fiscal year before last, same month last fiscal quarter, same month last fiscal quarter to date, same month last fiscal year, same month last fiscal year to date, same week fiscal year before last, same week last fiscal year, this fiscal half, this fiscal half to date, this fiscal quarter, this fiscal quarter to date, this fiscal year, this fiscal year to date, this rolling half, this rolling quarter, this rolling year, this year, this year to date, three fiscal quarters ago, three fiscal quarters ago to date, three fiscal years ago, three fiscal years ago to date, three months ago, three months ago to date, week after next to date, week before last to date) but am unable to because I am unable to define my go forward fiscal year.
I planned to start at 2026, add a 2027 year and define the periods to match the new fiscal calendar but since some of the months already exist in 2026, I receive the following message.
"Illegal period structure. Date 1/1/2026 is in multiple periods in Fiscal Calendar Standard Fiscal Calendar"
I understand that, so I attempted to redefine my existing periods (not really expecting I could) and I received the following message when I redefined the year end date.
"You are not allowed to disconnect an existing accounting period hierarchy and create a standalone accounting period."
I also understand this message and reasoning.
Next I tried creating a 2028 year that is defined as the correct fiscal period 05/01/2027 - 04/30/2028 and was successful. I tried creating a 2027 year that ended 04/30/2027 but of course could not move 05/01/2026 through 12/31/2026 into the 2027 year (since it is already attached to Q3 2026 and Year 2026)
I was hoping to start in the future, create a new year, move months into the new year and save that newly defined year then continue & repeat backward through, to the current year to accomplish the redefinition.
From my testing, I think I am finding this is not possible.
Could anyone confirm re-aligning/re-defining my years is not possible or suggest an alternative that may work?
In Sandbox, I was able to split the current month so I may have to give up the NetSuite base Date filter functionality and force my reporting to manually define the reporting time frames.
I appreciate anyone's insights, comments or suggestions. Thanks all.