Resolving Incorrect Register Balances in Sage 300 CRE Bank Reconciliation Reports

Resolving Incorrect Register Balances in Sage 300 CRE Bank Reconciliation Reports

Summary


A potential cause for the mismatch between the General Ledger (GL) and cash register balances in the Sage 300 CRE bank reconciliation report might be due to errors in accumulating amounts in the cash paster file, here's how to resolve it:
  1. Log into Sage 300 CRE as a user that has Application Administrator permissions.
  2. Navigate to CM>Reports>Reconciliation>Bank Acct. Balance Verification, select Register option, then click Preview.
  3. Scroll to the page that shows the account with the discrepancy.
  4. Look for the amounts under the Variance column (see the red markers below). If the wrong accumulation is the reason for the discrepancy, the amount under the Variance column should equal the discrepancy on the Bank Rec. report.
  5. Make note of values under "Derived..... Balance" columns (highlighted in yellow in the example below).

  

6. Go to CM>Tools>Options, check the "Audit Setup Activity" checkbox, then click OK.



7. Navigate to CM>Setup>Bank Accounts, select the bank account in question.
8. On the General tab, overwrite values under Register Balance and Bank Balances box to match the value under Derived Register and Derived Bank Bank Balance on the Balance Verification report (refer to step 5).





9.  Go to the Totals by GL Cash Acct tab.
10. Overwrite amounts under Posted (CM) Balance to match the Derived Posted CM Balance value from Bank Verification report (refer to step 5).




11. Re-run CM>Reports>Reconciliation>Bank Acct. Balance Verification, select Register option, then click Preview.
12. Verify that the Variance column is now reading zero.
13. Re-run your bank reconciliation report and verify totals.
14. IMPORTANT: Go to CM>Tools>Options, and un-check the "Audit Setup Activity" checkbox, then click OK.


    • Related Articles

    • QuickAim Manuals for Sage 300 CRE

      We have attached QuickAim Manuals to this article for your convenience. Here is a brief overview of what each manual covers: See the Attachments section to download the correlating manual QuickAim Core - (AB AP CM GL IA PR TX) Address Book Accounts ...

    • 2024 Year-End | Sage 300 CRE & Sage 100 Contractor

      Prepaa4rations for Year-nd Sage It’s that time again! Calendar year 2024 is wrapping up and 2025 is about to start. That means the Sage year-end software upgrades are just around the corner, and we’re here to help make that as smooth a process as ...

    • Resolving Aatrix Error When Generating Certified Payroll Report in Sage 300 CRE

      Issue Users of Sage 300 CRE version 23.1 may encounter a termination error message when attempting to generate any certified payroll report in Sage 300 CRE Payroll, under Tasks, Federal eFile and Reporting, or State eFile and Reporting. The error ...

    • What is a Sage 300 CRE System Review?

      Our Sage 300 CRE System Review is a comprehensive review of your system over the course of five, 1.5 hour sessions. Our team will provide you with quick wins and best practices, along with final recommendations throughout. *Please note that System ...

    • Configuring Bank Feeds in Sage Intacct

      Configuring bank feeds in Sage Intacct can streamline your financial reconciliation process significantly. In this tutorial, based on Mike Baio's comprehensive course, you'll learn how to set up and use Sage Intacct bank feeds effectively. ...