incorrect costbasis

#5 02-11-2004, 10:59 PM

- quote -

> -----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.
- quote -

> not so clever< joop

#4 02-11-2004, 07:07 PM

- quote -

> -----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

#3 02-10-2004, 11:08 PM

In microsoft.public.money, joop wrote:

- quote -

> > -----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.

#2 02-10-2004, 10:38 PM

- quote -

> -----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

#1 02-10-2004, 08:47 PM

- quote -

> -----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

02-10-2004, 03:54 PM

In microsoft.public.money, joop wrote:

- quote -

> 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?

#-1 02-10-2004, 08:51 AM

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

Similar Threads
Thread	Forum	Replies	Last Post
Budgeted amounts incorrect Cary: Several of my budgeted amounts are off. they appear to be off by the amount of a scheduled bill payment. I have tried deleting budgets and...	Microsoft Money	1	02-10-2004 05:37 PM
incorrect password steyn: I uninstalled money 2002 to install money 2003. After restoring my backup money does not recognise my VALID! password anymore. I uninstalled money...	Microsoft Money	2	01-10-2004 12:43 PM
Incorrect balances Tom C: Everytime I balance my money account, when I gert the next statement the balance has changed in the program. I am also find items that have been...	Microsoft Money	1	10-14-2003 04:25 AM
Incorrect balance Sandra Bonny: I used to automatically download statements from my bank. How come that the balance in my account, and the one in Money are not the same (there is...	Microsoft Money	4	10-05-2003 09:40 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode