Need help with manually entering and tracking a stock so that it reconciles

droopydog53
droopydog53 Member ✭✭✭
edited September 24 in Investing (Windows)

I have an individual, publicly traded stock, i.e., not part of any kind of fund and the dividends are automatically reinvested. I created the security followed by manually creating an offline brokerage account. All entries were manually entered. The first entry is the Opening cash balance of $0.00. The second entry is the balance adjustment for the number of shares. I entered the information from the four quarterly statement….Date…."ReinvDiv"….Security Name….the number of shares and the price for the quarter. The "Share bal," "Inv. Amt," both match the statement. The "Cash Amt" for each of the quarterly entries is blank. "Cash Bal" is $0.00. However, the "Total Market Value" which I think should match the "Market Value" on the statement is off by about $300. There are only six entries total in the account, so I am not sure why things are not matching up. Any help would be greatly appreciated!!

Tagged:

Answers

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭

    Change that "Balance Adjustment" to an "Add Shares" … and things should work out.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

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

    So the number of shares in the Account is correct, but the Market Value is different than the Statement's value?

    If I've got that right, then it would seem that the only reason for the disagreement is that the Quote/Price figure in the Account as of the Statement Date is different than the per-share market value per the statement.

    To fix that click on "Holdings", set the date to the date on the Statement, and change that Quote/Price figure to be the same as the one shown on the Statement.

This discussion has been closed.

Categories