Hi Sylvie MacIntosh ,

Thanks for sharing your situation—bank reconciliation issues like these can definitely be frustrating, especially when numbers seem to shift after restarting. Based on what you’ve described (discrepancy and unresolved amounts being equal but opposite, and an unexpected outstanding balance), it’s likely that Sage is functioning as designed, but one or more entries may not be clearing as expected due to date, duplicate, or matching issues.

Here are a few things to check:

 1. Matching Discrepancy and Unresolved Values
If your discrepancy and unresolved amount are equal but opposite (e.g., discrepancy of 146.17 and unresolved -146.17), this often points to a transaction that’s either:

• been posted to the wrong bank account, or

• is missing from your reconciliation screen due to date or filter settings.

This article explains how this can occur and how to resolve it by reviewing all transactions for:

• correct posting dates

• correct GL account

• duplication or reversal

 Tip: Use the “Display Cleared Transactions” setting to double-check if anything has been cleared or reversed incorrectly.

 2. Discrepancy Zero but Unresolved Remains
If at any point your discrepancy becomes 0 but an unresolved amount is still present, this may indicate an issue with how transactions are being grouped or matched. Refer to this article for deeper steps on reconciling unresolved values independently of discrepancy.

 3. Changing Totals After Reopening
It’s not unusual for the outstanding, resolved, or discrepancy values to appear different when reopening a saved reconciliation if:

• new transactions have been entered or edited since the last session, or

• filters have reset

You can learn more in this article.

 General GAAP Practice Tip:
Make sure all adjusting entries are dated correctly and assigned to the proper bank GL account. This prevents duplication and aligns the reconciliation process with proper period cutoffs.

If you’re still using an older, unsupported version of Sage 50, keep in mind some reconciliation features or fixes may not be present, which could contribute to persistent discrepancies. If updating isn’t an option right now, manual verification using bank statements, reports by source, and the clearing status of each transaction is your best workaround.

 NOTE: When using Sage 50 2020.2 or newer, with a Sage 50 CT subscription, try reversing a single bank reconciliation before resetting all bank reconciliations.

Hope this helps clarify what’s going on! Let us know if you were able to identify the cause or if you’re still seeing the same numbers—others here might have helpful tricks to share too.

—
If this helps, please mark it as verified