Balance of shares become negative :(

Balance of shares become negative :(

Post by Qk1S » Thu, 12 Jan 2006 03:34:02


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.
 
 
 

Balance of shares become negative :(

Post by via_newsgr » Thu, 12 Jan 2006 03:40:52


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

 
 
 

Balance of shares become negative :(

Post by Qk1S » Thu, 12 Jan 2006 03:59:02

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...
 
 
 

Balance of shares become negative :(

Post by via_newsgr » Thu, 12 Jan 2006 04:33:19


Its a Three Letter Acronym.

CONVERIUM is the stock that has symbol CHF.

Please translate "PLN" and "CHF".
 
 
 

Balance of shares become negative :(

Post by Dick Watso » Thu, 12 Jan 2006 04:34:29

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

Balance of shares become negative :(

Post by BozoZenobi » Thu, 12 Jan 2006 07:27:02

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.




enough.
your
I
in
 
 
 

Balance of shares become negative :(

Post by Chris Cowl » Thu, 12 Jan 2006 12:37:19


:^)
 
 
 

Balance of shares become negative :(

Post by Qk1S » Thu, 12 Jan 2006 20:13:02

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.



ozoZenobiapisze:
>> 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. >> >>

>>>> 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. >> >> >>
 
 
 

Balance of shares become negative :(

Post by Qk1S » Sat, 14 Jan 2006 02:46:03

Guys,

Let 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 sure that if it would be possible to chieve
this negative balance of sharesI wouldn bothering you.

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


ick Watsonpisze: >
> 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>
>>

>> > 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 bein> >> > converted from CHF (principal+interest) at the prevailing exchange rate> >> > What I would like to achive is a liability (track of credit level) o> >> > investment account> >> > >> > Thanks to all for help and explenation of terms abbreviation.>
>>
>>
>
 
 
 

Balance of shares become negative :(

Post by Dick Watso » Sat, 14 Jan 2006 04:21:24

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?



interest
"achieve
 
 
 

Balance of shares become negative :(

Post by BozoZenobi » Sat, 14 Jan 2006 06:46:09

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" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
interest
"achieve
at
the
deposit
no
Loan
exchange,
denominated
other
Cash
out of
for
from
CHF
me.
in
being
rate.


 
 
 

Balance of shares become negative :(

Post by Chris Cowl » Sat, 14 Jan 2006 09:34:53


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
 
 
 

Balance of shares become negative :(

Post by BozoZenobi » Tue, 17 Jan 2006 22:37:39

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?






and
 
 
 

Balance of shares become negative :(

Post by Chris Cowl » Wed, 18 Jan 2006 02:04:26


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

Balance of shares become negative :(

Post by Qk1S » Fri, 20 Jan 2006 00:40:04

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: XXXX@XXXXX.COM
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?