Free bachelor party budget template for Excel
Free Excel and Google Sheets budget for a bachelor or bachelorette party: six categories, 100 expenses and a worked example for 8 friends. No signup.
On this page
Plan the bachelor or bachelorette party budget and compare it with actual spending. The file has six categories, 100 expense rows and an average per paying guest: the guest of honor is not counted, so their costs are spread across the people who pay.
Download the free template (.xlsx)
No signup or email required to download. Open the file in Excel or import it into Google Sheets to edit it together. The example uses US dollars; the file does not convert currencies or calculate what each person owes.
Get started
- Open the file in Excel or import it into Google Sheets.
- In Budget, enter the number of paying guests and edit the blue cells.
- In Expenses, clear the five examples without deleting the rows. Then enter your group’s purchases.
Two sheets, one view of the weekend
Budget holds your planned costs for accommodation, transport, activities, food and drinks, decorations and other expenses. The sheet calculates spending by category, the amount remaining and an average per paying guest. A negative remainder means spending has gone over 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; entries below that range are not included in the totals. Keep the category names unchanged so the dropdown and summary continue to match.
Who pays for the guest of honor?
Most groups treat the bride or groom. The file follows that rule: you count only the people who pay, and the guest of honor’s costs stay in the totals. The average per paying guest already includes them.
Agree on this before booking and put it in the planning chat. If the guest of honor pays for their own train ticket but nothing else, keep that ticket out of the group total.
Example: a $2,500 budget for 8 paying guests
These are the fictional figures included in the file, not price estimates for a party. Replace them with your quotes and receipts. The Remaining column is the planned amount minus recorded spending.
| Category | Planned | Spent | Remaining |
|---|---|---|---|
| Accommodation | $960 | $960 | $0 |
| Transport | $320 | $320 | $0 |
| Activities | $480 | $480 | $0 |
| Food and drinks | $560 | $412 | $148 |
| Decorations | $80 | $64 | $16 |
| Other | $100 | $0 | $100 |
| Total | $2,500 | $2,236 | $264 |
The $264 remaining is room in the budget, not money in a shared pot. If a $150 brunch is still to come on Sunday, only $114 of that margin would remain. Check what is still unpaid before treating the remainder as spare money.
How to use it in Google Sheets
Download the file, open a spreadsheet in Google Sheets, then choose File → Import → Upload. Select the workbook, choose to create a new spreadsheet and import the data. Both tabs come with the file. 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 imported example shows $2,500 planned, $2,236 spent and $264 remaining. Agree who logs each purchase so the same dinner is not entered twice.
Record a cost once
If Max pays $960 for the house, record $960 once. A friend sending Max money is a repayment, not another expense. A deposit paid to the host and the final balance can be two lines, or one line for the total, never both.
Keep a refundable security deposit outside the expense total until an actual charge is confirmed. Enter a supplier refund, such as a canceled activity, as a negative amount in its category. See also a withheld security deposit and a refund for a canceled booking.
An average is not everyone’s bill
A friend who only joins the Saturday dinner does not owe for the house or the go-karting. Someone who drives down does not owe for the train. The average in this file helps plan; it does not allocate those costs. Record who takes part in each expense, as in our guide to splitting an activity not everyone joins. If the party is one of several costs before the wedding, read how wedding guests can split costs.
For activity ideas and planning the weekend, our bachelor party guide complements this file.
Keep the budget here, track who owes whom in Spliz
In the file, Max paid $960 for the house and $480 for go-karting, Tom paid $320 for train tickets and $64 for party favors, and Jules paid $412 for dinner. The total is $2,236. The $279.50 average does not yet tell you who needs a reimbursement.
Who pays whom in this example?
Assumption: the eight paying guests share all five expenses equally, the guest of honor’s costs included, and no repayments have been made. The other five are Leo, Sacha, Nils, Yanis and Malo. Each person’s share is $279.50.
| Person | Paid | Share | To receive or repay |
|---|---|---|---|
| Max | $1,440 | $279.50 | Receives $1,160.50 |
| Jules | $412 | $279.50 | Receives $132.50 |
| Tom | $384 | $279.50 | Receives $104.50 |
| Leo, Sacha, Nils, Yanis, Malo | $0 each | $279.50 each | Repay $279.50 each |
Leo, Sacha, Nils and Yanis each pay Max $279.50. Malo pays Max $42.50, Jules $132.50 and Tom $104.50. Max receives $1,160.50 in total. The workbook does not calculate these repayments; this is the worked example.
- Create a group for the party in Spliz and share its link with the guests.
- Add each expense with its payer and participants. Leave out anyone who only joins part of the weekend.
- Check the group balances. Once someone repays by bank transfer, in cash or with another app, record it in Spliz.
Use Spliz for event expenses. The app is free, with up to 5 ongoing Spliz at a time. Friends can join the group as guests without creating an account, after installing the app. Spliz does not move money: a repayment recorded in the app is not a payment. This file does not sync with the app; keep it for planning.
What if a total looks wrong?
Check that amounts are numbers, not text, and that the number of paying guests 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.
This is an editable planning file, with no macros, external data connections or payments. Keep a clean copy before changing its formulas.
Download the party budget (.xlsx)
Sources and method
- Google Sheets: import an Excel workbook, instructions for importing both tabs.
- The example table reproduces the figures in the downloadable Spliz workbook. All people and amounts are fictional.
Put the numbers into practice. Track what each friend paid in Spliz.