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

Trouble importing QIF file

Hello,
I am using Quicken for Windows on a Windows 10 platform. I regularly upload cash transactions from a mobile app that I can set to export in QIF. I have been doing this for nearly 7 years. I have recently run into a peculiar problem.
I export the data from the mobile app. When I attempt to import the QIF, it imports the majority of the transactions, but ignores one of the income accounts. The account name is identical. But it does not import those transactions.
I have verified the QIF export does contain the data, so I know that it's there. I just don't know why it isn't importing it.
Thanks in advance for any suggestions.

Answers

  • Thanks Sherlock for the information. I did try it as explained in that thread and it did not solve my issue.

    It is a cash account and for some reason it is not importing transactions that were income. I will do some more testing to see if it is all income accounts or just one. Hopefully by narrowing it down I will be able to find a solution.
  • Alan Williams
    Alan Williams Member ✭✭
    So I am continuing my attempt to find a solution.

    What I have done in the application that I export from is that I isolated a transaction that I am having the issue with. When the transaction does not have an account listed but still shows as income, then it correctly imports it into Quicken. Once I put the income account into that field, it no longer imports it.

    The account names are identical in the application and in Quicken.

    I also confirmed that once I removed the account name from the transaction in the application and exported and imported, it works again.

    So for some reason, there is a problem with that account name. Any suggestions?
  • Alan Williams
    Alan Williams Member ✭✭
    More testing has revealed that it has something to do with it being an income account that was not created by Quicken as a default.

    When the account type on Quicken's side is listed as an Income account, it does not import the transaction. If I use of the default account names, then it does import.

    I don't want to use the default one as that doesn't categorize my accounting like I want it to. I also don't want to identify an income account as an expense account within Quicken just to solve this. It is perplexing for sure.

    Are there any experts out there that know what might be happening with this account? And what might be causing it not to import transactions that use a self created income account?
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    You keep talking about "account" and "Income account", but it sounds more like you are talking about categories.

    If you can post a one transaction QIF file text that works, and one that doesn't (feel free change change the names of anything you consider personal). I will see what I can do to reproduce the problem and make suggestions.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Alan Williams
    Alan Williams Member ✭✭
    @Chris_QPW my apologies. Yes, I am talking about categories. I am happy to post a QIF file, however I don't see where to attach it or upload it to my message. Could you please tell me how to do that?

    The problem appears to be with the Quicken side of things. When the category is listed as Income, it does not import. When the category is changed to an expense, it does import.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    edited January 24
    EDIT sorry for the multiple posting, just trying to get the formatting to behave and not put in extra blank lines.  Note that the adding of the account for it to go into was needed to push it into a non cash account in Quicken versions before Quicken Subscription.

    Since QIF files a text I was saying just post them here in the comment.  That is the reason for making sure there is nothing personal in them.

    Also what version of Quicken are you using?
    What account type are you importing this transaction into?


    And just for reference all of these work for me (Quicken Subscription):
    C*
    D01/18/2021
    NN/A
    PDeposit
    LInterest Inc
    T269.37
    ^
    OR
    !Account
    NCash Account
    TBank
    ^
    !Type:Bank
    C*
    D01/18/2021
    NN/A
    PDeposit
    LInterest Inc
    T269.37
    ^


    Same works in a checking account.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Alan Williams
    Alan Williams Member ✭✭
    @Chris_QPW Thank you for your response and continued help. I'm using version R30.21 build 27.1.30.21.

    The account that I am attempting to import into is a cash account.

    Here is a copy of the text from the QIF that I am trying to import.

    !Account
    NCrowns - Xxxx
    TCash
    ^
    !Type:Cash
    D01/21/2021
    T300.00
    LLang Income
    PMxxxx Jxxx
    MEnglish lesson
    ^

    The category I am using is Lang Income. It is a category that I added as I want to track this separately from the default categories. But it only imports this transaction if the category within Quicken is changed to expense.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    Well the mystery deepens since I can't reproduce this.
    What I did is just put your text above in a QIF file and double click on it (it seems that Quicken Inc has fixed the long broken association with QIF files.  :) )

    This in turn created the account and the category and imported the transaction.
    And I also tried importing it through the menus.  All worked fine.



    About the only thing I can suggest is trying varying it. As in create a new category and trying it.  Trying a different account. Try importing into a checking account instead of a cash account.  Trying a different data file.
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
Sign In or Register to comment.