bank account data incorrect in both current and backup file - what to do?

livelyt

I use Quicken for Windows version R63.21 build 27.1.63.21. I update my file quarterly. Today Quicken performed an update, and when I opened the file it showed my primary checking account balance as overdrawn by -$23,652.64. This account was fully reconciled as of the 2/21/2025 statement with a balance of $7692.31. I reconcile manually after importing a .qfx file downloaded from my bank. Running the Repair File function did not correct the issue. More troubling, when I restored from the most recent backup file, dated 3/19/25, that also showed the incorrect bank balance. The running balance in this account is now incorrect going back to at least April, 2024, showing negative balances that never existed. Balances in other accounts in this file appear to be correct.

What is the best course of action?

Thank you.

livelyt

The problem was not a change in the download method or the opening balance. The file starts in 2021 and everything is fine until the beginning of 2024. At that point some transactions have simply disappeared from the register including my salary deposits. I can go back and re-enter data for 18 months of statements, but I'm afraid this file is now really messed up.

NotACPA

In the past few months, before March, did you change the download method of that account … say from Direct Connect or Express Web Connect to Web Connect (or any other variation of such)?

If so, your Opening balance might have been changed. So, see if you can restore an even older backup file (to a different name, so as to not over-write the current file) and see what the Opening Balance transaction is supposed to be.

The only other option is to pull out old account statements until you find one where Q and the statement agree and re-reconcile the account, month-by-month, to get things corrected. For this to have been the error almost always means that an "R" transaction was deleted/duplicated/changed/added because the balance in Q is a calculated, not stored, amount.

livelyt

The problem was not a change in the download method or the opening balance. The file starts in 2021 and everything is fine until the beginning of 2024. At that point some transactions have simply disappeared from the register including my salary deposits. I can go back and re-enter data for 18 months of statements, but I'm afraid this file is now really messed up.