How to have an expense which is a transfer to another account show up in a report
I am using Quicken 2017 Version 4.4.3 (Build 44.15091.100)
It seems like there should be solution for this, but I am not sure how to handle it properly. Or, perhaps, I am just thinking about this in the right way.
I have a liability account (a mortgage loan) which shows up in the accounts list at a Debt and which is used to track the payments on principal. I make payments on this mortgage from my checking account. Each payment of X is split into three parts - Principal, Interest, & Taxes. The money which goes into interest and taxes shows up in a a category summary report, but the money which is going towards principal does not. I would like to be able to track the money going towards principal as any other expense so I can see a "true" money out total. Is this possible?
I suppose what would work is to not have the split include the principal payment as a transfer to a liability account and then add the deductions to the loan account seperately. Is that the only solution?
Is there something I could be doing better or differently?
It seems like there should be solution for this, but I am not sure how to handle it properly. Or, perhaps, I am just thinking about this in the right way.
I have a liability account (a mortgage loan) which shows up in the accounts list at a Debt and which is used to track the payments on principal. I make payments on this mortgage from my checking account. Each payment of X is split into three parts - Principal, Interest, & Taxes. The money which goes into interest and taxes shows up in a a category summary report, but the money which is going towards principal does not. I would like to be able to track the money going towards principal as any other expense so I can see a "true" money out total. Is this possible?
I suppose what would work is to not have the split include the principal payment as a transfer to a liability account and then add the deductions to the loan account seperately. Is that the only solution?
Is there something I could be doing better or differently?
0
This discussion has been closed.

Comments
I've played with this a bit and I see what you're talking about and completely agree. Here's an example from my data. Two transactions in the category "Personal", one of which has a transfer to another account:
The Category Summary report for these looks like this:
I agree that one would expect to see both "Personal" transactions listed in the Money Out section. After all, you categorized the transaction so that you'd be able to see the total of expenses in that category. If you didn't care about the category, you would have just used the built-in "Transfer" category.
As you say, this is not necessarily a bug. But it does appear to be a poor design and is incompatible with how users would expect the report to work.
In your case, I don't see a great workaround. You could do as you mentioned: stop using a transfer in your mortgage payment transaction and enter a separate transaction in the liability account. But that's double work and hides the relationship between the checking and loan accounts. The only other alternative I see is to just be aware that you have to generate a report for your principal payments separately.
In my case, your having pointed out this flaw is going to make me change how I record my PayPal transactions.
I will report this issue on our SU channel. I'm not sure it's going to have any impact. In the mean time, there are a couple of IDEA threads you may want to go VOTE on. After you go to and read the thread, make sure to click VOTE in the upper right. Here they are:
https://getsatisfaction.com/quickencommunity/topics/create-a-useful-category-transaction-detail-repo...
https://getsatisfaction.com/quickencommunity/topics/add-ability-to-include-or-exclude-transfers-on-r...
A transfer is neither an Income nor an Expense ... because you are neither richer nor poorer after a transfer. Just as moving your wallet from pocket to pocket (a transfer) makes you neither richer nor poorer.
Now running Quicken Windows Subscription, Home & Business
Retired "Certified Information Systems Auditor" & Bank Audit VP
"I use the following workaround to deal with this situation in QM17 to accurately budget and report loan payments. I learned it courtesy of QM user Snoopy FC. Here's Snoopy's description of the workaround:
'I don't have any issues with the budget or reports with the following setup. I have one scheduled payment for the mortgage payment in my bank account. That payment is split to account for the payment on the mortgage, interest, real estate taxes, insurance, additional principal payment, etc. This transaction is budgeted and reported. The other scheduled payment is for the transaction in the mortgage balance account (principal reduction). This uncategorized transaction is not "budgeted or reported." This way there's no double accounting.'
(Note: Both scheduled transactions have to be manually modified every month when they come in. In your budget and in reports, make sure "Uncategorized" is deselected in the customization window)"
https://getsatisfaction.com/quickencommunity/topics/loan-amortization-isnt-supported-in-q-2017-for-m...
Much better, I think, would be if Quicken would treat the transaction as both a transfer and an expense if the user has put a non-"Transfer" category in along with the transfer-to account.
Using Q2017 Deluxe, the budget view of budget by month and total for year allows selection of categories to budget. In the category selection screen there is also a chance to select transfers to budget. I have used this method to budget loan payments both to interest accounts and loan accounts. Many reports also allow the inclusion of transfers in the Advanced tab, and works provided the account including the transfers is included in the Accounts tab of the report.