http://m.getsatisfaction.com/topics/7827083 Tracking downpayment as equity in new home 2018-12-09T00:42:48Z 2018-12-07T23:14:27Z 7827083 http://m.getsatisfaction.com/topics/7827083 7827083 Tracking downpayment as equity in new home 2018-12-09T00:42:48Z 2018-12-07T23:14:27Z ScottM http://m.getsatisfaction.com/people/9877771 https://www.gravatar.com/avatar/e6a5f3db993c887239b1a23600940f5a?d=identicon&s=55&r=PG scottm_jozrgbujghbql Using QfW 2016<br alt="" name="" rel="" target="" title="" type="" value="" />I recently purchased a new home for $335 with a down payment of $67K and a mortgage of $268K. I entered all of the "money in" amounts to the Title company escrow account into the "home asset" account ("803"), set up the linked Mortgage account and entered the closing costs by categories in a single, split transaction. When finished, what remained was the $8017.04 "cash return at closing" amount as expected. The value of the house is $350K (I'm a tough negotiator) so, to better track my net worth, I added a Cost to Value Adjustment item of $15K to the register so it calculates into my net worth. After hours of struggling, all my math worked out as it should.<br /><br alt="" name="" rel="" target="" title="" type="" value="" /><img alt="" name="" rel="" target="" title="" type="" value="" /><img src="https://d2r1vs3d9006ap.cloudfront.net/s3_images/1766070/RackMultipart20181207-5287-1ykr0gn-image_inline.png?1544224298" title="Image: https://d2r1vs3d9006ap.cloudfront.net/s3_images/1766070/RackMultipart20181207-5287-1ykr0gn-image_inline.png?1544224298" /><br alt="" name="" rel="" target="" title="" type="" value="" /><br />What I can't figure out how to do is get my $67K down payment/equity to calculate into my net worth. Leaving the illusory $15K cost-to-value item aside, that $67K is still "mine" and should be calculated into net worth...right? Or am I missing something.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />Any ideas?<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" /> question bank_accounts_downloading_and_categorizing bank_accounts_downloading_and_categorizing, windows complete 10 4 1 comment http://m.getsatisfaction.com/topics/7827083/replies/19894313 http://m.getsatisfaction.com/topics/7827083 19894313 Rich M responded to "Tracking downpayment as equity in new home" 2018-12-07T23:40:42Z 2018-12-07T23:40:42Z Rich M http://m.getsatisfaction.com/people/8342853 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10875398/original_medium.png richmny 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?&nbsp; Or am I missing something? 0 http://m.getsatisfaction.com/topics/7827083/replies/19894315 http://m.getsatisfaction.com/topics/7827083 19894315 QPW responded to "Tracking downpayment as equity in new home" 2018-12-07T23:42:34Z 2018-12-07T23:42:34Z QPW http://m.getsatisfaction.com/people/8342820 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10875282/original_medium.gif qpw Where did the $67K come from?<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />I would image it was a transfer from your checking or savings account.<br alt="" name="" rel="" target="" title="" type="" value="" />I would also imaging that you probably have put that in as a withdraw to some category.<br alt="" name="" rel="" target="" title="" type="" value="" />You should record it as a transfer from that account to the above account.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />But also note if the above account is your house account it isn't how it is normally recorded in Quicken.&nbsp; The balance of a house account in Quicken should be its current value, not your equity in the house.&nbsp; You get the equity in your house by subtracting the loan balance from the house balance.&nbsp; This is why Quicken allows you to link the two, so that it can show them together.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />You should either put the closing and such costs into the loan account or use a separate account for recording it.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />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.&nbsp; The same would be true of the closing costs.<br alt="" name="" rel="" target="" title="" type="" value="" /><br alt="" name="" rel="" target="" title="" type="" value="" />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.<br alt="" name="" rel="" target="" title="" type="" value="" /> 0 http://m.getsatisfaction.com/topics/7827083/replies/19894326 http://m.getsatisfaction.com/topics/7827083/replies/19894315 19894326 QPW responded to "Tracking downpayment as equity in new home" 2018-12-07T23:51:51Z 2018-12-07T23:51:51Z QPW http://m.getsatisfaction.com/people/8342820 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10875282/original_medium.gif qpw P.S.&nbsp; 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.&nbsp; What's more I would set it up for the actual loan amount to get all the calculations correct.&nbsp; I then first adjust the opening balance to be "more negative" by the amount of these fees/down payment.&nbsp; And then enter these transactions. 0 http://m.getsatisfaction.com/topics/7827083/replies/19894748 http://m.getsatisfaction.com/topics/7827083/replies/19894313 19894748 ScottM responded to "Tracking downpayment as equity in new home" 2018-12-08T13:25:21Z 2018-12-08T13:25:21Z ScottM http://m.getsatisfaction.com/people/9877771 https://www.gravatar.com/avatar/e6a5f3db993c887239b1a23600940f5a?d=identicon&s=55&r=PG scottm_jozrgbujghbql 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. 0 http://m.getsatisfaction.com/topics/7827083/replies/19894754 http://m.getsatisfaction.com/topics/7827083/replies/19894315 19894754 ScottM responded to "Tracking downpayment as equity in new home" 2018-12-08T13:36:46Z 2018-12-08T13:36:46Z ScottM http://m.getsatisfaction.com/people/9877771 https://www.gravatar.com/avatar/e6a5f3db993c887239b1a23600940f5a?d=identicon&s=55&r=PG scottm_jozrgbujghbql 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. 0 http://m.getsatisfaction.com/topics/7827083/replies/19894758 http://m.getsatisfaction.com/topics/7827083/replies/19894313 19894758 Rich M responded to "Tracking downpayment as equity in new home" 2018-12-08T13:41:19Z 2018-12-08T13:41:19Z Rich M http://m.getsatisfaction.com/people/8342853 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10875398/original_medium.png richmny As&nbsp;<a alt="" href="https://getsatisfaction.com/quickencommunity/people/qpw" name="" rel="nofollow" target="" title="" type="" value="">QPW</a>&nbsp;pointed out below, the 67k must have come from somewhere.&nbsp; 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.<br /><br />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. 0 http://m.getsatisfaction.com/topics/7827083/replies/19894775 http://m.getsatisfaction.com/topics/7827083/replies/19894313 19894775 ScottM responded to "Tracking downpayment as equity in new home" 2018-12-08T13:50:55Z 2018-12-08T13:50:55Z ScottM http://m.getsatisfaction.com/people/9877771 https://www.gravatar.com/avatar/e6a5f3db993c887239b1a23600940f5a?d=identicon&s=55&r=PG scottm_jozrgbujghbql 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. 0 http://m.getsatisfaction.com/topics/7827083/replies/19895209 http://m.getsatisfaction.com/topics/7827083/replies/19894313 19895209 QPW responded to "Tracking downpayment as equity in new home" 2018-12-08T20:31:47Z 2018-12-08T20:31:47Z QPW http://m.getsatisfaction.com/people/8342820 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10875282/original_medium.gif qpw 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. 0 http://m.getsatisfaction.com/topics/7827083/replies/19895243 http://m.getsatisfaction.com/topics/7827083/replies/19894315 19895243 QPW responded to "Tracking downpayment as equity in new home" 2018-12-08T21:02:01Z 2018-12-08T21:02:01Z QPW http://m.getsatisfaction.com/people/8342820 https://d2r1vs3d9006ap.cloudfront.net/public/uploaded_images/10875282/original_medium.gif qpw Bear in mind you are not trying to get an account balance that equals the amount of equity in your house.&nbsp; That will come from Quicken combining the totals of your house and loan accounts.<br /><br />If you are using a separate account for the fees then you want it to zero out.<br />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.&nbsp; 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.<br /><br />Note that the fees don't really belong in the house account at all.&nbsp; 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".<br /><br />As for the down payment, if you do it in the house then you have math that looks like this.<br /><br />Opening balance: 283K<br />Down payment: 67K<br /><br />For a balance of $350K<br /><br />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.&nbsp; Note that when you get a new value for your house this is exactly how the value will change, with a balance adjustment. 0 http://m.getsatisfaction.com/topics/7827083/replies/19895412 http://m.getsatisfaction.com/topics/7827083/replies/19894315 19895412 ScottM responded to "Tracking downpayment as equity in new home" 2018-12-09T00:42:48Z 2018-12-09T00:42:48Z ScottM http://m.getsatisfaction.com/people/9877771 https://www.gravatar.com/avatar/e6a5f3db993c887239b1a23600940f5a?d=identicon&s=55&r=PG scottm_jozrgbujghbql I got it all worked out. Thanks for all the help. 0