How do I get Quicken Mac to stop matching the wrong transaction?

  • 1
  • 2
  • Problem
  • Updated 2 months ago
  • In Progress
Quick Mac 2017 is matching a check transaction to the wrong check number.  A previous problem caused one of my checks to not be downloaded or otherwise lost.  It's on the bank side, I can see it if I pull a file down manually, but it never cleared in Quicken.  I had to manually add it and manually clear it myself.  That transaction is now 3 months old.  New checks entered (same provider, amount, etc) are not matched when downloaded, but this earlier "unmatched" but marked cleared transaction is matched.  I have to manually reject the match and manually drag-match the correct transaction.

Thoughts?
Photo of crkey

crkey

  • 306 Points 250 badge 2x thumb

Posted 9 months ago

  • 1
  • 2
Photo of smayer97 (QM2007, CDN user since '92)

smayer97 (QM2007, CDN user since '92), SuperUser

  • 274,086 Points 100k badge 2x thumb
I have yet to see ANY criteria definition of how Quicken performs its record matching...what I can share are some of my observations over the years...
  • check number does not seem to matter
  • date does not seem to matter, except that if the transaction date and the posted date are too far apart, if often fails to match...
  • payee/description does not matter
  • even when date, amount, payee and check # all match, Quicken sometimes still fails to match
  • if you have multiple entries with the same amounts, Quicken will often match to the wrong ones, requiring un-matching and re-matching.
So, my conclusion is that it seems the main (and possibly only) criteria is the amount and if the posted date is within some unknown date range...

The only thing you can do is perform manual matching by dragging one transaction over another whereby Quicken is suppose to "learn"...

But even that, I suspect is just building a rule set similar to the "Smart Payee" feature in QM2007 or renaming rules in QWin...but this is all a mystery, as there is no documentation on how it all works.

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
Photo of smayer97 (QM2007, CDN user since '92)

smayer97 (QM2007, CDN user since '92), SuperUser

  • 274,086 Points 100k badge 2x thumb
@Christopher Key No...the only way to prevent a transaction from being considered for matching is if it is already matched to something.

(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
Photo of Randy Hubbell

Randy Hubbell

  • 64 Points
This is an EPIC QUICKEN FAILURE....Ive wasted so much time dealing with mismatched check numbers. Quicken: get your stuff to together or get out!
Photo of jacobs

jacobs, SuperUser

  • 92,158 Points 50k badge 2x thumb
Not to add to your frustration, but... complaining here probably won't do any good. The Quicken developers generally don't read all the comments on this forum. A better way to register your frustration with what's going wrong and why it's such a pain is to use the Report A Problem feature, which you can find under Quicken's Help menu. You won't get a personal reply, but at least your comments will be seen by a member of the Quicken for Mac team. (Try not to rant,  and be clear about how specifically things go wrong.)
Photo of Rick Gumpertz

Rick Gumpertz

  • 2,434 Points 2k badge 2x thumb
Given that this is the official "community" for Quicken, one might think that somebody at Quicken should be assigned the job of monitoring this forum and submitting to the developers any complaints that can be determined to be legitimate bugs or requests for improvement.
Photo of jacobs

jacobs, SuperUser

  • 92,158 Points 50k badge 2x thumb
I am only trying to tell it like it is. They brand this as a "community" forum, meaning it's primarily for users to talk with fellow users. They do have a few moderators who maintain order and answer a limited number of questions, but they are not the same as Quicken Support. Occasionally, a member of a Quicken team posts here (like Mac product manager Marcus when there is a new release). we've been told that some topics here do get passed along to others at Quicken (I'm not sure by whom; possibly the moderators?), but what I'm stating is that it's not reliable to expect that a complaint posted here will be read and acted on by one of the Quicken staff.

I think this is a somewhat goofy layer of support for a product, and if it were up to me, I'd integrate this with their official Support, and/or assign someone to categorize and heat map topics, problems, complaints etc. -- but that's not the way they have decided to implement things. And, of course, posting here that this doesn't make sense to you or to me is not likely to be read by Quicken management. ;)
(Edited)
Photo of EdJ

EdJ

  • 80 Points 75 badge 2x thumb
I'm attempting to switch from Quicken for Windows to Quicken for Mac and the reconcile process is my major stumbling block.  In the Windows version it just worked flawlessly.   What took me a minute in Windows now takes me 5 to 10 minutes in the Mac version.  It would be nice if the two teams talked to each other and learned how to make this easy.
Funny...I find the reconcile feature in Quicken Mac 2017 far easier and simpler to use than in Quicken Windows 2017 (or previous versions).

I enter in the ending statement date and the ending balance.  Bingo.  Done.  
Photo of smayer97 (QM2007, CDN user since '92)

smayer97 (QM2007, CDN user since '92), SuperUser

  • 274,086 Points 100k badge 2x thumb
I enter in the ending statement date and the ending balance.  Bingo.  Done. 
That statement is a great oversimplification and assumes a lot...as for this thread's context, there are lots of errors matching transaction that I often have to correct.