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

Reconcile puzzle

I am seeing strange behavior that I've never observed in 30 years of using Quicken.
When I try to reconcile my Sam's Club World Mastercard account, there is an entry in the register that does not show up in the reconcile window, and the account balance is off by the amount of that transaction. I have attached screen shots of the register and the reconcile window. The transaction is Cleared but not Reconciled, and should be shown as a debit in the reconcile window. Anyone have any idea what is going on here?
Tagged:

Best Answers

  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Accepted Answer
    Turn on Downloaded posting date column.  I think you will find that the posting date for that transaction is past the reconcile ending date.  When available Quicken uses the downloaded posting date for determining if a transaction should be included in the reconcile, not the date the user has entered.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Bert Onstott
    Bert Onstott Member ✭✭
    Accepted Answer
    Thank you Chris. That worked.

Answers

  • Bert Onstott
    Bert Onstott Member ✭✭
    It's the registry entry for $82.16.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Accepted Answer
    Turn on Downloaded posting date column.  I think you will find that the posting date for that transaction is past the reconcile ending date.  When available Quicken uses the downloaded posting date for determining if a transaction should be included in the reconcile, not the date the user has entered.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Bert Onstott
    Bert Onstott Member ✭✭
    Chris - Where is that option - how do I 'Turn on Downloaded posting date column"?
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Sorry, should have included that information.

    Note you might have a gear icon, they recently changed this.
    You can also find a menu item in the top gear icon that says "Register columns...".
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Bert Onstott
    Bert Onstott Member ✭✭
    Thank you. I added that; the date matches the date I had. No surprise, as the date was downloaded; I did not enter or change it.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Look at that date again.  It is 12/28/2021
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Bert Onstott
    Bert Onstott Member ✭✭
    I did not see that. Somehow Synchrony bank sent the wrong date. Strange! Thanks.
  • Bert Onstott
    Bert Onstott Member ✭✭
    One (hopefully) last question. I can't change the downloaded date in Quicken. I can edit it in the transactions.qfx file, but the next time I update transactions, it will download another file with the 12282021 date.

    So I see no way to fix this until/unless Synchrony Bank is willing to fix the error in the transactions.qfx file. I've had no success even explaining the behavior to anyone there; much less getting them to fix anything.

    Is there a work around that would allow me to reconcile the account?
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Delete the transaction, and reenter it.   ;)

    Hopefully Synchrony Bank won't repeat the problem.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Bert Onstott
    Bert Onstott Member ✭✭
    Accepted Answer
    Thank you Chris. That worked.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Your welcome.

    BTW I thought this afterwards.  If you right click on the transaction it will give a menu and you can select Copy, and then right click again to paste it.  That will give you a transaction that is identical, but without the posting date.

    Note that the rules are use the posting date if available, if not use the one entered by the user (the main date).  And of course a "non downloaded" transaction doesn't have a posting date.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Bert Onstott
    Bert Onstott Member ✭✭
    Thanks. Appreciate the help.
Sign In or Register to comment.