Home Page link  

N/A in the Cash Column

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
N/A in the Cash Column DGD 02-10-2007
Posted by DGD on February 10, 2007, 11:31 pm
Please log in for more thread options
>
>
>
> > DGD wrote:
> > > wrote:
> > >> DGD wrote:
> > >>> I am trying to resolve a number of entries I have in
> > >>> Investment Accounts in Quicken XG 2005. All of them
> > >>> have N/A in the cash column. From previous posts, it
> > >>> was stated that these N/A entries were caused by
> > >>> placeholder entries. However, I have cleared all
> > >>> placeholder entries in my accounts, without any change
> > >>> to these N/A entries. I have entered the purchase of
> > >>> shares for certain securities and they are properly
> > >>> registered within Quicken. I have added subsequent
> > >>> re-invested investment transactions and again, Quicken
> > >>> treats them correctly. After adding another re-invested
> > >>> investement transaction for the same stock, I get a N/A
> > >>> entry. Any ideas as to what is happening here?
>
> > >> It's not enough to delete the placeholders.
>
> > >> Once a transaction has become associated with a
> > >> placeholder, it will never affect the cash in the
> > >> account ... even if the placeholder has subsequently
> > >> been deleted.
>
> > >> You must delete all the transactions that were linked to
> > >> placeholders (transactions for a security named in a
> > >> placeholder, with transaction dates on, or before, the
> > >> date of the placeholder).
>
> > >> [Also: you can have multiple placeholders for the same
> > >> security; and placeholders can be somewhat difficult to
> > >> find in Q2005 (much less so in Q2006). If you do not
> > >> see any placeholder in the account when you enter a new
> > >> transaction, and that new transaction shows "N/A" for
> > >> the cash, you probably still have a placeholder in that
> > >> account for that security, dated on or after the date of
> > >> transaction you entered.]
>
> > >> --
> > >> John Pollard
> > >> First initial underscore Last name at mchsi dot com
> > >> Please reply to newsgroup
>
> > > I can see no placeholders. Is there another way to
> > > identify these placeholders in the transactions list?
> > > What I don't get is that I have a transaction that
> > > registers the purchase of mutual fund, another
> > > transaction later in time to register a dividend and then
> > > a third transaction later in time to register another
> > > dividend that is marked N/A.
>
> > > Don't understand your comment:
>
> > > You must delete all the transactions that were linked to
> > > placeholders (transactions for a security named in a
> > > placeholder, with transaction dates on, or before, the
> > > date of
> > > the placeholder).
> > > I thought to clear the placeholder, one has to enter the
> > > history of the transactions summarized in the
> > > placeholder. I am missing something here.
>
> > Yes, you are.
>
> > Entering the transaction history does not delete the
> > placeholder, it *hides* the placeholder. The placeholder is
> > still in the register and all the transactions for that security
> > dated on or before the placeholder (the "history" transactions)
> > are linked to that placeholder.
>
> > To see a "hidden" placeholder in Q2005, I believe you must enter
> > a transaction that causes you to hold a different number of
> > shares than specified in the placeholder.
>
> > If the placeholder says you own 100 shares of IBM on Jan 1,
> > 2007, and you have entered historical transactions for IBM dated
> > on or before Jan 1, 2007 that add up to you owning 100 shares of
> > IBM as of jan 1, 2007; then the placeholder will disappear from
> > the Transactions List ... but it's still there in the account.
> > To see the placeholder again, temporarily enter some transaction
> > that causes you to own other than 100 shares on Jan 1, 2007.
>
> > To get rid of the "N/A" effect caused by placeholders, you must
> > delete the placeholder, then delete every transaction linked to
> > it ... then re-enter the non-placeholder transactions.
>
> > --
> > John Pollard
> > First initial underscore Last name at mchsi dot com
> > Please reply to newsgroup
>
> Wow! And I thought it was going to be easy. I'll give it a shot and
> see what happens. Thanks again for the information and way out of
> this.
>
> Cheers,
>
> Doug

John,

Thanks for the help. All of my N/A transactions have been addressed
and cleared up. In all cases except one, adding a bogus transaction
brought up the placeholder entry. For some reason, one mutual fund
didn't do it, but removing and re-entering all the transactions
cleared up the N/A transactions for this on as well. Thanks again


Doug


Posted by John Pollard on February 11, 2007, 10:41 am
Please log in for more thread options
DGD wrote:
>
> Thanks for the help. All of my N/A transactions have
> been addressed and cleared up. In all cases except one,
> adding a bogus transaction brought up the placeholder
> entry. For some reason, one mutual fund didn't do it,
> but removing and re-entering all the transactions cleared
> up the N/A transactions for this on as well. Thanks
> again.

You're welcome.

Just wanted to mention that starting with Q2006, there is an
option to "show hidden transactions" that is available for
investment accounts. Makes it much easier to find/fix
placeholder problems.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Similar ThreadsPosted
How can I display a cash balance column in a brokerage account? September 13, 2008, 12:46 pm
How to change Cash Amount and Cash Balance in Q2008 Investment Acct? January 1, 2008, 9:34 pm
Ref Column February 25, 2007, 10:01 pm
In split transaction, what is the "Exp" column? February 19, 2007, 7:28 am
Quicken Register's Ref. Column February 27, 2007, 9:07 pm
Column Widths in Adress Book August 17, 2006, 6:24 am
"Amount Invested" column in reports October 30, 2006, 4:55 pm
expanding titles/column data March 29, 2008, 1:33 pm
Report column width too wide July 1, 2008, 11:05 am
Quicken 2007 Blank Column in Register February 7, 2007, 6:00 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap