QBO Reconciliation Issue After Prior-Year Reconciliations Were Completed
I'm hoping someone can provide guidance before I make things worse.
A CPA firm reconciled my FHB Checking account through December 31, 2024, and the December reconciliation showed a $0 difference. After year-end, I had to make corrections involving a previously closed/reconciled period and now I'm attempting to reconcile January and February 2025.
In the January 2025 reconciliation, I'm seeing transactions from October and November 2024 appearing in the reconciliation window that should not be there. Specifically, I have transactions totaling $18,000 ($5,000, $10,000, and $3,000) that appear to be related to another bank account (BOA), yet they are showing in the FHB Checking reconciliation screen. [8.31.26 1 | PDF]
I also know that some historical deposits were deleted while correcting prior-year issues. These changes occurred after the CPA completed the 2024 reconciliations.
Current symptoms:
- December 2024 reconciliation completed successfully by CPA with no discrepancy.
- January 2025 reconciliation shows an $18,000 difference.
- When I select certain historical transactions, the difference changes but does not reconcile to zero.
- After working through February 2025 and verifying debits and credits against the bank statement, I still have an unresolved difference (currently about $4,390.96).
- The Reconciliation Discrepancy Report is showing historical transactions from 2024. [8.31.26 1 | PDF]
My questions:
- If reconciled transactions were modified, reassigned to another bank account, or deleted after a prior year's reconciliation was completed, can they reappear in a later reconciliation window?
- Should I be trying to correct the underlying historical transactions or using a reconciliation adjustment/journal entry?
- Is my best course of action to have the CPA undo/review the January 2025 reconciliation and repair the historical changes before proceeding with the 2025 reconciliations?
- What reports would you recommend to identify exactly which historical changes are affecting the January 2025 beginning balance?
My concern is that if January is not corrected properly, every subsequent month in 2025 will inherit the problem.
Thanks in advance for any suggestions.