Many users have asked for a template to help track toward savings goals. And, truth be told, it’s a piece of the Tiller-platform puzzle we haven’t fully figured out yet.
With the help of @peter & @heather, I’ve begun early concept work on what we hope will become a general-purpose, easy-to-use Tiller Labs savings template that integrates and synergizes with other Tiller core sheets.
What should a savings template do?
- Identify specific savings targets
- Report on additional savings required to achieve the savings goal(s)
- Track the effects of goal spending on goal balances
- Project when a goal will be achieved (based on modeled cashflow)
- Unlock budgeting workflows toward savings accrual - don’t have a solve for this yet
In this concept, whenever a user wishes to fund their savings account, they make a transfer (presumably from their checking account to a dedicated savings account). As that real-world balances accrues, it is loaded into their Tiller spreadsheet via feeds updates and the template will show progress toward savings goals.
Notes & Questions
- Where is savings accrued? This concept leverages a dedicated real-world bank account where the account balance represents total savings. As an alternative, envelope budgeting workflows typically accrue savings in categories (rather than account balances). I love the ease and flexibility of envelope workflows but they are difficult to realize without the complexity of dedicated support scripts.
Use of tags. To track spending against goals (e.g. early spend on a vacation savings goal on airline tickets), the concept uses a
Tagscolumn in Transactions. Tags are a decent fit for this use scenario because a transaction can be tagged and counted for a savings goal but can also be separately categorized where appropriate (e.g. Travel). An alternative approach could use new, discrete savings categories instead of tags. Using categories may be simpler & more intuitive (since Tiller spreadsheets all come prebuilt with categories), doesn’t require the addition of the
Tagscolumn, and may perform better as parsing multi-tag cells can be fussy. But single-use categories have disadvantages such as category proliferation and also the problem of how to retire discrete savings categories once a goal is achieved (e.g. do one replace all instances of the new “New Sofa” savings category with your existing, general-purpose “Household” category?).
- Goal prioritization. The concept demonstrated in the video doesn’t allow users to prioritize goals or fill savings buckets like a waterfall. It could be useful to only begin funding the Summer Vacation goal only after the higher-priority Rainy Day goal has been achieved.
- Budgeting workflow. Ideally, a savings goal template would integrate with a budgeting workflow so savings contributions can be planful. Unfortunately, the concept in the video doesn’t intuitively integrate in this way since savings contributions are simply “transfers” (which are typically not tracked in Tiller spreadsheets) out of checking and into the designated savings account.
Maybe you have workflow solutions that resolve some of these vexing workflow challenges!
Scope & Context
While there are many niche needs & workflow opportunities, our phase-one goal is to build something easy-to-use and broadly-useful. If there are popular-but-complex feature requests that extend the functionality, we can build those out and go deeper on the solution.
We haven’t tried workshopping a template concept in the community before.
I’m excited to see if/how this works. I welcome your feedback.