QIF importing into Quicken Windows 2018 is broken in the R2.3 patch update

  • 0
  • 19
  • Problem
  • Updated 7 days ago
  • In Progress

Reposting problem from QPW (https://getsatisfaction.com/quickencommunity/topics/qif-importing-into-quicken-windows-2018-is-broke...) which was closed with no resolution:

Two problems were introduced in this patch for QIF imports.

The first one is that in the past QIF imports would go the "Downloaded Transactions" tab.  This allowed the user to do matching and selective importing into the register.

Now the transactions go right into the register, but this isn't even like "automatic entry mode".
With the "real" "automatic entry mode" that you would see for Web Connect, Express Web Connect, or Direct Connect, the imported transactions would get a status of New or New Match and you could review them and use manual match on them.

With this problem the transaction go into the register and don't set any kind of status, so the review and matching system can't be used.

The second and even bigger problem in my opinion is that in the past when you imported a QIF file the payees in the transactions were matched to the Memorized Payee list, and if they matched the category would be filled in.

This no longer happens with Quicken Windows 2018 R3.2.

This makes the importing of transactions from a financial institution where the category wouldn't be known, pretty much useless, because the user would have to go in and add the category for every transaction.

Photo of JohnA

JohnA

  • 916 Points 500 badge 2x thumb
  • frustrated

Posted 1 month ago

  • 0
  • 19
Photo of QPW

QPW

  • 332,884 Points 100k badge 2x thumb
Thanks JohnA for reposting this.
Photo of GeoDosch

GeoDosch

  • 972 Points 500 badge 2x thumb
Personally I'm happy to hear the above (if I'm understanding correctly.)  I didn't like how previous versions tried to treat imported QIF entries as downloaded transactions for reconciling, since I use them as a way to import transactions.  And if a new transaction happens to match an existing uncleared item, It's then necessary to clear the 'Match' flag by using the 'Treat transaction as New' option.

What's really needed would be an option in the Import dialog to tell Quicken whether the imported transactions should be treated as imported data or reconciliation items.

I tried 2018 this weekend, and removed it a day later, mainly due to the Bills screen getting a major overhaul that makes it useless to me.  If they change that back to the way it used to be I'll likely give 2018 another try.
Photo of QPW

QPW

  • 332,178 Points 100k badge 2x thumb
On the red flag bug. Yeah I know of that one too.  It isn't really a non-cash account that triggers it.  It is if you are importing a QIF file into an account that is setup for downloading transactions.  Any "manual entry" account won't have the problem.
(Edited)
Photo of QPW

QPW

  • 332,178 Points 100k badge 2x thumb
Well I have finished testing for the ways I think QIF imports might be used and basically it comes down to this.  Having a way to tell Quicken not to do any matching is useful in couple of situations, and I would like to see it added as an option.

But in truth it is just inconvenient for a few "niche" use cases.  And in those cases you can just select to use "Make All New".

In the case of where the user's loses the ability have the QIF import use Quicken's memorized payees for filling in the category, this far more than "inconvenient".  And from what I can tell there are far more users using QIF importing that require this than the ones that have their QIF files already set with the categories they want.
Photo of GeoDosch

GeoDosch

  • 972 Points 500 badge 2x thumb
It isn't really a non-cash account that triggers it.  It is if you are importing a QIF file into an account that is setup for downloading transactions
@QPW, thanks for that information!
Photo of JohnA

JohnA

  • 916 Points 500 badge 2x thumb

>> I tried 2018 this weekend, and removed it a day later, mainly due to the Bills screen getting a major overhaul that makes it useless to me. 

Are you sure you are on the correct tab after clicking on "Bills & Income" in 2018?  The default Bills tab in 2017 used to be the middle tab.  In 2018, it is renamed to "Incomes and Transfers" while the first tab is called Bills but for online bills which I currently do not use.  I don't see any major differences between 2018 "Incomes and Transfers" and the 2017 Bills tab.

