BUDGET TRACKER WORKSHEET.xlsx

	D	E	F	G	H	I	J	L	M	N	O	P	R	S	T	U	V	W	X	Y	Z	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1
2	JUNE
3	Monthly Budget Tracker
4	Philippine Peso				₱
5
6	OVERVIEW
7	Total Income				₱	20000
8	Total Budget				₱	4000
9	Total Expenses				₱	4000.00
10	Total Savings				₱	1,000
11	Total Bills				₱	3,000
12	Total Debts				₱	7,000
13
14	Expenses Overview							Daily Expenses					Bills Tracker									Debts Tracker
15	CATEGORY	BUDGET FOR THE MONTH		TOTAL EXPENSES		REMAINING BUDGET		DATE	DESCRIPTION	CATEGORY	AMOUNT		DESCRIPTION	DUE	STATUS	BUDGET			ACTUAL		REMAINING	DESCRIPTION	DUE	STATUS	INTEREST	BUDGET		ACTUAL		REMAINING
16	Food	₱	60.00	₱	55.00	₱	5.00	6/1/2025	Sandwich	Food	₱	50.00	Spotify	1/31/2024	TRUE	₱	3.00	₱	3.00	₱	0.00	Credit Card	1/31/2024	TRUE	1.0%	₱	50.00	₱	35.00	₱	15.00
17	Transportation	₱	20.00	₱	3.00	₱	17.00	6/2/2025	Bus Fare	Transportation	₱	1.00	Internet	1/8/2024	FALSE	₱	5.00	₱	5.00	₱	0.00	Loan 1	1/15/2024	TRUE	2.5%	₱	20.00	₱	20.00	₱	0.00
18	Allowance	₱	50.00	₱	0.00	₱	50.00	6/3/2025	Dress	Savings	₱	20.00	Netflix	1/30/2024	TRUE	₱	5.00	₱	5.00	₱	0.00	Loan 2	1/30/2024	TRUE	5.0%	₱	15.00	₱	10.00	₱	5.00
19	Dues	₱	25.00	₱	0.50	₱	24.50	6/4/2025	Lunch	Food	₱	2.00	Insurance	1/31/2024	FALSE	₱	20.00	₱	15.00	₱	5.00			FALSE		₱		₱		₱
20	Miscellaneous	₱	5.00	₱	3.00	₱	2.00	6/5/2025	Office Supplies	Miscellaneous	₱	3.00	Rent	1/29/2024	TRUE	₱	120.00	₱	100.00	₱	20.00			FALSE		₱		₱		₱
21	Shopping	₱	30.00	₱	2.00	₱	28.00	6/6/2025	Bus Fare	Transportation	₱	1.00			FALSE	₱		₱		₱				FALSE		₱		₱		₱
22	Savings	₱	50.00	₱	20.00	₱	30.00	6/7/2025	Starbucks Coffee	Food	₱	3.00			FALSE	₱		₱		₱				FALSE		₱		₱		₱
23	Loans	₱	5.00	₱	0.00	₱	5.00	6/8/2025	Bus Fare	Transportation	₱	1.00			FALSE	₱		₱		₱				FALSE		₱		₱		₱
24	Others	₱	5.00	₱	2.00	₱	3.00	1/9/2024	Class Contribution	Dues	₱	0.50			FALSE	₱		₱		₱				FALSE		₱		₱		₱
25	TOTAL	₱	250.00	₱	85.50	₱	164.50	1/10/2024	Gift	Others	₱	2.00			FALSE	₱		₱		₱				FALSE		₱		₱		₱
26								1/11/2024	Phone Case	Shopping	₱	2.00			FALSE	₱		₱		₱				FALSE		₱		₱		₱
27	Income Overview							1/12/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
28	SOURCES	EXPECTED		ACTUAL		REMAINING		1/13/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
29	Allowance	₱	50.00	₱	45.00	₱	5.00	1/14/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
30	Online Business	₱	100.00	₱	100.00	₱	0.00	1/15/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
31	Part Time	₱	25.00	₱	20.00	₱	5.00	1/16/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
32	9-5 Job	₱	150.00	₱	150.00	₱	0.00	1/17/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
33	Affiliates	₱	5.00	₱	5.00	₱	0.00	1/18/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
34	TOTAL	₱	330.00	₱	320.00	₱	10.00	1/19/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
35								1/20/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
36	Savings							1/21/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
37	SOURCES	EXPECTED		ACTUAL		REMAINING		1/22/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
38	Travel	₱	20.00	₱	12.00	₱	8.00	1/23/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
39	Birthdays	₱	8.00	₱	6.00	₱	2.00	1/24/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
40	House Extension	₱	50.00	₱	50.00	₱	0.00	1/25/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
41	Car	₱	45.00	₱	40.00	₱	5.00	1/26/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
42	TOTAL	₱	123.00	₱	108.00	₱	15.00	1/27/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
43								1/28/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
44								1/29/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
45								1/30/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
46								1/31/2024			₱				FALSE	₱		₱		₱				FALSE		₱		₱		₱
47								2/1/2024					TOTAL			₱	153.00	₱	128.00	₱	25.00		TOTAL		8.50%	₱	85.00	₱	65.00	₱	20.00
48								2/2/2024
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64																																s
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