This template forecasts the balance of any checking / savings account, fully automatically, without having to do anything except adjust the timeframe you’d like to see, to produce a simple, easy-to-read graph.
(ignore the artifact on the left, it works seamlessly with real data but I got sick of messing with the fake ones)
I’ve seen other manual versions posted, but I wanted something that just works, without the need to double-check transactions or check boxes. That leaves room for error, this does not, and is extremely easy to use.
I was heavily inspired by the templates @1Email2RuleThemAll has posted, they’ve been some of the most useful to me so far, especially the “Upcoming Recurring Expense / Account Health Dashboard”. My goal was something like that, but for a longer time period and more at-a-glance.
I saw in the comment of that post the “Check Expenses Forecast” he’s planning, and I am very excited to see it when it comes out, but I realized it wouldn’t work for me at all for one big reason.
I work on commission. My income is highly variable, and with the plans to use “average net income” from “Income Settings” to drive paychecks in it, it won’t be useful to me.
I used @jpfieber 's “Paycheck Deduction Generator” to drive paychecks in this template.
Not sure I understand most of the formulas I cobbled together, but I just kept messing with it until it stopped breaking and I’m pretty sure I got it right. Came over from Mint about a month ago and have never used spreadsheets like this before, so if it’s broken I apologize (advice and critique very much welcome).
Install in the order listed below. Again, huge shoutout to @1Email2RuleThemAll , your work is amazing and this entire thing relies mostly on your templates to function. You’ve made some incredibly useful stuff, and I’m a huge fan of your modular approach.
- Paycheck Deductions Generator by @jpfieber - determines amount / date of all future paychecks
- Income Settings by @1Email2RuleThemAll - determines date of most recent upcoming paycheck
- Credit Card Settings by @1Email2RuleThemAll - determines due date / amount due from credit cards
- Recurring Expense Entry by @1Email2RuleThemAll - Feeds “Generated Expenses”
- Generared Expenses by @1Email2RuleThemAll - Feed all non-credit card recurring expenses
I know it’s a lot, but it’s worth it, I promise.
Once these are all in place, it’s extremely easy to use.
Finally, from the link below, copy “Auto Balance Forecast” to your Foundation Template.
- Open the hidden columns to the left of column E, and select the account your paychecks are deposited into.
That is all.
If you’d like your paychecks to show up with a name instead of blank in that list, put the name in Colomn C of the Paycheck Deductions Generator.
Simply select the account you would like to view, and the number of weeks into the future you would like to see.
I’m sure this could be made better, I have no idea what I’m doing to be honest.
Use it, modify it, whatever you like, feel free to share.
This is really only accurate 4-6 weeks out at the moment, if your expenses include credit cards.
It only accounts for current statement due at the moment.
Hopefully, I’d like to figure out how to forecast upcoming card statements / balances due based on recurring expenses charged to credit cards (combined with total balance remaining after the statement), but it’s breaking my brain at the moment. Any ideas / tips welcome.
Either way, I personally find it useful enough as-is to share.
Now includes current statement charges, next due date, and adds in any recurring charges that will hit before the current (and next!) statement end.
Should be extremely accurate 12-16 weeks out now.
Ask me below.
And hi! I’m new here and quite enjoying it, and thank you to everyone building amazing things here.