Overview
I have a highly variable income (and expenses) month to month and my cash flow will frequently go negative for a few months before it turns positive. Because of this, I am very interested in YTD monthly actual cash flow and what my budgeted cash flow per month looks like for the remainder of the year. With this info, I can determine which months I will need to cover expenses through other means and when I will catch up.
I started with someone else’s spreadsheet template that showed monthly Income and Expenses and modified it to include cash flow. I am sorry, but it’s been a long time since I originally started using it and then modifying it so I don’t remember what it was originally called and who did it. If anyone can help, I will give them the starting credit!
This worksheet is a monthly visualization to another worksheet I shared which forcasted end of year cash based on YTD actuals and remaining year budget.
Cash Flow chart example…
Expenses chart example…
Link to worksheet is here
Installation
Just copy into your workbook and you will be good to go.
Setup
If you want to include Net Cash at the beginning of the year, you’ll need to choose which accounts to include in the far right of the worksheet…
FWIW, my Net Cash is simply by Checking and Savings type accounts balances minus any credit card type account balances. If you want to include other Types of accounts, remove the filter in cell BY1, which gives you the drop down list of Accounts you can include in Net Cash…
Usage
You can choose the Year and whether you want Cash Flow, Expenses, or Income. You can also choose which Groups or Categories you want to show (this works well for Income and Expenses, but is not very useful for Cash Flow).
Permissions
It is absolutely ok for others to copy, use, and modify your workflow.
Please let me know if you have any questions or feedback.
Enjoy!