Quarterly budget vs. actual in a quarterly view?

Does anyone have the yearly budget view cut in a quarterly view I could leverage?

The Spending Trends sheet does have a quarterly view option, the breakdown seems pretty similar. Is there something specific you’re hoping to see that the Spending Trends sheet doesn’t have?

Im having this same problem…I want to see the spending VERSUS BUDGET…
It doesn’t appear that the spending trends sheet provides the budget part…I only see the spending part…Is there a sheet or template that allows you to see both?
Basically, to boil it down, Im looking for something similar to the monthly or yearly budget sheet that allows for custom date range…thanks!

1 Like

Thanks for chiming in, I haven’t seen a template that accomplishes that yet.

I modified the Monthly Budget View to have flexibility for full-year, quarterly and any range of months within a year. It works well for the purposes described here. Importing my version requires copying the sheet and then eliminating the source file references via an easy search and replace. It’s in Excel. Happy to share, though I’m not sure what’s the best way to make it easy.

1 Like

HI Jason. Wow! awesome. Can I upload the excel to google sheet and convert it to a gsheet after?

What is the best way to share? do you want to send me a downloaded file via gdrive?

Sounds great @JasonS . Consider having it as an Excel Show and Tell :tada:

@thaonguyen.tpn I believe you can open the Excel in Google Sheets and save it as a Google Sheet, I’m just not sure depending on the specific formulas to what extent it might break. Also check out Budget Review sheet - Summarize expenses, income, and budgets by month or quarter

That’s the tip I needed. I’ll try to get it there in the next few days. Is there a common place to land the actual .xls or does every simply point to their shared drive of choice?

I submitted this last night as a show and tell and will share the post here once it’s approve.

1 Like

Awesome @JasonS thanks for linking it here —> off I go to explore!