ABCDEFGHIJKLM
1
MAKE A COPY FIRST!! GO TO FILE, THEN MAKE A COPY
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
₦0
14
Increase in total savings
15
₦300
16
START BALANCE
END BALANCE
Saved this month
17
₦1,000₦1,300
18
19
20
ExpensesIncome
21
Planned₦750Planned₦900
22
Actual₦700Actual₦1,000
23
24
Expenses
Income
25
PlannedActualDiff.PlannedActualDiff.
26
Totals₦750₦700₦50Totals₦900₦1,000₦100
28
Food₦0₦0₦0Savings₦0₦0₦0
29
Gifts₦0₦0₦0Paycheck₦900₦0-₦900
30
Health/medical₦0₦0₦0Bonus₦0₦0₦0
31
Home₦750₦700₦50Interest₦0₦0₦0
32
Transportation₦0₦0₦0Other₦0₦1,000₦1,000
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₦0₦0
39
Custom category 1₦0₦0₦0
40
Custom category 2₦0₦0₦0
41
Custom category 3₦0₦0₦0
42
43
44
45