What is the goal of your workflow? What problem does it solve, or how does it help you?
The Monthly Cashflow sheet allows me to keep up with how much money that I have to spend on things that aren’t bills. Bills being a lose term to any kind of recurring expense.
How did you come up with the idea for your workflow?
I used Simplifi by Quicken for a little while and they had this feature and I more or less copied the way it works. It’s really simple and so far my favorite way to make sure I’m not overspending on any given month.
Please describe your workflow. What are the sheets? Does it use any custom scripts or formulas?
Pretty much everything happens on the Monthly Cashflow sheet. It does pull in the Spending Actual from F7 from the Monthly Budget Sheet but that the only time it interacts with another sheet. There aren’t any scripts and all of the formulas are basically addition/subtraction.
The sheet is pretty manual. First you need to input all of your expected incomes and how much you expect to earn that month. If your paycheck is higher than budgeted, your left to spend will increase when you put in the actual amount. If it is less than expected then it will go down. You do the same thing for your expenses.
The B and C cells are just simple addition/subtraction formulas. It gets your spendable income from the income that you input on the income section and will move up or down if the actuals are different. The Bills & Subscriptions works the same way.
Spending Plan is just the difference between Spendable Income and Bills & Subscriptions.
You can manually enter a Savings Goal total in if you to allocate some money to savings and keep it out of your Left to Spend amount.
Spent so Far takes the Spending Actual from the Monthly Budget sheet and subtracts the sum of your actuals from the M column.
Left to Spend takes the difference between Spending Plan and Spent so Far. This is the amount of money you have left to spend on things that aren’t accounted for in the Monthly Cashflow sheet.
Anything else you’d like people to know?
Is it ok for others to copy, use, and modify your workflow?
Yes. I’m not very adept at sheets so if you can make the sheet more aesthetically pleasing or improve its functionality please do. I wouldn’t mind seeing any improvements to it as I’m sure it could be improved upon.
If you said yes above, please make a copy of your workflow and share the copy’s URL: