| | |||
| |||
| 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:
The mortgage payment works because it splits payments into a Transfer> 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. 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
This kind of thing is why I don't download transaction data. I don't think> 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. 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
| |||
| |||
| 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 | |
| |