# Docs: Net Worth Tracker **URL:** \ **Category:** gSheets Templates\ **Tags:** google-sheets, networth, tcs-networth, tcs-gallery\ **Created:** [August 9, 2019, 4:36pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76 "2019-08-09T16:36:59Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [August 9, 2019, 4:36pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/1 "2019-08-09T16:36:59Z")
# What is the Net Worth Tracker? The Net Worth Tracker allows you to visualize your total net worth as well as trends over a customizable time period. ![net-worth-tracker-v2](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/1X/c047d0e9d2cb086dc2c698c29797196f2eaa8ff7.png) [Tiller Money Feeds](https://workspace.google.com/marketplace/app/tiller_money_feeds/417666986289) allows you to automatically import your daily account balances for easy tracking. # How to install the Net Worth Tracker template Install this template using Tiller Money Feeds using the following steps: 1. Launch Tiller Money Feeds 2. Under Templates near the bottom, click Browse 3. Find the template in the list using search or scroll to find it 4. Click the template name in the list to expand its card 5. Click Install to add the template to your spreadsheet [Read more in our help center](http://help.tillerhq.com/en/articles/3278731-using-the-tiller-money-feeds-add-on-for-google-sheets#h_f68be7d96c) # Customizing the Net Worth Tracker You can further customize your Net Worth Tracker by applying groups to your Accounts. 1. Open the Accounts sheet 2. Use the dropdown list in Column A to choose an account you’d like to assign to a group. 3. Enter a Group name in column C for each account you selected. ![Accounts-v2](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/1X/25739677fd5c30cf15852c86aa7474e45274bfd9.png) ## How to manually track accounts You can add manual accounts using the Tiller Money Feeds add-on for Google Sheets. Read more on our help center [here](https://help.tillerhq.com/en/articles/3251091-tracking-balances-for-manual-accounts). # Troubleshooting If you have a question or need help **first search the community** to see if someone has already asked and if not [click here to quickly post a question about this template](http://community.tiller.com/new-topic?title=net%20worth%20tracker%20issue&category=google-sheets&tcs=labs-networth) in the Get Help \> Spreadsheet templates category. Be sure to customize the title of your post with keywords about the issue or question so others can easily find the Q&A in search. ## Accounts not showing in appropriate groups If you’re noticing that your customized Account groups aren’t showing up on the Net Worth sheet the way you expect and some of the Account names are using the same formatting that the group header should use (e.g. light gray background and bold text instead of black text on white background) it could be due to incomplete balance history entries for manual accounts. Review your balance history sheet for manual account entries (Account ID starts with manual:[unique alphanumeric ID] - you may need to unhide the Account ID column). If any of the manual entries are missing the Account name data in the Account column this will break the Net Worth sheet. Fill in the names as appropriate. This happens sometimes in the Tiller Money Feeds add-on when the UI sidebar does not completely load before saving a new balance. Be sure to let the sidebar UI fully load all account details before saving. ---
**Author:** ![Richard](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richard/32/690_2.png) [@Richard](https://community.tiller.com/u/Richard)\ **Post date:** [October 6, 2019, 6:18pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/2 "2019-10-06T18:18:20Z")
The groups from Accounts V2 aren’t represented in the new Labs net worth sheet as mentioned in this article. I have also have the new Labs Balances and it is sub totally by the groups but the net worth sheet isn’t. To be sure I have the Account ID populated for every row in Balance History (adopted sheet) as the help article suggested. I also have the new green top bar on both net worth and balances, just to confirm with you I have the correct labs installed. I’m super interested in the net worth being subtotaled by groups and was excited to convert everything to V2. Am I missing something? PS - love the new net worth that combines it with the trends table!! Nice at a glance. ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [October 7, 2019, 7:37pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/3 "2019-10-07T19:37:46Z")
> [@Richard](#): > > The groups from Accounts V2 aren’t represented in the new Labs net worth sheet Do you mean that the Trends table below the chart on the Net Worth sheet (under Net Worth Trends Analysis Green bar) doesn’t give you a breakdown by group, but only shows Asset and Liability and then each account under that? ---
**Author:** ![Richard](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richard/32/690_2.png) [@Richard](https://community.tiller.com/u/Richard)\ **Post date:** [October 7, 2019, 7:58pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/4 "2019-10-07T19:58:34Z")
> [@heather](#): > > Customizing the Net Worth Tracker Hello Heather, The trends table below the Net Worth graph. That is correct, they are only showing Asset and Liability without groups. In the above article " Customizing the Net Worth Tracker" it says you can customize by applying groups. When I change the groups, they aren’t represented in the Net Worth tab. Changes to the Class Override do represent. What does this section mean, maybe I’m not understanding it? I’d expect the Net Worth Tracker to subtotal the accounts based on group within the Class, similar to how the Balances subtotals. Note, the sub total groups aren’t represented in the old net worth sheet (graph) or trends sheets (table) either. It’s something I’d love. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [October 7, 2019, 9:25pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/5 "2019-10-07T21:25:32Z")
You are correct that Groups are not implemented in the Net Worth template at this time. I will update the solution documentation at top. Apologies for the confusion and inconvenience, @Richard. Would you be willing to add this as a [feature request](https://community.tiller.com/c/feature-requests)? Randy ---
**Author:** ![jono](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jono/32/283_2.png) [@jono](https://community.tiller.com/u/jono)\ **Post date:** [November 4, 2019, 10:18pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/6 "2019-11-04T22:18:11Z")
There is now an update to the Net Worth sheet that includes grouping Accounts by Group. Get it using the Tiller Labs Add-on. Read more about it here: > [@Net Worth Tracker Sheet Revised to Work With Groups](https://community.tiller.com/t/net-worth-tracker-sheet-revised-to-work-with-groups/958): > > Tiller Labs has updated and improved the Net Worth sheet so it now works with Groups. To get the new sheet, go to the Tiller Labs add-on → View solutions. If you have a prior version of the sheet, select Manage Solutions, then select Net Worth and upgrade. If you don’t already have the sheet and want to get it, select Add a Solution instead of Manage Solutions. [Net%20Worth%20revised] Very little, if any, set-up is required to use the sheet. By default, the sheet will work using Today as th… ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [November 6, 2019, 2:54pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/7 "2019-11-06T14:54:37Z")
@Richard - Per @jono’s post below, we’ve pushed this update to the Tiller Labs add-on. If you “update” your Net Worth sheet using the Tiller Labs you’ll get the new grouping totals. ---
**Author:** ![Richard](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/richard/32/690_2.png) [@Richard](https://community.tiller.com/u/Richard)\ **Post date:** [November 8, 2019, 3:56am UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/8 "2019-11-08T03:56:10Z")
Super thank you heather, I installed the update, absolutely love it. ---
**Author:** ![BrittneyP](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brittneyp/32/226_2.png) [@BrittneyP](https://community.tiller.com/u/BrittneyP)\ **Post date:** [January 31, 2020, 2:50am UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/10 "2020-01-31T02:50:16Z")
Does this sheet have to be added to an existing sheet (for example, the Foundation Template or the Monthly Budget sheet) or can it be added to a new sheet of its own? ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [February 27, 2020, 9:24pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/11 "2020-02-27T21:24:42Z")
@BrittneyP, Sorry for the delayed reply here. You can add it to the Foundation Template or you can start in a blank Google Sheet and install the Tiller Money Feeds and install it on top of that. Heather ---
**Author:** ![chrisgp123](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/chrisgp123/32/275_2.png) [@chrisgp123](https://community.tiller.com/u/chrisgp123)\ **Post date:** [March 10, 2020, 8:09pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/12 "2020-03-10T20:09:42Z")
Purely opinion here, but I think it would make more sense to have Liabilities show as negative numbers instead of positive. Having them positive makes it a bit disorienting to read the chart at a glance. Knowing that Net Worth is essentially Assets minus Liabilities, you might expect that the Liabilities-over-time line would be below the zero point, Assets above, and the Net Worth line would be in the middle. Having them all above the zero line seems odd. Also, and maybe this is more of a Feature Request than a Comprehensive Guide comment, but it would be nice to see mini trendlines for each account in the table below the chart so that you could quickly see what’s trending up or down, and maybe add some conditional formatting style colors to the account totals to see how each value compares to the value to the left of it (green for an Asset increase, red for a decrease, opposite for Liabilities, etc.) Right now I’m just using sparklines to the right of the table to accomplish the trendlines, but stuff like that has to be reconfigured each time you guys update the sheet. Just a thought! ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [March 11, 2020, 4:46am UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/13 "2020-03-11T04:46:41Z")
Great feedback, @chrisgp123. Personally, I feel it is harder to compare assets and liabilities when they are on different halves of the chart, but I see your point. Perhaps in a future version we can add a “switch” that lets the user choose liability polarity. As for the sparklines, I’m really happy to hear you’ve just gone and added the features you need. That is what makes spreadsheets so powerful and wonderful. I just added a [changelog to Tiller Labs](https://community.tiller.com/t/tiller-labs-roundup-3-6-20-solution-changelogs-repair-balance-history-reconcile-transaction-improvements/3095#solution-changelogs) so when a template needs updating you can see if it is worth losing your mods. The Net Worth is pretty stable right now so I hope you won’t see frequent updates on that one. Best, Randy ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [April 8, 2020, 12:29pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/15 "2020-04-08T12:29:35Z")
Hi @briggs.jenna, The best way to manually track accounts is using the manual balances feature in the Tiller Money Feeds add-on. > **[Tracking balances for manual accounts](https://help.tillerhq.com/en/articles/3251091-tracking-balances-for-manual-accounts)** > > Learn how to manually track balances for non-automated accounts in your Tiller-powered Google Sheets My guess is that the manual account entries are missing an Account ID? Heather ---
**Author:** ![kfeelan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/kfeelan/32/3357_2.png) [@kfeelan](https://community.tiller.com/u/kfeelan)\ **Post date:** [May 3, 2020, 9:41pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/16 "2020-05-03T21:41:41Z")
I have added balance history for one of my accounts to the balance history sheet so now I am seeing more data in the net worth template, but it seems to only be pulling the first value I added for every month. Is there something else I am missing when adding historical data to this sheet? Account id is correct for every entry, date is first day of each month. ---
**Author:** ![kfeelan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/kfeelan/32/3357_2.png) [@kfeelan](https://community.tiller.com/u/kfeelan)\ **Post date:** [May 3, 2020, 9:47pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/17 "2020-05-03T21:47:38Z")
Nevermind, had to sort them newest to oldest, showing correctly now. ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [May 28, 2020, 12:59pm UTC](https://community.tiller.com/t/docs-net-worth-tracker/76/18 "2020-05-28T12:59:15Z")
We’ve closed this topic for replies. If you have a question or need help **first search the community** to see if someone has already asked and if not [click here to quickly post a question about this template](http://community.tiller.com/new-topic?title=net%20worth%20tracker%20issue&category=get-help/spreadsheet-templates&tags=labs-networth) in the Get Help \> Spreadsheet templates category. Be sure to customize the title of your post with keywords about the issue or question so others can easily find the Q&A in search.