Agree on the rule before you buy anything. For party costs, that usually means a 50/50 split, an income-based percentage, a usage-based share, or a hybrid of those choices. Put each purchase in a shared Google Sheets or Excel file, then record reimbursements separately.
That gives both partners one place to check the purchase and the balance. It also shows whether anything has been settled. Turns out, the arithmetic is usually easy. The awkward part is deciding what counts as shared.
Choose the split before shopping
Start with the purpose of the split. Equal shares keep things simple, while proportional and usage-based rules address differences in income or consumption.
| Method | Works well when | Example for a $200 party cost | Main tradeoff |
|---|---|---|---|
| Equal | Both partners have similar incomes or want the simplest rule | $100 each | May feel uneven if one partner has much less disposable income |
| Income-based | Partners agree to share costs according to an income ratio | At 60/40, P1 pays $120 and P2 pays $80 | Requires agreement on the income measure and some privacy |
| Usage-based | People consume clearly different items | The person requesting a special item covers more of it | Estimates can create arguments |
| Hybrid | Some costs are shared, while others belong to one person | Shared food at 50/50; a special request at a custom percentage | Each row needs a clear rule |
With an income-based split, agree on whether you are using gross income, after-tax income, or another consistent measure. If Partner 1 earns 60% of combined income, that partner pays $120 of a $200 bill and Partner 2 pays $80. A 62/38 ratio would produce $124 and $76 on the same total. Precision alone does not make a split fair.
Usage-based rules work best for items with an obvious difference. Drinks, special dietary food, or a requested cake might use a custom percentage, while shared decorations and basic groceries stay equal.
Account for guests separately
A guest contribution needs its own rule. Decide whether money or supplies from friends reduce the shared party cost, pay for a specific item, or count as a gift.
Record that contribution separately. Otherwise, the final balance can look lower without showing why.
Put the party rules in writing
A short agreement prevents most confusion. Before shopping, write down:
- which costs count as shared and which are personal
- the base split, such as 50/50 or 60/40
- how to handle special requests, dietary items, or extra drinks
- who fronts deposits and when reimbursements are due
- when you will review the sheet and settle
Keep the wording plain:
"We'll use 60/40 for shared party costs. Personal requests are paid by the requester. We will review the sheet Sunday evening and settle after the party."
Change the example to fit your plans. The point is to agree before a receipt creates pressure.
Build a shared party expense spreadsheet
One simple expense tab works for most two-person parties. Replace P1 and P2 with the partners' names if that makes the sheet easier to read.
| Date | Expense item | Total cost | P1 % | P1 share | P2 share | Paid by | Type | Notes |
|---|---|---|---|---|---|---|---|---|
| 2026-03-15 | Drinks | $50 | 60% | $30 | $20 | P1 | Expense | Receipt saved |
| 2026-03-16 | Food | $100 | 50% | $50 | $50 | P2 | Expense | Shared food |
Keep the percentage cell numeric. Enter 0.60 in D2 and format it as 60%; do not enter the text 60/40 in a cell used for calculations. If a row uses a 70/30 split, enter 0.70 for P1.
For layout ideas, Expense Sorted's shared expense tracker example includes fields for dates, descriptions, payers, amounts, shares, and settlement status. Jake Lee's income-ratio spreadsheet example demonstrates proportional calculations. Treat both as examples, not required systems.
Set permissions deliberately. Give both partners editing access if they will enter expenses, or let one person edit while the other has comment or view access.
Add formulas and a balance view
Assume row 2 is the first expense row.
| Cell | Formula | What it does |
|---|---|---|
| E2 | =C2*D2 |
Calculates P1's share |
| F2 | =C2-E2 |
Assigns the remaining amount to P2 |
The second formula keeps the two shares tied to the full charged amount. It also avoids small rounding gaps.
Add a small summary area before recording settlements:
| Summary item | Formula |
|---|---|
| P1 paid | =SUMIF($G$2:$G$100,"P1",$C$2:$C$100) |
| P1 owed | =SUM($E$2:$E$100) |
| P1 net | =SUMIF($G$2:$G$100,"P1",$C$2:$C$100)-SUM($E$2:$E$100) |
Change the row limit to cover your actual entries. A positive P1 net means P1 paid more than P1's assigned share and should receive money. A negative result means P1 owes money before settlements.
Record reimbursements without double-counting
Use a second tab for money that changes hands. A reimbursement is not another party expense.
| Date | From | To | Amount | Method or reference | Status |
|---|---|---|---|---|---|
| 2026-03-20 | P2 | P1 | $20 | Agreed payment method | Settled |
If P1 paid the full $200 at a 60/40 split, P2 owes P1 $80. If both partners paid for several items, use the net balance rather than sending money for every individual receipt.
If you use a payment app such as Venmo, treat it as the transfer method here. The spreadsheet remains the shared record. Keep receipt photos in a shared folder or sheet comments, and avoid putting sensitive account details in the notes.
Follow a simple log-and-settle workflow
-
Agree on the method and exceptions before anyone shops. State whether the event uses 50/50, 60/40, usage-based shares, or a hybrid.
-
Create the expense and settlement tabs. Enter one test row and check that the two shares add back to the total.
-
Log each purchase promptly. Include the date, item, amount, percentage, payer, and receipt location.
-
Check the math before moving on. A $50 drinks purchase at 60/40 gives P1 a $30 share and P2 a $20 share.
-
Review the sheet weekly. A ten-minute Sunday check-in works for recurring planning; a one-off event can be closed out after the party.
-
Calculate the net amount. If P1 covered $200 and the agreed split is 60/40, P2 owes $80 before other transactions are included.
-
Ask for repayment in a neutral way: "Per our 60/40 split on the party drinks receipt, your share is $20. Can you send it through our agreed payment method? The receipt is in the sheet."
-
Mark the settlement after it is confirmed. Keep the original expense row and add the payment to the settlement tab.
-
Revisit the rule if an item exposes a problem. A special dietary purchase or unusually personal request may need a different row-level split.
Handle taxes, tips, deposits, and special items
Party expenses rarely use one identical rule for every purchase.
| Situation | Agree on | Spreadsheet treatment |
|---|---|---|
| Tax and tip | Apply the same share used for the underlying items | Enter the final charged amount, not just the pre-tax amount |
| Special item | The requester pays 100%, or both partners approve a custom percentage | Add the rule in the notes |
| Deposit | Decide who fronts it and how it will be divided | Keep the original deposit row and record any refund separately |
| Guest money or supplies | Decide whether it reduces shared costs or counts as a gift | Label it as a contribution instead of hiding it in an expense |
| Missing receipt | Use an estimate only until the receipt is found | Mark the row as estimated and update it later |
Thing is, a returned deposit can make a correct sheet look wrong if you edit away the original row. Keep the original transaction and add a clearly labeled refund.
Know when a receipt folder is enough
To be honest, not every party needs a full tracker. For a one-off party under $100 with a genuine 50/50 split, a saved receipt and a quick calculation may be enough.
Use a spreadsheet when costs recur, more than one person fronts money, percentages vary, or deposits and contributions need a record. Save a copy of the final sheet with the receipts after the event.
FAQ
How do I calculate an income-based split for a $200 party bill?
At 60/40, multiply $200 by 0.60 for P1's $120 share. P2 pays the remaining $80. The ratio should come from an income basis or another rule both partners accept.
What if one partner pays for everything?
Enter that partner in the Paid by column for each expense. At a 60/40 split, a partner who covers the entire $200 total is owed $80 from the other partner, unless other expenses change the net balance.
Can different party items use different percentages?
Yes. Change the P1 percentage for each row. Shared food might use 50/50, while a special cake or requested drink could use a custom split agreed before purchase.
Should a reimbursement count as a party expense?
No. Add the original purchase to the expense tab and the repayment to the settlement tab. Counting both as expenses inflates the event total.
How often should partners review the spreadsheet?
A weekly ten-minute review keeps a recurring plan current. For a single event, review the sheet before shopping and settle it soon after the party.
When should we change the split method?
Review it after a major income change, a change in attendance or usage, or a disagreement about a recurring category. You can also revisit the rule after each large event.
Before the next shopping trip, create the two tabs, enter the agreed percentages, and test one sample row together. If the shares do not add back to the total, fix the sheet before spending real money.