Set up one Google Sheets workbook with a row for every Airbnb charge and a balance summary for each traveler. Rent, cleaning fees, groceries, gas, deposits, refunds, and reimbursements all stay in view, and you still get a clean page to print at the end.

Turns out dividing the booking total isn't the hard part. Anyone can split a number four ways. What trips groups up is keeping "who paid" separate from "who owes" while recording uneven stays without hiding the math. The layout below handles both.

Pick the split rule before you enter numbers

The split rule gets decided per charge, not once for the entire trip. Copy the final booking amount straight off the receipt, including cleaning fees, service fees, taxes, and any other charges the group has agreed to share.

Cost Starting rule When to adjust
Rental and shared booking fees Equal per person Use nights stayed when arrival or departure dates differ
Cleaning fee Equal per person Keep it separate if the group wants to discuss it separately
Groceries and meals Equal or limited to the people who used them Itemize meals when not everyone participated
Gas and rental car costs Equal among riders Use a usage or mileage rule if the group agrees
Private room premium Room-specific or agreed weighting Charge more for a larger or private room
Extra guest night Nights stayed or an agreed percentage Record the exception in Notes

An income-based split can fit a household budget. On a friend trip it's unusual, and it only works when everyone agrees before the booking is made.

Indzara's group shared-expense example shows equal, percentage, and amount-based split options. Simular.ai's rent receipt example also shows why consistent dates, amounts, methods, and notes make records easier to review. Treat both as layout references, not rules your group must follow.

Use three tabs instead of one crowded table

Three tabs beat one crowded sheet. Raw entries sit apart from conclusions, so a later correction doesn't turn into an archaeology project.

Tab Purpose Keep here
Expenses One row per charge or refund Date, description, amount, payer, split inputs, receipt notes
Summary Totals and open balances What each person paid, owes, and still needs to receive or pay
Settlements Reimbursements between people Sender, recipient, amount, date, reference, and confirmation

A single Paid? column on an expense row is usually too vague. The payer covered the booking, sure, but the other travelers still owe that person their shares. Actual reimbursements belong on the Settlements tab, not buried in an expense row.

Build the Expenses tab

These examples use four travelers: Alice, Jordan, Casey, and Devin. For a larger group, add more input and owed columns in the same order.

Column Header What to enter
A Date Date of the charge
B Description Airbnb rent, cleaning fee, groceries, gas, or refund
C Category Lodging, food, transport, or other
D Total cost Full amount from the receipt
E Paid by Person who paid upfront
F Split type Equal, Unequal-%, or Unequal-$
G Alice input 1 if included in an equal split, or a percentage or amount
H Jordan input Same rule as Alice
I Casey input Same rule as Alice
J Devin input Same rule as Alice
K Alice Calculated amount Alice owes
L Jordan Calculated amount Jordan owes
M Casey Calculated amount Casey owes
N Devin Calculated amount Devin owes
O Split check Confirms the calculated shares match the total
P Receipt or notes Receipt link, exception, or explanation

Use each participant's name alone in K1:N1. Your summary formulas stay simple that way.

One financial event per row, always. The deposit, the final payment, the cleaning fee, and any refund each get their own row, even when they belong to the same reservation.

And don't type 0.4/0.6/0/0 into a single cell. Sheets reads that as text, not math.

Four numeric input cells, one per person.

Enter equal and unequal allocations

  1. Put Equal in F when every selected person gets the same share.
  2. On an equal row, enter 1 for each participant, then leave the other input cells blank or enter 0.
  3. Unequal-% takes decimal percentages such as 0.4 and 0.6, or plain 40% and 60%, and the values must total 1.00. Unequal-$ takes each person's actual dollar amount, which has to add up to the charge.
  4. Add the formulas below once a sample row works.

Paste this into K2:

=IF($D2="","",IF($F2="Equal",IF(G2=1,$D2/COUNTIF($G2:$J2,1),0),IF($F2="Unequal-%",$D2*G2,IF($F2="Unequal-$",G2,""))))

Copy K2 across to N2, then copy the row down. As you copy across, the reference to G2 shifts to H2, I2, and J2 on its own.

Put the check formula in O2:

=IF($D2="","",IF(ROUND(SUM($K2:$N2),2)=ROUND($D2,2),"OK","Check split"))

Format D and K:N as currency. Where a row uses Unequal-%, format the input cells as percentages.

The formulas stay precise underneath, even when the display rounds. Split $800 three ways and Sheets may show $266.67 each while the stored values still total exactly $800. Whole cents are a people problem, though: agree on who absorbs the final one-cent difference before anyone sends a request.

Test the calculator with sample rows

A few sample rows go in before anyone else gets the link. The four below cover equal shares, an uneven grocery split, and a payer who owes a share of her own purchase. Watch the Split check column while you type.

Date Description Total Paid by Split type Inputs for Alice, Jordan, Casey, Devin Calculated shares
2026-07-15 Airbnb rent $800 Alice Equal 1, 1, 1, 1 $200, $200, $200, $200
2026-07-16 Cleaning fee $150 Jordan Equal 1, 1, 1, 1 $37.50, $37.50, $37.50, $37.50
2026-07-17 Groceries $60 Alice Unequal-% 0.4, 0.6, 0, 0 $24, $36, $0, $0
2026-07-18 Gas $40 Casey Equal 1, 1, 1, 1 $10, $10, $10, $10

Alice paid the $800 rent, and she still owes her own $200 share. Her position for that row is $600 before any other expense shows up.

Thing is, paying upfront doesn't cancel the payer's share. It changes the balance between people.

Calculate balances in the Summary tab

The Summary tab answers two separate questions: how much each person paid, and how much each person should carry. Those aren't the same number. Set up these columns:

