incorrect costbasis

hi,
with investments the individual transactions are right
for a particular stock (number x price + costs); add the
amounts manually you get a different amount from the one
Money 2004 shows as costbasis. I can't figure out why.
Suggestion anyone?
thanks
joop

via_newsgroup
Tue Feb 10 10:54:10 CST 2004

In microsoft.public.money, joop wrote:

>
>with investments the individual transactions are right
>for a particular stock (number x price + costs); add the
>amounts manually you get a different amount from the one
>Money 2004 shows as costbasis. I can't figure out why.
>Suggestion anyone?

More details? Are you in the USA?

Shows WHERE as a cost basis?

joop
Tue Feb 10 15:47:25 CST 2004


>-----Original Message-----
>In microsoft.public.money, joop wrote:
>
>>
>>with investments the individual transactions are right
>>for a particular stock (number x price + costs); add
the
>>amounts manually you get a different amount from the
one
>>Money 2004 shows as costbasis. I can't figure out why.
>>Suggestion anyone?
>
>More details? Are you in the USA?
>
>Shows WHERE as a cost basis?
>
>.hi, thanks for your reaction
yes, I was too low on the details: I am Dutch, so I use
the euro. My US investments are in $ US. I convert euro
to dollar with historical exchange rates. Cost basis in
my US port seems to convert these historical euro prices
in todays euro to dollar exchange rate. Is this a feature
or a bug?
thanks again for your time.
joop
>

anonymous
Tue Feb 10 17:38:29 CST 2004


>-----Original Message-----
>
>>-----Original Message-----
>>In microsoft.public.money, joop wrote:
>>
>>>
>>>with investments the individual transactions are right
>>>for a particular stock (number x price + costs); add
>the
>>>amounts manually you get a different amount from the
>one
>>>Money 2004 shows as costbasis. I can't figure out why.
>>>Suggestion anyone?
>>
>>More details? Are you in the USA?
>>
>>Shows WHERE as a cost basis?
>>
>>.hi, thanks for your reaction
>yes, I was too low on the details: I am Dutch, so I use
>the euro. My US investments are in $ US. I convert euro
>to dollar with historical exchange rates. Cost basis in
>my US port seems to convert these historical euro
prices
>in todays euro to dollar exchange rate. Is this a
feature
>or a bug?
>thanks again for your time.
>joop
>>
>.
>sorry for the inconvenience, but probably an example
works better to explain my problem:
(excluding dividends)

Buy:
date nr price$US pice+comm$US =euro
9-2-2003 100 50 5042.00 4688.92
21-08-2003 100 49 4941.75 4363.19
13-01-2004 200 52 10455.00 8250.47
p/s
$us: 51.09 euro: 43.26
Money tells:(valuation view)
costbasis:$21918.91
p/s: (average cost) 54.797
It eludes me....
joop

via_newsgroup
Tue Feb 10 18:08:54 CST 2004

In microsoft.public.money, joop wrote:

>
>>-----Original Message-----
>>
>>>-----Original Message-----
>>>In microsoft.public.money, joop wrote:
>>>
>>>>
>>>>with investments the individual transactions are right
>>>>for a particular stock (number x price + costs); add
>>the
>>>>amounts manually you get a different amount from the
>>one
>>>>Money 2004 shows as costbasis. I can't figure out why.
>>>>Suggestion anyone?
>>>
>>>More details? Are you in the USA?
>>>
>>>Shows WHERE as a cost basis?
>>>
>>>.hi, thanks for your reaction
>>yes, I was too low on the details: I am Dutch, so I use
>>the euro. My US investments are in $ US. I convert euro
>>to dollar with historical exchange rates. Cost basis in
>>my US port seems to convert these historical euro
>prices
>>in todays euro to dollar exchange rate. Is this a
>feature
>>or a bug?
>>thanks again for your time.
>>joop
>>>
>>.
>>sorry for the inconvenience, but probably an example
>works better to explain my problem:
>(excluding dividends)
>
>Buy:
>date nr price$US pice+comm$US =euro
>9-2-2003 100 50 5042.00 4688.92
>21-08-2003 100 49 4941.75 4363.19
>13-01-2004 200 52 10455.00 8250.47
>p/s
>$us: 51.09 euro: 43.26
>Money tells:(valuation view)
>costbasis:$21918.91
>p/s: (average cost) 54.797
>It eludes me....
>joop

I don't have the multi-currency experience, but I suspect your
suspicion is correct. This assumes that there are not
ReinvestDividend transactions in the above example that you have not
listed.

It is too bad that the tax authorities are not going to accept the
higher basis figures. ;-) I would expect that the tax authorities
want you to use the euro figure that existed at the time of the buy.
So for tax purposes, I think the thing to do would be to have the
account in euros, and convert each transaction from dollars only at
the time of purchase. But perhaps somebody with some multi-currency
knowledge will have some information for you.

joop
Wed Feb 11 14:07:01 CST 2004


>-----Original Message-----
>In microsoft.public.money, joop wrote:
>
>>
>>>-----Original Message-----
>>>
>>>>-----Original Message-----
>>>>In microsoft.public.money, joop wrote:
>>>>
>>>>>
>>>>>with investments the individual transactions are
right
>>>>>for a particular stock (number x price + costs); add
>>>the
>>>>>amounts manually you get a different amount from the
>>>one
>>>>>Money 2004 shows as costbasis. I can't figure out
why.
>>>>>Suggestion anyone?
>>>>
>>>>More details? Are you in the USA?
>>>>
>>>>Shows WHERE as a cost basis?
>>>>
>>>>.hi, thanks for your reaction
>>>yes, I was too low on the details: I am Dutch, so I
use
>>>the euro. My US investments are in $ US. I convert
euro
>>>to dollar with historical exchange rates. Cost basis
in
>>>my US port seems to convert these historical euro
>>prices
>>>in todays euro to dollar exchange rate. Is this a
>>feature
>>>or a bug?
>>>thanks again for your time.
>>>joop
>>>>
>>>.
>>>sorry for the inconvenience, but probably an example
>>works better to explain my problem:
>>(excluding dividends)
>>
>>Buy:
>>date nr price$US pice+comm$US
=euro
>>9-2-2003 100 50 5042.00
4688.92
>>21-08-2003 100 49 4941.75
4363.19
>>13-01-2004 200 52 10455.00
8250.47
>>p/s
>>$us: 51.09 euro: 43.26
>>Money tells:(valuation view)
>>costbasis:$21918.91
>>p/s: (average cost) 54.797
>>It eludes me....
>>joop
>
>I don't have the multi-currency experience, but I
suspect your
>suspicion is correct. This assumes that there are not
>ReinvestDividend transactions in the above example that
you have not
>listed.
>
>It is too bad that the tax authorities are not going to
accept the
>higher basis figures. ;-) I would expect that the tax
authorities
>want you to use the euro figure that existed at the time
of the buy.
>So for tax purposes, I think the thing to do would be to
have the
>account in euros, and convert each transaction from
dollars only at
>the time of purchase. But perhaps somebody with some
multi-currency
>knowledge will have some information for you.
>
>
>.hi,
thank for your reply, I'll try your suggestion and how it
works out.
brgs
joop
>

joop
Wed Feb 11 17:59:30 CST 2004


>-----Original Message-----
>
>>-----Original Message-----
>>In microsoft.public.money, joop wrote:
>>
>>>
>>>>-----Original Message-----
>>>>
>>>>>-----Original Message-----
>>>>>In microsoft.public.money, joop wrote:
>>>>>
>>>>>>
>>>>>>with investments the individual transactions are
>right
>>>>>>for a particular stock (number x price + costs);
add
>>>>the
>>>>>>amounts manually you get a different amount from
the
>>>>one
>>>>>>Money 2004 shows as costbasis. I can't figure out
>why.
>>>>>>Suggestion anyone?
>>>>>
>>>>>More details? Are you in the USA?
>>>>>
>>>>>Shows WHERE as a cost basis?
>>>>>
>>>>>.hi, thanks for your reaction
>>>>yes, I was too low on the details: I am Dutch, so I
>use
>>>>the euro. My US investments are in $ US. I convert
>euro
>>>>to dollar with historical exchange rates. Cost basis
>in
>>>>my US port seems to convert these historical euro
>>>prices
>>>>in todays euro to dollar exchange rate. Is this a
>>>feature
>>>>or a bug?
>>>>thanks again for your time.
>>>>joop
>>>>>
>>>>.
>>>>sorry for the inconvenience, but probably an example
>>>works better to explain my problem:
>>>(excluding dividends)
>>>
>>>Buy:
>>>date nr price$US pice+comm$US
>=euro
>>>9-2-2003 100 50 5042.00
>4688.92
>>>21-08-2003 100 49 4941.75
>4363.19
>>>13-01-2004 200 52 10455.00
>8250.47
>>>p/s
>>>$us: 51.09 euro: 43.26
>>>Money tells:(valuation view)
>>>costbasis:$21918.91
>>>p/s: (average cost) 54.797
>>>It eludes me....
>>>joop
>>
>>I don't have the multi-currency experience, but I
>suspect your
>>suspicion is correct. This assumes that there are not
>>ReinvestDividend transactions in the above example that
>you have not
>>listed.
>>
>>It is too bad that the tax authorities are not going to
>accept the
>>higher basis figures. ;-) I would expect that the tax
>authorities
>>want you to use the euro figure that existed at the
time
>of the buy.
>>So for tax purposes, I think the thing to do would be
to
>have the
>>account in euros, and convert each transaction from
>dollars only at
>>the time of purchase. But perhaps somebody with some
>multi-currency
>>knowledge will have some information for you.
>>
>>
>>.hi,
>thank for your reply, I'll try your suggestion and how
it
>works out.
>brgs
>joop
>>
>.correction:
I think I am to blame and not Money! Thinking it all over
again I realised that my costbasis is in euro's; so Money
is correct in converting the historical price in euro's
to todays dollars thus reflecting the true costbasis for
an account held in dollars. So it's a feature afterall!
I am sorry to have wasted your time.
>not so clever< joop

>