Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 02-11-2006, 10:44 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Multi-exchange rates

And none of the other ones helped? I could have saved a lot of typing...

"Rajesh" <Rajesh[at]discussions.microsoft.com> wrote in message
news:06757B4A-92CA-4624-881A-D5AAFBFC6311[at]microsoft.com...
- quote -

> Your last comment (sort of) replies my question. Thanks


  #1  
Old 02-11-2006, 10:17 PM
Rajesh
Guest
 
Posts: n/a
Default Re: Multi-exchange rates

HI Dick
Your last comment (sort of) replies my question. Thanks

rajesh

"Dick Watson" wrote:

- quote -

> I'm not sure I understand your case. If the account is AUD, then
> transactions get entered in that account in AUD and, once entered, how the
> individual transaction got to an AUD amount from a USD amount is lost
> forever. There is no way I know of to have transaction level exchange
> information retained except if a transfer between two accounts of the
> different currencies is involved. Perhaps I'm missing something incredibly
> fundamental here. (I'm wondering if downloaded transaction data and
> unaccepted transactions are involved here.) I'd love to have somebody show
> me a better way.
> As near as I can tell, there are two choices:
> 1) accept that transactions on the AUD card are entered exclusively in the
> AUD amounts and do not worry about the USD amount. Since the charge slips
> you walk away with will be in USD, this implies waiting for the bank
> statement to get the AUD amount. Even if you use the F8 currency converter,
> once entered, the original currency and the exchange rate applied is lost.
> Only the account-currency amount is retained.
> 2) enter the USD transactions in a USD account in USD and split the
> transaction and include a transfer to the transaction from the AUD credit
> card account that offsets the USD amount exactly. This allows each
> transaction to carry its own exchange rate. But the problem of waiting for
> the AUD statement--or hand adjusting the amount that gets in the AUD
> account--is still there.
> So you can understand this, here's an example.
> (In the USD Cash Account
> Payee: Royal Hawaiian Hotel, $0 split:
> category Vacation:Lodging $987.00
> category Transfer:My Aussie VISA -$987.00
> [When you enter this, Money will ask for the AUD amount or an exchange rate.
> Let's say you enter the AUD amount as AUD 1,338.40 or the exchange rate as
> 1.356:1]
> (the other half of that split will show up in the AUD account "My Aussie
> VISA"
> Payee: Royal Hawaiian Hotel, AUD 1,338.40, category Transfer:USD Cash Acct
> The transaction will retain this exchange rate and the AUD and USD amounts
> forever regardless of future exchange rate differences.
> Money should support creating any transaction in any account in some foreign
> currency and retain this information with the transaction. It doesn't.
> Money's support for people who get around the world is pretty weak.
> "Rajesh" <Rajesh[at]discussions.microsoft.com> wrote in message
> news:F76AA8EB-8DB4-472A-AAB1-231968EDD217[at]microsoft.com...
> > I maintain bank accounts and credit card accounts in other countries (like
> > Australia). When I use my Australian credit card in US, I get charged in
> > AUD
> > for the USD spent.
> > > MSMoney base currency is USD. The Australian Credit Card currency is AUD

> > (this allows me to match the dues in MS Money with dues on the card or
> > bank
> > statement). But MS Money allows only on exchange rate; whereas I get
> > charged
> > by my Australian bank at varying rates depending on market rates. So this
> > is
> > the problem:
> > > Actual spend in USD on 01/01/2006 100

> > Actual charge on AUD card statement 01/01/2006 126
> > Actual expenses in MS Money 100 USD (base
> > currency)
> > Dues to bank/ card 126 AUD
> > (ex
> > rate set [at] 1.26)
> > > Next Transaction:

> > Actual spend in USD on 01/20/2006 100
> > Actual charge on AUD card statement 01/10/2006 130
> > Actual expenses in MS Money 100 USD (base
> > currency)
> > Dues to bank/ card 126 AUD
> > (ex
> > rate set [at] 1.26)
> > > If I try to change the exchange rate to 1.3 (on 01/10/2006), then the

> > previous transaciton also adjusts to that rate. So it all goes off....
> > > any solutions???

 
Old 02-11-2006, 05:07 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Multi-exchange rates

I'm not sure I understand your case. If the account is AUD, then
transactions get entered in that account in AUD and, once entered, how the
individual transaction got to an AUD amount from a USD amount is lost
forever. There is no way I know of to have transaction level exchange
information retained except if a transfer between two accounts of the
different currencies is involved. Perhaps I'm missing something incredibly
fundamental here. (I'm wondering if downloaded transaction data and
unaccepted transactions are involved here.) I'd love to have somebody show
me a better way.

As near as I can tell, there are two choices:

1) accept that transactions on the AUD card are entered exclusively in the
AUD amounts and do not worry about the USD amount. Since the charge slips
you walk away with will be in USD, this implies waiting for the bank
statement to get the AUD amount. Even if you use the F8 currency converter,
once entered, the original currency and the exchange rate applied is lost.
Only the account-currency amount is retained.

2) enter the USD transactions in a USD account in USD and split the
transaction and include a transfer to the transaction from the AUD credit
card account that offsets the USD amount exactly. This allows each
transaction to carry its own exchange rate. But the problem of waiting for
the AUD statement--or hand adjusting the amount that gets in the AUD
account--is still there.

