Hi, I've just started doing a Companies accounts via Sage. Is it compulsory to do a month end as to me it doesn't seem to have been done last month and if so is it straight forward to do?
Many thanks
It's not compulsory to run the month end procedure, but it can be useful under some circumstances.
If you use things like the fixed assets module, for example, then that posts the monthly depreciation as part of the month end procedure.
If you feel it does need to be done, then it's Tools -> Period End -> Month End
And if last month's hasn't been done, then before doing this month you can run it for last month by changing the program date in Sage to the end of last month. Settings -> Change Program Date
If memory serves, though, you can only go back and perform month ends as long as no subsequent month ends have been run. For example: If January, February, and March have been done, then you can do April by changing the program date, and then May after changing it back. However, if January and March have been done, then you can do April and May, but you can't go back and do February.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
If you had a recurring transaction or some monthly depreciation, when you do the May month-end, did it do the monthly stuff for both April and May at that point? Or did it only do the May stuff and when you went back and did April, it then did the April stuff?
I sincerely hope it's the former, otherwise you could miss out a month and all the depreciation, etc, figures would be wrong. However, it is was the former, what does Sage actually *do* when you run the April month-end procedure?
That's a good question - it was only a very quick test: I simply loaded the practice data and told it to do the month ends in that order.
However, there were no prepayments or depreciation set up to see what transactions it would post; I simply tested whether it would allow me to go back and post a month end out of sequence, which it seemed to do. My recollection of this from a few years ago was that it wouldn't.
Of course, now you've mentioned the transactions, it makes me think I might have been misremembering - perhaps the problem I'd spotted was that it didn't post any transactions for the out of sequence month.
It certainly never used to do the monthly transactions for the missed month when the subsequent month was posted: This is how I'm aware there is - or was - a problem; I was called into a company to sort out a mess their Sage data was in, and one of the many things I'd spotted was that they were using the fixed asset register, but not consistently running the month-end, and not every month had any depreciation in the accounts. If Sage would post the transactions for the previous/missed month, that wouldn't have been a problem.
My first instinct was to try and run it for the missing months - and, as I've said, my recollection now is that it simply wouldn't allow it; which it did seem to do on the practice data yesterday.
I'll throw in some fixed assets and try it again shortly.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Okay, I've now tested it with an item in the fixed asset register - and I'm reverting to my original position:
"you can only go back and perform month ends as long as no subsequent month ends have been run. For example: If January, February, and March have been done, then you can do April by changing the program date, and then May after changing it back. However, if January and March have been done, then you can do April and May, but you can't go back and do February."
With my programer hat on:
It's easy to see that Sage stores the date the last depreciation was posted for any given asset as part of that asset's record. What I think it does, therefore, is perform a simple comparison of the month part of that date with the month for which the month-end is being processed:
If the month-end is more recent than the month of the last posting, post another month's depreciation. If the month-end is NOT more recent than the month of the last posting, don't.
(I'm assuming it does something similar with prepayments and accruals).
What it perhaps should (and possibly could) do is as you questioned, Rob: It would be much better if it determined that if the last time month-end was processed was (say) three months ago, then it should process the transactions for the intervening months as well.
Another quick test shows that if you add an asset *after* the month-end has been run (or even several month-ends) - ie it's in the accounts, but you've forgotten to add it to the asset register - it's possible to go back and re-process the month ends from the point it was added, and the depreciation for that asset will be posted for those months you re-process. (This makes sense given the above logic). If it posted transactions for the intervening months, it could also include monthly transactions for any given asset from the date of the addition.
(What I'd be inclined to do with an asset to be added late - if I actually used the asset register* - would be to manually work out and post the depreciation for the intervening months, and set the net book value when first setting it up; but the above would be so much easier).
* I don't like it because it means one depreciation journal for each asset each month - with a lot of fixed assets, that's a lot of journals. I prefer a spreadsheet; work out the figures at the start of the year and set up one twelfth of the total depreciation for each category as a recurring entry, and then forget all about it until there's an addition or a disposal, or until the next financial year, whichever is soonest.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Your reply has been really helpful. I will have a look into it to figure out what has been done before I took over. Would the easiest way to check what month ends have been done, if any be to look at the assets record. Is there another way of checking if previous month ends have been done?
I haven't done much work with Sage for a couple of years now but i'm sure after a few weeks i'll be back on the ball with it all. Hope so anyway!
