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

Spreadsheets Google Sheets

heather September 11, 2021, 3:51pm 6

Randy recently did a write up on this

Topic		Replies	Views
Adding Percentages Column to Savings Budget Google Sheets	11	391	June 13, 2024
Percent of Budget in Savings Budget sheet. (Like it is displayed in Monthly Budget sheet.) gSheets Templates showtell-votes	1	673	March 11, 2022
Adding a progress bar / spark line row to the Foundation template Google Sheets foundation , google-sheets , how-to , budgeting	4	1374	November 22, 2019
How do I report on percentage of budget category over income updating monthly Google Sheets how-to	1	455	October 7, 2019
Missing Actuals in Savings Budget Tab Google Sheets tcs-savings-budget	8	1050	January 19, 2023

Monthly Budget Percentage of Actual Budget Calculation

Related topics