Hi Christopher,

 

In the Bank Record > Account Details tab, the No Bank Reconciliation check box may not be available. This occurs when the bank account is set as the cash register account in Settings > Bank Defaults.

 

To resolve this you’ll need to follow one of these options:

 

• If the bank account is the cash register account, you can't clear the No Bank Reconciliation check box. This is because the cash register account doesn't need to be reconciled.
• If the bank account isn't the cash register account, select the correct account from the Bank A/C drop-down list in Settings > Bank Defaults.
• If you can't change the bank account, create a new bank account and transfer the balance across, either as one reconciled balance or as individual items if reconciliation is required. If this isn't possible the data can be submitted for repair but the time taken for this should be weighed up against the time taken to create a new account manually

 

Full info on how these steps here.

Regards,

Paul
Sage GB

Hello Paul

Implemented create new bank account.

Is there a video covering this - Tip: If there are individual transactions on the Cash Register account that need to be bank reconciled, these need to be transferred individually and given the date of the original transaction or you can amend the bank account in File > Maintenance > Corrections. Ideally I would like to just transfer all the data from the old account to the new account.

My second question. How entered the wrong opening balance for a bank account. What is the best way to rectify this issue.

Thank you.

Hi Christopher,

There isnâ€t currently a video available to help to set up a new bank account and transfer the balance, however you can follow these steps:

1. Bank accounts > New/edit drop-down > New > enter a new bank A/C Ref > enter a new Nominal Name, for example New Bank Account > Save.
2. Bank accounts > Bank transfer > enter the bank account to be debited from > enter the bank account to be credited to > enter the date of the transaction > enter any details > Save.

Tip: If there are individual transactions on the Cash Register account that need to be bank reconciled, these need to be transferred individually and given the date of the original transaction or you can amend the bank account in File > Maintenance > Corrections.

3. Bank accounts > open the original cash register account > change the Nominal Name to Old Cash Register > Save.


To correct a bank opening balance entered incorrectly, you must reverse this before you can post the correct opening balance. To do this you can reverse a reconciled opening balance by entering the opposite transaction to the original opening balance, using the same reference and date:

1. Bank accounts > select required account > New/edit drop-down > Edit > OB.
2. Enter the reference and date of the original opening balance.
3. Enter the required value in the Payment or Receipt box > Save > Save > Close.

You can then enter the correct opening balance.

Regards,

Paul
Sage GB

Hello Paul

Thank you for reply. I think Sage should think about producing a video for this.

Regrettably I'm still very, very confused. I'm assuming you are suggesting each transaction has to be re-entered? Does the transfer remove the transaction from the old account and into the new account plus linked transactions entries for example a customer payment or supplier payment? I'm assuming the transfer reduces the old account balance accordingly.

File>Maintenance>Corrections amend bank account even more lost no option whatsoever please see one drive image. onedrive.live.com/redir

Bank opening balance. Incorrect opening balance figure enter in receipt or payment. The correct opening balance in payment or receipt. onedrive.live.com/redir

Best regards

Hi Christopher,

When you create the new account, you can either re-enter each individual transaction or start with an opening balance for the value of all the transactions.

When you post a bank transfer it wonâ€t remove the transaction on the old account. The transaction remains on the account but the balance is transferred.

If youâ€re using v21 or above the options to Edit or Delete transactions are now located in the Transactions module. Go to Transactions > select the required transaction > Edit to amend the bank account

When correcting an opening balance, you need to post a receipt or a payment for the value that you need to correct the balance by.

For example, if the opening balance should be £5000 but you entered £50000 by mistake, you would need to post a payment of £45000 to get the correct opening balance of £5000.

If the opening balance should have been £5000 but you entered £500 by mistake, you would need to post a receipt of £4500 to get the correct opening balance of £5000.

I hope this helps Christopher.

Thanks,

Brian

Hello Brian

Thank you for your reply.

Apologise for delay in responding.

From your explanation I understand the how.

The process seems to be rather a laborious process for what appears to be on the face of it, a relatively easy requirement need to be able to initiate account reconciliation function. Perhaps a capability, software developers might like to add to the next software release. Users will make mistakes consequently it is essential solutions to operator errors need to be easy for workers to implement i.e. a few clicks and very little else.

In my case itâ€s probably better to not bother and just start using the new account. Iâ€m assuming my challenge will be producing financial end of year closure of accounts.

Best regards
Christopher

Hi Christopher,

Thanks for your suggestion. You can log this on our Ideas board here to help improve our Sage Accounts software.

To log your idea select Sage 50 Accounts and then Submit an idea.

Once logged, we’ll be able to use your idea and help us to shape your Sage software. Other customers will also be able to vote on your idea.

I have the same problem, however my account is set up as a cheque account. I cannot change the account in the bank default because the bank a/c is greyed out and has no drop down. I am reconciling a whole year of entries, so transferring to a new bank account or editing each entry isn't an option. Any suggestions. Also what happened to good old fashioned phone support???