Travel Budget Worksheet.xlsx

	B	C	E	F	G	H	I	J	M
1	Travel Budget								Start by entering the "Total Budget" for your trip. Then enter your expenses to see if you'll have extra money or if you'll need to cut back.
2	My Budget & Expenses		Where are my total expenses going?
3		Total Budget							← See an overview of your total expenses.
4		$2 750,00		Transportation	42%	1 068
5		Total Expenses		Lodging	24%	600	$2 553
6		$2 552,70		Food	21%	525	$2 553
7		Difference		Entertainment	4%	110
8		$197,30		Other	10%	250			← Other includes everything that is not one of the other 4 categories
9
10	https://www.vertex42.com/ExcelTemplates/travel-budget-worksheet.html						© 2014-2022 Vertex42 LLC
11
12		What are my expenses?
13	description			category		quantity	unit cost	amount
14		Flights		Transportation		2	400,00	800,00	← Enter expenses using the Quantity and Unit Cost columns
15		Taxi & Bus		Transportation		5	30,00	150,00
16		Driving (miles, cost/mile)		Transportation		50	0,56	28,00
17		Parking (days, cost/day)		Transportation		6	14,95	89,70
18		Hotel (nights, cost/night)		Lodging		5	120,00	600,00
19		Breakfast & Lunch		Food		5	45,00	225,00
20		Dinners		Food		5	50,00	250,00
21		Snacks and Drinks		Food		5	10,00	50,00	← Quantity is assumed to be 1 if left blank
22		Museum Tickets		Entertainment		2	20,00	40,00
23		Live Show Tickets		Entertainment		2	35,00	70,00
24		Maps and Guidebooks		Other			50,00	50,00
25		Souvenirs and Gifts		Other			200,00	200,00
26								-
27								-
28								-
29								-
30								-
31								-
32								-
33								-
34								-
35								-	← Insert new rows ABOVE this line
36							Total Expenses	$ 2 552,70
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