So you can understand this, here's an example.

(In the USD Cash Account
Payee: Royal Hawaiian Hotel, $0 split:
category Vacation:Lodging $987.00
category Transfer:My Aussie VISA -$987.00

[When you enter this, Money will ask for the AUD amount or an exchange rate.
Let's say you enter the AUD amount as AUD 1,338.40 or the exchange rate as
1.356:1]

(the other half of that split will show up in the AUD account "My Aussie
VISA"
Payee: Royal Hawaiian Hotel, AUD 1,338.40, category Transfer:USD Cash Acct

The transaction will retain this exchange rate and the AUD and USD amounts
forever regardless of future exchange rate differences.

Money should support creating any transaction in any account in some foreign
currency and retain this information with the transaction. It doesn't.
Money's support for people who get around the world is pretty weak.

"Rajesh" <Rajesh[at]discussions.microsoft.com> wrote in message
news:F76AA8EB-8DB4-472A-AAB1-231968EDD217[at]microsoft.com...
- quote -

> I maintain bank accounts and credit card accounts in other countries (like
> Australia). When I use my Australian credit card in US, I get charged in
> AUD
> for the USD spent.
> MSMoney base currency is USD. The Australian Credit Card currency is AUD
> (this allows me to match the dues in MS Money with dues on the card or
> bank
> statement). But MS Money allows only on exchange rate; whereas I get
> charged
> by my Australian bank at varying rates depending on market rates. So this
> is
> the problem:
> Actual spend in USD on 01/01/2006 100
> Actual charge on AUD card statement 01/01/2006 126
> Actual expenses in MS Money 100 USD (base
> currency)
> Dues to bank/ card 126 AUD
> (ex
> rate set [at] 1.26)
> Next Transaction:
> Actual spend in USD on 01/20/2006 100
> Actual charge on AUD card statement 01/10/2006 130
> Actual expenses in MS Money 100 USD (base
> currency)
> Dues to bank/ card 126 AUD
> (ex
> rate set [at] 1.26)
> If I try to change the exchange rate to 1.3 (on 01/10/2006), then the
> previous transaciton also adjusts to that rate. So it all goes off....
> any solutions???



  #-1  
Old 02-11-2006, 12:56 AM
Rajesh
Guest
 
Posts: n/a
Default Multi-exchange rates

I maintain bank accounts and credit card accounts in other countries (like
Australia). When I use my Australian credit card in US, I get charged in AUD
for the USD spent.

MSMoney base currency is USD. The Australian Credit Card currency is AUD
(this allows me to match the dues in MS Money with dues on the card or bank
statement). But MS Money allows only on exchange rate; whereas I get charged
by my Australian bank at varying rates depending on market rates. So this is
the problem:

Actual spend in USD on 01/01/2006 100
Actual charge on AUD card statement 01/01/2006 126
Actual expenses in MS Money 100 USD (base
currency)
Dues to bank/ card 126 AUD (ex
rate set [at] 1.26)

Next Transaction:
Actual spend in USD on 01/20/2006 100
Actual charge on AUD card statement 01/10/2006 130
Actual expenses in MS Money 100 USD (base
currency)
Dues to bank/ card 126 AUD (ex
rate set [at] 1.26)

If I try to change the exchange rate to 1.3 (on 01/10/2006), then the
previous transaciton also adjusts to that rate. So it all goes off....

any solutions???

Thanks

Rajesh



 

Tags
multiexchange, rates
Similar Threads
Thread Forum Replies Last Post
Update online prices and exchange rates
Neil: I have Money 2001 OEM Version 9 About four months ago I started getting error messages for downloads of stock exchange indices for Sydney, London...
Microsoft Money 1 10-08-2005 11:27 AM
Deleting Exchange Rates
CR-Taipan: Does anyone know how to delete exchange rates you do not use? The list shows a lot of currencies I do not have plan to use ever (eg Zambia) Thx!
Microsoft Money 1 03-11-2005 06:16 AM



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 04:41 PM.