You need to setup a scheduled Loan Payment:[name of Loan Acct]. Money should
have offered to do this when you created the loan account. You say you setup
a scheduled Bill, but if it is not a Loan Payment special category, the loan
account will not reflect that you are paying it.

The scheduled Loan Payment will automagically calculate an Principal
Transfer (to the loan account balance) amount, and an interest amount
(expensed to the category you specified when you setup the loan account)
that will be based ont he rate you set the loan account up with and the
balance outstanding and the time since the last payment or based on fixed
payment dates, again, depending on how you setup the loan in the first
place. You can edit the series of Loan Payments to add a Transfer:[some cash
account representing the escrow]. Then you can add the tax
payments/insurance payments to [some cash account representing the escrow]
as the mortgage company pays them. You can alternatively make these Loan
Payment detail entries just go directly to Taxes:Property and
Insurance:Home, but that doesn't accurately reflect what's going on. This
covers your a, b, and c items with the one exception that principal is not
normally budgeted. If you never download any transaction data, this should
continue to work just fine.

You go on to say you "end up with double entries in the Mortgage Account
Register". Do you mean you are having two sets of Loan Payments entered, one
from downloaded transactions for the loan account and one from scheduled
Loan Payments? If so, you need to match one with the other in the download
process. I can't tell you much about how to do this because I don't do the
downloadaed transaction data thing and save myself all of these headaches.

"Kris S" <anonymous[at]discussions.microsoft.com> wrote in message
news:2bd501c51ea0$79eca640$a401280a[at]phx.gbl...
- quote -

I am trying to achieve the following:

A. Make monthly entry in Mortgage account register and
apply principle and interest with each automated debit
payment. Track with initial amortization schedule.

B. Apply principle, interest, taxes, and insurance from
the same schedule into their respective budget categories.

C. Track PITI above as each payment is applied.

I set up a loan and got automated entries into the
Mortgage Register, but no debit entries from Checking and
no reflection of the values or activities in Budget. I
then set up a Scheduled Bill and split the categories for
each payment. The budget reflects everything as desired,
but I end up with double entries in the Mortgage Account
Register. I am then unable to match transactions in the
register.

Any input is appreciated!