Changing a transaction to be in Foreign currency

I am having problems with my investment accounts. My base currency is
canadian. However when I do a transaction in a security that is based in the
US, MS Money assumes that the price entered is in C$. Hence the purchase/sale
price is not reconciling with my statements adn I show a lower/higher cost in
Portfolio Manager

FYI The security is shown to be in US in the security details.

Cal
Thu Aug 03 10:54:47 CDT 2006

In microsoft.public.money, VUSA2006 wrote:

>I am having problems with my investment accounts. My base currency is
>canadian. However when I do a transaction in a security that is based in the
>US, MS Money assumes that the price entered is in C$. Hence the purchase/sale
>price is not reconciling with my statements adn I show a lower/higher cost in
>Portfolio Manager
>
>FYI The security is shown to be in US in the security details.

Assuming that the account itself is in Canadian dollars and the
commission is in Canadian dollars, when you enter the transaction
and you want to enter a USD amount, press the F8 key, and identify
the amount stated to be in USD. When you get your statement, correct
the amount to CAD to account for the difference in what your broker
used as an exchange rate vs what Money used.

Usually it is best to leave the Price field blank, and to let Money
compute that amount. In your case you may want to enter the price,
and let Money compute the total, which will serve as an estimate.
When you get the actual statement, blank out the Price and change
the Total to the statement amount. Then Money will re-compute the
actual per-share Price.

Was that answer to the question you were asking?

MikeWills
Thu Oct 05 02:52:01 CDT 2006

Hey Cal,

You might be able to help me with a different aspect of this problem.

I get paid in dollars, but live in Great Britain; so I am constantly moving
funds across the pond, and using local UK bank accounts to track day to day
living expenses. MONEY (2002, 4, 5) all seem to assume that I'm either
investing my dollars into sterling in an investment account -- which lets me
track the "buy" and "sell" prices on the currency -- or that it's just a bank
account and the exchange rate stays the same. BUT, the investment account
won't let me tag transactions with categories/subcategories so that I can
usefully budget and track real living expenses. Sure, the local UK checking
(bank) account in Money does this... but at one exchange rate for all time.

Advice please?

Cheers,
mike


"Cal Learner-- MVP" wrote:

> In microsoft.public.money, VUSA2006 wrote:
>
> >I am having problems with my investment accounts. My base currency is
> >canadian. However when I do a transaction in a security that is based in the
> >US, MS Money assumes that the price entered is in C$. Hence the purchase/sale
> >price is not reconciling with my statements adn I show a lower/higher cost in
> >Portfolio Manager
> >
> >FYI The security is shown to be in US in the security details.
>
> Assuming that the account itself is in Canadian dollars and the
> commission is in Canadian dollars, when you enter the transaction
> and you want to enter a USD amount, press the F8 key, and identify
> the amount stated to be in USD. When you get your statement, correct
> the amount to CAD to account for the difference in what your broker
> used as an exchange rate vs what Money used.
>
> Usually it is best to leave the Price field blank, and to let Money
> compute that amount. In your case you may want to enter the price,
> and let Money compute the total, which will serve as an estimate.
> When you get the actual statement, blank out the Price and change
> the Total to the statement amount. Then Money will re-compute the
> actual per-share Price.
>
> Was that answer to the question you were asking?
>