Importing Investment Transactions - Not appearing in Linked Cash Account

rrh770
rrh770 Quicken Windows Subscription Member ✭✭
edited January 5 in Errors and Troubleshooting (Windows)

I have imported transactions into an Investment account using the CSV import feature. The transactions correctly show in my investment account. However, they are not showing in the linked cash account. The investment transactions show the linked cash account, but the transactions are not there and I cannot reconcile. I have All Dates selected in my cash account display, so it's not a filtering issue. Is this a bug? Or am I doing something wrong?

Tagged:

Answers

  • rrh770
    rrh770 Quicken Windows Subscription Member ✭✭

    In further inspecting my files, I find that the price field in the transaction is blank, so it is not showing an amount. This explains why there is no linked cash transaction….but why is the Price blank? It is populated in the CSV file.

  • Quicken Kristina
    Quicken Kristina Quicken Windows Subscription Moderator mod

    Hello @rrh770,

    Thank you for reaching out! To help troubleshoot, please provide more information. How do you have the CSV file formatted? How do the transactions appear when you import them into your Quicken? Are the cash transactions completely missing (not importing at all), or are they going into the investment account instead of the linked checking account?

    I look forward to your response!

    Quicken Kristina

    Make sure to sign up for the email digest to see a round up of your top posts.

  • rrh770
    rrh770 Quicken Windows Subscription Member ✭✭

    The CSV file is formatted exactly as the sample file provided. The transactions appear in the Investment Account. In my first attempt, the price values were formatted as "General" and this was resulting in no values for the transactions. They would show the Date, Security, and Shares, but the values in the transaction records were blank. I restored to a backup and then changed the Price attribute in the CSV file to a Number (using current version of Microsoft Excel). I had blanks for amount, cleared status, etc.

    Two issues resulted:

    1. No transactions were recorded in the Linked Cash Account. They were in the Investment Account, but no matching transaction was found in the Linked Cash Account.
    2. Some transactions loaded with dates in 2012…which took me a while to track down. My lot balances were off on some of the securities. When I looked, I found transactions in 2012…which was before this account was opened.

    Regarding issue 1: If I opened a transaction imported into the Investment Account and saved it, it would generate the matching transaction in the Linked Cash Account. I accidently discovered this when I was correcting some input errors on the Total in the Investment Account record and was pleased to see it created a matching transaction in the Linked Cash Account when the Investment transaction was saved. I subsequently went into each imported transaction and saved it…even if nothing was edited…and my Cash transactions are now correct. This was a pain and something I'd like to avoid in the future…

    Regarding issue 2: My best guess on what happened is that it transposed the Month and Year on transactions dated around 12/10/12 and 12/11/12. I was able to delete the incorrect transactions and manually re-entered them with the correct date. It did not do this on all transactions and seemed to be some in November as well.

    FYI: The only reason I am importing the CSV file is due to the issue with importing from Fidelity NetBenefits not yet being resolved. Quicken acts like it is importing through OneStep Update, even asking me about new securities and historical splits, but nothing appears in the list of downloaded transactions. Sure would be great if we could get that fixed….it's been a minute….

    Thanks for your help.

Categories