I'm wonder if anyone of you could send me a Microsoft Money file with
proposed solution of my problem? - it will help me to adapt your proposal
into my files.
Thanks
please email-to: BMR[at]wp.pl
PS.
maybe it would be good idea to add possibility of 'achiving this negative
balance' but I think this is a question to people from Microsoft - anyone can
pass this query?

"BozoZenobia" <bozozenobia[at]nomorespam.chello.at> wrote in message
news:a691b$43cba1a7$d4116e2d$9116[at]news.chello.at...
- quote -

I have no clue.
--
Chris Cowles
Gainesville, FL

Thanks for that. I'll Goggle it and see what comes up. By the way, in
looking at the XML file, it makes reference to IFX, which I assume is a
different format to OFX?


"Chris Cowles" <spam_magnet[at]remove-me-bellsouth.net> wrote in message
news:eTu%23tk9FGHA.3100[at]tk2msftngp13.phx.gbl...
- quote -

"BozoZenobia" <bozozenobia[at]nomorespam.chello.at> wrote in message
news:a4944$43c6ce26$d4116e2d$15860[at]news.chello.at...
- quote -

Excel will open an XML file, no? Assuming so, there are several utilities
available to translate XML to QIF, at least, if not OFX.
--
Chris Cowles
Gainesville, FL

I have a very similar situation to that of the original poster and took a
very simplistic approach that works well for me using Money 2000 Canadian
Edition.

Before going into how I handle the situation using Money, some background
which might be of help to the original poster. Two accounts with the same
bank, one in EUR (regular account) and one in CHF (loan account). For each
periodic payment the bank debits the CHF account with the payment due. The
bank also debits the EUR account with the equivalent amount at the
prevailing CHF/EUR exchange rate. The bank then credits the CHF account
with the principle portion of the amount that was originally debited. All
three transactions have the same value date.

In Money, I handle the situation as follow. The EUR account was already set
up with EUR specified as the currency. A new bank account (*not* a loan
account) was set up (specifying CHF as the currency). As each periodic
payment is processed, the debits to the EUR and CHF accounts are entered
manually. Using Money, the EUR amount (new transaction, of course) is then
transferred to the CHF account to create the credit to that account. Money
asks for an exchange rate or the amount being credited -- I always use the
amount. Viewing the CHF account shows all transactions and the outstanding
balance due. I also set up a report to show the EUR and CHF transactions
using the various payee/account selection criteria.

It may be noted that some transactions are entered manually into Money.
This is because my bank does not provide an OFX download -- only XML and I
haven't yet figured out a way to import such a file into Money 2000! Anyone
out there who knows how?

No apologies for the rather verbose posting, which I have written in a way
that hopefully will be of assistance to the original poster.

"BMR" <BMR[at]discussions.microsoft.com> wrote in message
news:8123BB60-3E49-49C2-A10E-A8EB98428B08[at]microsoft.com...
- quote -

I understand what you want to do. I do not know why you think an Investment
Account uniquely helps solve this problem. What's the investment? How does
the Money investment model help you replicate the cash flow? Money is
flowing from the lender to you when you took out the loan. Your payments are
flowing back to the lender. This is exactly opposite of the Money investment
model. If you are asking how to setup negative shares at the get go--the
bank having invested in you, effectively--Money just can't do it.

I outlined a way to do this without trying to coerce the Money investment
model to fit the problem. Have you considered that?

"BMR" <BMR[at]discussions.microsoft.com> wrote in message
news:8123BB60-3E49-49C2-A10E-A8EB98428B08[at]microsoft.com...
- quote -

Guys,

Let’s imagine that I borrowed from any one of you 1000USD and you expect
that I will pay it back half year later (of course I should pay also interest
but let leave it now). Borrowed 1000USD I exchanged on PLN so I received
assume 3500PLN but now exchange rate for PLN/USD changed and it is as
3,8PLN/1USD so I owe you still 1000USD but for me it is 3800PLN instead
3500PLN (because I need to buy them to pay you back).

And this is what I would like to achieve by using Investment account to
track loan from the bank – I’m sure that if it would be possible to “achieve
this negative balance of shares” I wouldn’t bothering you.

Any way thanks for your up to now help but I hope that we will solve the
problem.


„Dick Watson” pisze:

- quote -

I re-read the prior post and your original post. I **think** I almost
understand what is going on here.

I think Investment Account and Investment are irrelevant here. I'm not at
all sure why you went that route.

I think you want a Loan Account in currency PLN that you deposit the
proceeds from in a CHF denominated account. Money has no easy way to
recognize the relationship between originating a Loan Account and where the
cash flows to/from. So, I'd create the PLN Loan Account, and enter a deposit
in the CHF account as separate activities with maybe a note in the memo
field as to where the money came from.

I've not tried a test case for Loans and cross-currency payments. I have no
idea if Money will let you do this and embed an exchange rate in the Loan
Payment. Given the very limited flexibility in Money for currency exchange,
I'd wonder if it can do it. If it can't, I'd set up a second PLN denominated
account as a Cash Account. (This may have been what you were trying to
accomplish with the investment account, but Investments do not do the other
half--amortizing a loan--of the problem.) I'd use a deposit in the PLN Cash
account, as noted above, to recognize the loan proceeds. I'd transfer out of
the PLN Cash Account to the CHF account to recognize the exchange rate for
the proceeds. I'd transfer from the CHF account to the PLN account to
recognize the payment exchange rate. Then I'd make PLN Loan Payments from
the PLN Cash Account to the PLN Loan Account.

I'm assuming the payment amounts are fixed amounts in PLN so that your CHF
denominated Loan Payments will vary in amount as a function of exchange
rate.

"BMR" <BMR[at]discussions.microsoft.com> wrote in message
news:FC4B2FF5-FDC2-4B2B-9622-6333ABCDF644[at]microsoft.com...
- quote -

Bozo - correct!
Maybe I wasn't clear enought but your interpretation is perfect for me.
Yes I took a loan denominated in CHF but received the borrowed amount in PLN.
I'll repay the loan payable by instalments in PLN with the amount being
converted from CHF (principal+interest) at the prevailing exchange rate.
What I would like to achive is a liability (track of credit level) on
investment account.

Thanks to all for help and explenation of terms abbreviation.



„BozoZenobia” pisze:

- quote -

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:hr28s1dht0im9l5ll1fhq123a19ef3jpuf[at]4ax.com...
- quote -

:^)

BMR:

If I interpret your post correctly, I would guess that you took a loan
denominated in CHF (= Swiss Francs) but received the borrowed amount in PLN
(= Polish Zloty). You repay the loan either all at once or in instalments,
in either case in PLN with the amount being converted to CHF at the
prevailing exchange rate.

If my guess is correct, please confirm and we can go from there.


"BMR" <BMR[at]discussions.microsoft.com> wrote in message
news:3F211635-5EF3-4AC1-B438-FC47A70EE82D[at]microsoft.com...
- quote -

TLA = three letter acronym. I think Cal wants to know what a PLN hold in CHF
is.

"BMR" <BMR[at]discussions.microsoft.com> wrote in message
news:B3113777-10B4-498B-AEDA-115D8FF1575F[at]microsoft.com...
- quote -

In microsoft.public.money, BMR wrote:

- quote -

Its a Three Letter Acronym.

CONVERIUM is the stock that has symbol CHF.

Please translate "PLN" and "CHF".



- quote -

What mean TLA? I don't understand also your question about 'shorting
CONVERIUM' could you be more clear - I'm not so fluent in english...

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, BMR wrote:

- quote -

Are you shorting CONVERIUM or what? I don't know your TLAs.


- quote -

I'm using an old version of Microsoft Money V4.0 and up to now it was enough.
Recently I took a credit for PLN hold in CHF and I try to use investment
account to post this transaction (end track exchange rate) - unfortunatly
I've received info:

" Adding this Sell activity will cause the balance of shares 'CHF' held in
this Investment Account to become negative at some point. Please arrange your
transactions to avoid a negative balance."

it is true massage I don't have any CHF - only borrowing from the bank but I
think that it would be very usefull if it would be possible to achive this
negative balance... Is it possible to track loan taken in other currency in
any of new MM version or is any other possibility to make this posting.

Big thanks in advance if any will go through my problem.