The Book-keepers Forum (BKF)

Post Info TOPIC: Sage month end


Veteran Member

Status: Offline
Posts: 66
Date:
Sage month end


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

__________________

Kiz



Expert

Status: Offline
Posts: 1811
Date:

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...)



Expert

Status: Offline
Posts: 1811
Date:

Okay, scrap that last paragraph. I've just fired up Sage and loaded the practice data to check.

It did seem to allow me to do a month end for May and then one for April.

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Senior Member

Status: Offline
Posts: 133
Date:

A query on what Sage did in your trial, then.

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?

__________________
Rob


Expert

Status: Offline
Posts: 1811
Date:

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...)



Expert

Status: Offline
Posts: 1811
Date:

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...)



Veteran Member

Status: Offline
Posts: 66
Date:


Thanks VinceH,

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!

Thanks again

__________________

Kiz



Senior Member

Status: Offline
Posts: 133
Date:

If the Audit Trail wasn't cleared as part of the month-end process, the fact that it happened could be recorded in there?

__________________
Rob
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About