Monthly budget

Budget vs. actual by category — frozen panes, a Status dropdown with chips, auto-totals, variance and spend share.

Use this templateSheets template
Monthly budgetBudget vs. actual by category — frozen panes, a Status dropdown with chips, auto-totals, variance and spend share.

Budget

ABCDEFGHI
1CategoryBudgetActualRemaining% usedStatusShare
2Rent$2,200$2,200$0100%On track51%
3Groceries$650$712-$62110%Over17%
4Transport$220$184$3684%On track4%
5Subscriptions$90$118-$28131%Over3%
6Dining out$300$265$3588%On track6%
7Savings$800$800$0100%On track19%
8Total$4,260$4,279-$19100%100%
9
10Categories over budget2
11Biggest overspend$62
12
13
14
Budget vs actual
0550110016502200RentGroceriesTransportSubscriptionsDining outSavingsRent — Budget: 2200Groceries — Budget: 650Transport — Budget: 220Subscriptions — Budget: 90Dining out — Budget: 300Savings — Budget: 800Rent — Actual: 2200Groceries — Actual: 712Transport — Actual: 184Subscriptions — Actual: 118Dining out — Actual: 265Savings — Actual: 800BudgetActual
Budget vs actual data
CategoryBudgetActual
Rent22002200
Groceries650712
Transport220184
Subscriptions90118
Dining out300265
Savings800800
Spend share
Total4279Rent: 2200Groceries: 712Transport: 184Subscriptions: 118Dining out: 265Savings: 800
Spend share data
LabelValue
Rent2200
Groceries712
Transport184
Subscriptions118
Dining out265
Savings800