That is a tough one. One way around it might be to set the Escrow account as
Not in budget. The TI will still show up in Debt but the thought I have is
that the stuff in the escrow wouldn't show up in the budget. This seems a
sub-optimal suggestion, bet there you have it. Were I designing Money, the
debt section wouldn't exist.

"Thomas Poteau" <thomas_poteau[at]hotmail.com> wrote in message
news:uYHQWztJGHA.2808[at]TK2MSFTNGP15.phx.gbl...
- quote -

I have some kind of the same problems with the PITI. The reasoning make
sense but there is one thing that doesn't seem to work.
By doing 3b, there TI will appear in the Debt section of the budget report.
However the step on 3c will be recorded in you spending category in your
budget reports. This means that in your budget report you will have the TI
included in the Debt (since they are part on your loan payment) and you will
also have the in the expense category which means they are counted twice.
The only way I can solve the problem is by not including the TI in the loan
payment but have them as a separate bill.

Can you tell me if my reasoning make sense as well as my solution.

Thank you


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:OEwXeNsGGHA.2040[at]TK2MSFTNGP14.phx.gbl...
- quote -

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:OEwXeNsGGHA.2040[at]TK2MSFTNGP14.phx.gbl...
- quote -

Slight clarification: it will not show up in spending reports, but it *will*
show up in budget reports. That's because all "Loan Payment: XXX"
transactions are categorized under the special 'Debt' budget category, if
paid out of accounts included in the budget.

The amount that appears is the total payment, including principal, interest,
and escrow.
--
Chris Cowles
Gainesville, FL

Let me answer the Paycheck question as well.

Money provides a type of transaction called a Paycheck that is a split that
has separated sections for wages, before tax deducts, taxes, and after tax
deducts. On it, you enter categorized entries to match your pay stub. For
instance, on the Taxes tab you might have entries for Taxes:Federal Income
Tax, Taxes:Medicare Tax, Taxes:Social Security Tax, Taxes:State Income Tax,
and Taxes:Local Income Tax. On the After Tax Deductions tab, you might have
Transfer:Savings. On the Before Tax Deductions tab you might have
Insurance:Health, Transfer:Healthcare Spending, and Transfer:My 401k
(contributions). On the Wages tab, you might have Wages & Salary:Gross and
Wages & Salary:Bonus.

Back to your first question. Did you create categories named Mortgage -
Principal and Mortgage - Interest and so on? That's another way, but you may
find in the long term that it is inadequate and complicates reporting or
really understanding what's going on. Money supports--but M06 tries to
deemphasize--a two level scheme for things like Taxes (examples above) and
Interest (Interest:Mortgage) and Insurance (Insurance:Homeowners). This
enables looking at things at a more macroscopic level when this is helpful.
I.e., all Insurance costs regardless of type, or all Interest expense.
Categorizing it into four categories as I think I read you are doing does
not enable this, nor does it enable you to track the loan balance itself.

You might want to enable Advanced Register, if you haven't already, and
enable Advanced Reports. You might also want to open the sample data file
and look around in it.

"Sc0rp10n" <Sc0rp10n[at]discussions.microsoft.com> wrote in message
news:E811494F-7645-44AB-85D7-258F88D4B290[at]microsoft.com...
- quote -

Here's how Money intends to solve this:

1) Create a Loan Account to model the mortgage.
2) Setup scheduled Loan Payments and/or enter Loan Payments to pay the
mortgage. A Loan Payment is a smart split for the P+I that has a Principal
Transfer to the Loan Account to reduce the liability. This component will
not show up in spending reports since it isn't really spending. You spend
the money when you bought the house. Now you are just paying the loan back.
The other element of the Loan Payment split is an interest expense (you tell
it the expense category to assign it to when you create the Loan Account)
that Money calculates for you each time you enter one of these Loan
Payments. That takes care of P+I.
3) I'm guessing you are asking about PITI because the lender is escrowing
the T+I. Assuming your T+I is paid by the lender from an escrow account,
here's how to handle it:
3a) Create a Cash Account to match the escrow account.
3b) Add another element to the Loan Payment mentioned above that is a
Transfer:[name of cash account modeling lender escrow account] for the
monthly T+I amount.
3c) Schedule the Insurance and Taxes expense payments to come out of the
Cash Account to match the schedule for your locality and insurance company.
These expenses will also get in your spending category reports. But they get
in there in the month they occur, not in the month you loan your money to
the loan company to cover them.

That's the best practices way. There are different ways that track the
activity less comprehensively.

"Sc0rp10n" <Sc0rp10n[at]discussions.microsoft.com> wrote in message
news:E811494F-7645-44AB-85D7-258F88D4B290[at]microsoft.com...
- quote -

Hi. In MS Money 2006 I split my mortgage transaction down into 4 categories:

Mortgage - Principal
Mortgage - Interest
Mortgage - Taxes
Mortgage - Insurance

I would like for my total mortgage payment to show up in reports like the
"Spending by Category" on the Money Home Page or in my Budget. I would also
like to do the same thing for my paycheck. I want to be able to get the
detail level, but want the total transaction amount to show up on reports.
Does this make any sense? Is this possible?