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.

Categories