Tracking downpayment as equity in new home
Comments
-
What you said makes sense to me, (Assets - Liabilities = Net Worth), your equity of 67k is the difference between 335k - 268k, so what's wrong? Or am I missing something?Quicken 2017 Premier - Windows 10 Pro0
-
0
-
P.S. If you are going to do this in the loan account when setting up the loan account in Quicken I would do with the manual loan account since you can't put in transactions in an automatically downloaded loan account. What's more I would set it up for the actual loan amount to get all the calculations correct. I then first adjust the opening balance to be "more negative" by the amount of these fees/down payment. And then enter these transactions.Where did the $67K come from?
I would image it was a transfer from your checking or savings account.
I would also imaging that you probably have put that in as a withdraw to some category.
You should record it as a transfer from that account to the above account.
But also note if the above account is your house account it isn't how it is normally recorded in Quicken. The balance of a house account in Quicken should be its current value, not your equity in the house. You get the equity in your house by subtracting the loan balance from the house balance. This is why Quicken allows you to link the two, so that it can show them together.
You should either put the closing and such costs into the loan account or use a separate account for recording it.
As in you would for instance start the loan balance $67K higher (negative amount) than the loan amount and the transfer in would zero it out, bring the balance down to the loan amount. The same would be true of the closing costs.
When finished with these the loan account balance would be the what you actually got the loan for, or if you were working in another account it should balance to zero.0 -
Thanks for chiming in Rich. Yes, that's the math. My issue is that Quicken isn't calculating the $67K down payment into the net worth. Somehow the "asset" transfer isn't calculating into the net worth.What you said makes sense to me, (Assets - Liabilities = Net Worth), your equity of 67k is the difference between 335k - 268k, so what's wrong? Or am I missing something?
0 -
Thanks, @QPW...Initially I tried to build all the closing costs into a "Title Escrow" account I created but couldn't get the math to work (most likely user-error). I'll take a whack at your suggestion and see what happens.Where did the $67K come from?
I would image it was a transfer from your checking or savings account.
I would also imaging that you probably have put that in as a withdraw to some category.
You should record it as a transfer from that account to the above account.
But also note if the above account is your house account it isn't how it is normally recorded in Quicken. The balance of a house account in Quicken should be its current value, not your equity in the house. You get the equity in your house by subtracting the loan balance from the house balance. This is why Quicken allows you to link the two, so that it can show them together.
You should either put the closing and such costs into the loan account or use a separate account for recording it.
As in you would for instance start the loan balance $67K higher (negative amount) than the loan amount and the transfer in would zero it out, bring the balance down to the loan amount. The same would be true of the closing costs.
When finished with these the loan account balance would be the what you actually got the loan for, or if you were working in another account it should balance to zero.0 -
As QPW pointed out below, the 67k must have come from somewhere. If this came from a bank account you already track in Quicken, then there will be no change to your net worth because you just moved a cash asset to a real estate asset.What you said makes sense to me, (Assets - Liabilities = Net Worth), your equity of 67k is the difference between 335k - 268k, so what's wrong? Or am I missing something?
If this money came from a source outside of Quicken, then you will have to include the source in Quicken to see it reflected there.Quicken 2017 Premier - Windows 10 Pro0 -
Correct. Without going too deep into detail, not all the money for the down payment came from a Quicken tracked account which is where I think the problem is. Thanks for the help.What you said makes sense to me, (Assets - Liabilities = Net Worth), your equity of 67k is the difference between 335k - 268k, so what's wrong? Or am I missing something?
0 -
If you need money to come from "outside" of Quicken enter the transaction with the category [This Account], where "This Account" is the one you are in.What you said makes sense to me, (Assets - Liabilities = Net Worth), your equity of 67k is the difference between 335k - 268k, so what's wrong? Or am I missing something?
0 -
Bear in mind you are not trying to get an account balance that equals the amount of equity in your house. That will come from Quicken combining the totals of your house and loan accounts.Where did the $67K come from?
I would image it was a transfer from your checking or savings account.
I would also imaging that you probably have put that in as a withdraw to some category.
You should record it as a transfer from that account to the above account.
But also note if the above account is your house account it isn't how it is normally recorded in Quicken. The balance of a house account in Quicken should be its current value, not your equity in the house. You get the equity in your house by subtracting the loan balance from the house balance. This is why Quicken allows you to link the two, so that it can show them together.
You should either put the closing and such costs into the loan account or use a separate account for recording it.
As in you would for instance start the loan balance $67K higher (negative amount) than the loan amount and the transfer in would zero it out, bring the balance down to the loan amount. The same would be true of the closing costs.
When finished with these the loan account balance would be the what you actually got the loan for, or if you were working in another account it should balance to zero.
If you are using a separate account for the fees then you want it to zero out.
If you are doing it in the loan account then you have to think of the fees "on top of your loan amount" and start with a bigger amount. And in fact you can think of it as if you didn't have a down payment your loan would be greater, and the adding in of the down payment is reducing it.
Note that the fees don't really belong in the house account at all. They should either be in a separate account or in the loan account if you are thinking of them as "on top of the loan".
As for the down payment, if you do it in the house then you have math that looks like this.
Opening balance: 283K
Down payment: 67K
For a balance of $350K
The 67K transaction can be a split transaction or more transactions that include a transfer, and the [This House Account] kind of balance adjustment for money that comes from the outside. Note that when you get a new value for your house this is exactly how the value will change, with a balance adjustment.0 -
I got it all worked out. Thanks for all the help.Where did the $67K come from?
I would image it was a transfer from your checking or savings account.
I would also imaging that you probably have put that in as a withdraw to some category.
You should record it as a transfer from that account to the above account.
But also note if the above account is your house account it isn't how it is normally recorded in Quicken. The balance of a house account in Quicken should be its current value, not your equity in the house. You get the equity in your house by subtracting the loan balance from the house balance. This is why Quicken allows you to link the two, so that it can show them together.
You should either put the closing and such costs into the loan account or use a separate account for recording it.
As in you would for instance start the loan balance $67K higher (negative amount) than the loan amount and the transfer in would zero it out, bring the balance down to the loan amount. The same would be true of the closing costs.
When finished with these the loan account balance would be the what you actually got the loan for, or if you were working in another account it should balance to zero.0