Google Sheets Safe2Spend "App" with Tiller

Overview

Write a brief description of what the template does.
What is the goal of your workflow? What problem does it solve?
How did you come up with the idea for your workflow?

Hello. I’m really new to Tiller (about a week) and am still learning. But I wanted to share something that I’ve created using Tiller and an “old” tool I’ve been using for a few years. I apologize for typos, issues, errors in advance. :slight_smile:

Description: This sheet calculates my Safe2Spend amount based on data from the Tiller Balances sheet (that’s all), and other data I put into the Safe2Spend sheet. As bills and income items clear my Tiller transactions sheet, I simply check them off on the Safe2Spend sheet and everything is updated for me. This “tool” is something I came up with a few years ago after the Level App died (was killed). I wanted a way to accurately know how much I could safely spend (per day, or for the rest of the month), taking into account any income and expense transactions that I had planned for. I tried many apps…none worked how I wanted/needed them to. This is mainly designed to be a sheet I can open using the Google Sheets app on my mobile phone, creating a quasi app with a dashboard of my key data.

Goal and Problem Solved: The goal is to allow me to know how much I have left to spend for the rest of the month and still have enough in my checking account to cover big bills at the start of the next month. The problem it solves is me having to do all of that mental math and potentially forgetting key items in that process.

How It Came About: I have three jobs, and each one pays on completely different schedules. They also vary drastically on annual income AND how much I’m paid each month. In the summer, I usually have a much lower income, and none if I choose to skip teaching summer courses. That means part of my monthly “expenses” includes automated regular transfers of money from checking to a special savings account meant to save up for summer living expenses. I also have other regular transfers to savings to save up for vacations and other high-priced items. I want those to be factored into the calculations telling me what is safe to spend since those happen at different times of the month (typically on paydays). I am not overly concerned with micro-tracking categories of expenses with this tool. The rest of Tiller (or other tools) can do that for me. I just want to know that my bills will be covered, that I’ve saved what I set out to, and that the REST is mine to safely enjoy. I created this sheet several years ago. Prior to finding Tiller a week ago, I manually updated all the Checking and Credit Card balances by hand, logging into my banks and updating them daily. Now, it’s the front Dashboard to my main Tiller sheet and it graphs those balances for me. I also use the Tiller data and other sheets to add graphs, tables, etc to that dashboard (not included in this sample). Tiller makes this tool much more powerful for many reasons, at least for me!

Description: This sheet calculates my Safe2Spend amount based on data from the Tiller Balances sheet (that’s all), and other data I put into the sheet. As expense and income items clear my Tiller transactions sheet, I simply check them off on the Safe2Spend sheet and everything is updated for me. Here is an image of what it looks like. Keep in mind that the text and items are large since my main use for this is on my phone using the Google Sheets App.

Installation

Explain how to install the template in their spreadsheet…

Are there dependent sheets?

The main sheet can be linked to the standard Tiller Balances sheet. See comments in cells D2 and D3 for information.

Where is the template hosted?

Just a file in my own personal Google Drive.
Link: Safe2Spend Sheet

What steps are required to add it to a user’s personal spreadsheet?

Copy the Safe2Spend sheet into your own Tiller sheet. (Don’t copy the Balances sheet provided in the link…it’s just there for illustration and is modified from the one in Tiller. Comments in various cells discuss this.)

Setup

Explain what the user needs to do to initially configure the template…

Usage

Edit the cells in D2 and D3 to pull the Checking and Credit Card Balances you will use (or enter them manually). See comments in those cells for more information.

Enter the amount of money you need/want to have in the Checking account at the start of next month in cell D4 (Desired End Balance).

Enter all expense and income transactions and the amounts that you want used to calculate the Projected End Balance and the Safe2Spend amount in cells D5 and D6. The Day of Month (DOM) column is optional but could be used for sorting by dates.

As you see Income and Expense transactions clear your account (I use the Transactions tab sometimes to do this), check them off in the Safe2Spend sheet. Values at the top in D5 and D6 will update based on what you check off and what you don’t.

Permissions

Is it ok for others to copy, use, and modify your workflow?

Yes. If you end up using it, I would appreciate knowing, but it’s not required that you do so. I have this open for anyone with the link so you can make your own copy and try it out.

Notes

Anything else you’d like people to know?

I understand that this use case may be unique. May no one else can use this. But I still wanted to share this since, over the years, it’s been so useful for me. I can look at this and know that all my upcoming bills, savings, etc are covered and what’s left for me to just enjoy.

FAQ

Optionally, add common questions and answers…