Our company is re-aligning our fiscal calendar to ...
# accounting
n
Our company is re-aligning our fiscal calendar to start in August rather than February. Does anyone know how we'd move transactions out of a period so we can re-align?
k
I have done this once before - you have to move everything
if you have any voids this presents an issue.
My advice would be to do a stub year and just miss a few days of reporting since it's only the 3rd.
Also there are some transaction types that simply can't be CSV imported.
k
you do not have to do any import/export, none of that. you nee to have multiple fiscal years enable, create one short year and that’s all you have to do. contact me if you need more
n
Hi @Karina - that is what we were thinking at first
The only wrench being that we already have transactions in one of the periods that shares a date range with the new FY 2022
message has been deleted
Ideally we end FY2021 with P6 and P7 becomes P1 of FY2022
We can't edit P7 since there are transactions, and we can't create a new FY2022 calendar since the dates overlap
So it seems like we need to move the transactions out of P7, create a new fiscal calendar and then move the original P7 transactions to P1 2022?
k
There are likely to be transactions you can't move. However, yes. 1) Delete unused periods. 2) Shorten p7 to end on 8/4 (most likely) 2a) shorten your calendar year setup to end on 8/4 3) Create new year starting on 8/5 to go until the next year proper end date. 4) move all the transactions that you can (hopefully all of them - but I expect hold outs that prevent you from moving them) 5) if you don't have transactions left - then you can play with your calendar year start date to have them correct. If not, you probably just let those 3/4 days ride, knowing that it's a small volume. You should note - you have to move all transactions (including non posting) and any amortization schedules are likely to completely mess you up if they flow into future periods.
That setup process is going to involve a lot of manual date fixes as you go because of not starting it on the 1st, but moving transactions into july and then back into august is likely to create issues
Honestly - I'd be inclined to leave august in current fiscal year and run next year sept -> July - and then start correctly from there
your year over year values are already gonna be a little messed up with this anyways - what's another month you have to do some math with break?
k
@Nicholas Penree - you cannot have overlapping FYs, your RE will not be calculated correctly. but you do not have transactions in future periods, just schedules, right? Your periods are still periods, they do not go away. You need to have different YEARS, and that is easy to organize.
n
@Karina correct. We currently have transactions in P7 FY2021 of the old calendar, which is really P1 FY2022 in our new calendar that started 8/1
so Ideally we end FY2021 because the dates would overlap
and we start FY2022 fresh
k
Well, what are your old calendar dates? Aug through July?
Complete that year. Then have short year Aug - Jan. then have new year Feb - Jan
it is all about RE
k
Their old dates are Feb - Jan. They are looking to switch to using Aug - July
and we're 3 days into Aug is the issue.