How to track my expenses that include account transfers

gsdubz

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?

Jon

If you edit the report, there are a couple options on the Advanced tab for including transfers. One option would be to exclude the mortgage account from the report, then on the Advanced tab turn on the "Include selected transfers with accounts outside of the report" option and check the Transfer box below it. If you have transfers to other accounts that are also not included in the report it will pick those up as well, so you'll have to try it out to see if you like the results. The transfers will show up at the bottom of the report in a separate Transfer section.

gsdubz

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.

Jon

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.

jacobs

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.