Help! Discrepancy in Bank Reconciliation

My March statement opening and end balances are correct and I am showing an unresolved amount of -28,916.97 and a discrepancy of -2,553.72.  If I add both together, this equals the first payroll of 3 in April that was posted in March (money taken by bank at end of March, employees paid April 2nd).

I've never had this issue before when we encounter a 3 payroll month and it's just driving me crazy.

Any tips?

Thanks!

Stephanie 

Parents
  • 0

    Run your prior months' reconciliation reports, look for entries after the reconciliation was posted.

    As a test, uncheck 'hide corrections' and deselect everything, set the ending balance to equal the beginning balance.   The unresolved should be zero.

    If it isn't the reconciliation is broken, and you may have to clear the reconciliation data.  

    If beginning and ending are the same, and the unresolved is zero, there's an entry error somewhere and you need to find it in order to reconcile / while you reconcile.

Reply
  • 0

    Run your prior months' reconciliation reports, look for entries after the reconciliation was posted.

    As a test, uncheck 'hide corrections' and deselect everything, set the ending balance to equal the beginning balance.   The unresolved should be zero.

    If it isn't the reconciliation is broken, and you may have to clear the reconciliation data.  

    If beginning and ending are the same, and the unresolved is zero, there's an entry error somewhere and you need to find it in order to reconcile / while you reconcile.

Children