Exclude Account from Net Worth?
Comments
-
BTW, just noticed that the little Net Worth window on the Dashboard page calculates the net worth properly! Its only the Report that seems to do the wrong thing. Which then rolls into the Planning window incorrectly. Strange.0
-
You shouldn't credit the asset account with all of the proceeds. You should only credit it with the amount of your cost basis at the time of the sale so that the account ends up with a zero balance. Any remianing amount is your gain. Your entry should be a split entry with the other amount as the gain on sale of the house. You might want to create an income category for this or else you can use the "_RlzdGain" built in hidden cateogry.
Quicken Windows user since 1993.
0 -
I assume you took the "net cash to you" number and put it in your checking Account and the other side of the entry went to your "old house" Account? That's not exactly correct because that net cash to you probably does include some element of other costs (e.g., allocation of property tax) that really should go somewhere else, but it's probably "close enough" for your purposes.
You have two ways of going now:
- You could make an "Increase" entry in that old house Account in the same amount that it shows as a negative balance right now with the "Category" being the same Account in which you're making the entry with the name surrounded by square brackets [Old House Account Name]. That would zero out the Account and make your Net Worth correct. That will zeor out the Account and not effect any other Account or Category in the file.
- The other way would be to make that same increase entry in the same dollar amount, with the offest being to a Category you create called something like "Gain on Sale of Old House." That too will zero out the Account and your Income and Expense report would show that gain on sale.
Either way will work from the standpoint of getting a properly stated Net Worth, but the second entry is "more correct" from an accounting standpoint.
0 -
Thanks folks. Sorry for the delay in responding as I was out of town. I will try your suggestions this weekend and report back.0
-
> @bmciance said:
> You shouldn't credit the asset account with all of the proceeds. You should only credit it with the amount of your cost basis at the time of the sale so that the account ends up with a zero balance. Any remianing amount is your gain. Your entry should be a split entry with the other amount as the gain on sale of the house. You might want to create an income category for this or else you can use the "_RlzdGain" built in hidden cateogry.
This worked. Thanks very much0