What is the goal of your workflow? What problem does it solve, or how does it help you?
I used to use YNAB 4 mostly because it was really easy to model account balances based on future transactions. I knew I needed to find a way to duplicate this functionality in Tiller and was able to edit the “Statements” sheets to meet my needs.
My goal is to see what my account balance will be on future dates based on the automatic deductions I expect. I mostly do day-to-day spending on credit cards, so this is to monitor paychecks vs big transactions like credit card payments and mortgage payments coming out of my checking account. You can also use it to model loan balances into the future.
Please describe your workflow. What are the sheets? Does it use any custom scripts or formulas?
The workflow uses an altered version of the “Statement Details” tab and the normal version of the “Statements” tab. I also use the tags column in the Transactions tab to indicate pending transactions. There are no custom scripts and it is very easy to set up.
First, you want to add your statements as usual for the account you want to track and assign the correct transactions to the statement. Then add a few manual entries for future dates. Select the right account on the “Account Projections” tab and you have a running balance and chart for the future dates. Use the tags “pending” or “placeholder” to highlight manual transactions in blue background/italics.
The running balance is green when it matches the current balance from the “Balance History”, red when less than zero, and yellow when less than 300 (but you can change that based on what you want your minimum desired balance to be). The Current Balance and Minimum Balance are at the top of the page.
Is it ok for others to copy, use, and modify your workflow?
Yes, please do! And let me know if you make it even better!
If you already use the “Statements” sheet from Tiller Labs, just copy in the “Account Projections” sheet.
If you do not already use the “Statements” sheet from Tiller Labs, I recommend adding the “Statements” and “Statement Details” sheets from the Labs add-on before copying in my “Account Projections” sheet.
If you said yes above, please make a copy of your workflow and share the copy’s URL:
Here is a screenshot of the “Account Projections” sheet: