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