Create a Simple Receipt Template Google Docs for the Travel Industry

Simple receipt template google docs for Travel Industry

hi this is Leah from pal and Grace this is a comprehensive video tutorial of our travel planner spreadsheet in this video I'm going to show you exactly how to use all the great features of this spreadsheet the link to purchase the spreadsheet will be below and if you have any questions at all please please be sure to reach out to us and without further Ado let's get into the video tutorial once you're ready to start using the spreadsheet the very first tab you're going to go to is the start tab on the start tab there are a couple things you'll want to do to set up your spreadsheet the very first thing you'll want to do is add in your currency symbol you can either type it in or copy and paste it from the web the next thing you're going to do is add in your currency code so for example my currency is the US doll so I would type in USD then you're going to select from the dropdown the day of the week that you start your week off with so for example for me that is Sunday finally you're going to add in different categories for your itinerary planning you can easily come back and add to this list in the future so no worries if you don't have all the categories figured out yet however I'll add in some example categories to reference after this the next tab you're going to go to is the trip info tab in this tab you're going to fill fill out all the general information of your trip the very first thing you're going to do is add in a start date for your trip which you can do by double clicking this Blank cell and selecting from the calendar or typing it in using the month day year format then you can add in an end date as well once you add in both a start date and an end date you'll be able to see the number of days and nights of your trip and the calendars over here will automatically update and highlight with the days that you'll be gone after this you can add in the different countries or states that you'll be visiting if you've selected to use the US map version of the spreadsheet then instead of countries you'll just add in state names this is also optional but you can add in the start date and end date of the different places that you'll be visiting along your trip to see which days you'll be there once you add in a country name that country should automatically highlight in the geom map to the right and lastly you can add in a vacation name down below if you're visiting one specific continent you can also change your geom map to reflect this for example if I double click the map and go to customize then to goo then to region I could select Europe and just see all the European countries and now is way more zoomed in like this so the very first itinerary is a very simple one that looks just like this this in it you can add different details for breakfast morning mid morning lunch evening dinner and night and if you scroll to the right it will include as many days as are included in your trip and after that it will look locked off like this and it will also highlight your current day so you can easily see that information quickly due to the layout of this itinerary I would say that the best use is on mobile itinerary B is very similar to itinerary a except it's essentially all in pictures so this is a picture based itinerary where you add in the URL in the light gray cells and an image will appear so that way you can see an image form what you have planned for each day you can fully customize these sections on the left as well similarly to itinerary a I would say that the best use for this would be on a mobile device itinerary C is one of my personal favorites because it combines both images and a more written L itinerary in this tab you can easily add in images by pasting in URLs into these light gray cells on the left the image will automatically appear right next to it after that you can add in more specific details for each thing you can add in start times end times estimated lengths you can add in categories to show what you'll be doing you can add in more details or specific names and then any notes still left followed by a link that you can add as you can see up here you can also turn the colors on and off for each day's itinerary just by checking and unchecking this check box another really great thing about this tab is that you can print it out I would recommend printing this in landscape form so that all the text appears larger however you can also print it out in portrait form as well it is totally up to you moving on to itinerary D this itinerary is very very similar to itinerary C except it removes the images and gives more space for everything so this is just a very vertically based itinerary and I think it can be super help F and amazing similarly to the last one you can also print this one out as well and I would recommend going to landscape however you can still choose to do portrait if you would like itinerary e is another great option where you can map out your day more specifically and it also includes a to-do list at the bottom that updates as you check off the tasks and you can add in any other notes as well at the top of the box you can also add in a brief summary of the day in any locations you'll be visiting to add in an image all you have to do is paste the URL into the beige cell up here and the image will automatically appear and again you can select from the drop downs very easily and add in more specific information for each thing you'll be doing that day due to the layout of this tab I would recommend using this one most on mobile itinerary f is one of our two time blocking itineraries as you'll see itinerary F and itinerary G are very similar the only difference is that itinerary f is in 15minute increments in itinerary G is in half an hour or 30 minute increments so it's slightly smaller and more compact to use these tabs the very first thing you're going to want to do is select a start time that will be used for each day once you do this the times will automatically update for the rest of the tab for each day you can add in locations Transportation information accommodations and a brief summary when it's time to do your time blocking you can easily select a category from the dropdown and then add in your details to do the actual time blocking select the cell and drag down over the time that it will cover and then click the merge cells button up here and the time will be blocked off just like this if you try to do this with the links you'll see an error but just click okay and it will merge completely fine so if you love time blocking this may be perfect for you if you realize you've made a mistake you can always go over to another section and just copy and paste part of it over and it will appear as normal or you can click to unmerge the cells just like this and then drag down the links to reset it so it's super easy and again itinerary G is used in the exact same way due to the layout of these two tabs I would also say that the best ease of use would be on mobile as opposed to printing them out however you can of course use them on your laptop or computer as well itinerary H and itinerary I are our two calendar based tabs they both include two months so you can hopefully see all the days of your trip the days of your trip will highlight in blue and the current day of the trip will highlight in an orange color itinerary H is a more image based tab you can easily add in an image to any of the cells by pasting the URL into the light gray box and the image will appear beneath that in the beige section you can add in any details of what you're doing that day this tab is a great one to print and I would recommend doing this in portrait so you can get the full calendar on both Pages lastly itinerary eye is incredibly easy to use as well in this tab you can add in the times in the Light Beige cells and then you can add in details in the lighter cells next to it each day has five different slots and if there's a different way that you would like to use this calendar you can absolutely do that as well this tab is another great Tab to print out and I would recommend printing this one out in landscape so you can fully view the calendars on each page like this those are all of our itinerary templates if you need help remembering which itineraries are best for what we do have this listed out for you you scroll down on the how to use tab lastly one quick thing I wanted to knowe is that when you open the spreadsheet if you add in any links to images this warning bar may appear here all you have to do is Click allow access and everything will work great and that concludes our video tutorial for the travel cleaner spreadsheet again a link will be left in the description box below for you to purchase the spreadsheet and if you have any questions at all please be sure to reach out to us and we'll be more than happy to help I'm so excited with how this spreadsheet turned out and I truly hope that you can use it to transform your trips and make travel planning much easier again I'm so excited for you to get to use this spreadsheet thanks for being here and I hope to see you around again here soon