have reconciliation negative discrepancy -1 st time reconciling

I have recently asked about doing a reconciliation for the first time in Sage 50 accounting .Hasnt been done since 2018. I did as informed, by picking a month ,I picked oct . I have gotten it to where the outstanding and unresolved are at zero but my discrepancy is at a high negative. My opening book balance is also at a negative . it wont let me reconcile until the discrepancy is resolved . How do I resolve and does the opening book balance have something to do with it?  Am I also able to adjust/ correct the opening balance? The closing book balance is correct . matched the bank statement . I am very frustrated and at my wits end .... 

  • 0

    Hi ,

    Thanks for reaching out. Did you ever find an answer to this issue? 

    Based on our article here, if the Discrepancy is negative: This means the opening book balance is less than the sum of: opening outstandings + statement opening balance. 

    So if the opening book balance is too low, it could be that:

    • There are missing debit entries(s) preceding the start date
    • There are too many credit entries(s) preceding the start date
    • The statement start date is wrong on the bank reconciliation window

    You must find out which of the three possibilities is correct and which are not. Process of elimination is the best approach:

    • Usually, the statement opening balance is correct
    • Then you are left with either the opening book balance is too low or the opening outstandings is too high

    Make the appropriate adjustments or entries once you have found the problem

    • The entry/adjustment must precede the current bank reconciliation's period
    • You may need to reset your bank reconciliation after posting the adjustments/entries if the discrepancy is still the same

    If you have voided a receipt or payment but did not clear the credit note where you should have, then clear the credit note dated the same voided receipt date.

    Stop here unless you also have an unresolved amount in which case go to Step 3.

    If you're still needing help and are on an active support plan, we'd be happy to have the team reach out to you. Just let us know.

    Warm Regards, 
    Erzsi

  • 0 in reply to Erzsi_I

    hi Erzsi,

    I did receive an answer. I am trying to work through it ,but Im finding it a little confusing as I am still learning even though its been a few years. .I am ok with the basics . general journal  ect . 

    Thank you for asking