Hi Bryan,

Instructions for deleting old bank accounts can be found in our knolwledgebase at ww.sageKB.com:

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=17408

Hope this helps!

I was able to locate that KB article, but I can not delete bank accounts that have balances from cash management.  I guess I have a more serious issue.  For example, there is an account that has not been used in a decade that is showing a balance of ($208,910.27) in cash management while the general ledger shows the accurate amount of $0.00.  

How do I get the balance of this cash account to $0.00 in cash management without changing any other accounts, so that I can then delete the cash account?  Like I mentioned before, I am new to my company and sage.  I have no idea how CM and GL could be so far off for so long.

Hi Bryan,

If your company has an active support plan, you can call in to support and have someone look at the bank with you to determine the best way to clear the balances.

You may also want to contact your certified Sage consultant for assistance with larger scale clean up, archiving and reconciliation to make thing more efficient in the software.

If you message me your account number I can look up your consultant and support plan for you.

Thanks!

Bryan,

I had a similar situation about 10 years ago but you need to know your system well. It happens, because people neglect CM and worry about the GL and Fin Statements. Some don't know that Sage 300 has certain rules i.e. all AP related transactions should go through AP, all AR through AR and Billing, all Cash through CM - like the control accounts. You have "Accountants" coming in and entering a number of AJEs to balance books or you have a module assigned to a person that has no idea how to manage it.

GL JOURNAL ENTRIES DO NOT POST TO CM.

You could turn off the interface between CM and GL (in CM) and do what you need to do in either CM or GL and then turn it back on. File\Company Settings\CM Settings\Posting & Interface settings. Then enter a CM entry with a certain date for the ($208K) under that bank account and you could use "clearing" account to offset. Make sure it is not carried over to GL ( I would have turned the GL posting to manual so that it stays in the NEW GL file and an option to rename it).  Then go to CM and open reconciliation and click the one transaction for the positive 208K and the bank balance will be zeroed out. GL should be fine as the transaction is not reflected there. You have to make sure that the date of the entry and reversal is the same to not mess up fin statements. Hope this helps.

Excellent advice Angel !

Thank you very much for the advice.  I think I am going to use our support plan for this one.  I'm still to new to Sage to attempt this one alone.  Going to be a learning experience.  Thanks again.

I had a very similar issue when I first took over as controller.  Items posted to a bank account via Direct Job Cost entry or GL entry do not show in the Cash Management reconcile screen which causes the balances in these screens to be different from the GL balances.  I did correcting entries in the CM module and then reversed the entries in the GL entry.  This caused the GL balance to not be changed but provided an adjusting entry in CM that I could clear against.  Once corrected, this can be prevented by processing all DJC and GL type bank related entries through a suspense account.  For instance, refunds that I deposit but want to be applied to job cost, are posted as a deposit that credits the suspense account, and again in DJC with a negative DJC and debit to the suspense.  Hope this helps.