Investment Holdings as of date

[Jeff]

Using Quicken 2005 Deluxe

I've downloaded investment account transactions from my FI and have been
adding the placeholder missing cost data where necessary, using my printed
statements from the FI.

Most are fine but I occasionally come across placeholders where I cannot
enter the correct purchase date because the box for the "Transaction Date"
insists that I enter a date prior to a certain date, whereas the shares were
actually purchased after that date. What I mean is that what is listed as
the "Holdings as of date ......." for that security is wrong (because the
security was purchased after that date.

In fact I noticed that a number of "Holdings as of date ......." dates are
in fact the identical same date in 2003 - which suggests to me it might be a
default date, possibly the date the account was first opened at the FI?

How can I reconcile this problem?

A second problem:
Sometimes, I will come across a security in the investment account where the
cost is listed as 0 but there is no placeholder for me to enter information
about when the security was purchased. How do I enter the cost info in
those cases?

Thank you.

--

Jeff Stevens
Email address deliberately false to avoid spam
jeff@stevens.com

Jeff wrote: Using Quicken 2005 Deluxe I've downloaded investment account transactions from my FI and have been adding the placeholder missing cost data where necessary, using my printed statements from the FI.

I'm persuming you mean that you are attempting to enter all the
historical transactions that comprise the share balances in the
placeholder entries.
Most are fine but I occasionally come across placeholders where I cannot enter the correct purchase date because the box for the "Transaction Date" insists that I enter a date prior to a certain date, whereas the shares were actually purchased after that date. What I mean is that what is listed as the "Holdings as of date ......." for that security is wrong (because the security was purchased after that date. In fact I noticed that a number of "Holdings as of date ......." dates are in fact the identical same date in 2003 - which suggests to me it might be a default date, possibly the date the account was first opened at the FI? How can I reconcile this problem?

If you are attempting to enter historical transactions to
account for the shares represented in a placeholder transaction,
you must enter the transactions with dates prior to the
placeholder date; I believe that will make sense if you think
about it.

If you told Quicken, when you first created the account, that
you held some number of shares of a certain security as of some
"date in 2003"; then Quicken will have created a placeholder
transaction for that security for that "date in Q2003". Any
transactions whose purpose is to account for the shares in that
placeholder (generally Buy and Reinvestment transactions) must
have dates prior to that "date in Q2003".

If you are planning to enter all the historical transactions at
one sitting (meaning you will not need Quicken to create any
reports showing your current holdings between the time you enter
the first historical transaction and the last), you could just
delete the placeholder and enter your historical transactions.

If you want to enter your historical transactions in a more
leisurely fashion over a number of diffrerent sessions with
Quicken and you want to retain accurate holdings information
during the entire time, then you can just modify the date of the
placeholder to be at least one day later than the latest
historical transaction that will be entered for that
placeholder.

A second problem: Sometimes, I will come across a security in the investment account where the cost is listed as 0 but there is no placeholder for me to enter information about when the security was purchased. How do I enter the cost info in those cases?

I'm not totally sure I grasp the situation you are experiencing
here; where do you "come across a security ... where the cost is
listed as 0"? I think you must find the transaction(s)
responsible for "adding" the shares of the security in question
to the account, and modify it/them to show the cost.


--
John Pollard
First Last at Bellsouth dot net
Please reply to newsgroup

John Pollard wrote: I'm persuming you mean that you are attempting to enter all the historical transactions that comprise the share balances in the placeholder entries.

Actually, I am *presuming*; not sure what I would be doing if I
was "persuming".

--
John Pollard
First Last at Bellsouth dot net
Please reply to newsgroup

[Mike B]

John Pollard <johnpollard@bellsouth.net> wrote: John Pollard wrote: I'm persuming you mean that you are attempting to enter all the historical transactions that comprise the share balances in the placeholder entries. Actually, I am *presuming*; not sure what I would be doing if I was "persuming".

Congratulations! You found a new word. You can make it mean whatever you
want. :-)

--
Mike B

Mike B wrote: John Pollard <johnpollard@bellsouth.net> wrote: John Pollard wrote: I'm persuming you mean that you are attempting to enter all the historical transactions that comprise the share balances in the placeholder entries.
Actually, I am *presuming*; not sure what I would be doing if I was "persuming".
Congratulations! You found a new word. You can make it mean whatever you want. :-)

