Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 08-23-2004, 08:42 AM
Andrew S. Clark
Guest
 
Posts: n/a
Default Re: Foreign Currency Transactions

Hello Carlos.

The only way I can see that this is possible is to change the exchange rate
to the date in which you are interested. I imagine, never having done this,
that you will need to login to money without the online features and then
change the exchange rate manually to one that you want. Subsequent login
with online features will probably set the exchange rate back.

Andrew.

"Carlos G" <cgnjunkregDELETE[at]hotmail.com> wrote in message
news:e12xO7mhEHA.3764[at]TK2MSFTNGP10.phx.gbl...
- quote -

> You got right to my problem:
> "The dollar value only represents the outstanding balance at today's
> exchange rate"
> However, now two months later I want to do a trip report. Some expenses
> were paid with my ? (euro symbol here, not sure if it'll come out.) credit
> card, some with my USD credit card. If I do a trip report, the values

will
> keep changing from day to day, since the report totals will be in USD

using
> today's exchange rate. I'm not so concerned about the 2% slop in exchange
> rates. But if the exchange rates change a lot, then my reports are

useless.
> FOr instance, I won't be able to compare a January trip with a June trip -
> in this case compare it in US$ since that is the currency that matters to
> me.
> Carlos
> "Andrew S. Clark" <asclark[at]yahoo.com> wrote in message
> news:%23%23C$joVhEHA.3236[at]TK2MSFTNGP10.phx.gbl...
> > I am assuming that your real credit card account is a Euro account. If

so
> > read on. If not - if you are really billed in USD - then set up a USD
> > credit card account. The currency conversion rate at the time of the
> > transaction will be kept as you desire. This will solve your problem
> > (except for the 2% rule below).
> > > For a real Euro credit card set-up in a USD based MS$ file ....

> > Think of it this way ...You pay for a meal in Paris. It costs you ?100.
> > The credit card will show in money as -?100
> > The credit card statement from your bank will show To Pay: ?100
> > Until you pay - until you convert USD to Euros and pay off the credit

> card -
> > you are dependant upon the whims of the international exchanges.
> > Remember, it's not really converting it to dollars. The dollar value

only
> > represents the outstanding balance at today's exchange rate - until

you've
> > cleared the balance. So it is correct in its behaviour.
> > > I use the UK version of money, and track USD, Euros, GBP. The

> > "normalization" to a single currency has no real value except to give a
> > perception of where I am in overall credit/debit. Remember, the

exchange
> > rates are always off +/-2%. MS$04 uses the daily (or momentary)

interbank
> > rate. You and I never get that when we do exchanges. So all costs are
> > always underestimated.
> > > Andrew.
> > > "Carlos G" <cgnjunkregDELETE[at]hotmail.com> wrote in message

> > news:ecF4h6ThEHA.3932[at]TK2MSFTNGP09.phx.gbl...
> > > I just set up in MS$04 a new credit card account which is set to use

> > Euros.
> > > I use this for my trips to Europe.
> > > > > I then setup a custom report that prints out all my expenses for a
> > > particular trip. The entries from the Euro account are listed in

Euros,
> > and
> > > then the report total is shown in dollars. So far so good.
> > > > > The problem, is that the report total seems to vary depending on

TODAY's
> > > exchange rate. Since the trip is in the past, and the historical

> > exchange
> > > rates are fixed, I would like the totals to stay fixed. Is it

> impossible
> > to
> > > do this if the account is in a foreign currency? Does money not keep

> > track
> > > of historical exchange rates, like it keeps track of investment

prices?
> > > (wouldn't it be funny if any investment purchase always showed up at

> > today's
> > > price - Mr IRS I swear I have no capital gains!
> > > > > I know I can set up dollars account and then convert each individual

> > entry -
> > > but then I loose track of the original Euros value for the

transaction.
> > > > > Thanks!
> > > Carlos
> > > > >

  #2  
Old 08-20-2004, 04:33 AM
Carlos G
Guest
 
Posts: n/a
Default Re: Foreign Currency Transactions

You got right to my problem:
"The dollar value only represents the outstanding balance at today's
exchange rate"

However, now two months later I want to do a trip report. Some expenses
were paid with my ? (euro symbol here, not sure if it'll come out.) credit
card, some with my USD credit card. If I do a trip report, the values will
keep changing from day to day, since the report totals will be in USD using
today's exchange rate. I'm not so concerned about the 2% slop in exchange
rates. But if the exchange rates change a lot, then my reports are useless.
FOr instance, I won't be able to compare a January trip with a June trip -
in this case compare it in US$ since that is the currency that matters to
me.

Carlos

"Andrew S. Clark" <asclark[at]yahoo.com> wrote in message
news:%23%23C$joVhEHA.3236[at]TK2MSFTNGP10.phx.gbl...
- quote -

> I am assuming that your real credit card account is a Euro account. If so
> read on. If not - if you are really billed in USD - then set up a USD
> credit card account. The currency conversion rate at the time of the
> transaction will be kept as you desire. This will solve your problem
> (except for the 2% rule below).
> For a real Euro credit card set-up in a USD based MS$ file ....
> Think of it this way ...You pay for a meal in Paris. It costs you ?100.
> The credit card will show in money as -?100
> The credit card statement from your bank will show To Pay: ?100
> Until you pay - until you convert USD to Euros and pay off the credit

card -
> you are dependant upon the whims of the international exchanges.
> Remember, it's not really converting it to dollars. The dollar value only
> represents the outstanding balance at today's exchange rate - until you've
> cleared the balance. So it is correct in its behaviour.
> I use the UK version of money, and track USD, Euros, GBP. The
> "normalization" to a single currency has no real value except to give a
> perception of where I am in overall credit/debit. Remember, the exchange
> rates are always off +/-2%. MS$04 uses the daily (or momentary) interbank
> rate. You and I never get that when we do exchanges. So all costs are
> always underestimated.
> Andrew.
> "Carlos G" <cgnjunkregDELETE[at]hotmail.com> wrote in message
> news:ecF4h6ThEHA.3932[at]TK2MSFTNGP09.phx.gbl...
> > I just set up in MS$04 a new credit card account which is set to use

> Euros.
> > I use this for my trips to Europe.
> > > I then setup a custom report that prints out all my expenses for a

> > particular trip. The entries from the Euro account are listed in Euros,

> and
> > then the report total is shown in dollars. So far so good.
> > > The problem, is that the report total seems to vary depending on TODAY's

> > exchange rate. Since the trip is in the past, and the historical

> exchange
> > rates are fixed, I would like the totals to stay fixed. Is it

impossible
> to
> > do this if the account is in a foreign currency? Does money not keep

> track
> > of historical exchange rates, like it keeps track of investment prices?
> > (wouldn't it be funny if any investment purchase always showed up at

> today's
> > price - Mr IRS I swear I have no capital gains!
> > > I know I can set up dollars account and then convert each individual

> entry -
> > but then I loose track of the original Euros value for the transaction.
> > > Thanks!

> > Carlos

>

  #1  
Old 08-18-2004, 07:42 PM
Andrew S. Clark
Guest
 
Posts: n/a
Default Re: Foreign Currency Transactions

Seems it didn't like the Euro symbol. Trying again.

I am assuming that your real credit card account is a Euro account. If so
read on. If not - if you are really billed in USD - then set up a USD
credit card account. The currency conversion rate at the time of the
transaction will be kept as you desire. This will solve your problem
(except for the 2% rule below).

For a real Euro credit card set-up in a USD based MS$ file ....
Think of it this way ...You pay for a meal in Paris. It costs you 100 Euro.
The credit card will show in money as -100 Euro
The credit card statement from your bank will show To Pay: 100 Euro
Until you pay - until you convert USD to Euros and pay off the credit card -
you are dependant upon the whims of the international exchanges.
Remember, it's not really converting it to dollars. The dollar value only
represents the outstanding balance at today's exchange rate - until you've
cleared the balance. So it is correct in its behaviour.

I use the UK version of money, and track USD, Euros, GBP. The
"normalization" to a single currency has no real value except to give a
perception of where I am in overall credit/debit. Remember, the exchange
rates are always off +/-2%. MS$04 uses the daily (or momentary) interbank
rate. You and I never get that when we do exchanges. So all costs are
always underestimated.

Andrew.

"Carlos G" <cgnjunkregDELETE[at]hotmail.com> wrote in message
news:ecF4h6ThEHA.3932[at]TK2MSFTNGP09.phx.gbl...
- quote -

> I just set up in MS$04 a new credit card account which is set to use
Euros.
> I use this for my trips to Europe.
> I then setup a custom report that prints out all my expenses for a
> particular trip. The entries from the Euro account are listed in Euros,

and
> then the report total is shown in dollars. So far so good.
> The problem, is that the report total seems to vary depending on TODAY's
> exchange rate. Since the trip is in the past, and the historical

exchange
> rates are fixed, I would like the totals to stay fixed. Is it impossible

to
> do this if the account is in a foreign currency? Does money not keep

track
> of historical exchange rates, like it keeps track of investment prices?
> (wouldn't it be funny if any investment purchase always showed up at

today's
> price - Mr IRS I swear I have no capital gains!
> I know I can set up dollars account and then convert each individual

entry -
> but then I loose track of the original Euros value for the transaction.
> Thanks!
> Carlos



 
Old 08-18-2004, 07:32 PM
Andrew S. Clark
Guest
 
Posts: n/a
Default Re: Foreign Currency Transactions

I am assuming that your real credit card account is a Euro account. If so
read on. If not - if you are really billed in USD - then set up a USD
credit card account. The currency conversion rate at the time of the
transaction will be kept as you desire. This will solve your problem
(except for the 2% rule below).

For a real Euro credit card set-up in a USD based MS$ file ....
Think of it this way ...You pay for a meal in Paris. It costs you ?100.
The credit card will show in money as -?100
The credit card statement from your bank will show To Pay: ?100
Until you pay - until you convert USD to Euros and pay off the credit card -
you are dependant upon the whims of the international exchanges.
Remember, it's not really converting it to dollars. The dollar value only
represents the outstanding balance at today's exchange rate - until you've
cleared the balance. So it is correct in its behaviour.

I use the UK version of money, and track USD, Euros, GBP. The
"normalization" to a single currency has no real value except to give a
perception of where I am in overall credit/debit. Remember, the exchange
rates are always off +/-2%. MS$04 uses the daily (or momentary) interbank
rate. You and I never get that when we do exchanges. So all costs are
always underestimated.

Andrew.

"Carlos G" <cgnjunkregDELETE[at]hotmail.com> wrote in message
news:ecF4h6ThEHA.3932[at]TK2MSFTNGP09.phx.gbl...
- quote -

> I just set up in MS$04 a new credit card account which is set to use
Euros.
> I use this for my trips to Europe.
> I then setup a custom report that prints out all my expenses for a
> particular trip. The entries from the Euro account are listed in Euros,

and
> then the report total is shown in dollars. So far so good.
> The problem, is that the report total seems to vary depending on TODAY's
> exchange rate. Since the trip is in the past, and the historical

exchange
> rates are fixed, I would like the totals to stay fixed. Is it impossible

to
> do this if the account is in a foreign currency? Does money not keep

track
> of historical exchange rates, like it keeps track of investment prices?
> (wouldn't it be funny if any investment purchase always showed up at

today's
> price - Mr IRS I swear I have no capital gains!
> I know I can set up dollars account and then convert each individual

entry -
> but then I loose track of the original Euros value for the transaction.
> Thanks!
> Carlos



  #-1  
Old 08-18-2004, 04:15 PM
Carlos G
Guest
 
Posts: n/a
Default Foreign Currency Transactions

I just set up in MS$04 a new credit card account which is set to use Euros.
I use this for my trips to Europe.

I then setup a custom report that prints out all my expenses for a
particular trip. The entries from the Euro account are listed in Euros, and
then the report total is shown in dollars. So far so good.

The problem, is that the report total seems to vary depending on TODAY's
exchange rate. Since the trip is in the past, and the historical exchange
rates are fixed, I would like the totals to stay fixed. Is it impossible to
do this if the account is in a foreign currency? Does money not keep track
of historical exchange rates, like it keeps track of investment prices?
(wouldn't it be funny if any investment purchase always showed up at today's
price - Mr IRS I swear I have no capital gains!

I know I can set up dollars account and then convert each individual entry -
but then I loose track of the original Euros value for the transaction.

Thanks!
Carlos


 

Tags
currency, foreign, transactions
Similar Threads
Thread Forum Replies Last Post
Foreign Currency Accounts
Alex: I've searched MS Money help as well as this newsgroup, however, haven't found an answer to the following question: Does MS Money support...
Microsoft Money 2 07-16-2004 01:54 PM
Investment - Foreign Currency
Jimbob: Hi, I have an investment account in 'Canadian Dollars', today I purchased my 1st US stock and I'm trying to figure out how to enter it. When I...
Microsoft Money 1 06-16-2004 10:14 AM
Bonds in Foreign Currency
Ken Cooper: I'm using Money 2004, and having a problem trying to enter bond purchases in a foreign currency. I'm doing so in a dollar based account. When I...
Microsoft Money 2 01-13-2004 03:21 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 06:41 PM.