Discrepancy in Bank reconciliation

I am completing our January 2014 bank reconciliation and I have a discrepancy of -297 and an unresolved amount of 297.  I know exactly what this is but do not know why it happened or how to fix.  On January 23 I posted an invoice to a supplier for $297 and on January 27 I ran the cheque for $297.  The debit and credit appear in the trade payables account and the withdrawal for cheque #19402 shows in the bank GL.  The 297 does not show on the bank reconciliation as an outstanding cheque.  I have double checked ending and starting balances for the bank and everything is correct.
Any idea why cheque 19402 for $297 doesn't show in my bank reconciliation?

  • 0

    Hi Rhonda7,

    The following article may help you to determine the reason why you have the discrepancy and unresolved.

    My bank reconciliation has a discrepancy and/or an unresolved amount. - KB10237

    If the discrepancy and unresolved amount are not valid and you have not done a reset, refer to the link of related resources: How do I reset the bank reconciliation in the article.

    Hope this helps.

  • 0

    The discrepancy indicates that the 297.00 is posted prior to the start date of your current bank reconciliation.

    Hence why it is not showing on your bank reconciliation.

  • 0 in reply to Smith and Co

    The $297 is dated January 27th the beginning and ending dates of the bank recon are January 1st and 31st respectively.  Hence that is not why is not showing up.  

  • 0 in reply to Rhonda7

    Hi Rhonda,

    It's not impossible for the data to pile up and require that you clear the reconciliation and start over.   (it's happened to me, while I was doing a reconciliation, and while in multi-user mode with others entering payments)  That's a lot of work to go to, especially if it isn't the cause of the problem.

    Try this:

    Open the reconciliation screen.   (or if it's already open, save the reconciliation)

    Put in the same amount for the ending balance, as shown in the beginning balance. 

    Make sure the box for 'Do not show corrections' is unchecked, then

    Click the 'uncheck all' button to un-clear all the transactions.  

    It should show zero unresolved.    If it doesn't, the data has gone wonky.

    If it DOES show zero unresolved, close the reconciliation window WITHOUT SAVING IT so you don't erase the reconciliation you're working on.


     

  • 0 in reply to RandyW

    Hi Randy,

    I did as you suggested and I still have an unresolved amount of $297 so I guess it looks like there's a problem with the data.  I'll be calling Sage today to see what they suggest.

    Thank you!

  • 0 in reply to Rhonda7

    One thing I didn't mention above, do make sure that you are showing corrections, and none of these are checked, either.

    The usual procedure is to 'reset' the bank reconciliation, which will remove all reconciliations from the account, and allow you to start over.  I recommend first doing the 'clear reconciliation' procedure on a saved COPY of your data, to make sure that you have found the cause of the difference  (File | Save As, use a filename like 'TEST' or 'TEMP')

    You want to be certain that the problem is with the data, or you will just end up back where you started, but without all your past reconciliations.