A blank Google Sheet can track an Austin bachelor party's rental, meals, bar tabs, gas, and activities in one place. Use one row per charge. Record who paid, who participated, and each person's share.

Keep trip costs and repayments in separate tabs. That prevents double-counting. An Airbnb deposit is a trip expense; a friend's later repayment is a settlement, not another expense.

Turns out, the difficult part is usually the group rule, not the formula. Decide in advance who pays for optional activities, whether non-drinkers share bar tabs, and whether the groom's portion is covered by the group.

Agree on split rules before anyone pays

Write the decisions in the Summary tab so nobody has to reconstruct them after the weekend. These are practical starting points, not mandatory rules.

Cost Starting split Decision to record
Airbnb or vacation rental People staying at the property Whether the groom participates
Rental car and gas People using the vehicle Whether transportation is shared by everyone
BBQ or group meal People eating Whether small extras are shared
Bar tab Drinkers or itemized orders How non-drinkers are excluded
Optional activity People attending What happens if someone cancels
Groom's share Group decision Write down yes or no before the trip

If the group covers the groom, leave him out of the participant flags for that expense. Add a note explaining the decision. If he is paying his own portion, include him normally.

Use four tabs instead of one crowded ledger

A simple structure keeps the calculations readable and makes reimbursements easier to audit.

Tab Purpose Example
People Names used throughout the workbook Alex, Ben, Chris
Expenses One row for each charge Airbnb deposit
Settlements Repayments made after expenses Ben pays Alex
Summary Paid, owed, sent, received, and net totals Alex should receive

Use the same spelling everywhere. Chris R. and Christopher are different names to a formula.

Build the Austin expense tracker

Create a blank Google Sheet and add the four tabs above. Name the file something recognizable, such as Austin Bachelor Party Expenses.

On the People tab, put one name in each row. The names will also appear across the Expenses and Summary tabs.

On the Expenses tab, use these columns:

Columns What to enter
Date Date the charge occurred
Description Clear detail such as Airbnb deposit or Sixth Street bar tab
Category Lodging, transportation, food, drinks, or activity
Amount Total charged, in dollars
Paid by Person who fronted the money
Split type Equal, Percent, or Custom
Participant inputs One column per person
Participant shares One calculated column per person
Receipt link Optional link or file reference
Notes Context, exclusions, or refund details

Put the participant names in G1:L1, using one column per person. Repeat those names in M1:R1 for the calculated share columns. Replace the example range if your group has more or fewer people.

Use the setup in this order:

  1. Format the Date column as a date and the Amount and share columns as currency.
  2. Add a dropdown for Split type with Equal, Percent, and Custom.
  3. For an equal or usage-based split, enter 1 for each participant and 0 for everyone excluded.
  4. For a percentage split, enter decimal weights such as 0.5 and 0.5.
  5. For a custom split, enter the exact dollar amount each person owes in the participant input columns.
  6. Paste the share formula below into M2, then copy it across and down.
=IF(G2="","",IF($F2="Equal",IF(SUM($G2:$L2)=0,0,IF(G2=1,$D2/SUM($G2:$L2),0)),IF($F2="Percent",$D2*G2,IF($F2="Custom",G2,""))))

When you copy the formula from M2 to the right, G2 becomes H2, then I2, and so on. The participant range stays fixed.

For example, a $1,200 Airbnb deposit split equally among six participants gives each person a $200 share. A bar tab can use the same formula with 1 only in the drinkers' columns.

Leave the formula unrounded until the final display. If a split creates a fractional cent, assign the leftover cent to one agreed participant and note the adjustment.

Add a Summary tab that shows who should pay

The Summary tab should use the same names in B1:G1 as the share columns on Expenses. Put these labels in column A:

Cell in column A Meaning
A2: Paid Total each person fronted
A3: Share Total amount allocated to that person
A4: Sent Repayments that person made
A5: Received Repayments that person received
A6: Net Final amount to receive or pay

Put these formulas in column B and copy them across the other names:

B2: =SUMIF(Expenses!$E:$E,B$1,Expenses!$D:$D)
B3: =SUM(Expenses!M:M)
B4: =SUMIF(Settlements!$B:$B,B$1,Settlements!$D:$D)
B5: =SUMIF(Settlements!$C:$C,B$1,Settlements!$D:$D)
B6: =B2-B3-B4+B5

