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 outSavings2200650220903008002200712184118265800BudgetActual
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