190x Filetype XLSX File size 0.03 MB Source: www.kpu.ca
Sheet 1: TravelBudget
Insert Project Title Here | 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. | ||||||||||
My Budget & Expenses | Breakdown of Expenses | ||||||||||
Total Budget | ← See an overview of your total expenses. | ||||||||||
$2,750.00 | Transportation | 41% | 1,068 | ||||||||
Total Expenses | Lodging | 23% | 600 | $2,613 | |||||||
$2,612.70 | Food | 22% | 585 | ||||||||
Difference | Entertainment | 4% | 110 | ||||||||
$137.30 | Other | 10% | 250 | ← Other includes everything that is not one of the other 4 categories | |||||||
http://www.vertex42.com/ExcelTemplates/travel-budget-worksheet.html | © 2014 Vertex42 LLC | ||||||||||
What are my expenses? | |||||||||||
description | category | quantity | unit cost | amount | |||||||
Flights | Transportation | 2 | 400.00 | 800.00 | ← Enter expenses using the Quantity and Unit Cost columns | ||||||
Taxi & Bus | Transportation | 5 | 30.00 | 150.00 | |||||||
Driving (miles, cost/mile) | Transportation | 50 | 0.56 | 28.00 | |||||||
Parking (days, cost/day) | Transportation | 6 | 14.95 | 89.70 | |||||||
Hotel (nights, cost/night) | Lodging | 5 | 120.00 | 600.00 | |||||||
Breakfast | Food | 5 | 12.00 | 60.00 | |||||||
Lunch | Food | 5 | 45.00 | 225.00 | |||||||
Dinners | Food | 5 | 50.00 | 250.00 | |||||||
Snacks and Drinks | Food | 5 | 10.00 | 50.00 | |||||||
Museum Tickets | Entertainment | 2 | 20.00 | 40.00 | |||||||
Live Show Tickets | Entertainment | 2 | 35.00 | 70.00 | |||||||
Maps and Guidebooks | Other | 1 | 50.00 | 50.00 | |||||||
Souvenirs and Gifts | Other | 1 | 200.00 | 200.00 | |||||||
- | |||||||||||
- | |||||||||||
- | |||||||||||
- | |||||||||||
- | |||||||||||
- | |||||||||||
- | |||||||||||
- | |||||||||||
- | |||||||||||
- | ← Insert new rows ABOVE this line | ||||||||||
Total Expenses | $2,612.70 |
HELP | ||
http://www.vertex42.com/ExcelTemplates/travel-budget-worksheet.html | © 2014 Vertex42 LLC | |
Getting Started | ||
Enter the total budget for your trip in cell C4. | ||
Enter all of your trip expenses in the section titled "What are my expenses?" Make sure to enter the expense category as one of the following: Transportation, Lodging, Food, Entertainment, or Other. | ||
The "Where are my expenses going?" section is populated automatically based on the total budget and expenses you enter. | ||
You can change a category label in cells F4:F7. For example, you could change the label "Entertainment" in cell C7 to "Activities." | ||
The "Other" category will include everything that is not one of the other four categories. Do not change the name of the "Other" category. | ||
Cell C8 shows the difference between the Total Budget and the Total Expenses, so you can easily see if you are over or under budget. | ||
For other types of budgeting spreadsheets, visit Vertex42.com. | ||
Additional Help | ||
The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template. | ||
TEMPLATE | Vertex42.com: Money Management Template | |
TEMPLATE | Vertex42.com: Family Budget Planner | |
TIPS | Vertex42.com: Spreadsheet Tips Workbook | |
ARTICLE | Vertex42.com: How to Make a Budget with a Spreadsheet | |
ARTICLE | Vertex42.com: Budgeting Tips |
no reviews yet
Please Login to review.