Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Better Transaction Matching Between Register and Downloaded Transactions

I'm trying to figure out whether there is a way for Quicken to better match transactions from the register and the back downloads. I have weekly transactions that are entered into the register, for example a weekly transfer to a joint account. But when the downloads come in, they are not matched by date. A November register transaction could be matched to a January download for the same amount. It is frustrating to have to go in a manually match so many transactions to the correct dates. I am wondering whether I have set something up wrong to cause this.

Any help would be appreciated.

Best Answer

  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    Accepted Answer
    teendoc said:
    > @NotACPA said:
    > Are you reconciling this account monthly?  Because a downloaded transaction shouldn't match to a previously reconciled transaction.It WILL however match to the earliest, otherwise identical, unreconciled transaction.
    @NotACPA:  My understanding is downloaded transactions may match previously reconciled transactions if the previously reconciled transactions have not been previously matched.
    I sometimes go a couple of months between downloading and the matching does not usually occur by the earliest identical unreconciled transaction. It can match with a transaction 1-8 weeks later. There doesn't seem to be a rhyme or reason to it.

    Also, is there a way to have Quicken not match an identical amount but a different payee, or is that just going to happen? I make a transfer to an account every 2 weeks and also pay my housekeeper the same amount weekly using Zelle. It always matches her transactions with the account transfers.

    Thanks!
    I suspect the issue may be that you go a couple of months between downloading.  I suggest you import the transactions more frequently.  In my experience, Quicken's automatic matching algorithm only matches transactions within the previous 30 days.

    If the downloaded payee/memo are unique, you should be able to use renaming rules to coerce Quicken to match the payees in the entered transactions. 

Answers

  • NotACPA
    NotACPA SuperUser, Windows Beta Beta
    Are you reconciling this account monthly?  Because a downloaded transaction shouldn't match to a previously reconciled transaction.
    It WILL however match to the earliest, otherwise identical, unreconciled transaction.
    Q user since DOS version 5
    Now running Quicken Windows Subscription,  Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • teendoc
    teendoc Member ✭✭
    > @NotACPA said:
    > Are you reconciling this account monthly?  Because a downloaded transaction shouldn't match to a previously reconciled transaction.It WILL however match to the earliest, otherwise identical, unreconciled transaction.

    I sometimes go a couple of months between downloading and the matching does not usually occur by the earliest identical unreconciled transaction. It can match with a transaction 1-8 weeks later. There doesn't seem to be a rhyme or reason to it.

    Also, is there a way to have Quicken not match an identical amount but a different payee, or is that just going to happen? I make a transfer to an account every 2 weeks and also pay my housekeeper the same amount weekly using Zelle. It always matches her transactions with the account transfers.

    Thanks!
  • NotACPA
    NotACPA SuperUser, Windows Beta Beta
    There is No Way, within Q, to adjust the matching algorithm.
    Q user since DOS version 5
    Now running Quicken Windows Subscription,  Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • teendoc
    teendoc Member ✭✭
    > @NotACPA said:
    > There is No Way, within Q, to adjust the matching algorithm.

    Okay, well I get to continue manual matching. Sigh... I just wish it would match on date and amount.

    Thanks.
  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    Accepted Answer
    teendoc said:
    > @NotACPA said:
    > Are you reconciling this account monthly?  Because a downloaded transaction shouldn't match to a previously reconciled transaction.It WILL however match to the earliest, otherwise identical, unreconciled transaction.
    @NotACPA:  My understanding is downloaded transactions may match previously reconciled transactions if the previously reconciled transactions have not been previously matched.
    I sometimes go a couple of months between downloading and the matching does not usually occur by the earliest identical unreconciled transaction. It can match with a transaction 1-8 weeks later. There doesn't seem to be a rhyme or reason to it.

    Also, is there a way to have Quicken not match an identical amount but a different payee, or is that just going to happen? I make a transfer to an account every 2 weeks and also pay my housekeeper the same amount weekly using Zelle. It always matches her transactions with the account transfers.

    Thanks!
    I suspect the issue may be that you go a couple of months between downloading.  I suggest you import the transactions more frequently.  In my experience, Quicken's automatic matching algorithm only matches transactions within the previous 30 days.

    If the downloaded payee/memo are unique, you should be able to use renaming rules to coerce Quicken to match the payees in the entered transactions. 
  • teendoc
    teendoc Member ✭✭
    Thanks, @Sherlock. I used to be better about regular downloads but it has been quite intermittent in the past couple of years. I'll see if this gets better with more frequent downloads.
Sign In or Register to comment.