Skip to content

x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 109 subscribers
  • Views 1151 views
  • Users 0 members are here
Browse Forums
Announcements
322
topics
380
replies
Business Object Interface
1k
topics
8k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
8k
replies
General Discussion
1k
topics
4k
replies
Partner Cloud
58
topics
118
replies
Payroll, Time Tracking, and Job Cost
817
topics
1k
replies
Reporting and Analytics
1000
topics
3k
replies
Sage CRM for Sage 100
169
topics
370
replies
Technical and Installation
2k
topics
10k
replies
Year-end Forum
95
topics
247
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!

Parents
  • +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. 

Reply
  • +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. 

Children
No Data

*Community Hub is the new name for Sage City