JohnA" wrote
Quicken does not see some check numbers as such even though they are within the expected box in the register. This has the following side effects:
1) Ordering the register by check number will exclude them from the expected sequence.
2) The missing check report will not list them.
This can be bypassed by rewriting the check - in my case, I added a character to the memo field and then deleted the character. After doing that, the check shows up in the proper sequence. I suspect this is an artifact from my original Money conversion. Since I have too many checks to do this manually, it would be nice if at least there was there was a way I could do this in one operation for the affected check range. Doing a validation/repair has no effect. Any ideas?
-----------------------------------------------------------------
I don't believe Quicken has any feature that would address the issue directly.
You could try right-clicking one of the problem transactions, selecting "Cut transaction(s)", then right-clicking in the register and selecting "Paste transaction(s)". If that cures the problem for that one transaction, you can select all the problem transactions (as you would select multiple files in Windows Explorer), then Cut and Paste them.
If that fails, you can try this:
1.) Backup
2.) Create a new (temp) account in Quicken.
3.) Cut the problem transactions from the current account and Paste them in the temp account.
4.) Export the temp account to a QIF file.
5.) Import the QIF file into Excel using the free Excel AddIn, "xl2qif". (Google for it).
6.) Make sure the check# column is formatted as numeric
7.) Export from Excel to a QIF file, using xl2qif
8.) Use the instructions in the following FAQ to import the QIF file into the desired Quicken account.
formatting link
9.) Delete the temp account from step 2.