Failure to add proceeds from sales of securities

Joel CR

On three of my entries for sales of securities the program failed to record the cash in the cash balance column and failed to add the cash to the balance. Instead of the cash amount, the column enters "NA". All of the data on the entry shows correctly. All other entries made on this occasion were properly recorded. The problem persisted after deleting the entries and re-entering them.

Tom Young

That N/A is likely arising from a Placeholder in the Transaction List for that particular security. Make sure that Placeholders can be seen in the Account and work through both the history of the security and also look for Placeholder that might be future dated.

Jim_Harman

To make Placeholders visible, go to Edit > Preferences > Investing and make sure the Show hidden transactions box is checked. 

Placeholders will have a gray background in the account’s transaction list (register) even if they are not selected, and will have “Entry” in the Action column.

Placeholders compensate for missing or incorrect investing transactions by forcing Quicken’s share balance for a security to match a specified value on the date of the Placeholder. This is usually the share count downloaded from your financial institution (FI).

Because transactions are missing or incorrect, Quicken will not be able to compute the cost basis or performance for the affected securities. You will see asterisks in the Portfolio views for this data.

Often Placeholders are due to rounding errors in the downloaded data, so for example you will see a Placeholder that adjusts the share balance by .0013 share following a dividend reinvestment. In this case you can adjust the number of shares in the Reinvest transaction so that the Placeholder is zero, then delete the Placeholder.

Placeholders also prevent new transactions like Div, Bought and Sold prior to the security’s Placeholder date from affecting the account’s cash balance. It does this by creating a linked Cash Balance Adjustment just before the affected transaction. Deleting one of these will delete them both. This shows up as N/A in the Cash Amt column of the transaction list. 

To allow the cash balance to change when entering missing transactions that affect the cash balance, you must first delete all the Placeholders for this security that have later dates than the transaction you are entering. Because of this, if you are entering a series of missing transactions it will be easiest to work in reverse chronological order.