Perusing my presumption, perhaps.

--
John Pollard
First Last at Bellsouth dot net
Please reply to newsgroup

[Jeff]

Dear John

Thank you again for being willing to help me. I am really new to Quicken.

I guess I did not explain that I set these accounts manually but by using
the online option given when you setup a new account. Some of these
downloaded securities downloaded as x shares worth so much today and the
cost for them appears as 0 with no placeholder available to enter historical
data. They contain a memo entry saying "Creating Initial Positio" The "date
acquired" seems to be the date the account was created at the FI (not at Q)
even though the securities were actually acquired at later dates in 2004. I
did not manually create these positions. They were all downloaded from the
FI.

What I figured out to do (please correct me if I am doing it wrong) is to go
to the Transaction Tab for that account, find the security in question,
click on Edit and (because the security was purchased at various dates in
several lots I cannot enter one date and cost of acquisition) selected
"adjust shares", and, on that screen clicked on "enter History". When I
enter the missing transactions in that way, it doubles the total number of
shares, so I then deleted the original downloaded transaction. I am not sure
if this will create problems when I next update online.
If you told Quicken, when you first created the account, that you held some number of shares of a certain security as of some "date in 2003";

I did not tell Q anything other than the name of the account. I downloaded
all the rest of the info in that account from the FI. That is why I think
the "date acquired" listed is an arbitrary default date (it is the same
identical date for a whole slew of securities even though they were acquired
at later dates).
If you are attempting to enter historical transactions to account for the shares represented in a placeholder transaction, you must enter the transactions with dates prior to the placeholder date; I believe that will make sense if you think about it.

That I know how to do when there is a placeholder, except as described above
when the "date acquired" seems to be a manufactured default date that is not
the correct one. Other times, the cost is listed as 0 with no placeholder
available (!) because the position downloaded listing it as acquired on that
(same fictitious 2003 date) even though it was acquired later in several
lots.

--

Jeff Stevens
Email address deliberately false to avoid spam
jeff@stevens.com


