ABCDEFGHIJKLM
1
2
GET STARTEDNOTE
3
Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below.Only edit highlighted cells.
4
Try not to alter cells that contain a formula.
5
As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month.
6
7
8
Monthly BudgetStarting balance: $1,000
9
10
11
12
13
-130%
14
Decrease in total savings
15
-$1,296
16
START BALANCE
END BALANCE
Saved this month
17
$1,000-$296
18
19
20
ExpensesIncome
21
Planned$2,518Planned$1,450
22
Actual$2,796Actual$1,500
23
24
Expenses
Income
25
PlannedActualDiff.PlannedActualDiff.
26
Totals$2,518$2,796-$278Totals$1,450$1,500+$50
28
Food$890$800+$90Savings$0$0$0
29
Gifts$678$980-$302Paycheck$1,450$1,500+$50
30
Health/medical$0$0$0Bonus$0$0$0
31
Home$950$1,000-$50Interest$0$0$0
32
Transportation$0$0$0Other$0$0$0
33
Personal$0$0$0Custom category $0$0$0
34
Pets$0$0$0
35
Utilities$0$0$0
36
Travel$0$0$0
37
Debt$0$0$0
38
Other$0$8-$8
39
Custom category 1$0$8-$8
40
Custom category 2$0$0$0
41
Custom category 3$0$0$0
42
43
44