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.
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?
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.
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!
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 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.
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.