The M:M reference in B3 should move to N:N, O:O, and so forth as you copy the formula. Keep the share columns in the same order as the names in the Summary header.

A positive Net means that person should receive money. A negative Net means that person owes money. If Alex paid $1,200 for a six-person rental and Alex's share is $200, Alex starts with a positive $1,000 from that expense before other charges are included.

Add two checks somewhere on the Summary tab:

Total expenses: =SUM(Expenses!$D:$D)
Total allocated: =SUM(Expenses!$M:$R)

Those totals should agree for completed rows. A mismatch usually means a participant was missed or a custom allocation does not add up.

Record repayments on a separate Settlements tab

The Settlements tab needs only a few columns:

Column What to enter
Date Date the repayment was made
From Person sending money
To Person receiving money
Amount Positive repayment amount
Method or reference Optional note such as cash or transfer
Status Planned, sent, or confirmed

Do not add a repayment to the Expenses amount column. Doing so inflates the party total and makes the group appear to owe more than it does.

The sheet records the agreed amount. It does not move money or verify that a payment arrived. After someone pays, add the settlement row and update its status. If the group uses a payment app or cash, keep that transaction outside the spreadsheet and use this tab as the record.

A plain reminder can be enough: Your current group balance is $[amount] owed to [name]. Please send it using the agreed method and reply when it's done.

Share the file without exposing the formulas

Invite specific people by email when possible. Use Viewer for people who only need to check totals, Commenter for people who need to flag an issue, and Editor for trusted friends entering expenses.

For a private trip, keep general access restricted. Review whether editors can change permissions or share the file before sending invitations. Google's Docs Editors Help has the current sharing options, while Tiller's sharing and permissions walkthrough provides a practical explanation of the common roles.

Protect the formula columns and the Summary tab through Data > Protect sheets and ranges. Leave the input areas editable: dates, descriptions, amounts, payers, split types, participant inputs, receipt references, and notes.

Thing is, protection works best when access is limited to people you trust. If someone overwrites a row, use version history to review or restore an earlier version instead of guessing what changed.

Use a steady trip workflow

When Action
Before the first charge Confirm who participates in lodging, transportation, meals, drinks, and optional activities
Immediately after a charge Save the receipt and enter one complete expense row
Each evening Check the amount, payer, participant flags, and split type
Before settlement Look for duplicate charges, refunds, missing receipts, and incomplete rows
After a repayment Add a Settlements row and mark its status

A refund should stay visible. If a $200 cancellation refund goes back to the original payer, add a negative $200 expense using the same participants and explain it in Notes. This lowers both the amount paid and the allocated shares without deleting the original charge.

To be honest, most disputes come from vague descriptions. Dinner is harder to review than BBQ catering for Friday. Add the location or purpose when it helps the group recognize the charge.

Common spreadsheet mistakes and the fix

Mistake Better approach
Adding repayments to trip expenses Record them only on Settlements
Including everyone on every optional charge Use participant flags or custom amounts
Changing a deposit row after a refund Add a negative refund row when appropriate
Using different spellings for one person Copy names from the People tab
Overwriting calculated shares Protect formula columns
Sharing private receipt links broadly Check link access before adding the URL
Forgetting small cash charges Enter them the same day with a short note

FAQ

How should non-drinkers skip a bar tab?

Use 1 only for the people sharing the tab and 0 for everyone else. If one person ordered a noticeably different amount, use Custom and enter the agreed dollar shares.

Should the groom's portion be covered?

There is no universal rule. Some groups cover it, while others have the groom pay his own way. Decide before the trip, then reflect that decision in the participant inputs.

Can several people edit the file?

Yes, people with Editor access can enter changes in the same file. Keep formula ranges protected and ask everyone to add a new row rather than rewriting an old one.

What should happen if someone disputes an expense?

Keep the original row, add a note, and discuss the split outside the formula cells. If the amount changes, edit it only after the group agrees, or add a correcting row so the history remains clear.

When should the sheet be archived?

After all settlements are confirmed, download a copy if the group wants a record and change access to Viewer. Keep the final Summary and Settlements tabs together.

Create the blank file, add the four tabs, and test one equal split before anyone pays. Then add a bar-tab example with only the participating drinkers and confirm that the Summary totals balance.