The Naked Kayaker
  • Blog
    • Search the site
  • Resources
    • Complete List of Posts
    • Trip Planning 101
    • Intro to Kayaking - Course Outline
    • Where can I rent a kayak in Belgium/the Netherlands?
    • How do I get certified in NL?
    • Map of Paddling Clubs
    • Dutch-English Watersports Dictionary
  • Destinations
    • West Coast
    • Great Lakes Region
    • New York State
    • New England
    • Europe
    • Oceania
  • Water Nerd
  • About & Contact

Blog

"Believe me, my young friend. There is nothing, absolutely nothing,
half so worth doing as simply messing around in boats." 

The Wind in the Willows

Trip Planning 101: Estimating and Tracking Your Travel Budget

2/16/2018

1 Comment

 
Picture
Activity (biking), transportation (3 eur/day public transit bike), lodging (tent), and food. It doesn't get much better than that! Taken during a 3-day overnight bike trip in the parks west of Amersfoort.
This is the fourth post in a 6-part series about trip planning. If this is the first time you're seeing this post, I recommend you start here! For an overview of the complete series, please visit the Trip Planning 101 page.

Do you make an estimate of trip expenses before going on a trip? How do you keep track of who-paid-what? In this post I share the next tab of the "Best Trip Planning Spreadsheet Ever": the Budget! I'll explain how it can be used to estimate trip costs, log transactions during the trip, and keep all travelers happy and content by keeping costs low, transparent, and well documented. ​​Here in the Netherlands, it's a cultural norm to split costs equally (e.g. "going Dutch") and keep track, sometimes to the cent, via easy bank transfers and payment request apps. I hear this is also catching on in the US, so hopefully this precise approach won't alienate any of you readers! 

As a bonus, I also share the ways that I keep my travel costs low!

Why should I use this budget sheet? There are plenty of apps for this!

Below I share how to use a spreadsheet, which is part of the larger Trip Planning Spreadsheet, to keep track of your travel finances. However, if you live and travel in the same country and all your travel companions have smartphones, then using an app (e.g. Splitwise) is probably a better option for you. Here are some situations when I prefer to use the Budget spreadsheet:
  1. When you won't have reliable phone service and/or regular opportunities to charge your phone. In these cases, I print out the sheet and fill it in by hand - entering it into the digital version at the end of the trip. 
  2. When your travel buddy doesn't have a smartphone. This comes up often amongst my travel companions - maybe it's an outdoorsy/minimalist person thing :) 
  3. It's nice for estimating future trip costs (see section below), and it's a simple step to convert an estimated cost to a paid cost. 
  4. I enjoy having a record of the total cost of a trip. It's harder to glean this information from apps or credit card statements, especially when multiple travelers are splitting costs and paying by various mean.

The spreadsheet is not set up to (easily) deal with multiple currencies at the same time. In these instances I usually choose one dominant currency and convert everything to that.
Picture
Backpacking is a super cheap way to travel (if you have access to gear). Campsite on Colchuck Lake in the The Enchantments, Washington, in October 2016.

Let's calculate! Steps to estimate and track your trip budget:

Disclaimer: if you are also a spreadsheet nerd, this post probably won't be very illuminating for you - there's nothing super fancy/innovative going on here. 
​​
That brings us to the Trip Planning Spreadsheet! Below are instructions for how to use the Budget tab. Hopefully it's mostly self explanatory, but these instructions are there to clear up anything unclear. Each step below is also labeled in the spreadsheet. The spreadsheet has a color key to make it obvious which cells you should change (green), and which cells are calculated and should not be changed (grey). The results (who owes/is owed how much) is shown in yellow. 

Step 0: Traveler names
Add names of each traveler. You only enter names once - the rest of the names in the sheet populate automatically. The example at the bottom of this page shows spots for four travelers. However, the sheet works for up to 8 travelers. You just need to un-hide the columns between F and K, and between O and T, and (optional) between X and AC. You can do this by clicking on the little arrows on the cell headers.

Step 1: Description of cost
Add a brief description of what was paid (e.g. Airbnb in Barcelona, groceries in San Sebastian...). You can optionally add the date paid, though I am often too lazy to do this. It is not necessary for the sheet to function, but helps if you want to look it up in your records later. 
Picture
Another (relatively) affordable way to travel: hiking from hut-to-hut. This is Hofpürglhütte, one of the 4 huts we hiked to in Austria in October, 2017.
Step 2: How much did each person pay?
Who paid? If one person paid, enter the full amount below that person's name. If more than one person paid, enter the amounts they each paid under their names. 

