Travel Budget Template

Budget several trips at once, log expenses in any currency with an exchange rate, and see spend per trip, per night and per traveller.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Budget Sheets

Tables

Trips, Expenses

Fields

22

Views

grid, calendar, timeline, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Trips

12 fields · 3 sample rows

  • Trips (Grid)
  • Calendar (Calendar)
  • Timeline (Timeline)
TripTextTraveller / clientTextDestinationTextStartDateEndDateNightsFormulaTravellersNumberBudgetCurrencyExpensesLink to another tableSpentRollupRemainingFormulaPer person per nightFormula
Bali honeymoonAditya & RiyaUbud & Seminyak, Indonesia9 Dec 202616 Dec 202672₹2,80,000Return flights BLR–DPS, Villa with private pool (4 nights), Visa on arrival₹1,29,924₹1,50,076₹9,280
Dubai family breakThe Menon familyDubai, UAE9 Nov 202614 Nov 202654₹4,20,000Flights COK–DXB (4 pax), Hotel, Downtown Dubai, Desert safari₹2,15,050₹2,04,950₹10,753
Kerala backwatersSophie LaurentAlleppey & Munnar3 Jan 20279 Jan 202761₹90,000Houseboat (1 night)₹14,500₹75,500₹2,417
Field details
Trip · Text
Traveller / client · Text
Destination · Text
Start · Date
End · Date
Nights · Formula
IF(AND({Start}, {End}), DATETIME_DIFF({End}, {Start}, 'days'), BLANK())
Travellers · Number
Budget · Currency
INR
Expenses · Link to another table
Links to Expenses
Spent · Rollup
sum of Amount (INR) via Expenses
Remaining · Formula
{Budget} - {Spent}
Per person per night · Formula
IF(AND({Nights}, {Travellers}), ROUND({Spent} / {Nights} / {Travellers}, 0), BLANK())

Expenses

10 fields · 7 sample rows

  • By trip (Grid)
  • Calendar (Calendar)
  • Spend (Dashboard)
ExpenseTextTripLink to another tableCategorySingle selectDateDateCurrencySingle selectAmountNumberRate to INRNumberAmount (INR)FormulaBookedCheckboxConfirmationAttachment
Return flights BLR–DPSBali honeymoonFlights20 Oct 2026INR64,000.00₹64,000Yes
Villa with private pool (4 nights)Bali honeymoonHotels22 Oct 2026USD720.0084.2000₹60,624Yes
Visa on arrivalBali honeymoonVisa & insurance9 Dec 2026IDR10,00,000.000.0053₹5,300
Flights COK–DXB (4 pax)Dubai family breakFlights10 Oct 2026INR1,12,000.00₹1,12,000Yes
Hotel, Downtown DubaiDubai family breakHotels9 Nov 2026AED3,600.0022.9000₹82,440Yes
Desert safariDubai family breakActivities11 Nov 2026AED900.0022.9000₹20,610Yes
Houseboat (1 night)Kerala backwatersHotels3 Jan 2027INR14,500.00₹14,500
Field details
Expense · Text
Trip · Link to another table
Links to Trips
Category · Single select
Flights, Hotels, Local transport, Food, Activities, Visa & insurance, Shopping
Date · Date
Currency · Single select
INR, USD, EUR, AED, IDR
Amount · Number
Rate to INR · Number
Amount (INR) · Formula
IF({Currency} = 'INR', {Amount}, {Amount} * IF({Rate to INR}, {Rate to INR}, 1))
Booked · Checkbox
Confirmation · Attachment

Travel Budget Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates