With Quicken Loans, you can do the same thing with your mortgage payment. A lot of you probably used Rocket Mortgage to upload your documents and set up your loan with us. When it comes time to make your payments, you can use Rocket Mortgage in order to make your mortgage payment. Quicken Web Connect downloads your Wells Fargo account data and matches. Mortgage Loans Home Equity Lines Personal Lines and Loans. Account: If you already have the account set up in Quicken, and you would like to add. The file is automatically downloaded to your desktop. You can double click on.
Home›Quicken for Mac›Errors and Troubleshooting (Mac)edited August 2018 in Errors and Troubleshooting (Mac)
I'm using Quicken for Mac 2016. I attempted to set up categories for reducing the outstanding loan amount each month and then an interest expense category. I believe I have 'totally screwed up' the loan account I originally set up by messing with categories including a transfer category. Can anyone point me to a video and/or other help that will show and explain categories and transfers..as it relates to mortgage loans... how they look in the split display? Thanks in advance.
Comments
- edited August 2018I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
- edited March 2017HQ, let me use some round numbers to illustrate. Let's say your mortgage balance is $150,000, and your monthly mortgage payment is $1,000. You pay your mortgage out of your checking account. You've created a Liability account called 'XYZ Mortgage Co.' with an opening balance of $150,000. (If you have questions on how to do any of that, write back.)
Now, in your checking account, you're going to enter your mortgage payment. You enter a payment to XYZ Mortgage Co. for $1,000. Click on the Split icon. Your first split line is going to be the amount of principle paid off for this month, and the second spit line is going to be the interest paid for this month. You'll need either your mortgage statement or an amortization spreadsheet to know what those values are each month. Let's say the first month is $400 principle and $600 interest. So here are your split lines:
Split line 1
Category is Transfer
Transfer is XYZ Mortgage Co.
Amount is -400.00
Split line 2
Category is Home:Mortgage Interest
Amount is -600.00
That's it. After entering this transaction in your checking account, your checking account is reduced $1,000, your loan balance is reduced $400, and you have $600 in interest expense.
You can set up this transaction in your checking account as a recurring monthly transaction by clicking the Schedule button in the bottom toolbar. Then, each month, you'll have to take a few seconds to edit the transaction for the correct split between principle and interest.
If part of your monthly payment goes to an escrow account for real estate taxes, that's pretty easy to add to the equation. Create a new Asset account called Escrow, and enter the current balance in your escrow account. Then add a third split line to your monthly transaction for the amount paid to your escrow account: Category=Transfer, Transfer=Escrow Account. Then when you get a tax bill that is paid from your escrow account, you'd make an entry in the escrow account with the Payee='My School District' and the Category=Taxes:Property Tax.
Write back if any of that doesn't make sense!QMac 2007 & QMac Subscription • Quicken user since 1993 - edited November 2016
Thanks for your response. First, I should add my mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly created a category for the monthly principal.I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to. - edited December 2016
If you have a statement that shows the actual principle from each payment, then the balance is either escrow, fees, or interest. If you have no escrow or fee amounts, then the full amount left over is interest and can be added to the interest line of the split transaction.I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
- edited March 2017Thanks for your detailed explanation. It all makes sense.
I'm still ground up trying to figure out how to reverse my mistakes.
I'll just add my update to the other Super User in terms of where I am. Feel like I'm in a Quicken maze that I created and can't find my way out! ;-)
My mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly create a category for the monthly principal and messed up the transfer that resulted from my download from the mortgage company.
Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to.
Thanks again. - edited December 2016
Forgot to say:I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
the principle portion is what gets placed in the transfer line of the split transaction to your loan account.
So bottom line is, you should go to the bank account side of the transcation and adjust each one to be a split transaction; one line of the principle, which will be a transfer to your loan account, the second line is for the interest (add more lines for the escrow and fees as applicable).
Now on the mortgage loan side, you probably will end up with duplicates: one created from the downloaded data from the FI/bank, the other created from the transfer from the bank account entries you are editing. You will need to delete the transactions in the mortgage loan account downloaded from the bank.
Then you should reconcile the mortgage loan account with the remaining transactions against your mortgage statement.
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
- edited December 2016
Once you get through that, you will need to make sure all is set up correctly for future transactions.I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
Since you already have the loan account created, you will need to make sure you have the loan payment created as scheduled transaction to your bank account. Then every payment, you will apply the payment and modify the principle and interest lines as needed.
After all is set up, I would recommend one of 2 choices:- Only download your data for the bank account FIRST. This will allow you to match the download to your scheduled transaction and apply it to your bank account, with the edits you need to make to the split lines. Then you can download you mortgage loan account data, which should then match your newly applied entry into your bank and mortgage account, via the transfer line of the split transaction
- OR FIRST apply the loan payment to your bank account BEFORE you download ANY data, again applying any edits to each split line. THEN you can download the data for your bank account and your mortgage loan account. In this case, the order does NOT matter.
HTH.
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- edited December 2016
ONE CORRECTION re: 'You will need to delete the transactions in the mortgage loan account downloaded from the bank.'I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
You may not need to perform this step. Instead...you may be able to match the duplicates by dragging one over the other. This should allow Quicken to learn the matching criteria and improve the matching for future downloads of your mortgage loan data.
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
- edited November 2016
Wow.. Do appreciate all this help! Now, I'll have to digest and execute. Needless to say, it's clear why you're designated a super user. A future version of Quicken for Mac automating some of this will be greatly appreciated.I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.) - edited December 2016
You can now VOTE for the feature for Loan Amortization, here:I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
https://getsatisfaction.com/quickencommunity/topics/loan-amortization-in-quicken-for-mac-2016
Be sure to click on the link above to go there, then click VOTE at the top or THAT page to increase the count and therefore its visibility to the developers.
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
- edited November 2016
Thanks again for your help!! Got it all straightened out .. Quicken Mortgage Loan account is spot on...principal and interest amounts all square with the Mortgage Company balance. Made my weekend work with Quicken for Mac and I learned a lot!I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.) - edited December 2016
Good going!I believe your mistake is treating the principle as a category. The principle is always a transfer to a loan account, because it reduces the loan by the that amount.
Read this Quicken Mac FAQ for the description: How to set up a mortgage/loan (in QM2015/2016)
Watch the following video to help: https://www.youtube.com/watch?v=WNoaWmHWPcQ
(it mentions Quicken Essentials but it equally applies to QM2016).
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
- edited December 2016
HQ, we can work this through and get you fixed up!Thanks for your detailed explanation. It all makes sense.
I'm still ground up trying to figure out how to reverse my mistakes.
I'll just add my update to the other Super User in terms of where I am. Feel like I'm in a Quicken maze that I created and can't find my way out! ;-)
My mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly create a category for the monthly principal and messed up the transfer that resulted from my download from the mortgage company.
Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to.
Thanks again.
First, I wanted to clarify what you are downloading. Is it *just* transactions from your checking account bank, or are you also downloading something from Quicken Loans? Here's why I'm asking... If it's just your checking account, then the split you create will transfer the portion of the payment that is principle to transfer to -- and reduce the balance of -- your loan account. But if you are also downloading transactions from Quicken Loans then you already have a transaction reducing your principle, and the approach in Quicken would be different.
I think I know what's happening, but before I go off on a wrong tangent, could you fill in a few details by saying what is one of the transactions is currently. Just use round dummy numbers, but tell me the total amount of the transaction, and then what the existing split lines are (category, transfer, amount).QMac 2007 & QMac Subscription • Quicken user since 1993 - edited November 2016
Thanks for your follow-up! Fortunately, I was able to clear up the issue by relinking the downloaded mortgage payments to the loan account. Everything is balanced now. Do appreciate your help!!Thanks for your detailed explanation. It all makes sense.
I'm still ground up trying to figure out how to reverse my mistakes.
I'll just add my update to the other Super User in terms of where I am. Feel like I'm in a Quicken maze that I created and can't find my way out! ;-)
My mortgage company debits my checking account automatically for my monthly payment. And, I download the transactions into the Quicken Mortgage Loan account. I did mistakenly create a category for the monthly principal and messed up the transfer that resulted from my download from the mortgage company.
Now, I can't figure out how to reverse my mistakes so the correct principal amounts reduce the mortgage loan account and the interest goes into an Interest Exp category. When I do a split on a monthly transaction and type in the principal amount from my statement Quicken creates a third row with an amount shown as uncategorized and I have no idea what the amount relates to.
Thanks again. - edited August 2018I am disappointed that you are/have not included loan amortization. You had it in previous editions and if I had known that I would have used a different product. Now I am committed to use 15 until the end of this year. January will be another decision point.
- edited December 2016
Apparently, Quicken is working on this feature, though no mention as to when it will be available. Meanwhile, to have your say, please add your vote to this feature request as noted above : https://getsatisfaction.com/quickencommunity/topics/using-quicken-for-mac-2016-for-mortgage-loan?top...I am disappointed that you are/have not included loan amortization. You had it in previous editions and if I had known that I would have used a different product. Now I am committed to use 15 until the end of this year. January will be another decision point.
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
![Add mortgage account quicken for mac download Add mortgage account quicken for mac download](/uploads/1/2/5/6/125677885/125807610.png)
edited October 2018 in Errors and Troubleshooting (Mac)
SITUATION: With Quicken for Mac 2017, I set up a mortgage loan account and am using a split transaction and transfer category principal and interest. The mortgage loan account (with my MANUAL help!!) is showing the correct mortgage loan balance. HOWEVER, when I do a MONTHLY 'SPENDING' OVERVIEW only the 'interest' amount is included as an expense. So, my monthly spending TOTAL is OFF by the amount applied to the principal. I would expect the monthly spending OVERVIEW to show the total amount I paid to the mortgage company. Is this the way it's suppose work? Did I set it up wrong?
![Quicken cannot add account Quicken cannot add account](/uploads/1/2/5/6/125677885/809502358.png)
Comments
- edited August 2018Currently, transfers are not considered expenses throughout QM2017 (which is what your payment is to the mortgage company. So there is not much you can do. Though I doubt it will make a difference, have you tried categorizing your transfer?
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.
(Canadian user since '92, STILL using QM2007)
Have Questions? Check out these FAQs:- Quicken Windows FAQ list
- Quicken Windows FAQ list
- edited October 2018By definition, transfers are neither Income nor Expense - but they are Cash Flow - moving funds from one pocket to another.
That aside, in QMac, one can assign categories to Transfers and thereby generate reports that include these cash flow events.
Create and assign a category for the split item mortgage principal. This item will then display in the Spending report you are looking at. You can do the same for other routine transfers such as credit card payments, escrow payments, auto loan principal, etc.QWin & QMac (Deluxe) Subscription
Quicken user since 1991 - edited December 2016
Thanks for letting me know. Have not tried categorizing the transfers.Currently, transfers are not considered expenses throughout QM2017 (which is what your payment is to the mortgage company. So there is not much you can do. Though I doubt it will make a difference, have you tried categorizing your transfer?
(If you find this reply helpful, please be sure to click 'Like', so others will know, thanks.)
Is this the way Quicken for Windows handles Mortage accounts and spending overviews? Meaning the 'total' amount paid to the mortgage company isn't reflected in a monthly 'spending' report? It just seems odd that a QM overview doesn't show my total spending while still reducing my Mortgage account balance.
I'm not a software developer and new to QM2017 so wondering if I'm mistaken in how it should or could work. - edited October 2018Thanks for letting me know.
I'll try categorizing the transfers as I would like to see my total spending. - edited December 2016
As suggested, I set up a new expense category called Home:Mortgage Principal.Thanks for letting me know.
I'll try categorizing the transfers as I would like to see my total spending.
However, when I go into the existing screen (window) showing mortgage transactions split with Transfer of the 'principal' to the loan account and 'Interest' to the expense category Home:Mortgage Interest, I can't figure out how to 'assign the transfer mortgage principal' to the new Home:MortgagePrincipal category.
If this sound confusing it's because I am confused ;-)
My existing mortgage transaction split is set up like this:
Split line 1
Category is Transfer
Transfer is XYZ Mortgage Co.
Amount is -400.00
Split line 2
Category is Home:Mortgage Interest
Amount is -600.00
Also, I saw this on the Quicken website so not sure if it applies to Quicken for Windows and 'not' to QM2017. As I read it, it says a transfer can't be categorized.
What if I need to categorize a transfer? Updated: 04/19/2016 | Article ID: HOW24388You can't categorize a transfer with an income or expense category. When you transfer money from one account to another, you're not spending or receiving money--you're simply moving it. (Instead of an income or expense category, the name of the account youâ€TMre moving the money to or from appears in the Category field in the register.)You can use Quicken tags with transfers, however. Tags allow you to group transactions without categorizing them as income or expense. - edited December 2016
HQ wrote;Thanks for letting me know.
I'll try categorizing the transfers as I would like to see my total spending.
'Split line 1
Category is Transfer
Transfer is XYZ Mortgage Co.
Amount is -400.00'
Open the transaction in Edit mode. You should be able to change the Category from Transfer to Home:Mortgage Principal.
The Help article you cite is for Windows and for older Mac versions. The ability to assign a category to a transfer is new to the new QMac versions.QWin & QMac (Deluxe) Subscription
Quicken user since 1991 - edited December 2016
JM, your guidance worked. Thank you!Thanks for letting me know.
I'll try categorizing the transfers as I would like to see my total spending.
After the change (setting up the Mortgage Principal category) the mortgage loan account still shows the right loan balance. And, the monthly spending overview report shows my total monthly mortgage payment in two categories; Interest and Principal. It seems to satisfy everything I wanted.. Loan balance tracking, Interest payment tracking and Principal payment tracking.
Shouldn't an automated QM mortgage loan tracking feature and report structure work this way? Is there any downside to this loan mortgage set up I'm not seeing?