Bank Reconciliation Discrepancy

Question

Opening Balance on Worksheet is 255.02 less than the actual opening Balance in Transaction Window. 255.02 is the discrepancy. The Worksheet balance is "greyed out" and I cannot change it. I have reset the Reconciliation several times but cannot clear the discrepancy. Can anyone help? Thanks.

Alwyn · Accepted Answer

To me this is not a software problem otherwise there would have been some very loud voices on this forum and on social media looking for a response. 
 I suspect that you have reconciled the account and then gone back and made changes to amounts already reconciled. When you do this both sides of the clearing do not always get checked off ready for the next reconciliation. To watch for this I always verify my opening balance with the Unreconciled amount before I do anything else. If they do not match you will then have to look to see if a check mark is missing beside one or more entries. Every check mark already on the reconciliation must have a second check mark for the same amount, one negative and one positive. Once you are certain all checkmarks that are required have be entered then you can start to input the dates, closing balance, and comments. You are now ready to start checking off the entries required to match to your bank statement. 
 If you are using Sage 50C 2022 you can reverse the bank reconciliation one month at a time until you get back to a month that is properly reconciled with no discrepancy. If you have an older version of Sage 50 you will have to reset the bank reconciliation module. I would pick a month where you had a clean reconciliation with a report of the outstanding entries at the end of the month, This gives you a good start to reset the reconciliation as at the beginning of the next month. 
 Hope this helps

Sage 50 Canada

Bank Reconciliation Discrepancy

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING