Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For this example, assume the table below lists your actual transaction history for a security.

DateTransaction detailsTotal shares
Jan 1, 2012Buy 100 shares100
Jan 1, 2013Sell 80 shares20
Jan 1, 2014Buy 10 shares30
Jan 1, 2016Buy 10 shares40

...

Suppose that you start using Quicken in Jan 2016 and download transactions. Since many brokerages allow downloads for a limited period (90 days or 1 year), you cannot download the entire transaction history. For this example, you are able to download only one transaction; that is, the Jan 1, 2016 Buy 10 shares transaction. At this point Quicken records the purchase date and cost (and thus the cost basis) of this single share transaction.

...

Now, you need to enter the entire transaction history as shown in the table below:

Transaction detailsTotal shares in QuickenTotal shares in broker reportPlaceholder value
Jan 1, 2012 - Buy 100110 shares40 shares-70 shares
Jan 1, 2013 - Sell 8030 shares40 shares+10 shares
Jan 1, 2014 - Buy 1040 shares40 shares0(zero)-Resolved

Important: Note that there can be swings between positive and negative figures when you are backfilling transactions. These swings might be even bigger if you are entering stock splits or multiple stock splits. However, after you enter all the missing transactions that impact the number of shares, the placeholder value should eventually be zero.

...

Tip: If you have an account with many transactions over many years and do not wish to enter everything, you could use the Guessstimate option to account for this missing shares. Just estimate the total cost of the missing shares and enter that value in the guesstimate field. This will get you a gain/loss value on the portfolio view, but should not be used for tax reporting.

Related topics