Auto loan monthly payments & final payoff vs Expenses Total for the year.

Question

I had an auto loan that had monthly payments and a full payoff, all in 2021.

I established a liability account for the loan and made 9 payments. Then I paid off the balance. My approach was not optimal and now I want to get full year expenses to buy the car correct.

The primary issue is the monthly payments do not show up in my expenses, given my mistake in the way I set this up. I wish to add these monthly payments to the payoff (which is properly in expenses for the year) so the report "by category" contains the full amount of what I spent on the car in 2021.

Any ideas?
 N+13

N+13 · Answer

To Tom and Jim: thanks for the advice and effort you put in. I'll distill it and come up with something that works for me. Stay safe.

Tom Young · Answer

I'm puzzled too.  Quicken uses no judgement and exercises no discretion when it comes to your accounting.  Its output should flow logically from your input and how you set up your reports.You said you set up a loan, made monthly payments, then paid off the balance.  All those entries, even the payoff, should look exactly the same, differing only in their amounts:Debit (reduce) Loan Liability Account                   $XXX
Debit (increase) Car Interest Expense Category $YYY
Credit (decrease) Cash in Bank Account              $ZZZThe Car Interest Expense will, automatically, show up in a spending report as an expense because that $YYY amount was posted to a Category.  If I wanted to principal amounts to also show up as an expense then I'd customize the report to include that as a form of "Expense."  It would show up as a line item reading "TO Loan Liability Account."  The sum of the Car Interest Expense and the To Loan Liability Account amount would represent the cost of car ownership (principal plus interest) as a current event.If I was adamant that all amounts paid would reflect the car ownership expense then I wouldn't set up the car loan at all, I'd do as @Jim_Harman suggests and make every payment look like:Debit (increase) Car Expense Category    $AAA
Credit (decrease) Cash in Bank Account   $AAAThat way a Spending report, right out of the box, would show all payments as an expense posted to the Car Expense Category.Any report covering the entire event - taking out the loan to final loan payoff - would present either of these accounting approaches consistently, it's not going to leave off "regular payments" but present "loan payoff."So, you're not giving us the complete picture or have found a Big Bug in Quicken.  It appears that you did use a Category, not an Account, for the offset to your final payment, which now brings up the "complementary" question to my first question: How did you get the loan off the balance sheet? (And, despite what @Jim_Harman says, I have no problem with anybody's presentation of anything.  I've certainly shown transfers between Accounts as a form of expense of income as it suits my purpose.  I answered as I did because you did set up a car loan Account, which suggests that you had to get rid of that car loan Account, somehow, and the only way to get rid of that loan through a series of payments is by making the transfers show up as a quasi-expense.)

Jim_Harman · Answer

The simple way to handle this would be to not set up the loan at all and just record all your payments as expenses.

Or you could exclude the loan account from your spending report and set the Transfers setting on the advanced tab of the report to Exclude internal.

[@Tom Young may object to this]