For domestic trips, either delete/ignore this column. Item: However you want to describe the purchase you made.Ĭost: Cost in foreign currency. Other categories of your own choosing are accepted but will NOT automatically display on the Overview page. While the specific city sheets are pretty much self-explanatory, here is a bit of clarification if anyone gets confused:Ĭategory: Pick from a dropdown menu: Airfare, Visa, Lodging, Phone, Transport, Food, Activities, Cash, Misc. 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.
Home budget spreadsheet google doc 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) 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.
0 kommentar(er)