Summary column Formula or entry Meaning
A Person Type Alice, Jordan, Casey, and Devin One name per row
B Paid upfront =SUMIFS(Expenses!$D$2:$D,Expenses!$E$2:$E,$A2) Expenses paid by that person
C Share owed =SUM(Expenses!K2:K) for Alice Change K to L, M, or N for each person
D Balance before settlement =B2-C2 Positive means the person should receive money
E Open balance after settlement See formula below Balance after recorded reimbursements
F Status Enter Open, Paid, or use a checkbox Manual confirmation

In E2, use:

=D2+SUMIF(Settlements!$B:$B,$A2,Settlements!$D:$D)-SUMIF(Settlements!$C:$C,$A2,Settlements!$D:$D)

On the Settlements tab, use these headers:

Date From To Amount Reference Confirmed
Date sent Person sending money Person receiving money Reimbursement amount Payment note or receipt Yes or No

Say Jordan sends Alice $200. Jordan goes in From, Alice in To, and 200 in Amount. Don't add that transfer to Expenses; it's a settlement, not a new trip cost.

This is where SUMIFS earns its keep. It totals what a person paid. It won't tell you what that person owes unless you point it at the right owed column.

A couple of simple review views round this out. Relayfi's expense tracker examples use familiar SUMIFS, QUERY, and FILTER patterns; the versions below just adapt them to these columns.

Category totals:

=QUERY(Expenses!A1:P,"select C, sum(D) where C is not null group by C label sum(D) 'Total'",1)

Expenses above $100:

=FILTER(Expenses!A2:P1000,Expenses!D2:D1000>100)

That $100 threshold is an example, nothing more. Swap in whatever amount your group wants to review.

Print a readable Airbnb cost split sheet

Print the Summary tab for the final conversation. When people need to inspect receipts or individual charges, print Expenses separately.

  1. Select the Summary range, or take the current sheet if you want every populated cell.
  2. Open File > Print.
  3. In the print settings panel, choose Selected cells or Current sheet.
  4. Pick Letter or A4 paper, use landscape orientation, and choose Fit to width or Fit to page when the participant columns run wide.
  5. Adjust margins, then decide whether gridlines or row and column headings help the people reading the paper copy.
  6. Check the preview, then save or print the PDF.

The Google Sheets print settings walkthrough covers selected ranges, orientation, scaling, margins, and gridlines.

A PDF is a snapshot. Handwritten changes won't update a single formula in your workbook. Paper works for the conversation; make the final edits in Sheets.

Share the file without breaking formulas

Contributors need enough access to enter expenses. The calculated cells need protection from that same access.

  • Payers can edit the input columns A:J plus the receipt or notes column.
  • Protect K:O and the Summary tab with Data > Protect sheets and ranges.
  • Editor access goes only to people changing entries; Commenter or Viewer fits anyone reviewing the numbers.
  • Keep receipt links and explanations in Notes, so a later correction has a record.

A sheet protection walkthrough shows the range-based approach. Pick the narrowest sharing permission that fits the group.

Record deposits, refunds, and reimbursements separately

A deposit gets its own expense row the moment someone actually pays it. The final booking payment is another row. If the deposit comes back later, record a separate negative row with the refund date and recipient in Notes.

A charge canceled before anyone loses money doesn't need to inflate the expense total. When one person receives a refund for the group, the payer and split fields show how that refund changes the group balance.

Reimbursements belong on Settlements. A formula such as =IF(H2="Yes",0,G2) can make a row look paid, but it never shows who sent money to whom. That missing detail is where disputes start.

Fix the mistakes that distort the result

Check the finished workbook against these before you trust the totals.

Mistake Better approach
One Individual Share column for an uneven trip Use one allocation and one owed column per person
Treating the payer as the only person who paid the cost Record the payer, then calculate every person's share
Marking an expense Paid? after one reimbursement Record the transfer on Settlements
Storing percentages as text such as 0.4/0.6 Use separate numeric cells
Overwriting a deposit when the final payment arrives Keep both rows and explain the relationship in Notes
Deleting paid expenses Keep the raw record and create a filtered or copied archive
Editing formulas by accident Protect formula columns before sharing
Forgetting the final receipt total Replace estimates with the amount shown on the receipt

When a spreadsheet is enough

A sheet is the sensible fit for a one-off trip when the group can agree on the split rule and one person will keep entries current, and it hands everyone a record without forcing the whole group onto the same payment tool, which is usually half the battle anyway.

To be honest, an app may be more convenient for receipt scanning or repeated payment requests. Tracking, requesting, paying, exporting, and recordkeeping are separate jobs, though. The workbook can remain the shared record even when another tool handles the actual transfer.

FAQ

Can I use a simpler equal-split template?

Yes. If every charge divides equally, a compact layout works: Date, Description, Total Cost, Payer, Number of Shares, Individual Share, and Notes. With Total Cost in D and Number of Shares in F, the per-person formula is =D2/F2. Move to person-specific columns as soon as shares differ.

How should I split an extra guest night?

Use Unequal-% based on nights or an agreed amount-based split. Put the reason in Notes, and make sure everyone's on board before the final balance gets requested.

Can I fill out the PDF by hand?

Yes, though it becomes a paper record only. Export the final calculated Summary first, then write notes or confirmations by hand. Enter any changes back into the workbook afterward.

Should a cleaning fee be split separately from rent?

It can be. Equal sharing often makes sense when everyone uses the property, while a nights-stayed or room-specific rule fits a group with different stays or room arrangements.

What if someone disputes an expense?

Keep the receipt link, description, payer, and split rule on the expense row. Leave the disputed amount visible, mark the row in Notes, and settle the undisputed items first if the group agrees.

Create the three tabs, enter the four test rows, and don't share the link until every populated Split check cell says OK.