"John Pollard" <johnpollard@bellsouth.net> wrote in message
news:JNFtd.49277$Ch2.37525@bignews5.bellsouth.net... Jeff wrote: Using Quicken 2005 Deluxe I've downloaded investment account transactions from my FI and have been adding the placeholder missing cost data where necessary, using my printed statements from the FI. I'm persuming you mean that you are attempting to enter all the historical transactions that comprise the share balances in the placeholder entries. Most are fine but I occasionally come across placeholders where I cannot enter the correct purchase date because the box for the "Transaction Date" insists that I enter a date prior to a certain date, whereas the shares were actually purchased after that date. What I mean is that what is listed as the "Holdings as of date ......." for that security is wrong (because the security was purchased after that date. In fact I noticed that a number of "Holdings as of date ......." dates are in fact the identical same date in 2003 - which suggests to me it might be a default date, possibly the date the account was first opened at the FI? How can I reconcile this problem? If you are attempting to enter historical transactions to account for the shares represented in a placeholder transaction, you must enter the transactions with dates prior to the placeholder date; I believe that will make sense if you think about it. If you told Quicken, when you first created the account, that you held some number of shares of a certain security as of some "date in 2003"; then Quicken will have created a placeholder transaction for that security for that "date in Q2003". Any transactions whose purpose is to account for the shares in that placeholder (generally Buy and Reinvestment transactions) must have dates prior to that "date in Q2003". If you are planning to enter all the historical transactions at one sitting (meaning you will not need Quicken to create any reports showing your current holdings between the time you enter the first historical transaction and the last), you could just delete the placeholder and enter your historical transactions. If you want to enter your historical transactions in a more leisurely fashion over a number of diffrerent sessions with Quicken and you want to retain accurate holdings information during the entire time, then you can just modify the date of the placeholder to be at least one day later than the latest historical transaction that will be entered for that placeholder. A second problem: Sometimes, I will come across a security in the investment account where the cost is listed as 0 but there is no placeholder for me to enter information about when the security was purchased. How do I enter the cost info in those cases? I'm not totally sure I grasp the situation you are experiencing here; where do you "come across a security ... where the cost is listed as 0"? I think you must find the transaction(s) responsible for "adding" the shares of the security in question to the account, and modify it/them to show the cost. -- John Pollard First Last at Bellsouth dot net Please reply to newsgroup

[Jeff]

Actually In downloaded all the data and am just trying to enter historical
data. That is no problem when there is a placeholder (except when the
"Acquired Date" is an incorrect downloaded default date). My main problem is
when the downloaded position is listed as having a acquired cost of 0 with
no placeholder present AND the security was acquired in several lots.

--

Jeff Stevens
Email address deliberately false to avoid spam
jeff@stevens.com


"John Pollard" <johnpollard@bellsouth.net> wrote in message
news:YZFtd.49279$Ch2.6567@bignews5.bellsouth.net... John Pollard wrote: I'm persuming you mean that you are attempting to enter all the historical transactions that comprise the share balances in the placeholder entries. Actually, I am *presuming*; not sure what I would be doing if I was "persuming". -- John Pollard First Last at Bellsouth dot net Please reply to newsgroup

[Jeff]

Hey, he is a good guy and a great help. He can use any word he wishes if it
will help!

--

Jeff Stevens
Email address deliberately false to avoid spam
jeff@stevens.com


"Mike B" <mrcics2000-news-nomail@nomail.yahoo.com> wrote in message
news:41b731c6_1@news1.prserv.net... John Pollard <johnpollard@bellsouth.net> wrote: John Pollard wrote: I'm persuming you mean that you are attempting to enter all the historical transactions that comprise the share balances in the placeholder entries. Actually, I am *presuming*; not sure what I would be doing if I was "persuming". Congratulations! You found a new word. You can make it mean whatever you want. :-) -- Mike B

Jeff wrote: Actually In downloaded all the data and am just trying to enter historical data. That is no problem when there is a placeholder (except when the "Acquired Date" is an incorrect downloaded default date).

Just reviewing: when this occurs, you should be able to either
delete the transaction and enter your history using the Enter
Transactions button, or modify the date of the placeholder so it
is later than the date of any historical transaction which
contributed to its share balance then use the Enter History
button in the placeholder transaction to enter the history.
My main problem is when the downloaded position is listed as having a acquired cost of 0 with no placeholder present AND the security was acquired in several lots.

I would leave the "downloaded position" transaction in place
while you manually enter the correct history using Enter
Transactions. When your manually entered transactions have
"added" enough shares of the security to the account to equal
the "downloaded position", delete the "downloaded position"
transaction.

--
John Pollard
First Last at Bellsouth dot net
Please reply to newsgroup

[Jeff]

Thank you. Because I am new at Quicken I was reluctant to modify any of the
entries that had downloaded "automatically" in case that would cause
problems with future downloads. But what you say makes sense. Thanks.

--

Jeff Stevens
Email address deliberately false to avoid spam
jeff@stevens.com



John Pollard wrote: Jeff wrote: Actually In downloaded all the data and am just trying to enter historical data. That is no problem when there is a placeholder (except when the "Acquired Date" is an incorrect downloaded default date). Just reviewing: when this occurs, you should be able to either delete the transaction and enter your history using the Enter Transactions button, or modify the date of the placeholder so it is later than the date of any historical transaction which contributed to its share balance then use the Enter History button in the placeholder transaction to enter the history. My main problem is when the downloaded position is listed as having a acquired cost of 0 with no placeholder present AND the security was acquired in several lots. I would leave the "downloaded position" transaction in place while you manually enter the correct history using Enter Transactions. When your manually entered transactions have "added" enough shares of the security to the account to equal the "downloaded position", delete the "downloaded position" transaction.