Lordbanks' personal expense tracker

	A	B	C	D	E	G	H
1	Lordbanks' Personal Expense Tracker.					Monthly Allowance	300,000.00
2	Lordbanks' Personal Expense Tracker.					Total spent	188,772.77
3	Item	Description	Date	Limit	Balance	Amount left	111,227.23

4	Yo. Bankole here. This is all dummy data. Scroll down or check out the instructions in the next sheet to figure out how to edit this and make all of it work!
5	Essentials			10,000.00	8,200.00
6	Toilet paper	Carla	03/05/2017	1,000.00
7	Tooth paste	Close Up	03/05/2017	300.00
8	Bathing soap	Imperial leather	03/05/2017	500.00
9	Add new expense
10
11	(create new row above this)
12	Total			1,800.00
13
14	Food			75,000.00	21,450.00
15	Foodstuff	Bulk supermarket run	03/05/2017	38,550.00
16	Lunch	Monthly allowance	03/05/2017	15,000.00
17	Add new expense
18
19
20	(create new row above this)
21	Total			53,550.00
22
23	Digital			25,000.00	-1,800.00
24	Airtime	Etisalat	03/04/2017	1,500.00
25	Mobile data	5GB, Etisalat	03/04/2017	3,500.00
26	WiFi	Smile unlimited	03/06/2017	19,800.00
27	Apple Music	Hian		2,000.00
28	Add new expense
29	(create new row above this)
30	Total			26,800.00
31
32	Logistics			190,000.00	83,377.23
33	Bank charge	Access Maintenance fee	03/01/2017	217.77
34	Uber	Yaba > Ikeja	03/02/2017	2,300.00
35	Uber	Ikeja > Yaba	03/02/2017	1,500.00
36	Uber	Failed Uber	03/02/2017	1,000.00
37	Cafe Neo	Fruit juice	03/04/2017	750.00
38	Cafe Neo	Fruit juice	03/04/2017	750.00
39	Bank charge	GTB transfer fee	03/05/2017	105.00
40	Rent	Contribution to Fibre	03/05/2017	50,000.00
41	Savings	Mutual fund	03/05/2017	50,000.00
42	Add new expense
43
44	(create new row above this)
45	Total			106,622.77
46
47	This is all dummy data, to get started just delete the expense entries and set your own expense category limits. Rename the expense categories if you want. If you want to add a new category, you will need to update cells H1 and H2 to stay in sync. Check out the instructions in the next sheet to figure out how to edit this and make all of it work! If you like this spreadsheet, let me know on Twitter! - @mrbankole. Feel free to suggest changes/improvements (see info below) You're free to use and share this spreadsheet however you like, just attribute the original and its creator here. Cheers! ;)
48	Contact me
49	Twitter
50	Email
51	Why did I make this?
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