ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
MAKE YOUR OWN COPY ( FILE -> MAKE A COPY)
2
How to update
3
4
The only 2 tabs that you would need to update information on are the "Statement" and "Mapping List"
5
6
The remaining tabs (Income, Needs, Wants, Savings, Summary) are automatically populated from your "Statement" and "Mapping List" tabs.
7
8
Statement tab
9
10
This is the tab that you would enter all your transactions
11
12
Enter all bank transactions. Income should be entered as a positive number, and expenses as a negative number. Don't include credit card payments from your bank as we will enter credit cards separately. You can export transactions from your bank portal as a CSV file and input them with the date in column A, description in column B, and amount in column C.
13
14
Once you've entered all bank transactions, start entering your credit card transactions directly below the last row of the bank transactions. Credit card expenses should also be entered as negative values.
15
16
If you have multiple credit cards, do them one by one. You can export transactions from your credit card portal as a CSV file.
17
18
Column D has a formula that checks whether you have mapped the vendor in the "Mapping list" tab
19
20
Mapping List
21
22
After entering all your transactions, you will need to map each transaction to a specific vendor.
23
24
Go to the "Statement" tab and filter column D on "No"
25
26
These are transactions for which you need to create a unique identifier.
27
28
In column A of "Mapping List" enter the merchant.
29
30
In column B, enter unique identifer from your transaction line. Something that can help the formula uniquely identify where to map the transaction to.
31
32
Then, categorize the transaction into the appropriate category.
33
34
After that, your statement should have only "Yes"
35
36
You only need to add merchants that you haven't added in previous months.
37
38
Income/Needs/Wants/Savings/Summary
39
40
All of these tabs are automatically populated with your transactions.
41
42
The tabs will display the projected spending, the actual amount spent, and any variances.
43
44
The "Summary" tab will generate charts based on your spending and show you the categories where your money was allocated.
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100