How to exclude budget adjustments from loan view (Q Mac)
I have a couple of loans set up with all details (auto / mortgage). For budget purposes I have an itemization for the loan payments in total of the payment amount. Then there is a corresponding adjustment to remove that payment. This keeps my budget correct but plays havoc with the loan details graphs and spending reports. Is there any way to exclude the budget-only payment and adjustment items from the loan summary?
The lines are little hard to see, but in the graph 50% of the spend is "Mortgage". That makes sense when that line item is the same as the total payment. If there were a way to suppress that payment line or, if not that, also include the counterparty adjusting line item to more accurately present the spend in the context of the loan and related reporting.
Best Answer
-
Thanks, guys. These suggestions work for my needs.
0
Answers
-
I can't make much sense out of this, but why not just edit your budget & exclude the Mortgage category?
0 -
The budget amount is the full payment, not just the various components. And another post on this site advised this is the right way t o set up the loan to track the details yet also budget the mortgage / rent category.
0 -
I don't know of any way to exclude specific transactions from a budget. You can exclude accounts or categories. So all I can suggest is put the payments you want excluded from the budget in their own category & exclude that category.
0 -
If you've set up a detailed reminder for your Mortgage, you can budget for just the full payment amount without having to do all the adjustments to make it play nice with your budget. Edit your budget, go to expense categories, and look for the "Loans (Detailed Payments)" section. It will show any detailed mortgage payments you have set up and let you easily budget for the actual amount of the payment as a whole, while still breaking out Principal, Interest, and any other splits you have set up on your detailed reminder that shows in your register. Does this accomplish what you are trying to do with all of the adjustments?
0 -
As a Quicken for Windows user with a mortgage which was paid off a few years ago it was necessary for me to set up a separate Escrow account.
The monthly mortgage payment could only include these 4 Splits- Principal (categorized as transfer from checking to the mortgage account)
- Interest
- Additional Principal (or $0.00, transfer to the mortgage account)
- Escrow (the amount held by the mortgage company for county tax, mortgage insurance, etc. and paid by them as needed)
When the mortgage company paid tax, etc. from the escrow account once or twice a year, I recorded transactions in my Quicken Escrow account register.
This kept the extra information away from the graphs and made budgeting easier.Would it work better for your graphs and reports if you kept your payment splits down to just these 4 items and maintained an escrow account for the other stuff?
0 -
Thanks, guys. These suggestions work for my needs.
0