First timer here. I have just started at this company and been thrown in at the deep end. I need to create 3 new Petty Cash accounts for the three foreign currencies they use - however the Accountant before me seems to have used up all the codes from 0080 through to 0099 for a couple of bak accounts and then other random things like 'loans'. Is there any way I can adjust these to create room for my Petty Cash accounts? I am using Sage 50 Prof btw. Any help would be appreicated.
Why has the accountant used account 0080 to 0099 because typically these are all Fixed Asset accounts, when all of the bank and cash accounts in sage run from 1200 to 1299
All of the fixed asset codes run from 0001 to 0999
A personalised COA has been set up and the codes are completely different to the default. She has used all the codes chronologically which means there is no manouveure to enter new codes for accounts inbetween. Not really sure how to put in these three codes for Petty Cash when there is no space for them! do you think I could amend the personal COA layout? I've always been told to leave gaps between Nom codes!
Make it idiot proof and they just design a better idiot!
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
What about all of the existing entries that have been recorded under the wrong nominal code?
I've actually seen things similar to this before where employers make common software unique to themselves in order to make it difficult for staff to move easily to another employer.
It could be that such is either company policy at your current employers or the person who set up the system came from such a company.
Whatever the situation good luck anyway tShap (oh yes, and welcome to the forum).
kindest regards,
Shaun.
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
You say you are using an amended CoA, with codes being used chronologically. What I take this to mean is that they created a blank CoA and added codes starting at 0001 as and when required? In the standard Sage codes, fixed assets go up to 0999, as Mark says. Having 1000 codes seems a large amount. So is it possible that no codes above 1000 have been used?
Why not try creating a whole set of new codes for where things "should" be that are not fixed assets, then journal all the non-fixed asset existing balances to the new codes at a period start (which allows you to only have to worry about one set at a time). I guess you'd then have to change some settings, like telling Sage where the control accounts now are, assuming Sage hasn't just used the codes it wants for them in an case.
This solution is just a theory, but you get the idea. But... please, please, please... take several backups before trying this.
Thanks Shaun. The personl who had taken over till I came along to help also couldn't work out what had happened.
That's what I was thinking of doing Rob-f58049. She seems to have used them chronologically, but then jumps around a bit. she has amended the COA to reflect the correct Nom codes, but like I said, has left no room for manoeuvre. Will def try and give that a go.
Golden rule - Back up! always :)
Thank you all for your help. I wish I had found this forum a long time ago!
