Hi Sheila H ,

Thanks for reaching out. First, ensure all transactions from your bank statements are correctly recorded in Sage 50 with the accurate dates, and that all transactions that appear in your bank statement have been cleared in Sage. If there are discrepancies or unresolved amounts, it might be necessary to reset the reconciliation to correct any incorrect entries from previous periods.

If your opening book balance is too low, it could be due to missing debit entries or too many credit entries before the start date. Conversely, if your opening outstanding is too high, it may be due to too many outstanding debit checks or not enough credit checks.

Since you’re seeing a negative discrepancy and unresolved amount, it might be useful to look at Option 5 and 7 from this article, which discusses steps to take when you have a negative discrepancy or unresolved amount.

Here are a few immediate steps you could consider:

1. Double-check your statement opening and ending balances, as well as the transaction dates.
2. If there's a discrepancy or unresolved amount, attempt to locate the source of the error by reviewing the transactions preceding the current reconciliation period.
3. Consider using the 'Rebuild' option in the Support Utilities if there's a potential data corruption (as advised by this article - option 3).

It's crucial to remember that adjustments or entries to correct the discrepancy should precede the current bank reconciliation period. If the problem persists after making the necessary adjustments, you might need to reset your bank reconciliation.

If you need a step-by-step guide on resetting the bank reconciliation, you can refer to this article from our knowledge base: How do I reset the bank reconciliation?

Additionally, if after adjusting your transactions, the unresolved amount remains unchanged, it may be worthwhile to reach out to your Sage business partner or a Sage-certified accountant for personalized guidance.

If this helps please mark it as verified :)

Warm Regards,
Erzsi

Hi Sheila H ,

Thanks for reaching out. First, ensure all transactions from your bank statements are correctly recorded in Sage 50 with the accurate dates, and that all transactions that appear in your bank statement have been cleared in Sage. If there are discrepancies or unresolved amounts, it might be necessary to reset the reconciliation to correct any incorrect entries from previous periods.

If your opening book balance is too low, it could be due to missing debit entries or too many credit entries before the start date. Conversely, if your opening outstanding is too high, it may be due to too many outstanding debit checks or not enough credit checks.

Since you’re seeing a negative discrepancy and unresolved amount, it might be useful to look at Option 5 and 7 from this article, which discusses steps to take when you have a negative discrepancy or unresolved amount.

Here are a few immediate steps you could consider:

1. Double-check your statement opening and ending balances, as well as the transaction dates.
2. If there's a discrepancy or unresolved amount, attempt to locate the source of the error by reviewing the transactions preceding the current reconciliation period.
3. Consider using the 'Rebuild' option in the Support Utilities if there's a potential data corruption (as advised by this article - option 3).

It's crucial to remember that adjustments or entries to correct the discrepancy should precede the current bank reconciliation period. If the problem persists after making the necessary adjustments, you might need to reset your bank reconciliation.

If you need a step-by-step guide on resetting the bank reconciliation, you can refer to this article from our knowledge base: How do I reset the bank reconciliation?

Additionally, if after adjusting your transactions, the unresolved amount remains unchanged, it may be worthwhile to reach out to your Sage business partner or a Sage-certified accountant for personalized guidance.

If this helps please mark it as verified :)

Warm Regards,
Erzsi

Thank you so much.  I will continue to work on this and I appreciate the info. 

Sheila