Issues with transaction D/L - and not Matching existing and/or setting as Cleared

58kopykat
58kopykat Member ✭✭✭
This involves 2 different accounts and has been ongoing for MONTHS. I am tired of creating a test file where things work then going back to the real file for the d/l to work for one day. As you see from my screenshots. One has had a transaction d/l as cleared but hasn't marked it as cleared and the online balance knows it is cleared. The 2nd one has d/l a scheduled transaction, the name is identical, the $ amount is identical, but Q didn't match it. This happens all the time and if the transaction is cleared days after the schedule and I miss it then suddenly I'm looking at overdrafts. I have to go back to find what wasn't cleared and look to see if it really did clear. I'm beginning to think that Q needs to be replaced with Excel.

Comments

  • UKR
    UKR SuperUser ✭✭✭✭✭

    Transaction download problems with matching and adding new transactions correctly

    First please ensure that all optional settings in Quicken pertaining to recall, memorization, automatic categorization and renaming of payee names are enabled. You find those settings in Edit / Preferences / Data Entry & Quickfill and Downloaded Transactions. Additional settings can be found for the detection and processing of transfer transactions in Edit / Preferences / Transfer detection.

    Are you automatically accepting downloaded transactions into your registers?

    If you are relying on Quicken to "automagically" fill your account registers from downloaded transactions, you may run into problems. Despite all efforts by the Quicken programmers, the "Autopilot" (that's my name for the part of the Quicken program which processes downloaded transactions and converts them into new register transactions) is not infallible. For that process to work 100% of the time one would need a crystal ball because the information downloaded from the banks often is just too terse and cryptic.

    You should, at least for a while, turn off the "automatically accept downloaded transactions into registers" setting to gain better control over what is downloaded and what to do with it. Review each downloaded transaction, make changes if necessary (e.g., to get a payee name = "Starbucks" instead of "POS TRANS 070119 STARBU", "POS TRANS 070219 STARBU", "POS TRANS 070319 STARBU" or to assign a category) before you click to accept each transaction.

    Any changes you make to downloaded Payee Names are remembered in Renaming Rules.

    Any other changes you make (add/change Category or Memo text) are remembered in the Memorized Payee List.

    Next time the same transaction for this Payee comes along, Quicken should remember and give you a better new register transaction.

     

    In case you have issues with transfer transactions not being generated correctly:

    For best results manually enter transfer transactions into your register BEFORE you download transactions from the bank which contain the transfer confirmations. For recurring transfers use scheduled reminders and enter them a day or two before the due date. Be sure to use distinct Payee Names for each transfer / credit card payment to avoid confusing Quicken - memorized payee entries.
    That takes the guesswork out of the Autopilot's process. Because a correctly entered transfer transaction already exists in your account registers, the Autopilot should just match the downloaded transfer transaction to the existing one in both accounts.

     

    Where are the "Auto-accept downloaded transaction" settings?

    There are two places where this is controlled in Quicken for Windows:
     - Globally, for all accounts, in Edit / Preferences / Downloaded Transactions
     - For each account individually, the global setting can be overridden from the Edit Account Details screen, Online Services Tab. Look for blue text "Automatic Entry is: ON / OFF". Click the text to change the setting.


  • 58kopykat
    58kopykat Member ✭✭✭
    edited March 2021
    1st - I've been a Q customer for over 20 years
    2nd - "First please ensure that all optional settings in Quicken pertaining to recall, memorization, automatic categorization and renaming of payee names are enabled." All of the settings have been set and working until this year's fiasco upgrade. Then it has sporadically worked.
    3rd - "Are you automatically accepting downloaded transactions into your registers?" Yes I am since I use the renaming rules. If you bothered to look at the one picture you would see the (as I also stated) the name and everything in the scheduled transaction is identical (aka the same as) to what was d/l from the bank.
    4th - "In case you have issues with transfer transactions not being generated correctly:" That hasn't been an issue - surprisingly.
    5th - "Where are the "Auto-accept downloaded transaction" settings?" Those are set up correctly and as they have been in the past.

    FINALLY - Everything seems to have gone bad since Jan. upgrade between Q & the banks.

    [Removed - Sarcasm/Violation of Community Guidelines]
  • Ps56k2
    Ps56k2 SuperUser ✭✭✭✭✭
    58kopykat said:  The 2nd one has d/l a scheduled transaction, the name is identical, the $ amount is identical, but Q didn't match it.
    Is this a checking account ?
    I wonder if Quicken has a hierarchy for matching... and in this case it almost looks like the downloaded and cleared transaction is looking for matching Check Number #0 ?


    QWin - R54.16 - Win10

  • Ps56k2
    Ps56k2 SuperUser ✭✭✭✭✭
    58kopykat said:
    One has had a transaction d/l as cleared but hasn't marked it as cleared and the online balance knows it is cleared.
    Not sure why the Cleared status wasn't changed - would have to see what the Register looks like... like your other example - But how can you "download" a transaction, and not have it marked "cleared" - ?


    QWin - R54.16 - Win10

This discussion has been closed.