Transaction not showing in reconcile
Hi --
Today I had a reconcile problem with Quicken Mac 2017 Version 4.6.8 (Build 46.19304.100). Been using Quicken Mac for many years and I've never had any reconcile issues in the past.
The problem is that one deposit transaction would not show up in the reconcile window. I entered Statement ending date and balance in the "Use Statement balance" fields and clicked "Next" but the transaction was not there. I started over several times and got the same result. The transaction DID appear in the list of unreconciled transactions that displays before clicking the "Next" button, but not in the final window (where you can click the "Clr" box for each transaction).
The transaction in question was manually entered on 1-24-18 and then matched via the "Update All Online Accounts" (transaction downloads) function on 1-25-18. The date that I entered matches the date that the transaction posted to the real-world bank account. The statement beginning and ending dates are the 1st and 31st of January, respectively.
Oddly, the "Show Details" window for the transaction says "Appears on your statement as BKOFAMERICA MOBILE 02/26 xxxxxx on 2/26/2018," and then under that, "Entered 1/24/2018" and "Posted 2/26/2018."
I got around the issue by reconciling both January and February statements at the same time, i.e., entering the starting balance of the January statement and the ending balance of the February statement. The transaction then appeared in the reconcile window where I could clear it, but I don't understand why it wouldn't display when entering the January opening/closing dates. I suspect it has something to do with Quicken's transaction matching function, but the real-world posting date was a week before the January statement closing date so unless it matched it to the wrong transaction, I don't understand why it wouldn't show within the January reconcile dates.
Anyone have any insights into why Quicken set the match date to 2/26? Is there some way to"fix" the match dates when they get out of whack like this?
Thanks in advance.
Today I had a reconcile problem with Quicken Mac 2017 Version 4.6.8 (Build 46.19304.100). Been using Quicken Mac for many years and I've never had any reconcile issues in the past.
The problem is that one deposit transaction would not show up in the reconcile window. I entered Statement ending date and balance in the "Use Statement balance" fields and clicked "Next" but the transaction was not there. I started over several times and got the same result. The transaction DID appear in the list of unreconciled transactions that displays before clicking the "Next" button, but not in the final window (where you can click the "Clr" box for each transaction).
The transaction in question was manually entered on 1-24-18 and then matched via the "Update All Online Accounts" (transaction downloads) function on 1-25-18. The date that I entered matches the date that the transaction posted to the real-world bank account. The statement beginning and ending dates are the 1st and 31st of January, respectively.
Oddly, the "Show Details" window for the transaction says "Appears on your statement as BKOFAMERICA MOBILE 02/26 xxxxxx on 2/26/2018," and then under that, "Entered 1/24/2018" and "Posted 2/26/2018."
I got around the issue by reconciling both January and February statements at the same time, i.e., entering the starting balance of the January statement and the ending balance of the February statement. The transaction then appeared in the reconcile window where I could clear it, but I don't understand why it wouldn't display when entering the January opening/closing dates. I suspect it has something to do with Quicken's transaction matching function, but the real-world posting date was a week before the January statement closing date so unless it matched it to the wrong transaction, I don't understand why it wouldn't show within the January reconcile dates.
Anyone have any insights into why Quicken set the match date to 2/26? Is there some way to"fix" the match dates when they get out of whack like this?
Thanks in advance.
0

Comments
One option to work around this if it happens again... just mark it cleared in the register before you start reconciling.
I say "rematched" because the transaction was, I assume, matched to the correct transaction on 1-25 when I ran the download/update function, which I run every day.
The only thing I can think might have happened is, maybe for some reason Quicken didn't actually match the transaction on 1-25, and maybe I manually checked the "Clr" box, although I don't recall doing that. Then when Quicken saw the deposit on 2-26, which was for the same amount, it matched the 1-24 transaction to it.
Assuming that's what happened, is there some way could I have fixed the mismatched transaction? Maybe by deleting and re-entering it? Or would that cause Quicken to eventually mismatch it to the next deposit with the same amount?
There is a preference under Connected Services about using the Posted date for downloaded transactions. Check that. I question if your reconcile was using the Posted date of 2/28 and that is why it wouldn't show up in Reconcile when using the prior month date range.
John
The primary question is why it mismatched the transaction entered on 1-24 to the transaction dated 2-26 in the first place. I run the update/download function every day (or two at most), which automatically checks the "Clr" box for all posted transactions. I can't swear to it but I think that the 1-24 transaction was matched to the correct downloaded transaction, which posted to the real bank account on 1-24, when I ran the update/download function on 1-25, which means Quickent must have "rematched" it on or after 2-26 to the wrong transaction somehow. I don't really know if that's possible, though. If not then I must have done something or other to prevent Quicken from matching it to the correct transaction.
On another note, and just so you know, your redacted Quicken ID was visible in the "New Comment" email that the Getsatistaction site sent out to me. Did you happen to notice if the info that I redacted in my picture was visible in the email you got for this thread?
I reposted my screenshot, so that is why you saw the original version. I was not particularly worried if people see my email address, but I redacted it because I know of all the fuss others would create when they saw it. I guess it is good they worry about me :-)
Yes I'll probably never know what happened, but where are these "logs" you mention?
I'm guessing the logs probably won't shed any light on things either, but I've never looked through them before so not sure what additional info they may contain.
To modify a transaction "Posting Date": right-click the transaction, hold down CTRL while left-clicking "Copy Transaction(s)". There you'll see the "Posting Date" which you can modify just like any other date in Quicken.
This does seem like a bug in QMac. The duplicate option is a workaround that doesn't have any big consequences as far as I can tell.