jagomart
digital resources
picture1_Spreadsheet For Expenses 32916 | Travel Budget Template


 188x       Filetype XLSX       File size 0.03 MB       Source: www.kpu.ca


File: Spreadsheet For Expenses 32916 | Travel Budget Template
sheet 1 travelbudget insert project title here start by entering the quot total budget quot for your trip then enter your expenses to see if you ll have extra money ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
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




Sheet 2: Help
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

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet travelbudget insert project title here start by entering the quot total budget for your trip then enter expenses to see if you ll have extra money or need cut back my amp breakdown of larr an overview transportation lodging food difference entertainment other includes everything that is not one categories httpwwwvertexcomexceltemplatestravelbudgetworksheethtml copy vertex llc what are description category quantity unit cost amount flights using and columns taxi bus driving miles costmile parking days costday hotel nights costnight breakfast lunch dinners snacks drinks museum tickets live show maps guidebooks souvenirs gifts new rows above this line help getting started in cell c all section titled make sure expense as following where going populated automatically based on can change a label cells ff example could activities will include four do name shows between so easily over under types budgeting spreadsheets visit vertexcom additional link at top worksheet take web page talks...

no reviews yet
Please Login to review.