Manually Match Transactions does not show all unmarked transactions

Geoff Stuart

Self-explanatory. July 1 transaction in Register does not appear in Manually Match window. Why not?

[Attachment removed - QS]

Sherlock

I suspect the 7/1 transaction displayed in the register may have already been matched to an imported transaction.  To confirm, I suggest displaying the Downloaded Posting Date column: open the register, press Ctrl + Shift + N, select Register columns..., check Downloaded Posting Date, and select Done

Note:  The 5/1 transaction in the register is not matched

Chris_QPW

Given that your 5/1 transaction has never been matched, and the 7/1 is (because it isn't on the list) what I would do is match it with the 5/1, more to get the 5/1 off the list than any other reason.

This might seem "wrong", but let's examine what is really going on during the matching.

First the information in the downloaded transaction is being merged with the transaction in your register.
Second it marks the transaction cleared.
Third it is marking that existing transaction in the register as matched so that future downloaded transactions won't try to match to it.

In reality in this case for the first part the existing transaction has all the details, and the downloaded transaction adds no more information other than knowing that the transaction has cleared the bank.  For the second part you can clear the transaction manually either in the register or while doing a reconcile.

And for the third part matching to the 5/1 will get it off of the list so that it doesn't cause problems.  I think these days the manually match only has a 90 day window, but it certainly won't hurt anything to get the 5/1 off of the list.

Geoff Stuart

Done, thanks for the assistance.

Chris_QPW

You posted a PDF with a discussion on a recipe.

Geoff Stuart

Sorry about that. SnagIt is always dumping my saved files somewhere I'm not expecting. Here is the correct file illustrating the problem.

Geoff

Sherlock

I suspect the 7/1 transaction displayed in the register may have already been matched to an imported transaction.  To confirm, I suggest displaying the Downloaded Posting Date column: open the register, press Ctrl + Shift + N, select Register columns..., check Downloaded Posting Date, and select Done

Note:  The 5/1 transaction in the register is not matched

Geoff Stuart

@Sherlock, I appreciate this info. I did not know abut the columns you suggested. I had a lot of trouble setting up this mortgage (four calls to four different phone reps, took 60 days to figure it out). I have no trouble believing that all the screwing around with these payments is what caused the downloading info to go haywire.

So I gather that Q looks at these columns to determine whether to display the trans in the Manually Match window, and it will disregard whether there is an entry in the Clr column?

Thanks,

Geoff

Sherlock

Geoff Stuart said:

@Sherlock, I appreciate this info. I did not know abut the columns you suggested. I had a lot of trouble setting up this mortgage (four calls to four different phone reps, took 60 days to figure it out). I have no trouble believing that all the screwing around with these payments is what caused the downloading info to go haywire.

So I gather that Q looks at these columns to determine whether to display the trans in the Manually Match window, and it will disregard whether there is an entry in the Clr column?

Thanks,

Geoff

I can not say which field Quicken is using to determine that the transaction is not eligible to be matched but the only way to set a value in the Downloaded Posting Date column is to accept an imported transaction and Quicken does not use the Clr column for this purpose.

Chris_QPW

Given that your 5/1 transaction has never been matched, and the 7/1 is (because it isn't on the list) what I would do is match it with the 5/1, more to get the 5/1 off the list than any other reason.

This might seem "wrong", but let's examine what is really going on during the matching.

First the information in the downloaded transaction is being merged with the transaction in your register.
Second it marks the transaction cleared.
Third it is marking that existing transaction in the register as matched so that future downloaded transactions won't try to match to it.

In reality in this case for the first part the existing transaction has all the details, and the downloaded transaction adds no more information other than knowing that the transaction has cleared the bank.  For the second part you can clear the transaction manually either in the register or while doing a reconcile.

And for the third part matching to the 5/1 will get it off of the list so that it doesn't cause problems.  I think these days the manually match only has a 90 day window, but it certainly won't hurt anything to get the 5/1 off of the list.

Geoff Stuart

Done, thanks for the assistance.