The Net Worth Tracker allows you to visualize your total net worth as well as trends over a customizable time period. The net-worth template has been one of our most popular in Google Sheets for years. Now it is available for Microsoft Excel.
@randy - This sheet is fantastic! Last piece that was missing in my day to day tracking for the excel environment. One thing I noticed when importing my google sheets data is that the balances were just a bit off. I think I got it by adjusting the Filter function in columns AF:AQ where balance history date < EOMONTH. I was showing the balances from a day or two before the end of the month, rather than the true EOM date, so I made the comparison ā<=ā, which looks to have resolved it for me.
I could be wrong, Iāve only been working in the sheet for about 30 minutes!
Net Worth Excel version
I had 2 accounts with the same name but different account numbers. Balances handled this ok, but Net Worth had the same amount for both accounts - ie it had pulled the value from 1 account and propagated it to both accounts. I changed the account names on the Tiller Console to be unique and now Net Worth is correct.
Thanks for the feedback, everyone. Just published version 0.93 which addresses the custom range bug, @adekunledauda, and the matching account name bug, @MikeB. Let me know what you think.
Iām new to Tiller. Iāve downloaded the Net Worth Excel template and followed the directions in the blog. The template does not update. I have a blank fields when Iāve copied the sheet to the Tiller Money sheet. When I first download the Net Worth template, the fields are populated. After I move or copy it to the Tiller sheet, the cells donāt populate.
I hope Iāve explained this well enough. Can anyone give me some suggested remedies? Thanks!
BTW I had to Unhide the Accounts and Balance History worksheets in the Net Worth template before I was able to move the Net Worth worksheet into my spreadsheet. I am using Excel 365.
Thatās strange, @mntom. If you can unhide the columns on the right of the Net Worth template in your sheet, you should see some hidden calculations that fill into the main area. Iād poke around in there. See if the cells are filling with account names & balances by month. See if there are any broken links or references to the (external) original template you downloaded.
Tankyou @randy for taking the time to develop this.
I have been waiting for the NW tracker for Excel for ages!!
I have not been able to make it work, though.
I made a fresh sheet to make sure I did not mess anything, and then moved the NW tab from the v.93 sheet to that new sheet as per the instructions.
I can only see the name of my accounts in colmn A but no data.
Same here. First of all, thanks for putting this together, @randy .
I too cannot get the balances to fill-in. Iām a pretty advanced Excel user, but this has me stumped. Is there any info you need from me to help diagnose?
I too downloaded the Net Worth spreadsheet. Followed the directions and have not see any data populate. When it came up blank, I looked at the hidden columns first and my Accounts/Class/Groups were all correct. I validated my source links to the existing workbook was also correct. I may try to repeat the steps and see if it results differently. I do have V 0.9 so Iāll see if downloading V 0.93 gets it going.
Hi @randy - so I downloaded v0.93 and the same persists on my end.
In column AG, I have no account totals. One thing I noticed, and not sure if this is playing a role or not, but I save my Excel workbook in Microsoft OneDrive as opposed to locally in a file folder on the Mac. When opening it says, āThis workbook contains links to one or more sources that could be unsafe. If you trust them, update themā¦ā. I click Update and the next error - āCanāt Open File. Sorry we couldnāt findā¦ā (insert file path)ā¦Is it possible it was moved, renamed or deleted".
The file had not been moved from MS OneDrive. I click okay - āMicrosoft Excel cannot access the file (insert file path)ā¦File path doesnāt existā. Click okay, and the file opens.
In AG7, the formula should look like this: =IF(OR(INDEX($AA$7#,,1)="",AG2="",EOMONTH(TODAY(),0)+1<=AG$2),"",LET(tablesortedbydate,CHOOSECOLS(SORT(FILTER(BalanceHistory[[Date]:[Account ID]],BalanceHistory[Date]<=EOMONTH(AG2,0),""),1,-1),COLUMN(BalanceHistory[Date]),COLUMN(BalanceHistory[Account ID]),COLUMN(BalanceHistory[Balance])),IFERROR(INDEX(tablesortedbydate,MATCH(INDEX($AA$7#,,1),INDEX(tablesortedbydate,,2),0),3),"")))
Is it possible that your formula still has external paths in it? I.e. because the Change Source step in the install instructions did not execute properly?
