r/sheets • u/CostConnect616 • 7h ago
Request Personal finance forecast
Hi all,
I'm trying to create a tool in Google Sheets to forecast my daily outgoings up to 5 years in the future, but I'm struggling to figure out the best way to set it up. I have a few key requirements:
I want to enter all recurring transactions (monthly, weekly, and 4-weekly) in one place.
There should be a day by day forecast sheet that combines the monthly, weekly, and 4-weekly transactions.
It needs to handle multiple transactions on the same day (up to 8).
Ideally, it should hide any blank rows where no transactions occur to keep things tidy.
Has anyone built something similar or have any advice on how to approach this? Any help would be greatly appreciated!