Extending Company year end on Sage

Extending Company year end on Sage

Didn't find your answer?

I have a client company that has extended it's year end by two months so I need to prepare accounts for a 14 month period.  They use Sage for their book-keeping and I am struggling with how to a get reports and a trail balance to cover the 14 month period.  The year end accruals and prepayments are quite complicated as they receive and make many payments in advance so I only have figures for these at the new year end.  Can anyone suggest a simple solution.

Replies (11)

Please login or register to join the discussion.

avatar
By Cloudcounter
27th Nov 2012 14:01

It's possible if you have an up to date version of sage.  Have a look at the help screens

Thanks (0)
avatar
By User deleted
27th Nov 2012 16:05

Assuming you have a version you can do this in ...

... my preference is to not run a year end first, unless there is a compelling need to do so. That way you will get totals for all 14 months, rather than having to add a 12 and 2 month period together. You won't however be able to look at months 1 and 2 in isolation so run off any reports you want for those periods first (or if you have multi-company keep a spare copy pre change just in case. If only single company take a back-up first then at worst case you can restore to interrogate then restore the current version again after.

If your version wont allow the change, you may be able to pay SAGE to do so, or someone on here may be able to help (WitchQueen!).

Thanks (0)
avatar
By breakaway.barry
27th Nov 2012 15:10

Sage Help

The version they are using is Sage 50 Accounts Professional 2011 version 17.0.15.208

The help section has "Sage 50 Accounts only enables a twelve month financial year. However, after processing the first twelve months, you can use the Change Financial Year facility to move the financial year to the last twelve months of your year. You can then transfer the necessary information from what is now the brought forward period, into the current financial year"

The only option in Sage appears to be to change the start date  for a twelve month period not the period end so (OGA) how can you "get totals for all 14 months"

Thanks (0)
avatar
By ChrisDL
27th Nov 2012 15:23

Transactional report

I think OGA (though I defer to his wisdom) would do what I have just done and use a transactional trial balance to get a TB for the 14 months - this will only work if the year end has not been done.

Thanks (0)
avatar
By User deleted
27th Nov 2012 16:06

Depends ...

... if you change the year start, so say y/e was 31/03/2013, and you want 31/05/2013 change the start point to June. When you look at P&L activity, the 01/04-31/05/2012 movement will show in the  B/F box on the detail tab.

You can either run a TB at 30/06/2013 which will show the all the transactions for the 14 months and teh closing B/S items, or a transactional TB for the period 01/04/2012 - 30/06/2013 which will only show the movements on the B/S items.

I always rollover my IRIS figures and post the transactional TB, but that is my preference (If it is my first year I will however import the whole TB to date).

When you run a year end in SAGE it just posts a reversing journal in total for any transaction dated before the year end date (or up to the start of the next period if that is easier to understand). SAGE is limited to being able to report on 12 months, so any tranactions earlier than that have not been reversed to 3200 get lumped under B/F, and will appear on the B/S as Prior Year Adjustments.

I look at it from a compliance accountant perspective, i just want the periods tranactions in the easiest way to load into IRIS. A management accountant will have different criteria.

If I get a SAGE backup where the year end has been done, I just reverse the journal (two journals if a year end has been done prior to lengthening the accounting period) and then extract a transactional TB to import as a csv into IRIS.

Thanks (0)
avatar
By breakaway.barry
27th Nov 2012 16:03

Possible solution

I think I may have found the solution.  If I move the start date for the current period on two months without running a year end the trial balance for the new month twelve appears to include all the figures for the 14 months.  If I then run the year end the journals clear the P&L nominal accounts and the brought forward balances are correct for the next financial year.  Can anyone see a problem with this approach.

Thanks (0)
avatar
By User deleted
27th Nov 2012 16:04

No ...

... that is exactly what I said above.

Thanks (0)
avatar
By breakaway.barry
27th Nov 2012 16:25

Thank you

Yes, having re-read your post it is, thank you.  What puzzles me is why Sage help doesn't suggest doing this instead of the complicated procedure that they advocate.

Thanks (0)
avatar
By User deleted
27th Nov 2012 17:12

I think ...

... as someone said on another SAGE thread, the people at SAGE are not accountants. Again though, for people who use SAGE for monthly accounts the 14 month period may not be appropriate, but if SAGE just used for year/period end, or to check reserves for dividends it works best.

Thanks (0)
By ireallyshouldknowthisbut
27th Nov 2012 17:12

.

"What puzzles me is why Sage help doesn't suggest doing this instead of the complicated procedure that they advocate"

Because its sage - there to make the simple, complex.  And then charge you for sorting it out. 

 

I have I have done it OGA way before - before of course getting to ditch SAGE for something written in the last 20 years. 

 

Thanks (0)
avatar
By syed.rafe
08th Jul 2015 08:18

I must know this

Hi,

I am using 2011 Sage 50 version, can someone help me to know how to close the year end for more than 12 Months?, i see the above comments and could not find the same in sage 50, i think its for the later versions of sage, it is the first year of business for my company and have to close the period end of 18 months. I am getting the year end date only and not the year start date, ....

Thanks (0)