Step 3: What % should each person have paid?
What % should each person have paid? This is often 50% for two travelers, 33.33% for three travelers, 25% for four travelers, etc. This step is completely independent from who paid for the cost (Step 2). The total % should, obviously, add up to 100%. I've added a check column on the right which will turn red if the total is not 100%.

Step 4: Settling the debt
You can see the balance in yellow at any time. A negative number below your name means you owe that much money to other traveler(s). A positive value means you paid that much more than you should have. When one person pays another person back, add that amount in the row above as a positive number for the person who paid, and a negative number for the person who was paid. Since this can be a bit confusing, I've provided an example:

Example: In the screenshot below, we can see that Emily paid the most during the trip (Total actually paid: 823). She should have paid 668 (Total should have paid), so she paid too much (823-668 = 155). We see in Step 4  that Brian has already paid Emily back 78 euros (as shown by adding 78 below his name and -78 below Emily's name). This results in him owing 0 (in yellow). Nena, on the other hand, only paid 533 euros, while she should have paid 610. The yellow results show that she still owes someone 77 euros. We can also see that Emily is still owed 77 euros. Therefore, Nena pays Emily 77 euros (result shown in second screenshot), and everyone is paid up! See second photo below for how that is done.

At some point I may set up a separate little form to keep track of Step 4 more easily. If that's something that would be useful to you, let me know in the comments! I'll deliver :) 

Note: for simplicity, I've rounded all numbers to the nearest 1 dollar/euro/other currency. If you want more detail, you can always show the decimals 
Picture
Example of Step 4, before debts are settled
Picture
Example of Step 4, after debts are settled. The equation entered for Emily is show (78 paid by Brian, 77 paid by Nena)

How to estimate future trip costs

Another use for the Budget tab is to estimate of how much a trip will cost. How does that work?
  1. In one of the "Name" columns (Step 0), write "Estimate"
  2. Put each estimated cost as a separate row (Step 1), with person "Estimate" paying the full price (Step 2). 
  3. Enter what % every *real* person would be responsible for (Step 3, Estimate = 0%)
  4. The results will tell you how much the trip would cost for each person.
  5. (optional) When someone actually pays one of the expenses, move the paid value (Step 2) from the Estimate column to the person who actually paid.
Picture
Another cheap way to travel: by kayak! This was during a 4-day tour through Friesland in August 2017.

Bonus: How I keep travel costs low

When I first wrote this post, it was exclusively focused on sharing the spreadsheet with you; I can sometimes be a bit tunnel-visioned that way. On second thought, I've added how I approach keeping travel costs low. Most of these things are obvious, and there are entire blogs dedicated to this topic, so I'll just summarize my most common tips/tricks: 
​
  1. Start planning early. While people may tell you they find last-minute deals, I've found that planning a last-minute trip is almost always more expensive than starting early. If you start early you have plenty of time to think about the best routes, modes of transportation, and types of activities that will make the trip the most enjoyable and affordable. Plus, you get to daydream more about your future trip! 

  2. Do outdoor, self-organized + catered activities. Chose activities that also happen to be transportation, like walking, boating, or biking. Moving between campsites/huts by foot/boat is, in my opinion, more fun, rewarding, and cheaper in terms of lodging, transportation, and probably food than taking trains between hostels! It's about the journey, not the destination! Obviously it helps that hiking/biking/kayaking/camping are some of my favorite activities. This is not a tip I'd give to someone who hates being outside :) but they wouldn't be reading this blog anyway... 

  3. Track airline prices. According to gmail, I've been using kayak.com price alerts since 2008 (woah!). I'd like to think it's saved me some money. On quite a few occasions, I've gotten an alert about a big price drop (a few 100 dollars/euros), dropped everything I was doing, and bought my tickets. I usually start tracking a year to 6-months ahead of time. That's my approach, but literally everyone has their own opinions about when/how to save money on flights! I'm not really into saving via credit card schemes/loyalty programs, etc. 

  4. Carshare. I've had some experience sharing rides on blablacar.com, and it was a nice way to cover the cost of gas (and more). It doesn't work for all destinations, but for city trips you can usually find rider(s). We once drove 2 passengers back and forth between Brussels and Strasbourg and made ~120 euros. We were going that way anyway!

  5. ​​Book Airbnbs early. Unlike flights, Airbnbs only seem to go up in price the longer I wait. The highly rated but cheap places disappear first. I have read that some drop their prices at the last minute, but since we're all into awesome trip planning, we'll be long booked by then, right? ;) Speaking of which, I have some Airbnbs to book for Greece... 

  6. Track car rental prices. I've used autoslash.com a few times in the past and liked it - they email you every time they find a cheaper rental car. I saved a bit of money on some European car rentals this way.

  7. Avoid eating out too much. I mostly shop at local grocery stores/markets (so fun!) and cook at the Airbnb or over a campstove. This might bother some people, because I know many are culinary enthusiasts and love to try all the local specialties. I'm not super rigid in this habit, and I'm certainly open to eating out if it seems like we'll try something new that we can't make ourselves. I'm just often disappointed by eating out, and really enjoy making a meal together with other travelers using local ingredients. It's the simple things :)  This is coming from the perspective of pretty expensive restaurants in the Netherlands/Belgium/parts of Europe. However, if local prices are cheaper (and the food more flavorful) I'd be more open to eating out!

That list got a lot longer than I was expecting! I guess it could have been its own post... but this is not a financial blog... 
<-- Back to Step 3. Making Your Itinerary
Continue to Step 5. Packing List -->

Example: The Budget

See below for an example of the budget sheet from a trip in Spain. If you find any errors while using the sheet (to be published soon!), please contact me!
1 Comment
maxie
10/2/2019 03:07:37

Hi Nena, first of all i wanna thank you for creating this amazing itinerary sheet. Been looking for sometime that trip planner that work detail like this one. I have some problem with the budget sheet: Since my trip will included 5 friends and each will pay for different thing, in the end of the day, possible for me to split the spending, who still owes who and how much who need to pay from/to each person. Its that possible to do in Budget sheet?

Reply



Leave a Reply.

    Welcome!

    This is a blog about exploring the outdoors (mostly by kayak), traveling, trip planning, and coastal engineering. It currently focuses on kayaking in the Netherlands and Belgium, but previous posts cover Upstate New York, California, and much more. See the Complete List of Blog Posts for a history of the site. Looking for something specific? Search the site here.

    In addition to the blog, check out the Water Nerd section, where I write about coastal engineering and hydrology. 

    ​Happy Paddling!
    ​Nena

    Subscribe Here!

    Email updates on new blog posts, about once per month.

    Reader Tips

    Click the "Read More" link at the bottom of each summary for more photos, to see an interactive map of the route, and to read about the adventure.

    Maps in each blog post: Click the icons to learn more about the launch site (amenities) and destinations. Click the square in the bottom-left corner to see an aerial photo behind the route.
    Suggestions much appreciated!


    Archives

    December 2020
    April 2019
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    August 2017
    July 2017
    May 2017
    April 2017
    March 2017
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    March 2016
    December 2015
    November 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    December 2013
    June 2013
    May 2013
    December 2012
    November 2012
    June 2012
    May 2012
    May 2011
    November 2010
    October 2010
    September 2010
    August 2010
    July 2010
    June 2010
    May 2010


    Categories

    All
    Biking
    Camping
    Canoeing
    City Trip
    Distance: 00 - 05 Miles
    Distance: 05 - 10 Miles
    Distance: 10 - 15 Miles
    Distance: 15 - 20 Miles
    Distance: > 20 Miles
    Guest Post
    Hiking
    Kayak Polo
    Reflections
    Region: Belgium
    Region: California
    Region: Canary Islands
    Region: Croatia
    Region: France
    Region: Great Lakes
    Region: Greece
    Region: Italy
    Region: Netherlands
    Region: New York
    Region: New Zealand
    Region: Norway
    Region: Oregon
    Region: Portugal
    Region: Spain
    Region: Switzerland
    Region: UK
    Region: US East Coast
    Region: Vancouver
    Region: Washington
    Roadtrip
    Tide: Non-Tidal
    Tides: Non-Tidal
    Tides: Tidal
    Time Capsules
    Trip Planning 101
    Type: Bay
    Type: Canal
    Type: Channel
    Type: Fjord
    Type: Lake
    Type: Lake/Reservoir
    Type: Open Coast
    Type: River
    Water Nerd

    RSS Feed

    Click the RSS Feed link, copy the URL, and paste it into your favorite feed reader.
    Blog Expat: living abroad

    Expats Blog
© 2021 The Naked Kayaker. All rights Reserved.