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

  • 0
  • 1
  • Problem
  • Updated 1 month 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 Christopher Key

Christopher Key

  • 152 Points 100 badge 2x thumb

Posted 1 month ago

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

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

  • 222,622 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

  • 222,622 Points 100k badge 2x thumb
Agreed...bottom line, just remember that Quicken does NOT match using check number...if there is a correct match, it is purely coincidental if the check # matches...

SO, if you know you have more than one unreconciled transaction in the register with the same amount, be sure to check that the match is correct.

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

DHC

  • 2,036 Points 2k badge 2x thumb
Is there any possible justification for ignoring obvious attributes such as check number? I can't think of one? A "proprietary" algorithm that is incompetent seems to be a bit of a sad joke, no?
Photo of Christopher Key

Christopher Key

  • 152 Points 100 badge 2x thumb
Is there a way to mark a transaction as matched or otherwise "hide" it from the matching algorithm?
Photo of smayer97 (QM2007, CDN user since '92)

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

  • 222,622 Points 100k badge 2x thumb
@DHC agreed...it should look for an unreconciled cheque # first and only if it cannot find one THEN consider other matching transactions...
Photo of smayer97 (QM2007, CDN user since '92)

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

  • 222,622 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 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

  • 222,622 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.