Vacation Budget Planner

Plan your vacation budget, save up for it and keep spending on track while you travel, all in one spreadsheet. List what you expect the trip to cost, and the Vacation Budget Planner works out your total, the cost per person and per day, and how much to save each month before you leave. Log payments as you go, from flights booked months ahead to coffee on day three, and the dashboard shows budget vs. spent for every category. Traveling with friends or family? Note who paid and the planner works out who owes whom. WHAT'S INCLUDED • Trip dashboard: trip budget, spent so far, left to spend, budget per person, average spent per trip day and money saved, with progress bars • Budget vs. spent table for up to 12 categories (transport, lodging, food, activities, souvenirs and more), plus a bar chart and a doughnut chart • Trip budget with 50 lines: category, cost x quantity, and a Planned / Booked / Paid status • Daily expense log (300 rows) with category dropdown, trip day, and an optional per-person split • Who paid what: each traveler's payments, fair share and balance (up to 8 travelers) • Savings plan: months until you leave, monthly amount needed (total and per traveler), and a month-by-month deposit tracker • Day-by-day itinerary (up to 21 days) showing what you spent each day • Packing checklist with 60 rows, a starter list and a packed counter • Setup tab for trip details, travelers and categories • Start Here guide • Two files: a blank planner and a filled-in example WORKS WITH • Microsoft Excel (2010 or later, Windows and Mac, and Excel online) • Google Sheets (free): upload the file to Google Drive and open it with Google Sheets HOW IT WORKS 1. Purchase and download instantly from your Etsy Purchases page. 2. Open the file in Excel, or upload it to Google Drive and open it in Google Sheets. 3. Fill in the Setup tab, list your expected costs, then log spending as you go. PLEASE NOTE • This is a digital download. No physical item will be shipped. • Amounts are in US dollars ($). Currency formatting can be changed in your spreadsheet app. • Costs on the trip budget are your own estimates; actual prices vary. • For personal use. Please don't resell or share the file. • Not financial advice. How we make it: Every Penny & Pencil template and worksheet is designed in-house with AI-assisted tools, then each page, formula and answer key is checked and tested before it is listed. Questions? Send us a message. We usually reply within a day.