At the request of some of our customers, we published a new net-worth template that is simplified for monitoring and for comparisons. The new sheet shows your Net Worth either on a single user-input day or can run a side by side account-by-account comparison across two user-input dates.
P.S. To stay up to date on the latest features and additions to the Tiller Labs add-on, consider following the labs-roundup tag— also available via RSS.
Here is how I have used the new template. I have been tracking in Excel all the 12-31-xx balances in all of my retirement accounts since 1993. I know, call me crazy. That amounts to about 5-10 numbers per year that took me about 5-10 minutes each year to maintain. Over the last few days, I have entered all this data into the Balance History tab. Although there is more to my yearly net worth than just these retirement accounts, the new template allows me to quickly compare all of my retirement account balances for two dates. Not something I intend to use a lot, but it was worth the time investment and it is nice to see how my retirement accounts have changed over the years.
I am a new customer, so please forgive me if this question is addressed somewhere else. Is the Net Worth Snapshot template add-on compatible with the Foundation template?
NO ISSUE with compatibility. I scoured the info available and found a statement that resolved that question. Now I need to know how to enter Asset categories that are not driven by income or expenses. On my Balances, Net Worth etc — I see my chart of accounts under the group of Assets, but cannot find a way to add the Fair Market Value of my Home. This leaves my account severely out of balance. I get an error if I attempt to add an account that is not income/expense/or transfer. How do I add a beginning net worth balance?
Thank you. That manual addition to Balance History worked but resulted in an issue for Net Worth Snapshot. Net Worth sheet reflects change OK, but Net Worth Snapshot has also added Home Expenses to the Asset category. How do I fix this?
I renamed some accounts and now I realize the issue is that Net Worth Snapshot does not have a Liabilites category. Strange… Net Worth sheet does, but Net Worth Snapshot does not.
Whoops! Now things are really getting screwed up. My Monthly Budget is filled with #REF! and I don’t know how to recover. Help!
Hi @4edjennings,
Let me offer some suggestions that might fix this.
Look at your Accounts sheet. It might be hidden but you can find it by clicking the 4 bar hamburger next to the plus sign on the bottom left of the spreadsheet. Look at the hidden Account columns. Do you see anything strange there? There should only be Accounts, not any Categories like Home Expenses. If you see something like Home Expenses, there might be a problem with your Balance History where there is a Home Expenses listed somewhere. Balance History shouldn’t contain any Categories.
Where are the #REF! errors showing up? In place of the category names column or the numbers columns. And is there any error message if put your cursor in the #REF! error cells?
1- Accounts sheet has only institutions, no categories. Balance History does not have any categories.
2- I got rid of the #REF errors, but can’t remember how I did it. But I got tired of fighting one issue after another, so I called up an earlier sheet from google drive and started over.
Still have the issue with Liabilities not showing a header on the Net Worth Snapshot. It looks like the liabilities are under Assets.
Hi @4edjennings - you can just use the “restore” option under Managed Solutions after selecting the Net Worth Snapshot in the Tiller Labs add-on. Not need to make an archive of that sheet.
Thanks, Heather! That worked. The LIABILITIES header now shows and the Liabilities group is properly showing. Whew! I have spent 4 days trying to set up Tiller. I don’t think I would have begun if I knew it was going to be this difficult. But thanks for your help.
Hi @4edjennings,
Thanks for sticking with it to resolve this. Glad it is working now.
I think you might have entered something by mistake in one of the cells that was breaking it. For many Tiller reports, only type in the green shared selector cells.
