Expense Tracker Template- (Make a Copy)

	A	B	C	D	E	F
1	Timestamp	Purchase Date	Item	Amount	Category

2	8/22/2020 14:56:26	8/22/2021	Bill Example	₹1,000.00	Bills	Example ONLY - Delete these rows
3	8/22/2020 14:56:47	8/22/2021	Subscriptions Example	₹499.00	Subscriptions	Example ONLY - Delete these rows
4	8/22/2020 14:57:08	8/22/2021	Entertainment Example	₹500.00	Entertainment	Example ONLY - Delete these rows
5	8/22/2020 14:57:31	8/22/2021	Food & Drink Example	₹2,500.00	Food & Drink	Example ONLY - Delete these rows
6	8/22/2020 14:57:49	8/22/2021	Groceries Example	₹300.00	Groceries	Example ONLY - Delete these rows
7	8/22/2020 14:58:17	8/22/2021	Health & Wellbeing Example	₹5,000.00	Health & Wellbeing	Example ONLY - Delete these rows
8	8/22/2020 14:59:07	8/22/2021	Other Example	₹50.00	Other	Example ONLY - Delete these rows
9	8/22/2020 14:59:40	8/22/2021	Shopping Example	₹870.00	Shopping	Example ONLY - Delete these rows
10	8/22/2020 15:00:10	8/22/2021	Transport Example	₹40.00	Transport	Example ONLY - Delete these rows
11	8/22/2020 15:00:30	8/22/2021	Travel Example	₹300.00	Travel	Example ONLY - Delete these rows
12	8/22/2020 15:00:50	8/22/2021	Business Example	₹20,000.00	Business	Example ONLY - Delete these rows
13	8/22/2020 15:01:06	8/22/2021	Gifts Example	₹1,100.00	Gifts	Example ONLY - Delete these rows
14	8/25/2020 20:51:42	8/22/2021	Income Example	₹100,000.00	Income	Example ONLY - Delete these rows
15
16
17
18
19	How to Use?
20	Click File > Make a Copy to save a copy of this sheet on your Drive.
21
22	Enter your purchase date, item name, amount. Then, enter the category name correctly.
23	The expense will be automatically tracked in the "Monthly Expenses" sheet which can be switched to at the bottom,
24	The current entries are only for example- delete them.
25
26	To change the currency, select the boxes with currency, click on Format > Number > More Formats > More Currencies > Select USD or currency of your choice.
27
28	Original File Credits: https://www.deborahho.com/productivity/expense-tracker
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
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