Bank reconciliation adjustment required

My reconciliation report shows "adjustment required" where the bank balances to book value. The same amount is an outstanding item on my withdrawls...a reversal from 2012. but my bank shows no unresolved items. How and why is this happening and how do I fix it? Help please.

Parents
  • 0

    Tjmack:

    In the reconciliation module under the worksheet folder an "adjustment required" means your Sage ledger bank account and the bank statement do not balance. If the amount you are out is the amount from a reversing entry from 2012 it would need to be ticked off as being reconciled. This should correct your problem. However, to be sure I would need to look at your Sage reconciliation. Please contact me directly to solve your issue.

  • 0 in reply to Agate

    Hi Randy,

    If I tick it off it will then say I have an unresolved amount. This is why I am so confused. It seemed going back to previous reconciliation's this adjustment should have been ticked off like you said.

  • 0 in reply to tjmack

    Tjmack:

    You may have to make a journal entry to correct the unresolved amount. Check the original adjustment and make an entry to the same accounts but in reverse.

    Otherwise give me a call.

  • 0 in reply to Agate

    It sounds like someone adjusted an entry on the bank for a period that was already reconciled. If you can do the reconciliation manually, but not on the system, you likely need to reset your bank reconciliation. Keep in mind that if you do this, you will lose ALL previous bank recs on the system, so #1 do a backup first and #2 make sure you have all the bank recs printed to hard copy or pdf before starting.

  • 0 in reply to AmyGurl

    I think that this is what needs to be done because I posted adjustment, and it still says "adjustment required" with the amount in a positive instead of negative balance when I print off the rec. Is it difficult to reset bank reconciliation? Easy to screw up? I did it once before but I don't remember much. If I can remember I just need the prior bank reconciliation to add all the outstanding cheques correct?

Reply
  • 0 in reply to AmyGurl

    I think that this is what needs to be done because I posted adjustment, and it still says "adjustment required" with the amount in a positive instead of negative balance when I print off the rec. Is it difficult to reset bank reconciliation? Easy to screw up? I did it once before but I don't remember much. If I can remember I just need the prior bank reconciliation to add all the outstanding cheques correct?

Children