Bank Reconciliation Discrepancy

SOLVED

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.

Parents
  • 0

    Did the reconciliation work properly in the prior month? If so, I would reverse the last reconciliation and redo it, this may/should correct your starting point for the current reconciliation. Check to see if there was an entry for 255.02 that was reversed (deleted) or adjusted in the past couple of months. Sometimes adjusting an entry that was already reconciled in a prior period causes a problem in the current period.

  • 0 in reply to Alwyn

    The reconciliation worked properly last month.  I did go back and redo it.  Now there is a discrepancy of 4.91.  I have redone it twice with the same amount.  I tried putting 4.91 in as an adjustment through the General Journal.  No discrepancy shows, however error message says that the starting and ending balances are not correct.  Over the years, I have had to reset the Reconciliation, but it always worked the second time.  Any ideas?

  • 0 in reply to JTaylor

    It sounds like you have a second processing problem for a new amount. Was there a missed entry when resetting the bank reconciliation that was not brought forward or it was brought forward and should not have been. Again you will have to check your entries to see if there is one for $4.91

  • 0 in reply to Alwyn

    There are two entries that should have cleared the month before (they cleared when I did that reconciliation) but now show as uncleared.  The amounts of those are 50.95 and 1.00.  None of the discrepancy amounts that have popped up make sense.  I have checked back for the entire year and the discrepancy amounts keep changing (70.81, 184.22 and 255.02) and there are no entries for those amounts.  (small company, not too many entries)  I am wondering if this is a software problem as these statements balanced when I did them.

  • +1 in reply to JTaylor
    verified 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

Reply
  • +1 in reply to JTaylor
    verified 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

Children
No Data