Problem with Reconcilliation

In my experience, if "Resolve" is available at all, you can get it by unreconciling a transaction, then initiating a Reconcile. Otherwise, the only remedy I found was to unreconcile all transactions, then initiate a Reconcile up to the last known statement balance. (You could re-reconcile for each previous statement, but that could be very cumbersome and time consuming and I could not find any justification for spending that time).

John, thanks for the advice but no luck so far.

I tried unreconiling a transaction but that did not give the resolve function.

I then made a copy of my fileset. I then validated the copied file. It found 1 transaction in the QSD where the splits had been removed. I corrected that transaction. There were also 51 errors in the QEL file where it said there were payments removed that were not in the register. Is the QEL file for online payments?

I tried reconciling the account by changing all the reconciled tranactions to cleared. When I do the reconcilliation it is off by the same amount as before when I reconcile to the current statement. I then tried reconciling to last months statement and I am still off by the same amount. I then reconciled to a statement that is from about 4 years ago. It is still off but by a smaller amount.

Do you think I had 51 transactions deleted somehow?

Any futher advice or suggestions would be helpful.

Kev> Kev>

I believe the QEL file is related to online activities, but I do not know enough to clarify what happened here.

Unless you are finding that Quicken's math is incorrect, I think this indicates that you have some missing or incorrect transactions.

Could be, but not sure it is helpful to know, especially if there are no specifics on which transactions were involved.

I have only had one or two problems with old reconciles becoming unreconciled and, in my recollection, they were solved by simply re-reconciling all transactions: that is, my data was correct, the reconciliation totals were wrong. In your case, it sounds like your data is wrong.

I would start at the beginning (as far back as you can go anyway) and reconcile until there is a discrepancy; noting what is wrong, then moving on to subsequent reconciles until you find another discrepancy. Perhaps a pattern will reveal itself; then you might go directly to, and fix, the missing/incorrect transactions, after which one final reconciliation of remaining transactions might finish the job. If no pattern appears, all I can think of is to re-reconcile each statement to the present (I don't like the idea of trying to enter a single adjustment sometime in the distant past that would make the current balance correct ... it would mean the balance on most dates would still be wrong).

Thanks! That is what I was going to try next. I had to dig up statements since 1998.

Kevin Allen

John Pollard wrote:

John thanks for the suggestion on re-reconciling.

I found two transactions entered as balance adjustments -- which I know I never entered. Once I deleted those I was able to reconcile without any other issues.

I checked the copy of the file set I made before the validating the files set and the balance adjustments were already in the check book register. Once I deleted them from there I was able to reconcile that file set too.

I think I should use the copy of the file that I validated and then super-validated. The validation found 1 record in the QSD file that lost the splits for the transaction and 51 records in the QEL file that were removed because there was not a matching transaction. The super-validation did not find any additional errors. What is the likelihood that I still have some corruption in my database? The date for the balance adjustments entered into my check book were both before the transaction that was corrected by the validation.

I have been having some minor problems when downloading transactions from my Bank and one of my credit cards. The problem with my bank is that periodically (every few months) it will download records that I have already downloaded. My credit card uses web connect. If I use the default date range it downloads transactions I have already downloaded. This did not use to happen but has been doing it for about 9-12 months now.

I also have some Online payments that have a lightening bolt next to them even after the records have been cleared or reconciled. Most of the records that have been cleared/downloaded do not have the lightening bolt. Could this be the records with the problem in the QEL file? Will Quicken try to make these payments with the lightening bolt again?

I have prefer to keep my data from previous years so I have not done the year end function since 1995.

I am using Quicken 2004 with Windows XP Home.

Thanks!

Kevin Allen

Kev> Thanks! That is what I was going to try next. I had to dig up

I have never known Quicken to enter an adjustment without asking, but I suppose stranger things have happened.

I would.

I don't know the answer to that.

I don't know.

I don't know, but I don't think so. I hardly ever use online payments, but I have done a few online "transfers"; the only one reconciled so far continues to show the lightening bolt. I have no idea whether retaining the lightening bolt is according to design or not; but that transaction has not caused a duplicate transfer ... its transaction date is back in July of 2005.

I have never done a Start New Year, and do not plan to do so unless I am somehow forced.