Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 12-12-2007, 12:52 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Home Equity Accounts - Track Payments and Asset Value

see inline below

"jerlenaz" <jerlenaz[at]discussions.microsoft.com> wrote in message
news:F65203BE-2B85-46FF-AAAC-395A59511ADB[at]microsoft.com...
- quote -

> There are two parts to my question:
> 1) I setup an "Other" account, set the account specifics (limit, interest
> rate, etc.). When a payment shows up in my checking account, I associate
> the
> payment (thru the categories section) as a Transfer to: Home Equity
> Account.
> The problem, however, is that the payment has both principal and interest,
> and I obviously just want the principal amount to be deducted from the
> line
> of credit amount to show how much my balance is. What is happening is the
> entire payment amount is being deducted from my loan balance, which shows
> an
> incorrect balance.
> When I setup my home mortgage, this method worked fine, so I don't know
> what
> I'm doing wrong.


The mortgage payment works because it splits payments into a Transfer
component and an interest Expense component. I suggest you do the same. Then
the balance of the HELOC account only declines by the transfer amount, not
by the total of the transfer + interest amount.

- quote -

> 2) I have another option - my home equity line of credit is thru my bank
> with the checking account, so I have access to on-line account to download
> the payments made for reconciliation. The issue here is the bank
> separates
> the principal and interest credits (i.e., two separate transactions), so
> when
> I associate the payment in the checking register (i.e., thru the
> Category -
> Transfer to Home Equity Line), the enire amount shows up in the Home
> Equity
> Account and I need to associate two register entries (i.e, the princial
> and
> the equity) to the payment, which I'm unable to do.
> If anyone has any suggestions on what I can do (or where else I can search
> for a solution), I would be very grateful.


This kind of thing is why I don't download transaction data. I don't think
Money will let you take two separate downloaded transactions and associate
both those with split elements of the same transaction as the one we
discussed entering above. You could leave the interest expense, accept and
void the transfer component and then not do the split outlined above for the
entry in your checking account but do the whole amount as a Transfer. Thus
your balance of the HELOC would go down by the whole transferred amount and
then back up by the interest component as downloaded for the HELOC account.
Balance is where it should be then.


  #-1  
Old 12-12-2007, 05:20 AM
jerlenaz
Guest
 
Posts: n/a
Default Home Equity Accounts - Track Payments and Asset Value

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 the
help files, microsoft support, and other technical
communities/blogs/newsletters, and can't seem to find if Money can support
this feature (or how I'm doing in incorrectly).

There are two parts to my question:
1) I setup an "Other" account, set the account specifics (limit, interest
rate, etc.). When a payment shows up in my checking account, I associate the
payment (thru the categories section) as a Transfer to: Home Equity Account.
The problem, however, is that the payment has both principal and interest,
and I obviously just want the principal amount to be deducted from the line
of credit amount to show how much my balance is. What is happening is the
entire payment amount is being deducted from my loan balance, which shows an
incorrect balance.

When I setup my home mortgage, this method worked fine, so I don't know what
I'm doing wrong.

2) I have another option - my home equity line of credit is thru my bank
with the checking account, so I have access to on-line account to download
the payments made for reconciliation. The issue here is the bank separates
the principal and interest credits (i.e., two separate transactions), so when
I associate the payment in the checking register (i.e., thru the Category -
Transfer to Home Equity Line), the enire amount shows up in the Home Equity
Account and I need to associate two register entries (i.e, the princial and
the equity) to the payment, which I'm unable to do.

If anyone has any suggestions on what I can do (or where else I can search
for a solution), I would be very grateful.

thanks,
Jerry
 

Tags
accounts, asset, equity, home, payments, track
Similar Threads
Thread Forum Replies Last Post
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
Asset accounts for home/vehicles
mandg: Is there a way to exclude an adjustment (increase/decrease) to the Assets account from the reports? For instance, when I adjust the Asset account...
Microsoft Money 2 06-29-2004 04:30 AM
Re: Can't link a Home Equity Line of Credit to Home Asset Acct
Javier Ruiz: Thank you Richard, That made sense, I did the change, but for whatever reason, when I go to associate another loan account, the pull-down...
Microsoft Money 2 08-30-2003 03:30 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 11:31 PM.