Photo of GeoDosch

GeoDosch

  • 972 Points 500 badge 2x thumb
Are you sure you are on the correct tab after clicking on "Bills & Income" in 2018?
Yes, quite sure.  The middle sub-tab, which used to show a 'Stack' view of income and expenses now only shows income & transfers.  The left-most sub-tab, which was 'linked bills' is now the billing reminders, which shows as a vertical list instead of the stack view.  But what's worse is the income and outgo are now on separate screens. 
I don't see any major differences between 2018 "Incomes and Transfers" and the 2017 Bills tab.
The difference is that Q2018 does not show any bills on the "Income & Transfers" tab, which in my case means that about 90% of what would appear there is now gone.  There is a rather active discussion of the issue in another topic.
Photo of QPW

QPW

  • 332,884 Points 100k badge 2x thumb
BTW for the record where is what I think changed.  Before when you imported a QIF file it would open/go through the Downloaded Transactions tab.   It isn't doing that any more.  So it is basically bypassing all the downloading processing which includes both the matching of transactions in the register to downloaded transactions, and the matching of payees to the memorized payees.
Photo of QPW

QPW

  • 332,884 Points 100k badge 2x thumb
Whereas I would love it that the QIF import "follow all the rules" that say a QFX import does where it honors the user preference for automatically entering transactions of using the Downloaded Transactions tab, I also realize that this feature isn't one they really want to spend a lot of time to support.  So I just hope they will put it back in a form that is "usable".

Currently the transactions go straight into the register like you might see in automatic transaction entry mode (no matter what the user's option is set to), but it doesn't perform any of the matching to the memorized payee list, it doesn't match existing transactions, and it doesn't allow for reviewing or manual matching.

And as for it being a bug.  Well to the software developers a bug is it not doing what it was designed to do.  So they can say it isn't a bug if this how it was designed to work.  But it is certainly a bug that they broke the existing functionality.
Photo of GeoDosch

GeoDosch

  • 972 Points 500 badge 2x thumb
I also realize that this feature isn't one they really want to spend a lot of time to support.
The QIF import screen gives a list of account types that it cannot be used to import into, including credit cards.  However, it is possible to do just that if you put the account info into the QIF data.  But I don't think I can complain to support if something that's not supposed to work doesn't work the way I'd like it to.  So for me it's ixnay on the ugbay. :)
Photo of QPW

QPW

  • 332,884 Points 100k badge 2x thumb
@GeoDosch believe or not they actually removed the "QIF import GUI block" for Quicken 2018.  So I think the new company is trying to be better accommodating than Intuit was.  I just hope this behavior on the import was a mistake.
Photo of GeoDosch

GeoDosch

  • 972 Points 500 badge 2x thumb
Thanks for letting me know that.  I hadn't used 2018 long enough to have tried doing a QIF import.

And now that all that empty real estate is available on that screen, it looks like a perfect spot to put a selector for whether the QIF file is for importing transactions or reconciling. :)
Photo of QPW

QPW

  • 332,884 Points 100k badge 2x thumb
I was think about this and figured it would be a good idea to put in a suggestion for not matching existing transactions during a QIF import.
You can vote on it here:
https://getsatisfaction.com/quickencommunity/topics/add-an-option-to-the-qif-import-to-not-do-matching-to-existing-transactions
Photo of QPW

QPW

  • 332,884 Points 100k badge 2x thumb
I noticed an extra problem today.  When you do a QIF import the balance doesn't update in the Account bar.  You have to restart Quicken for it to get it to be right.  You can't even just go to another account and back.
Photo of GeoDosch

GeoDosch

  • 972 Points 500 badge 2x thumb
I just tried this in QP2017 and the account bar updated correctly, for both a cash account as well as a credit card where it has initially matched the transactions.  So this is a new bug in Q2018.
Photo of QPW

QPW

  • 332,884 Points 100k badge 2x thumb
Yes, new bug in Quicken 2018.