How to track my expenses that include account transfers

Question

I try to track my expenses using monthly reports based on categoty. However, this report does not handle transfers very well. For instance, I can input my mortgage data and Quicken knows how to calculate the interest and principal that are paid each month and I can go to my Property and Debt account and see the princopal reduced each month. I can also assign the interest paid to a Loans:Loan Interest category

However, in the catefory monthly report, all I see is the loan interest expense. The money I spend to refuce the principal does not show up as an expense, at least not one that is defined as a category. It shows up as a transfer to the mortgage account and therefore, is not included as a monthly expense.

HOw do I track all my expenditures and income if sokme of those entries are transfers between accounts?

jacobs · Answer

To add to @Jon's comment, in the Advanced tab of the report, you need to select the option to "Include selected transfers with accounts outside of report". That means to include transfers to accounts which are NOT included in the report. So exclude the mortgage account, select this Advanced option, and you'll get a section of your report showing transfers to the loan account.

Jon · Answer

I have selected all accounts to be included in the report

That's why it doesn't work. You need to EXCLUDE the mortgage account.

gsdubz · Answer

Wish that it were so! Maybe I have the accounts set up incorreclty but I have selected all accounts to be included in the report and the mortgage account just doesn't show up.

A second account that I set up was for a no interest loan set up with a relative. They make monnthly payments diectly to my checking account that I then transfer to show a comparable deduction to their loan. The money does not show up as income on my summary no matter how I categorize it.