Historical Cash Flows

[thaylon]

I’m looking to ultimately set up a bar chart that allows me to visualize my cash flows on a monthly basis historically. The Monthly Analysis tab has these values for the last 12 months, but I can’t quite figure out how to get the cash flow amounts by month for all time in a table to use as the source data. Ideally this automatically adds on each additional month as new data comes into the workbook.

Any help and guidance would be appreciated.

[twalane]

Will the >> Net Worth Tracker << do? You can modify the graph type perhaps?

[Cowboy13]

@thaylon

Just ran across your post. I also wanted to see this so I created…

Cash Flow forecast by month based on YTD Actuals and remaining monthly budget

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 …

You can view 12 months of cash flow, income, expense and filter on Category or Category Group.

Would love to know if this helps or if you have any feedback on how to make it better.

Thanks.