A negative and positive discrepancy and unresolved amount in the bank reconciliation

Summary

How to resolve a discrepancy and unresolved amount that cancel each other out in the Sage 50 Accounting bank reconciliation. The discrepancy and unresolved are the same amount but one is positive and the other is negative.

Cause

  • Clearing invalid transactions in the bank reconciliation 
  • Incorrect General Ledger opening balance
  • Bad records in the Account Reconciliation module

Resolution

Reverse the bank reconciliation

  1. Reverse the bank reconciliation.
  2. Verify you no longer have a discrepancy and an unresolve amount.

Run the rebuild tool

  1. Verify the opening book balance, statement opening outstanding and statement opening balances are correct.
  2. Make the necessary adjustments with your accountant for any incorrect balances.
  3. Run the Rebuild tool to fix the bank reconciliation.

Review the discrepancy and unresolved amount

  1. Review the discrepancy and unresolved amount.
  2. Make the necessary corrections.

Solution Properties

Solution ID
220924150010037
Last Modified Date
Mon Mar 31 20:00:01 UTC 2025
Views
0