Home Equity Accounts - Track Payments and Asset Value


J

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

Advertisements

D

Dick Watson

see inline below

jerlenaz said:
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.
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top