How do I remove old cash accounts from the system?

SOLVED

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?

Parents
  • 0
    SUGGESTED

    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. 

Reply
  • 0
    SUGGESTED

    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. 

Children
No Data