How do I remove old cash accounts from the system?

Question

I am the new CFO for a company that has been using Sage CRE for 15+ years. I started to use the Reconciliation Dashboard to close my first month and noticed there are a number of cash accounts in the system that have not been used for years. They are incorrectly showing balances in Cash Management but the GL correctly shows them at $0.00. How do I remove the balances in cash management and delete these accounts?

Jesse Gordon · Accepted Answer

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!

MHmvenus · Answer

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.

Angel Goldman · Answer

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.

Sage Construction & Real Estate

How do I remove old cash accounts from the system?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING