![]() This will affect all of your average calculations.Įach row, except the last two, represents a day on the road and the columns are used as follows. The first thing to do on this sheet is to enter your personal “Daily Allowance” amount (highlighted in yellow on the example file). This page is for entering your daily expenses, the data used to populate the first two tables of the Snapshot. In our example below, we see that we have spent $465 leaving $29,535 of our original $30,000. We think it will be enough however, unexpected events happen and we want to have a place to track those costs should it require more money than anticipated. We have put aside an additional amount of money beyond our $60 per day for major expenses. The third table provides a quick look at how much we are spending on large expenses outside our daily budget: transportation, visas, major bike repairs, or medical expenses as well as any donations or income we have received.Nothing to be significantly worried about and maybe a night or two of wild camping or Warm Showers might bring that average down a little. These are not daily purchases like food and lodging, so we are not necessarily getting into bad habits, just needing some infrequent items that boost our daily average. We can see some details of why we are over budget, including that we entered a new area and needed to purchase a guide book for $21 and that we needed a $30 repair and some new gear. In our example below, we see our total and daily expenses by category for two days. This data is useful in identifying trends. ![]() ![]() The second table shows a more detailed view of the total and daily average spent in each area of our daily life.The “Travel Days Remaining” is just a rough estimate based on the amount of money available and the daily allowance. The “Total Remaining” cell includes deposits made during the trip. In our example below, we see that for the first two days that we are over budget by $54 and should reduce spending for a few days until that number comes closer to zero. If this is a black number without parentheses, then we know that we are under budget and may be able to splurge a little however, if it is a red number with parentheses, then we know we are already exceeding our budget and should cut back a little. The key cell in this table is the “Over / Under Budget” cell. The first table provides that quick look at how well we are sticking to our overall daily budget based on $60 per day and the number of days we have been out on the road.We set aside an additional 50% of our daily expenses budget given the high price of vaccines, visas, and cargo ship travel. In the third table, the “Initial Account Balance” cell should be updated with your budget for major expenses. In the first table, the “Initial Account Balance” cell should be updated with your budget for daily expenses. The majority of cells on this page contain formulas that pull data from the following three pages and should not be edited, with the exception of two cells (highlighted in yellow on the example file). This page contains three tables that each show a different aspect of our overall trip spending and earning, albeit to a much smaller extent. Click this image to download a free copy of our Budget Tracker spreadsheet (MS Excel). This resulted in a four page Excel workbook: the first page contains the desired budget snapshot with the following three containing the data that populates it. His reasoning was so we would instantly know whether we needed to tighten our belts a bit or, if we were doing well, could afford a splurge. We always knew we’d track our daily expenses in attempt to keep to our planned budget, but Doug really wanted to have a running scorecard that showed +/- how we were doing compared to that budget. However, if you’re like us and have a finite budget that includes some headroom to splurge occasionally, then you might find it helpful to know on any given day how much money you have spent compared to what you expected to have spent up to that day. Likewise, if you have plenty of money, then tracking daily spending may not be of much interest to you either. If you are a minimalist and spending next to nothing is your plan, then this article may not be for you. Identifying and tracking your daily travel budget may not be important to everyone.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |