I’ve been using Tiller this year and overall have really enjoy the automation and data presentation. one thing i miss from a prior budgeting spreadsheet is the ability to see the yearly budget reconciled to a given month/time of year showing the difference between budget and actual to that point of the year. i think the closest i’ve seen in the monthly budget sheet but that’s not cumulative. here’s a shot of what i’m referencing.
thx for the follow up question. the suggestion from that thread was to use a P+L statement or edit the view on the yearly budget overview. i tried looking at those options but dont think its what i’m looking for- the P+L doesnt show the cumulative budgeted amounts as a comparator and the yearly budget overview doesnt show the month by month cumulative amounts.
the yearly budget overview would do what i’m looking for if the option existed to look at the tallied results in variable timeframes instead of defaulting to a 12 month period. the closest i came was altering the date formula in B3:D3 to show the Jan through current month (October, as an example- AH3) which updated the column heading to the timeframe i was interested in but that didnt update the any of the other forumlas for either the budget or actual columns.
