|
|
I recently set up a new company on Sage 50. I have posted three months worth of transactions- was about to reconcile the bank account, when realised I had inadvertently ticked the 'no bank reconciliation' button. As it is now greyed out- I cannot find a way to reverse this. Having looked at a few forums, I decided it was best to start a new bank account and transfer postings over? What is the easiest way to do this- and will it affect any of the other accounts? Any help gratefully received
|
|
|
Hello,
You should be be able to click on the tick box to un-check the option. I can do that on Sage Instant so Sage 50 should be the same. If, for some strange reason that doesn't work, you can open a new bank account, then go into Corrections and change the bank for the transactions on the old bank to the new a/c number. You will probably have to print off a transaction report to check that the transactions are all moved correctly. This solution will not work for any bank transfers or other transactions that have been generated as nominal journals, but you can handle them via bank transfers making reference to the original transaction. Alternatively, you can leave the original transactiions where they are, do a manual bank rec and just transfer the current closing balance to the new account.
|
|
|
Hello,
You should be be able to click on the tick box to un-check the option. I can do that on Sage Instant so Sage 50 should be the same. If, for some strange reason that doesn't work, you can open a new bank account, then go into Corrections and change the bank for the transactions on the old bank to the new a/c number. You will probably have to print off a transaction report to check that the transactions are all moved correctly. This solution will not work for any bank transfers or other transactions that have been generated as nominal journals, but you can handle them via bank transfers making reference to the original transaction. Alternatively, you can leave the original transactiions where they are, do a manual bank rec and just transfer the current closing balance to the new account.
Roz
|
|
|
Thank you for the swift reply- the unchecking is not an option unfortunatley. But I will give the correctiosn thing a go.
|
|
- Member
- Practice Licence
- 44 posts
|
The No Bank Rec option is greyed out if the account has been set up as the default for the cash register.
Goto Settings - Bank Defaults and try changing the Cash register Bank a/c Nominal code to another account number.
Paul.
|
|
|
Paul W said:
“
The No Bank Rec option is greyed out if the account has been set up as the default for the cash register.
Goto Settings - Bank Defaults and try changing the Cash register Bank a/c Nominal code to another account number.
Paul.
”
I've just seen this and am having the same problem. I set sage up as a new company in building trade, after adding in a months worth of transactions it won't reconcile. The button is greyed out so cannot reverse it. Bank defaults is set to cash register and it won't let me change it. Why would it have set this as the default being bank account 1200? Very frustrating, doesn't look like it will let me change all of my transactions in the corrections tab so I'm going to have to manually adjust them all to a new bank account. As if it hasn't taken me long enough to do just one month, I've still got another 5 to go!
|
|
- Member
- Practice Licence
- 44 posts
|
ButterflyJak said:
“
I've just seen this and am having the same problem. I set sage up as a new company in building trade, after adding in a months worth of transactions it won't reconcile. The button is greyed out so cannot reverse it. Bank defaults is set to cash register and it won't let me change it. Why would it have set this as the default being bank account 1200? Very frustrating, doesn't look like it will let me change all of my transactions in the corrections tab so I'm going to have to manually adjust them all to a new bank account. As if it hasn't taken me long enough to do just one month, I've still got another 5 to go!
”
Do you have other accounts set up besides 1200?
When I try to change the default cash register account, I get an error saying that the new account has unreconciled transactions, but if I select an account that has no transactions at all, it will allow me to change it.
Create a new cash account and try changing the default to that new account.
Paul.
|
|
|
Thanks Paul, but I've tried that, just keeps telling me that Bank 1200 has transactions and cannot be changed. I have emailed Sage but think I going to have to use a new bank account!
|
|
- Member
- Practice Licence
- 44 posts
|
ButterflyJak said:
“Thanks Paul, but I've tried that, just keeps telling me that Bank 1200 has transactions and cannot be changed. I have emailed Sage but think I going to have to use a new bank account!”
Is this the message you get?
"The bank account selected has unreconciled transactions
Before it can be used as the cash register, these transactions must be bank reconciled."
That is the message that tells you the account you have selected as the new cash register account has got transactions.
Goto the Bank section and click new, create a new account eg 1236 and select type cash account.
Now goto Bank Defaults, and change the cash register account to 1236
Paul.
|
|
|
No, I get the message "The bank account selected has been marked as not requiring bank reconciliation"
Do you know if there's a report that will export all my transaction into excel? possibly export everything, rebuild sage, correct setting and import everything back in.
|
|
- Member
- Practice Licence
- 44 posts
|
ButterflyJak said:
“
No, I get the message "The bank account selected has been marked as not requiring bank reconciliation"
Do you know if there's a report that will export all my transaction into excel? possibly export everything, rebuild sage, correct setting and import everything back in.
”
Thats the message you get when you try to reconcile the account.
After changing the default cash register you then go into account 1200 and untick the box about no reconcilitaion required.
If you want to talk on skype I can walk you through it.
Paul.
|
|
|
Paul I've tried that, but it won't let me change it, message is "Bank 1200 has transactions and cannot be changed". Seems to be a stale mate situation! I'm going to wait and see if Sage get back to me before I do anything else drastic now.
|
|
- Member
- Practice Licence
- 5 posts
|
Hi Guys..have been looking at this and there is a simple solution the entries that have been entered in the Un-Reconciled Bank account can be transferred as a balance to the NEW account that you decide to use , as a Journal . This will be your opening position.I use SAGE all the time and have found quite often that clients have not set up the banks correctly.Please feel free to contact me on my mobile above.I will talk you through the process. No need for excel sheets !! and don't panic...there is always a solution. CheersContact Kim 07581433013
|
|
|
Kim Clarkson said:
“Hi Guys..have been looking at this and there is a simple solution the entries that have been entered in the Un-Reconciled Bank account can be transferred as a balance to the NEW account that you decide to use , as a Journal . This will be your opening position.I use SAGE all the time and have found quite often that clients have not set up the banks correctly.Please feel free to contact me on my mobile above.I will talk you through the process. No need for excel sheets !! and don't panic...there is always a solution. CheersContact Kim 07581433013”
Thanks a lot Kim for your kind offer. I am aware of just doing a journal over, but I am very picky and have just started to transfer all my stuff onto sage and wanted it to be perfect!
Anyway, I did speak with Sage, appears as I have the 2011 version it's not supported anymore, the version I have I got with Ideal Schools, I can upgrade, so considering if it's worth doing the upgrade, they will then transfer out for me the data. Think I'm going to go through a demo and decide, probably is worth having a system with some sort of support for the future.
|
|
- Member
- Practice Licence
- 5 posts
|
Hi ......Support is always a good idea with any software package.....Its an Insurance policy that is just as important as your car insurance.Any major crashes.....and lost data or corruptions can cause grief in a business. I am always so surprised when my clients try to back out of not having the software support....but it has been a justified cost when things have gone wrong.I like the idea of being perfect but on occasions you sometimes have to make decisions that same time!!! In our business Time is a very valuable commodity and we have to make decisions, that do not waste time or more importantly duplicate the hard work you have already done . Good Luck with the process .Cheers Kim
|
