| Author |
Message |
LCaution
Guest
|
 Posted:
Fri Nov 11, 2005 9:02 am Post subject:
Q2003 - problem with handling of a CD |
|
|
This is a bit hard to describe.
1. I set up a brokerage account some months back with a linked cash
account.
2. I downloaded transactions into Q2003.
3. One of the transactions was for a "Problem CD" - this was
transferred to me from an external account. Quicken made an entry into
the linked cash account for the "Problem CD" with the face value
showing as a deposit. In the linked investment acct., the "Problem CD"
is entered with the same face value in the "Amount/Comm" field and
"MiscIncX" in the "Action" field..
4. New CDs bought with money from the linked cash account show up in
the investment account as "BuyX". In the linked cash account, the face
value is shown as a "Payment".
5. In the "Security View", the "Problem CD" has 0 for "shares held" and
0 for "MktValue". The other CDs show a number in the "shares held"
field and the face value in the "mkt value".
6. When I do reports, I can track the new CDs as individual entities,
but the "Problem CD" is invisible. It is just a part of the lump sum
cash.
For Example:
CD 1 $1,000
CD 2 $1,000
Cash 5,000 (including the "Problem CD")
I want the "Problem CD" to act just like the other CDs, but I haven't
the foggiest idea how to do it.
Does anybody have any idea what kind of transactions I have to do to
accomplish this?
LC
p.s. I have several reasons for doing this - mainly so my reports will
contain the info I want and so it is easier to compare my Quicken stuff
with the brokerage statements. But, in addition, Quicken keeps telling
me (when I try to reconcile) that things don't match up and I think
this might be one of the reasons.
|
|
| Back to top |
|
 |
John Pollard
Guest
|
| Posted:
Sat Nov 12, 2005 12:07 am Post subject:
Re: Q2003 - problem with handling of a CD |
|
|
LCaution wrote:
| Quote: | This is a bit hard to describe.
1. I set up a brokerage account some months back with a
linked cash
account.
2. I downloaded transactions into Q2003.
3. One of the transactions was for a "Problem CD" - this was
transferred to me from an external account. Quicken made an
entry
into the linked cash account for the "Problem CD" with the
face value
showing as a deposit. In the linked investment acct., the
"Problem
CD" is entered with the same face value in the "Amount/Comm"
field
and "MiscIncX" in the "Action" field..
4. New CDs bought with money from the linked cash account show
up in
the investment account as "BuyX". In the linked cash account,
the
face value is shown as a "Payment".
5. In the "Security View", the "Problem CD" has 0 for "shares
held"
and 0 for "MktValue". The other CDs show a number in the
"shares
held" field and the face value in the "mkt value".
6. When I do reports, I can track the new CDs as individual
entities,
but the "Problem CD" is invisible. It is just a part of the
lump sum
cash.
For Example:
CD 1 $1,000
CD 2 $1,000
Cash 5,000 (including the "Problem CD")
I want the "Problem CD" to act just like the other CDs, but I
haven't
the foggiest idea how to do it.
Does anybody have any idea what kind of transactions I have to
do to
accomplish this?
LC
p.s. I have several reasons for doing this - mainly so my
reports will
contain the info I want and so it is easier to compare my
Quicken
stuff with the brokerage statements. But, in addition,
Quicken keeps
telling me (when I try to reconcile) that things don't match
up and I
think this might be one of the reasons.
|
Have you tried changing the MiscIncX transaction to an "Add -
Shares added" transaction.
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
| Back to top |
|
|
LCaution
Guest
|
| Posted:
Sat Nov 12, 2005 1:02 am Post subject:
Re: Q2003 - problem with handling of a CD |
|
|
I just tried it and it doesn't work. Quicken gives a "doesn't match"
message and asks me to adjust shares or cost basis. I tried both and,
in both cases, the value in the investment account stays the same, but
the value of the linked cash account is reduced by the amount of the CD
- so it results in a net loss in the two accounts equal to the value of
the CD.
LC
p.s. Why oh why oh why doesn't Quicken have an "undo" like every other
application. Thank goodness I had a current backup.
John Pollard wrote:
| Quote: | LCaution wrote:
This is a bit hard to describe.
1. I set up a brokerage account some months back with a
linked cash
account.
2. I downloaded transactions into Q2003.
3. One of the transactions was for a "Problem CD" - this was
transferred to me from an external account. Quicken made an
entry
into the linked cash account for the "Problem CD" with the
face value
showing as a deposit. In the linked investment acct., the
"Problem
CD" is entered with the same face value in the "Amount/Comm"
field
and "MiscIncX" in the "Action" field..
4. New CDs bought with money from the linked cash account show
up in
the investment account as "BuyX". In the linked cash account,
the
face value is shown as a "Payment".
5. In the "Security View", the "Problem CD" has 0 for "shares
held"
and 0 for "MktValue". The other CDs show a number in the
"shares
held" field and the face value in the "mkt value".
6. When I do reports, I can track the new CDs as individual
entities,
but the "Problem CD" is invisible. It is just a part of the
lump sum
cash.
For Example:
CD 1 $1,000
CD 2 $1,000
Cash 5,000 (including the "Problem CD")
I want the "Problem CD" to act just like the other CDs, but I
haven't
the foggiest idea how to do it.
Does anybody have any idea what kind of transactions I have to
do to
accomplish this?
LC
p.s. I have several reasons for doing this - mainly so my
reports will
contain the info I want and so it is easier to compare my
Quicken
stuff with the brokerage statements. But, in addition,
Quicken keeps
telling me (when I try to reconcile) that things don't match
up and I
think this might be one of the reasons.
Have you tried changing the MiscIncX transaction to an "Add -
Shares added" transaction.
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
|
| Back to top |
|
|
John Pollard
Guest
|
| Posted:
Sat Nov 12, 2005 1:02 am Post subject:
Re: Q2003 - problem with handling of a CD |
|
|
LCaution wrote:
| Quote: | I just tried it and it doesn't work. Quicken gives a "doesn't
match"
message and asks me to adjust shares or cost basis. I tried
both and,
in both cases, the value in the investment account stays the
same, but
the value of the linked cash account is reduced by the amount
of the
CD
- so it results in a net loss in the two accounts equal to the
value
of the CD.
|
I don't understand. What "doesn't match"? I tested in an
investment account with a linked cash account; I had no trouble
changing a MiscIncX to an Add Shares. But even if you can't
"Edit" it, you can surely delete the MiscIncX and Enter an Add
Shares from scratch. Since this sounds like a new "security"
(CD), during the process, I would expect Quicken to drop you
into the "New Security" dialog.
And I also don't understand your comment about the net loss.
You said the CD came from a source you were not tracking in
Quicken; so you didn't pay for it from your linked cash account
or any other Quicken account ... so I can't understand why any
transaction involving that CD should wind up *deposting* money
in the cash account. (Probably the result of the fi not having
anyway to know how you would want the transaction handled).
The way to introduce a security into an investment account when
you didn't pay for it with cash from a Quicken account is to
"Add Shares". And when you add shares, you can enter a "cost"
of those shares; that should establish a "price/share", if the
security is new; though you can also just add your own price in
the price history.
When you finish, your investment account should have a value
that is increased by the value of the CD (as entered by you),
and the cash account value shouldn't change: as measured against
the value of those accounts *before* the MiscIncX transaction
was entered, not after.
--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in