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

SOLVED

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. 

  • 0 in reply to Kevin M

    Do you know how the "blank" bank code happens?? I had one appear and i can not delete it but i don't even know how it appeared. I have have the same issue as above but because of the "blank" bank code i can not run this fix, but i also can't remove the offending code. So very lost on what to do next.

  • 0 in reply to Lisa Hazlett

    There is no known cause that I am aware of... it just happens occasionally.    (If anyone knows a way to do this purposefully, please share!).

    You need to use a raw data editing tool (DFDM) to delete the blank row.  Ask whoever administers your Sage 100 for assistance, if you don't know what that means.