Hi Mitch6810,
Thank you so much for your post and my apologies for the late response. There are a couple of potential reasons for the unexpected imbalance in your bank reconciliation. It could be due to a deleted transaction that was previously reconciled, or there might be some minor file damage.
To troubleshoot, I recommend starting by running today's Reconciliation report with the date of your November reconciliation. Compare this with the reconciliation report from November. If they don’t match, try going back a couple of months and repeating the process.
Comparing these reports will help identify previously reconciled transactions. When a reconciled transaction gets deleted, it disrupts the balance from that point onwards, affecting subsequent reconciliations.
While it might involve more than one transaction, begin by cross-checking the reports to find a matching point. Once you identify that point, the missing transaction should appear in the next reconciliation. This process should help pinpoint and resolve the discrepancy. Please check this help article for more information about: Resolving out of balance bank reconciliations
Feel free to post again, we're happy to help!
Regards,
Earl