ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Income & Expense Tracker
3
4
This template is designed to track all the Income and Expenses that you have for a 12-month period.
5
All the calculations are done for you, simply enter your Income and Expenses.
6
7
8
9
❗️IMPORTANT INFORMATION
10
11
📆 To pick a date in the 'Date' columns, simply double-click on cell and the calendar will pop up.
12
⚠️ Please do not delete any hidden columns. They are used in the formulas to produce your reports.
13
14
15
16
Setup
17
18
To set up your Income & Expense tracker template go to the 'Categories' tab.
19
Changes made here will auto-populate throughout the spreadsheet.
20
21
1.1 Starting year & month (required)
22
23
The Overview tabs and charts built into this template are designed to include data for a 12-month period.
24
To make sure that the reports show the correct 12-month period, you have to choose the starting year and month.
25
26
To select the starting year & month, simply double-click on cell D3 in the 'Categories' tab.
27
Select year and month from the pop up calendar (select the day that you're starting from, 28 July 2024, for example).
28
29
Or, you can enter the starting date manually in cell D3 (use the format MM/DD/YYYY).
30
For example, 07/28/2024.
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
1.2 Catergories (required)
52
53
The Overview and Monthly Budget tabs group your income and expenses by category.
54
You can add up to 20 categories for each section (income, bills, expenses, savings, investments and debt payoff).
55
56
Enter your income streams into the 'Income' table (cells B7 to B26),
57
then enter your recurring bill categories into the 'Bills' table (cells D7 to D26), etc.
58
59
Add categories for every section that you'd like to use.
60
You can add additional categories later (❗️please do that in the 'Categories' tab only).
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
Annual Budget tab
82
83
This is a zero-based budget tab, where you can set your monthly budget for each category.
84
The zero-based budget row indicates how close you are to zero dollars left to budget.
85
86
Later you can compare monthly budget and actual amounts in the Monthly Budget tab.
87
88
Simply enter your monthly budget amounts for each category. All the totals calculate automatically.
89
90
91
92
93
94
95
96
97
98
99
100