x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 110 subscribers
  • Views 430 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
Mikayla M.

Bank Reconciliation - Beginning Balance Changed from Ending Balance of Previous Month

SOLVED
Posted By

Hello everyone,

I am trying to reconcile one of our accounts in Sage 100 and when I am in the Reconcile Bank feature, it shows that there is zero difference, but when I printed the report it said that I was off. I have identified that it was the beginning balances are different from the bank statement and the bank recon by looking at the bank recap report; however, when I looked at the previous reconciliation for this account the ending balance matches the beginning balances of the bank statement. I am not sure how it was changed. How can I fix it so that the beginning balances match again so I can reconcile?

Thanks in advance!

  • 0

    First thing to try - if you have rights - Library Master/Utilities/Rebuild Sort Files - rebuild Bank Rec Sort files.

  • 0 in reply to bethbowers

    Before doing that, make sure you do not have a blank bank code.  (Running rebuild sort files for BR can corrupt things if you have a blank record in the GL_Bank table).

  • +1
    verified answer

    Thanks for your replies. Before trying it, since when going into the Rebuild Sort Files feature it said it should only be done at the suggestion of a customer rep. I had emailed a consultant to ensure I didn't change anything other than what was intended.

    His advice was to use the utility under Bank Rec called "Recalculate Outstanding Entries Totals." The summary tables were affected by environmental issues and didn't get written to properly. By hitting the utility feature it then showed the same balance on both and I was able to reconcile after entering a necessary adjustment since an entry hadn't been captured, but was cleared. 

*Community Hub is the new name for Sage City