How come Unresolved amount can be different than Discrepancy amount ?

Question

Hi all, 
 bank reconciliation is my nightmare. This time I have a strange case as described in the Question title. Here a screenshot 
 How is that possible ? 
 Thanks, 
 Gilles

Erzsi_I · Answer

Hi Gilles Plante , 
 Thanks for reaching out. In Sage 50 Canada ank reconciliations, Discrepancy and Adjustment Required/Unresolved are calculated from different parts of the reconciliation, so they don&rsquo;t have to match. The Discrepancy typically points to an opening balance / opening outstanding mismatch, while the Unresolved amount relates to what&rsquo;s needed to bring the ending book and statement figures into alignment. 
 When you see both values (and they don&rsquo;t match), it often means something changed in the background (for example: an incorrect GL opening balance, clearing an invalid transaction, or bank reconciliation records that need repair). 
 Best-practice checks to pinpoint it: 
 
 Confirm the Statement Start/End dates and the Opening/Ending balances match your bank statement exactly, and re-check that the correct transactions are cleared (watch for similar amounts or duplicates). 
 Print the bank reconciliation detail and compare it to the General Ledger bank account for the same period to spot anything that was edited/voided after being cleared. 
 If everything looks correct but the values remain, try reversing (voiding) the last reconciliation and re-doing it. If the issue persists, run the recommended rebuild/utility step to repair reconciliation records, then reconcile again. 
 
 Helpful references: 
 
 A negative and positive discrepancy and unresolved amount in the bank reconciliation 
 Unresolved amount in bank reconciliation but the discrepancy is zero 
 How to reverse bank reconciliations 
 How to use the Database Utilities (rebuild tool) 
 
 If you can confirm whether any previously cleared deposits/withdrawals were edited, voided, or re-cleared after a prior reconciliation, the community can help narrow down the most likely culprit. 
 If this helps, please mark it as verified

Sage 50

How come Unresolved amount can be different than Discrepancy amount ?

État HTTP 400 – Requête invalide

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING