Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 06-11-2006, 05:22 AM
harrelsonesq
Guest
 
Posts: n/a
Default Re: Loan amortization

Minor caveat to Ian's post: "Loan payment:my mortgage account" is the right
categorization. Beware, though, that there is another category of just "Loan
Payment."

DO NOT USE this one, as it does not do what you want. It also appears before
the correct one as you are scrolling, and the correct one is in
alphabetical, but almost invisible, position between the "Credit Card
Payment:xxxxx" list and the "Transfer:xxxxx" list, in "Special"
transactions, so it is very easy to overlook.

I'm one of the many people who have "had trouble making this work," in the
NG, and that turned out to be what I done to screw it up. After having gone
to all the trouble to set it up correctly, I assigned the just plain "Loan
Payment" category by mistake to the next transaction, which immediately
caused it to stop working.

My .02, so hopefully no one else will do the same.

Susan

"R. Ian Lee" <ian[at]houseoflees_NOMORESPAM.com> wrote in message
news:OyCY91PjGHA.4884[at]TK2MSFTNGP03.phx.gbl...
- quote -

> Be sure that the category for your Bill is setup as "Loan Payment: my
> mortgage account". Until I figured out this was available, I was just
> setting it up as a "Transfer" and getting the effect you describe. When
> you choose "Loan Payment" then Money will split the payment correctly.
> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
> message news:OBIUnHMjGHA.4512[at]TK2MSFTNGP02.phx.gbl...
> > Yes.
> > > The following way:
> > > 1) Use Advanced Register for all accounts. Essential Register should be

> > called Lame Register.
> > 2) Setup an account as a Loan Account to represent the mortgage.
> > 3) Setup a Bill (use Advanced Bills for the same reason noted above) that
> > is a Loan Payment:[name of loan account setup in step 2]. The Setup
> > Accounts wizard for Loan Accounts will offer to do this for you.
> > 4) Enter the Loan Payments from Bills Summary and then make sure to match
> > the downloaded transaction to the scheduled Loan Payments. For more on
> > this read the correct 10% of threads in the newsgroup that deal with
> > everybody's problems making this work.
> > > "oceans777" <oceans777[at]discussions.microsoft.com> wrote in message

> > news:EDADCBAD-1AC8-4349-8667-79333AF426D9[at]microsoft.com...
> > > I am setting up Microsoft Money 2006, and I would like to have my
> > > mortgage
> > > listed as one of my accounts, so I can automatically see how much
> > > principle
> > > is still owed. I also would like to have my mortgage set up as an
> > > automatic
> > > bill each month. However, when I have the automatic payment set up, it
> > > simply deducts that entire payment (PITI) from the principal amount
> > > owed,
> > > even though I have a fixed loan and my principle payment changes each
> > > month.
> > > I would like to set it up somehow so that when I automatically pay the
> > > mortgage, the amount of the loan remaining changes to the correct amount
> > > of
> > > principal each month without me always having to go type it in. Is this
> > > possible? And, if so, how do you do it?!

> >


  #1  
Old 06-11-2006, 02:19 AM
R. Ian Lee
Guest
 
Posts: n/a
Default Re: Loan amortization

Be sure that the category for your Bill is setup as "Loan Payment: my
mortgage account". Until I figured out this was available, I was just
setting it up as a "Transfer" and getting the effect you describe. When you
choose "Loan Payment" then Money will split the payment correctly.


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:OBIUnHMjGHA.4512[at]TK2MSFTNGP02.phx.gbl...
- quote -

> Yes.
> The following way:
> 1) Use Advanced Register for all accounts. Essential Register should be
> called Lame Register.
> 2) Setup an account as a Loan Account to represent the mortgage.
> 3) Setup a Bill (use Advanced Bills for the same reason noted above) that
> is a Loan Payment:[name of loan account setup in step 2]. The Setup
> Accounts wizard for Loan Accounts will offer to do this for you.
> 4) Enter the Loan Payments from Bills Summary and then make sure to match
> the downloaded transaction to the scheduled Loan Payments. For more on
> this read the correct 10% of threads in the newsgroup that deal with
> everybody's problems making this work.
> "oceans777" <oceans777[at]discussions.microsoft.com> wrote in message
> news:EDADCBAD-1AC8-4349-8667-79333AF426D9[at]microsoft.com...
> > I am setting up Microsoft Money 2006, and I would like to have my mortgage
> > listed as one of my accounts, so I can automatically see how much
> > principle
> > is still owed. I also would like to have my mortgage set up as an
> > automatic
> > bill each month. However, when I have the automatic payment set up, it
> > simply deducts that entire payment (PITI) from the principal amount owed,
> > even though I have a fixed loan and my principle payment changes each
> > month.
> > I would like to set it up somehow so that when I automatically pay the
> > mortgage, the amount of the loan remaining changes to the correct amount
> > of
> > principal each month without me always having to go type it in. Is this
> > possible? And, if so, how do you do it?!



 
Old 06-10-2006, 07:13 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Loan amortization

Yes.

The following way:

1) Use Advanced Register for all accounts. Essential Register should be
called Lame Register.
2) Setup an account as a Loan Account to represent the mortgage.
3) Setup a Bill (use Advanced Bills for the same reason noted above) that is
a Loan Payment:[name of loan account setup in step 2]. The Setup Accounts
wizard for Loan Accounts will offer to do this for you.
4) Enter the Loan Payments from Bills Summary and then make sure to match
the downloaded transaction to the scheduled Loan Payments. For more on this
read the correct 10% of threads in the newsgroup that deal with everybody's
problems making this work.

"oceans777" <oceans777[at]discussions.microsoft.com> wrote in message
news:EDADCBAD-1AC8-4349-8667-79333AF426D9[at]microsoft.com...
- quote -

> I am setting up Microsoft Money 2006, and I would like to have my mortgage
> listed as one of my accounts, so I can automatically see how much
> principle
> is still owed. I also would like to have my mortgage set up as an
> automatic
> bill each month. However, when I have the automatic payment set up, it
> simply deducts that entire payment (PITI) from the principal amount owed,
> even though I have a fixed loan and my principle payment changes each
> month.
> I would like to set it up somehow so that when I automatically pay the
> mortgage, the amount of the loan remaining changes to the correct amount
> of
> principal each month without me always having to go type it in. Is this
> possible? And, if so, how do you do it?!



  #-1  
Old 06-10-2006, 06:51 PM
oceans777
Guest
 
Posts: n/a
Default Loan amortization

I am setting up Microsoft Money 2006, and I would like to have my mortgage
listed as one of my accounts, so I can automatically see how much principle
is still owed. I also would like to have my mortgage set up as an automatic
bill each month. However, when I have the automatic payment set up, it
simply deducts that entire payment (PITI) from the principal amount owed,
even though I have a fixed loan and my principle payment changes each month.
I would like to set it up somehow so that when I automatically pay the
mortgage, the amount of the loan remaining changes to the correct amount of
principal each month without me always having to go type it in. Is this
possible? And, if so, how do you do it?!
 

Tags
amortization, loan
Similar Threads
Thread Forum Replies Last Post
Money 2005 bug in loan amortization?
R: I may have found one. In Money on my mortgage I clicked on the link on the left that says "Analyze Loan". The table that then displays looks...
Microsoft Money 2 11-16-2004 12:40 AM
Loan Amortization Report?
Sara: Hi, I just got Money Deluxe and am playing with it. One of the primary purposes for my purchase was to do a loan amortization report - but when I...
Microsoft Money 2 11-24-2003 11:09 PM



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 08:02 PM.