Skip to main content
Tools
Tools5 min read

Free festival budget template for Excel and Sheets

Download a free festival budget for friends: tickets, camping, transport, food and 100 expense rows. Excel or Google Sheets, worked example, no signup.

On this page

To budget a festival with friends, list what the group plans to spend together by category (tickets, camping or lodging, transport, food, drinks), then log each actual purchase with the person who paid. This free template does it for you: six categories, 100 expense rows and the remaining budget calculated automatically.

Download the free template (.xlsx)

No signup or email required. Open the file in Excel or import it into Google Sheets to fill it in together. The example uses US dollars. The file does not calculate what each person owes: the example below does that by hand.

Get started

  1. Open the file in Excel or import it into Google Sheets.
  2. In Budget, enter how many friends share the costs and edit the blue cells.
  3. In Expenses, clear the five examples without deleting the rows. Then log the shared purchases, from the first ticket to the last tank of gas.

What is in the file?

Budget holds your planned costs: tickets, camping or lodging, transport, food, drinks and shared gear. The sheet calculates spending by category, the amount remaining and an average per person. A negative remainder means spending has exceeded the plan.

Expenses records the date, category, description, person who paid, amount and notes. There are 100 input rows, from row 7 to row 106. Keep the category names unchanged so the dropdown and summary continue to match.

What goes into the shared budget?

Only what the group pays for together. Passes one friend buys for everyone, the shared tent, gas and groceries for the campsite go in. A band T-shirt, a meal someone eats alone on site or a drink at the bar stays out. Agree on this before the first purchase: tickets often sell months ahead, and that is when one person fronts the biggest amount.

Example: a $1,900 budget for five friends

These are the fictional figures in the file, not festival price estimates. Replace them with your own amounts. Remaining is the planned amount minus recorded spending.

CategoryPlannedSpentRemaining
Tickets$1,000$950$50
Camping or lodging$250$200$50
Transport$200$180$20
Food$250$210$40
Drinks$150$120$30
Shared gear$50$0$50
Total$1,900$1,660$240
Five friends: $380 planned and $332 spent per person on average.

The $240 remaining is room in the budget, not money held in a shared account. If groceries on site or parking are still to come, take them out of that margin before treating it as spare money.

How to use it in Google Sheets

Download the file, open a spreadsheet in Google Sheets, then choose File → Import and select the Excel file. Create a new spreadsheet: both tabs come with it. Google documents this in its guide to importing Excel files.

Share one working copy with the group. Before entering your own figures, check that the example shows $1,900 planned, $1,660 spent and $240 remaining. Agree who logs each purchase so the same groceries are not entered twice.

Record each cost once

If Hugo pays $950 for the five passes, record $950 once. When Malik sends him his share, that transfer is a repayment, not another expense. If a friend resells a pass and refunds the group, enter the amount recovered as a negative amount under Tickets.

An average is not everyone’s share

One friend comes only on Saturday, another sleeps in a hotel instead of the campsite, two don’t drink: the template’s average helps you plan, it does not allocate those cases. For tickets at different prices, read how to split concert or festival tickets. For gear and groceries, see splitting a group camping trip, and for the drive, the fuel cost calculator.

Who pays whom in this example?

In the file, Hugo paid for the five passes ($950), Léa for the campsite pitch ($200) and the groceries ($210), Sam for gas and tolls ($180) and Nora for drinks ($120). Malik has not paid anything yet. Assume the five friends share everything equally and no repayments have been made. $1,660 divided by five is $332 each.

PersonPaidShareTo receive or repay
Hugo$950$332Receives $618
Léa$410$332Receives $78
Sam$180$332Repays $152
Nora$120$332Repays $212
Malik$0$332Repays $332

Malik pays Hugo $332, Nora pays Hugo $212, and Sam pays Hugo $74 and Léa $78. Hugo receives $618 and Léa $78: everyone is settled. The workbook does not calculate these repayments; this table explains the example.

Budget in the sheet, balances in Spliz

  1. Create a festival group in Spliz and send its link to your friends.
  2. Add each expense with the person who paid and the people it covers. Leave out of an expense anyone who did not take part.
  3. Check the balances, repay by bank transfer, in cash or with another app, then record the repayment. Recording it does not move money.

Use Spliz for event expenses. The app is free. Friends can join the group as guests without creating an account, after installing the app. The file does not sync with Spliz: keep the sheet for planning and one shared record for the expenses.

What if a total looks wrong?

Check that amounts are numbers, not text, and that the number of people is a whole number between 1 and 100. The Budget tab flags invalid inputs. An amount with a missing or unknown category appears under Uncategorized and still counts toward spending. Check that you have removed the sample expenses and stayed within the 100 input rows.

This is an editable planning file, with no macros, external data connections or payments. Keep a clean copy before changing its formulas.

Download the festival budget (.xlsx)

Sources and method

Put the numbers into practice. Track what each friend paid in Spliz.