Hi Cheryl S.

The following KB article may be able to help you with your issue:

Discrepancy and Unresolved are even. One is a positive and one is a negative - KB10037

Hope this helps.

Hi Keith,

Unfortunately, even after following all of the recommended fixes, the problem still exists.  I have tried doing the reconciliation again without entering the outstanding items which results in my discrepancy being $0, but gave me rather skewed numbers for resolved and unresolved. :)

Hi Cheryl S.

The resolved amount is for the cleared items.  It means the item shows up in both your book and the bank statement that you want to reconcile with.  That is OK.  

The number that you have to pay more attention is the unresolved amount.  You will need to figure out where this unresolved amount comes from.  It can be something that shows up in the bank statement but not yetentered in your book.  For example, bank charges or bounced cheques. 

As written in the KB10237 - My bank reconciliation has a discrepancy and/or an unresolved amount. (Link at the bottom from the first KB link I sent you), unresolved amount is based on the following equation:

Statement Ending Balance = Outstanding + Book Ending Balance

If they are not equal, the difference is the unresolved amount.  One of number in the equation must be incorrect.  Suggestion is to reprint the GL report of the account as of the reconciliation month.  Place it side by side with your bank statement and cross out those items that show up in both the bank statement and the report.  

Hope this gives you more direction. 

Hi Cheryl S.

The resolved amount is for the cleared items.  It means the item shows up in both your book and the bank statement that you want to reconcile with.  That is OK.  

The number that you have to pay more attention is the unresolved amount.  You will need to figure out where this unresolved amount comes from.  It can be something that shows up in the bank statement but not yetentered in your book.  For example, bank charges or bounced cheques. 

As written in the KB10237 - My bank reconciliation has a discrepancy and/or an unresolved amount. (Link at the bottom from the first KB link I sent you), unresolved amount is based on the following equation:

Statement Ending Balance = Outstanding + Book Ending Balance

If they are not equal, the difference is the unresolved amount.  One of number in the equation must be incorrect.  Suggestion is to reprint the GL report of the account as of the reconciliation month.  Place it side by side with your bank statement and cross out those items that show up in both the bank statement and the report.  

Hope this gives you more direction. 

Most of the time when there is an unresolved amount, and almost always when there is a discrepancy, the only answer is to rebuild the bank rec.

Despite the information generally provided above and in the KB article, which occasionally do work, my experience has been that there is a corruption of some sort in the bank rec. Deleting the account from the bank rec system and re-adding it, rebuilding the rec and then continuing is frequently the only answer.

You can also attempt to "fix bank rec" - this is a "back door" area that Sage's Tech Support can get you to. It may, or may not, work. If it doesn't rebuild the bank rec accurately (and it does on occasion) you will likely have to rebuild as above.