Import of investment transactions doesn't calculate cash amount correctly

Warren Pettit
Warren Pettit Member ✭✭
in Investing (Windows)

I am working with importing investment transactions via a csv file. I have a cash balance of $153.89 in my register. I import a "Bought" transaction with share value of 153.89 and a price of $1. The register then shows an Investment amount of $153.89 (like it should) but the Cash Amount is $153.88. If I enter this same transaction via the register, it calculates the Cash Amount as $153.89. I am attaching some graphics to show the problem.

Result after importing the csv transaction:

Snap1.jpg

This is the csv file:

Snap2.jpg

This is the edit dialog box for the above transaction:

Snap3.jpg

This is entering the transaction via the register:

Snap4.jpg

This is the result of entering the transaction via the register

Snap5.jpg

How can the Cash Amount not be equal to the Investment Amount in the import csv case?

Answers

  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭

    I expect the problem is related to this conversation:

    https://community.quicken.com/discussion/7968168/is-there-an-error-importing-csv-investment-file-into-a-brokerage-account

    Obviously Quicken might have some kinks to work out.

  • STEVEN WEINBERG
    STEVEN WEINBERG Member ✭✭✭

    I have a slightly different problem. It seem that not all investment transactions do not get entered into the cash account. It seems that this hit and miss. Ever reconcile of the account is off by the missing cash part of the transaction. How do you correct or fix. One solution that does not work because it seem to take hours and hours is unchecking tracking method in the investment account and then rechecking it. Any help anyone? Thanks.

  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭

    "It seem that not all investment transactions do not get entered into the cash account."

    That double negative is difficult to parse. Are you saying that not all investment transactions (presumably, transactions the use or create cash) get entered in the cash account (a linked cash account for a brokerage account?), or that investment transactions should not be entered into the cash account, but that some are?

    The original problem voiced in the first post in this thread involved importing csv files and having the numbers imported "incorrectly." Are you doing that too?

    I'm not sure I understand the "fix" you mentioned. Are you referring to Simple Investing vs. Complete? You can switch between the two methods in an instant. Having not used Simple Investing it's unclear to me if switching from Simple to Complete miraculously results in all transactions being shown; my impression was that sometimes it does and other times it doesn't, depending on how long you've been using Simple investing?

Categories