#Travel budget planner spreadsheet code#

Renaming city sheets does not rename cities in Overview page.Adding new categories that aren't included will not automatically display.The Cost column for each city can only display the foreign currency at the moment and doesn't support multiple currencies.IMPORTANT: To account correctly for cash in the spreadsheet, ATM withdrawals must be input as ATM in the Item column and cash purchases must have Cash in the Card column. Notes: Your little space for you to remind things for yourself or each purchase. You can to specify individual credit cards. Fees are often not reflected in the foreign cost as well. As of now, this must be manually done as different purchases can be made at different currency rates for better accuracy. currency fee): Total cost in USD or home currency including all fees. For domestic trips, either delete/ignore this column. Item: However you want to describe the purchase you made. Other categories of your own choosing are accepted but will NOT automatically display on the Overview page. Category: Pick from a dropdown menu: Airfare, Visa, Lodging, Phone, Transport, Food, Activities, Cash, Misc. While the specific city sheets are pretty much self-explanatory, here is a bit of clarification if anyone gets confused:ĭate: Date of purchase. You can also set a per diem column for other allowances. Once you've entered known quantities, this will give you a better idea as to how much you should allocate to your budget (also figure in cost of living differences). The number that comes up is the number that you need.Įach city is preset with a few expenses.

#Travel budget planner spreadsheet code#

Type '1 USD (or your home currency) to 1 XXX' while replacing XXX with the foreign currency code into Google. For foreign countries/cities, finding the rate is easy.

The FX Rate in the overview budget is set to '1' for domestic trips. The template will also calculate the leftover cash you have from the ATM withdrawals you have made. Everything else will automatically tabulate. To set the budget for each city, set it in the Overview page in the Total Budget column. Unfortunately at the moment, you will also have to rename (and delete) the corresponding city rows in the Overview page where the names appear to match. To start, rename or delete the City sheets to the cities that you are traveling to. This is easily changeable so that your main currency of choice is reflected – just edit all references to USD. The template, by default, is set for U.S.

Calculates foreign costs into your home currency (changeable, default is USD).

Accommodates itineraries up to five different cities or countries.Calculates your physical cash in hand, while accounting for this in your overall spending total.Breaks down expenses into eight categories for domestic or international trips.Trip Budget and Expenses Template (Excel/xls) What does it do in a nutshell? Definitely throw any questions, suggestions or issues you have our way! Ladies and gents, we present the. You'll need to sign in to your Google account to see the template.

It’s definitely not perfect by any means, but it will give you a more accurate view of your finances. It’s not a travel calendar, but a simple budget planning tool that will hopefully break down the main complexities down for any traveler.Īnd if you happen to be on the up-and-up while on the road, this will also help you calculate your exact costs to the T. So while this Google Docs spreadsheet isn’t as automatic as other online organizers such as TripIt (or even Mint), it should help you gauge your spending. I’ve gone all geeky for you and have taken all the guesswork out for you in trying to budget for a trip.