Home Page link  

N/A in the Cash Column

  
Groups | Search | About
User Password
Register Now! Lost Password?

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, 10:01 am
Please log in for more thread options
 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? Thanks.

Doug


Posted by John Pollard on February 10, 2007, 10:11 am
Please log in for more thread options
 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




Posted by DGD on February 10, 2007, 3:46 pm
Please log in for more thread options
> 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.

Appreciate the help and assistance to clear this up.


Doug


Posted by John Pollard on February 10, 2007, 4:44 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



Posted by DGD on February 10, 2007, 6: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


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