Use one row per purchase, record who paid, and assign each person's share separately. For a small party, a shared Google Sheet can track food, drinks, decorations, deposits, and final reimbursements without burying the math in a group chat.

Equal splits are fastest. A hybrid split is often fairer when some people skip alcohol, arrive late, or cover a deposit.

Turns out, the difficult part isn't the formula. It's deciding what the group agreed to share. Write that rule down before receipts pile up.

Pick the split rule before anyone buys

Start by separating costs everyone benefits from items only some people use. A venue deposit may be shared by every confirmed attendee, while a specialty drink may belong only to the guests who want it. If someone pays upfront, that changes the payer's balance, not automatically their share.

Method Works well when Main tradeoff
Equal split Everyone attends and uses roughly the same shared items Fast and clear, but less precise
Usage-based split Some people skip meals, drinks, or paid activities Fairer for uneven use, but requires more detail
Custom percentages The group agrees that people should contribute different amounts Flexible, but the reason must be clear
Hybrid split Fixed costs are shared while optional items follow the users Usually practical, with a few extra rows
Income-based contribution People voluntarily choose contributions based on budget or income Can help some groups, but may feel too personal for a casual party

A 100% share is appropriate when one person alone owns a cost. It isn't a shortcut for recording that person fronted the money.

For most casual parties, hybrid is a sensible default: split the venue and basic food among confirmed attendees, then assign optional extras only to participants. A no-show rule belongs here too. If the group hasn't agreed whether a nonrefundable deposit follows the attendee or the person who paid it, ask before purchase.

Create a ledger with separate expenses and payments

Create four tabs if the party has more than a few purchases. Keep the structure simple.

Tab Purpose
Expenses One row for every purchase
Summary What each person paid, owes, or should receive
Payments Reimbursements and their status
Rules The agreed split method, attendee list, and special decisions

On the Expenses tab, use one row for every purchase, even if the same person buys twice. Keep the payer field separate from the share fields; paying $200 does not mean that person consumed $200.

Column Example What it records
Date 1/15/2026 When the purchase happened
Description Catering What the money bought
Category Food Food, drinks, decor, venue, or other
Amount 160 The full purchase amount
Paid by Alice The person who fronted the money
Person percentage columns Alice 25%, Bob 25% Each person's assigned share
Receipt Receipt 01 A link, file name, or photo reference
Notes Shared by attendees Exceptions or explanations

Receipts get added late. Names get shortened. Someone writes "food" for three different purchases, and then the total looks wrong. Build for that mess.

Format the amount column as currency. Format each percentage column as a percentage, and enter 25%, not 25.

Add formulas that show the real balance

Assume the percentage columns run from F through I for Alice, Bob, Carol, and Dana. Put their assigned dollar shares in J through M.

For the first expense row, use these formulas:

Cell Formula Purpose
J2 =IF($D2="","",$D2*F2) Alice's assigned share
K2 =IF($D2="","",$D2*G2) Bob's assigned share
L2 =IF($D2="","",$D2*H2) Carol's assigned share
M2 =IF($D2="","",$D2*I2) Dana's assigned share
P2 =IF($D2="","",IF(SUM(F2:I2)=100%,"OK","CHECK")) Confirms the row totals 100%

Copy the share formulas down for every purchase. If the check cell says CHECK, fix the percentages before requesting money.

The Summary tab needs three calculations: how much each person paid, their assigned share, and the difference between those numbers. Put the person's name in A2, then use formulas like these:

Summary field Formula for Alice
Paid =SUMIF(Expenses!$E$2:$E$100,A2,Expenses!$D$2:$D$100)
Assigned share =SUM(Expenses!$J$2:$J$100)
Net =B2-C2

Use the K, L, or M share column for the next person. Extend row 100 if the event has more purchases.

A positive net means that person should receive money. A negative net means that person owes money. The net total should reach zero, apart from a possible rounding cent.

See how the calculation works

Suppose four attendees share $160 of catering and $80 of decorations. Alice pays for the catering, and Bob pays for the decorations. Everyone has a 25% share of both purchases.

Total spending is $240. Each person's assigned share is $60.

Person Paid Assigned share Net Result
Alice $160 $60 +$100 Receives
Bob $80 $60 +$20 Receives
Carol $0 $60 -$60 Pays
Dana $0 $60 -$60 Pays

Carol can send Alice $60. Dana can send Alice $40 and Bob $20. Those transfers clear the balances without changing the original expense rows.

Record reimbursements as transfers

Thing is, a repayment is a transfer, not a new party cost. Adding Carol's $60 payment as another $60 expense would inflate the event total.

Use a Payments tab with these columns:

Date | From | To | Amount | Method | Status | Note

Then follow this workflow:

  1. Finish entering purchases and confirm that every share row totals 100%.
  2. Read the net balance for each person instead of dividing the total again.
  3. Add each planned repayment to the Payments tab.
  4. Mark the payment Owed, Partial, or Paid.
  5. Leave the original expense row unchanged after someone repays the group.

An upfront payer's 100% belongs in the Paid by field, not in the share columns. A person has a 100% share only when that person is responsible for the cost itself.

Some templates model an upfront payment with a row labeled "Reimbursement" and assign 100% to the person being repaid. That convention works only if the sheet treats the row as a transfer rather than a new expense. In a simple spreadsheet, keeping expenses and repayments on separate tabs is easier to audit.

Set the due date in the group rule rather than treating one deadline as universal. A clear message is enough: "Party total is final. You owe $60 to Alice. Please send it by the agreed date and reply when done."

Share the sheet without losing control

Give edit access to the people entering purchases. Use viewer or commenter access for everyone else when possible; a Google Sheets permissions guide outlines the basic role choices.

Protect formula columns if your sheet supports range protection. Keep a duplicate or dated snapshot before the party, especially if several people will edit at once. Save the final Summary and receipt references after all payments clear.

To be honest, a one-off gathering may need only a sheet, receipts, and a written rule. If expenses change constantly, compare any app by what it actually handles: logging purchases, calculating shares, requesting money, paying, and keeping records are separate jobs. Don't assume one tool does all five.

Fix common party-splitting mistakes

Problem Better fix
Someone enters 25 instead of 25% Format the column as a percentage and enter 25%
The payer is given no credit Keep Paid by separate from each person's assigned share
A repayment is counted as another expense Record it on Payments and exclude it from spending totals
A guest cancels after buying starts Apply the rule the group agreed to and add a note
A formula gets overwritten Protect formula columns and let editors change input cells only
A receipt is hard to identify Use a clear description and a matching receipt reference
Optional drinks are assigned to everyone Give shares only to the people who agreed to share them

Create the Expenses, Summary, and Payments tabs before the next purchase. Enter two test rows, confirm every percentage check says OK, and send the agreed split rule to the group.