Incorrect balances imported from Q2007 file

Antonio27

I have signed up for and paid for Q2019 subscription and I received an email saying that my Q2007 would not work after the next Apple OS update — 64bit.
I checked that my Q2007 file was up to date, closed it and then used the Q2019 to import that data. The best option appeared to be the Q2007 in the list of options. I selected the file and all looked OK except for 3 accounts that had substantially incorrect balances. A phone call to service provided little help.

jacobs

@Antonio27I'd focus on getting your Quicken 2007 account back in order, and then once you have that as a reference you can rely on, you can go back to trying to import your 2007 file into Quicken 2019.

You didn't answer whether you did what @smayer97 suggested: re-indexing your Quicken 2007 data file. Quicken 2007's database is notable for corruption that can make chunks of transactions seem to disappear, or show up out of order, and re-indexing cures most of those ills. I'd suggest re-indexing, and even if you did it before, do it again. This brings things back to normal most of the time.

If the account balance in your checking account is still way off, start hunting for the cause. Scroll through somewhat quickly to see if you see transactions pretty much continuously back to the beginning of the account, and that there isn't a chunk of time that disappeared. Is there a $300,000 adjustment that jumps out anywhere? Then start looking for where the balance goes haywire, using a half-interval method: let's say you have 20 years of history in your account. Jump back to about 10 years ago, and see if the balance looks plausible. If so, move about five years forward and again check to see if the balance is plausible. Continue jumping about halfway between where the balance seems okay and where you know it's bogus, and see if you can find a "smoking gun" transaction that's causing the problem. Another approach, if you have years of bank statements on file: Pull out your last bank statement each year and compare to the Quicken account balance on that date, to figure out where things were correct and where they went wrong.

smayer97

Have you tried re-indexing your QM2007 file before performing the import? With the QM2007 data file open, simply press CMD-OPT-B. A dialogue box will open telling you the index is being rebuilt. See if that helps.

Antonio27

Thank you for taking the time to respond. Sadly, not only is the 'new' subscription file a mess with incorrect data but now, for some terrible reason my Quicken 2007 file is also full of errors . . . nice to see $307, 296 in my checking account but the reality is truly well under ten grand!
Just about ready to pull out what little hair I have left.

jacobs

@Antonio27I'd focus on getting your Quicken 2007 account back in order, and then once you have that as a reference you can rely on, you can go back to trying to import your 2007 file into Quicken 2019.

You didn't answer whether you did what @smayer97 suggested: re-indexing your Quicken 2007 data file. Quicken 2007's database is notable for corruption that can make chunks of transactions seem to disappear, or show up out of order, and re-indexing cures most of those ills. I'd suggest re-indexing, and even if you did it before, do it again. This brings things back to normal most of the time.

If the account balance in your checking account is still way off, start hunting for the cause. Scroll through somewhat quickly to see if you see transactions pretty much continuously back to the beginning of the account, and that there isn't a chunk of time that disappeared. Is there a $300,000 adjustment that jumps out anywhere? Then start looking for where the balance goes haywire, using a half-interval method: let's say you have 20 years of history in your account. Jump back to about 10 years ago, and see if the balance looks plausible. If so, move about five years forward and again check to see if the balance is plausible. Continue jumping about halfway between where the balance seems okay and where you know it's bogus, and see if you can find a "smoking gun" transaction that's causing the problem. Another approach, if you have years of bank statements on file: Pull out your last bank statement each year and compare to the Quicken account balance on that date, to figure out where things were correct and where they went wrong.