End of Year Discrepancies?
For many users of Sage 300 Construction and Real Estate, December 31st constitutes the end of the financial fiscal year and January 1st starts the mad rush to close the year and tie out subledger reports to general ledger balances. And you’re wondering, “Why is my cash management out of balance?”
Common Causes of Discrepancies
Whether it’s year-end or month-end, one of the issues users may encounter is discrepancies between the general ledger and one or more of the balances displayed on the Bank Reconciliation report in Cash Management. The following information may be helpful in understanding and troubleshooting these balances:
Bank Statement Ending Balance
- The Bank Statement Ending Balance on the Bank Reconciliation report is calculated as follows: The Bank Balance on the bank account less the total of all entries with a Cleared Date greater than the Statement Date on the report.
Adjusted Bank Balance
- The Adjusted Bank Balance total calculates as follows: The Last Reconciled Balance on the bank account plus all transactions that have an Accounting Date less than or equal to the last reconciled date with a status of open (O) or cleared (C).
Register Balance as of Statement Date
- The Register Balance as of Statement Date total calculates as follows: The current Register Balance on the bank account minus all transactions with a Reference date greater than the Last Reconciled Date.
Why Balances May Not Match
If the Bank balance on the bank account is wrong, the Bank Statement Ending Balance will not match the bank statement. Also, when finishing a bank reconciliation, the task may take some time to fully complete. If users access the bank account before the Reconcile task fully completes – for instance, to immediately print the Bank Reconciliation report, the balances on the bank account may not update correctly. It’s always a good idea to check Background Tasks to confirm that the Reconcile task completes successfully before accessing reports or the register for the bank account.
Troubleshooting Bank Reconciliation Issues
When balances are incorrect on the Bank Reconciliation report, the first line of defense for users is the Sage knowledgebase. Article 64702, “Reconciling the Cash Management Bank Reconciliation Report and General Ledger,” will walk you through the various reasons balances in Cash Management may not match General Ledger and direct you to additional knowledgebase articles to help you troubleshoot your specific issue.
Before You Begin Troubleshooting
-
Confirm that you have clicked Finish in the Reconcile task for the bank account that needs fixing.
-
Use File Tools to back up the Master.CMM and Register.CMT files.
Need Further Assistance?
As always, if you need help troubleshooting if your cash management is out of balance or any other reconciliation issues, don’t hesitate to contact ETHOSystems. Or, log onto the Sage Knowledgebase or Sage City and search for more info.
This article first appeared in the ETHOSystems February 2020 Newsletter.
Need help from a certified Sage 300 CRE Consultant? Just click, and we’ll contact you in a jiff! It’s no big deal, right?
by Kyle Zeigler, Sage Senior Certified Consultant