Weekly Cash Flow Budgeting

Google Sheets
1

Hello, long time user, first time caller.

I’ve got the “foundation” understood. Categories are set up, autocat works, loving the tool.

However, I want to build weekly cash flow projections instead of monthly in the foundation. I have the “week” column in my transactions sheet.

Any thoughts?

2

Sorry for the delay in replying here @judd.a.rogers. Right now, there isn’t an out of the box way to get the Foundation template to show weekly cash flow projections. Perhaps consider adding a feature request though.

Some savvy spreadsheet nerd might have an idea, but I don’t have an official recommendation to share.

3

Hi Judd

See attached link for my current solution. It’s not elegant but it is effective.
You should be able to copy the yellow tab right into you workbook.

Tabs Comment
Outline Tab Layouts, Purposes, and Procedures
Legend Key for cell coloring and layout of cells and column comments
CashFlow Cashflow workbook tab

I think if dates were added to the categories budgeting forcasting could be automated further but right not the front end process of forecasting is manual. The back end of the process where the ledger is true-up to the transactions and tied out to the bank balance is automated.

Hope this helps

Good Luck

https://docs.google.com/spreadsheets/d/1l__YkmVvRYLTSU36juMIkZjohg29SUs8W-OYHMXtNBw/edit?usp=sharing

-Isaac

1 Like
4

Isaac - having issues accessing your solution via the link. Ideas?

5

Thanks for sharing this @idscott47. If you’re open to it, would love for you to write up and share via Show & Tell. I’m sure others would love to see something like this.

6

Hi Judd

Thanks for patience. I see what you mean. It looks like the link is not functioning by clicking on it.

As a work around I copied the like and pasted it to my address bar.

Let me know if that works for you

-Isaac

7

Hi Heather

Sure do you have any guidlines or procedures for posting links on show and tell, so I do not run into the same issue with the link.

-Isaac

8

@idscott47,

Just make sure that whatever sheet you’re including for sharing has permissions set up so anyone with the link can view.

The not being able to click could have something to do with our community trying to protect against malicious links if the person doesn’t have a high enough trust level.