Hello, I’m new to Tiller and was looking for a way to keep track of my daily account balances.
I’m hoping for a sheet that has each date as a row, and each column with an investment account’s balance and a total balance column. I was hoping each day it would add a new row to the sheet with that days’ balance, while keeping all rows with the past days balances on the sheet. Here’s a screen shot if what I’m looking for.
This is essentially the content of the hidden “Balance History” sheet in your Tiller spreadsheet. You can find all the data in there.
Unfortunately, the data is organized somewhat differently— and occasionally there will be two balance entries for a single account on a single day. From this data source, you should be able to render the table you’re requesting. The only caveat is that a sheet like this with discrete lookups by date AND account for every day on a Balance History sheet that can have 10k’s of rows can be bad for spreadsheet performance.
One more note… the Net Worth template essentially does what you’re looking for on a monthly basis. You can unhide the “hidden area” on the right and reference those formulas as you build.
Net Worth has a weekly option too. I’d say don’t sweat it and don’t watch the balance every day Or you could add a daily option to the net worth sheet (I am not quite sure how to do it, though)
If you know how to write a google script or ask Gemini or chatGPT for help, you could write a Google script that would generate that sheet based on the balance history.
You should also know that the balance history in Tiller can lag behind the actual account balance due to the limitations of the data aggregators. So your numbers might be off by a day from your actual balances. That may or may not matter to you.
about 6 months ago i put together a sheet like this. I used the code from the Net Worth sheet and built it out using options to select day, week, month, quarter, or yearly intervals. I also built it to select which accounts are selected. I can choose “Net Worth” “Assets” “Liabilities” “Investments” etc. I can also select which accounts to include. Whatever I choose is charted and the balances are reported in columns below. I only have about 2 years data in it but it works reasonably well. I don’t know if it would hold up to many more years. I do have many accounts (like 40) and it seems to process them well.
I have it organized into 2 sheets. There is a setup sheet which builds out the hidden columns of the original net worth sheet. Its a “wide” sheet with each row representing a category or account and hundreds of columns for each balance. The actual “net worth dashboard” is a “long” sheet with columns for each catagory and rows for each date. Using query functions when i select an interval, start date or end date in my “net worth dashboard” the “setup” sheet will change the intervals between columns from days to weeks, months, etc.
One issue i’ve noticed is that sometimes when i’ve tried to update tiller balances while the sheet is set on “daily” i get an error. I don’t know why. But i generally leave it on weekly and only inspect “daily” when i want to see a particular value. I’ve also noticed a few problems when the “balance history” tab isn’t sorted by reverse date.
Its good for my purposes and I’m happy to share it, but I’m not really interested in supporting it at the level a lot of other excellent sheets here.
Here’s a screenshot of the top of the sheet without any values. Below the chart are columns with daily values for each of the items i’ve checked off in the field on screen right.
Or you could add a daily option to the net worth sheet (I am not quite sure how to do it, though)
