Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 11-10-2008, 08:52 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: How Can I Track Home Equity LOC Interest and Principal?

A third great way. Probably better than the other two and yes, the ability to
enter these kinds of charges during the balance account wizard is exaclty
what that is there for. Note that this ends up making transactions exactly
like one of the two methods I posted.

"ScottW" wrote:

- quote -

> When I make a payment, I book it as a transfer from savings/checking to
> HELOC account. When I reconcile the statement, I enter interest charged for
> the month in the interest area of the rec box & everything works out fine.

  #2  
Old 11-10-2008, 05:06 PM
ScottW
Guest
 
Posts: n/a
Default Re: How Can I Track Home Equity LOC Interest and Principal?

When I make a payment, I book it as a transfer from savings/checking to
HELOC account. When I reconcile the statement, I enter interest charged for
the month in the interest area of the rec box & everything works out fine.

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uxSuxBfQJHA.1448[at]TK2MSFTNGP04.phx.gbl...
- quote -

> .$9,750 and the $150 in Interest Expense : HELOC Interest will.
> "Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
> message news:upmxvMdQJHA.3404[at]TK2MSFTNGP05.phx.gbl...
> > Interest, and a $250 Transfer to the HELOC. The HELOC balance will now be
> > $9,750 and the $250 in Interest Expense : HELOC Interest will also have
> > been recorded.



  #1  
Old 11-08-2008, 09:22 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: How Can I Track Home Equity LOC Interest and Principal?

…$9,750 and the $150 in Interest Expense : HELOC Interest will…

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:upmxvMdQJHA.3404[at]TK2MSFTNGP05.phx.gbl...
- quote -

> Interest, and a $250 Transfer to the HELOC. The HELOC balance will now be
> $9,750 and the $250 in Interest Expense : HELOC Interest will also have
> been recorded.


 
Old 11-08-2008, 05:52 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: How Can I Track Home Equity LOC Interest and Principal?

Since a HELOC allows non-fixed payments, the way to do this is a two step
activity. You have to enter principal payments to offset the liability
balance. And you have to enter interest expenses. There are basically two
choices on how to do this.

1) Enter expense transactions in the HELOC account register that represent
the interest Expense component. To do this you just enter the transaction
like any other as a Charge in the amount of interest reported on your
statements. Then make the payment just as a Transfer into the account. (It
will show as Credit.) Example: say you have a $10,000 balance and get a
statement that says you owe $400 and were charged $150 in interest. Enter
the Expense transaction of $150--balance now $10,150. Enter the $400
Transfer--balance now $9,750.

2) Split the payment transaction to include both a Transfer and a Expense
component for the interest. Example: say you have a $10,000 balance and get
a statement that says you owe $400 and were charged $150 in interest. Enter
a $400 transaction in, say, your checking Account. Split this transaction
into the Expense transaction of $150, category, say Interest Expense : HELOC
Interest, and a $250 Transfer to the HELOC. The HELOC balance will now be
$9,750 and the $250 in Interest Expense : HELOC Interest will also have been
recorded.

If you don't know how the bank calculates interest and principal before you
make the payment, your only good choice is to go fix it after the fact when
you get the next statement.

"lanekp" <lanekp[at]discussions.microsoft.com> wrote in message
news:5F4C300F-37EF-4462-97D6-71373ABFEB48[at]microsoft.com...
- quote -

> Using Money Plus Home & Business.
> I created a HELOC account and have a simple question.
> The account register has one column named "Charge"
> and another named "Credit".
> When I withdraw from the account, the xaction shows
> up on the "Charge" column, when I deposit into the account the
> xaction shows up in the "Credit" column.
> Here's my question:
> How can I track my interest and principal payments in my HELOC
> account?
> If I have an outstanding balance and make a deposit, of say, $100.00 into
> the account, that $100 deposit gets put into the "Credit" column and the
> account balance goes down by $100.00. In other words, it doesn't
> calculate
> the interest and principal of the $100.00, it treats the entire amount as
> principal.
> Of course, my bank is charging me interest on the outstanding balance
> so my Money acct is out of sync with my bank statement.
> goes down by $100.00.


  #-1  
Old 11-08-2008, 05:29 PM
lanekp
Guest
 
Posts: n/a
Default How Can I Track Home Equity LOC Interest and Principal?

Using Money Plus Home & Business.
I created a HELOC account and have a simple question.
The account register has one column named "Charge"
and another named "Credit".
When I withdraw from the account, the xaction shows
up on the "Charge" column, when I deposit into the account the
xaction shows up in the "Credit" column.

Here's my question:

How can I track my interest and principal payments in my HELOC
account?

If I have an outstanding balance and make a deposit, of say, $100.00 into
the account, that $100 deposit gets put into the "Credit" column and the
account balance goes down by $100.00. In other words, it doesn't calculate
the interest and principal of the $100.00, it treats the entire amount as
principal.

Of course, my bank is charging me interest on the outstanding balance
so my Money acct is out of sync with my bank statement.
goes down by $100.00.
 

Tags
equity, home, interest, loc, principal, track
Similar Threads
Thread Forum Replies Last Post
Home Equity Accounts - Track Payments and Asset Value
jerlenaz: I'm trying to setup a Home Equity Line of Credit Account in Money to track my payments, and equity value left on the equity payments. I've scoured...
Microsoft Money 1 12-12-2007 12:52 PM
How to Accurately Show Interest Payments in Home Equity Loan
TLMc: This is driving me crazy. Does anyone have a good workaround? I transfer $1000 out of my checking to my Home Equity Loan in MS Money. Checking...
Microsoft Money 1 04-05-2007 12:45 PM
Home Equity Loan - Interest computed on a 365/365 simple interest basis
Kathleen Anderson [MVP - FrontPage]: I recently took out a Home Equity Loan with Bank of America and set it up in Money 2004. The first payment was taken by auto-debit a couple of days...
Microsoft Money 11 10-21-2005 03:45 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 03:01 AM.