Take a look at the topic “ Income and Expense Report with One Formula “ Does that do what you want? I’m going to use it very much like you described, “I need a spending calculation monthly and yearly, so I know how much I need to bring in to afford everything for everyone in the current economic state.”
For myself I’m considering figuring out (with help) a version that will give monthly trend lines. However, seems that the budget sheets can do the same because it populates what you spent already, even if you do not have a budget
https://community.tiller.com/t/income-and-expense-report-with-one-formula/34078