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