Is it possible to adjust the % calculation on the “Monthly Budget” tab of the foundations template? Currently the template will display the % of your total budget allocated for each expense sub-category, but I’d like to have this calculation based on actual expenses to see how close I am to 50/30/20…

Hey Matt, thanks so much for the suggestion here! These formulas are a bit above my skill level but I see what you were going for moving the current equation over to be based on actual spending. For some reason, I got an error on both of these cells using your recommendation. Although, you pointin…

Monthly Budget Percentage of Actual Budget Calculation

Google Sheets

heather September 11, 2021, 3:51pm 6

Randy recently did a write up on this

Topic		Replies	Views
Percent of Budget in Savings Budget sheet. (Like it is displayed in Monthly Budget sheet.) Show & Tell showtell-votes	1	578	March 11, 2022
Template for monthly actual vs budgeted Google Sheets	2	595	August 26, 2021
Review Last Month's Category Actuals in the Categories Sheet Show & Tell budgeting	2	802	September 9, 2021
Monthly Budget - Hide Categories That Have No Budget or Actual Microsoft Excel	4	218	November 23, 2023
Foundations Monthly Budget Available balance not accurate Google Sheets troubleshooting	1	191	May 29, 2023

Monthly Budget Percentage of Actual Budget Calculation

Related Topics