Use a payer column, but don't stop there. It records who fronted the cash; it doesn't show who should ultimately carry each cost.

Build a Transactions tab and a Summary tab in a blank Google Sheet. Add an Allocations tab when different expenses involve different people, and a Settlements tab when you want to record reimbursements separately.

Wedding expenses tend to arrive in clumps: a deposit, a rush of small purchases, then a refund or last-minute travel change. Turns out, the payer total is easy; the fair-share rule needs more care.

Choose columns that separate payment from reimbursement

Keep vendor payment and group repayment as separate fields. A caterer can be paid while the person who covered that bill is still waiting to be repaid.

Column What to enter Example
Expense ID A short, unique code for each charge W-001
Date The date the charge or refund cleared MM/DD/YYYY
Description A clear item or vendor description Rehearsal dinner deposit
Amount The charge as a positive amount $1,250.00
Category A consistent spending group Catering
Payer The person who paid the vendor Bride's Parents
Expense status Pending, Paid, or Refunded Paid
Reimbursement status Not needed, Open, Partial, or Settled Open
Receipt / Notes A receipt link, vendor detail, or split note Receipt link

Use positive amounts for charges. Put a refund on its own negative row and give that row Refunded status, so the original charge remains visible.

Don't use Reimbursed as the expense status. Reimbursement is a separate transfer between people.

Build the file in five passes

  1. Create four tabs named Transactions, Summary, Allocations, and Settlements. The last two can stay empty until you need them.
  2. Paste the transaction headers into row 1. Freeze that row with View > Freeze > 1 row, so the payer and status columns remain visible while you scroll.
  3. Format the Amount column as currency and the Date column as a date. Turn on text wrapping for the Receipt / Notes column.
  4. Add a Lists tab with participant names, categories, and status values. Apply dropdowns through Data > Data validation to the Payer, Category, Expense status, and Reimbursement status columns.
  5. Protect the Summary tab and formula cells through Data > Protect sheets and ranges. Leave the transaction entry cells editable.

Keep participant names consistent. Alex Kim and Alex become different people in a formula.

Calculate payer totals on the Summary tab

Enter each participant once in Summary!A6:A20. Use the cells above that list for group checks:

A1 can say Participant count. Put =COUNTA(A6:A20) in B1.

A2 can say Cleared group cost. Put =SUMIF(Transactions!$G$2:$G,"Paid",Transactions!$D$2:$D)+SUMIF(Transactions!$G$2:$G,"Refunded",Transactions!$D$2:$D) in B2.

A3 can say Share check. Put =SUM(B6:B20)-$B$2 in B3. A result of zero means the shares assigned below match the cleared group cost.

Set row 5 to these headers: Participant, Share due, Paid for expenses, Gross position, Sent, Received, and Remaining.

For an equal split, enter this in B6 and copy it down:

=IF($A6="","",IF($B$1=0,"",$B$2/$B$1))

In C6, calculate what that participant actually paid:

=IF($A6="","",SUMIFS(Transactions!$D$2:$D,Transactions!$F$2:$F,$A6,Transactions!$G$2:$G,"Paid")+SUMIFS(Transactions!$D$2:$D,Transactions!$F$2:$F,$A6,Transactions!$G$2:$G,"Refunded"))

In D6, calculate the gross position:

=IF($A6="","",B6-C6)

A positive number means that person owes the group. A negative number means they paid more than their share and should receive money.

Do not remove a settled reimbursement from the expense total. The payer still made the original vendor payment; the later transfer belongs in the settlement record.

Record actual reimbursements separately

Create the Settlements tab with these columns: Date, From, To, Amount, Method or reference, Status, and Notes. Use Planned and Recorded as status values, and mark a transfer Recorded only after it happens.

In E6, calculate how much the participant has sent:

=IF($A6="","",SUMIFS(Settlements!$D$2:$D,Settlements!$B$2:$B,$A6,Settlements!$F$2:$F,"Recorded"))

In F6, calculate how much the participant has received:

=IF($A6="","",SUMIFS(Settlements!$D$2:$D,Settlements!$C$2:$C,$A6,Settlements!$F$2:$F,"Recorded"))

In G6, calculate the remaining position:

=IF($A6="","",D6-E6+F6)

Copy those formulas down. The Remaining column tells you who still owes money after recorded transfers.

Use allocations when not everyone shares every cost

Thing is, equal shares hide exceptions. Parents may cover the venue, one attendant may pay their own travel, and a guest may attend only one dinner.

Use the Allocations tab for those cases.

Column What to enter
Expense ID The matching ID from Transactions
Participant The exact participant name from Summary
Assigned share The amount that person owes for that expense
Include in settlement? A checkbox checked after the expense clears

For example, assign a venue deposit only to the people who agreed to share it. A pending charge should not count toward reimbursement yet. When it clears, check the allocation boxes.

Replace the equal-share formula in Summary!B6 with this allocation formula:

=IF($A6="","",SUMIFS(Allocations!$C$2:$C,Allocations!$B$2:$B,$A6,Allocations!$D$2:$D,TRUE))

Use one method or the other. Don't leave both formulas in the same cell.

Add an optional Allocation check column in Transactions!J. In J2, enter:

=IF($A2="","",D2-SUMIF(Allocations!$A$2:$A,$A2,Allocations!$C$2:$C))

A zero means the assigned shares equal the transaction amount. For a refund, use a new expense ID and negative allocation amounts, or the original share will remain too high.

Equal shares are fastest. Per-person shares work when headcount changes. Usage or nights fit travel and lodging. Task-based splits suit attire or personal travel. Income-based contributions can work too, but only if the group agrees on the basis before payments begin.

Add quick views for categories and payers

A category summary helps the couple see where money is going without sorting the transaction list manually.

Place this formula on Summary or a separate report area:

=QUERY(Transactions!A:I,"select E, sum(D) where G = 'Paid' or G = 'Refunded' group by E label sum(D) 'Total'",1)

To show cleared expenses for the participant named in Summary!A6, use:

=FILTER(Transactions!A2:I,Transactions!F2:F=$A6,Transactions!G2:G="Paid")

If you want a budget comparison, enter the agreed budget in B4 and use =B4-B2 in C4. That figure compares the budget with cleared expenses, so pending charges remain outside it by design.

Share the sheet without losing the audit trail

Share with named people rather than using a broad link when receipts include addresses, invoices, or other personal details. Give Editor access to people entering charges, and use Commenter or Viewer access for people who only need to review.

Protect the Summary and formula ranges before inviting the group. Keep the Transactions tab open for data entry.

Use the Notes column for questions and receipt links. If a row is corrected after a settlement, document the change instead of silently deleting the history. Save a fixed copy or PDF after final settlement if the group wants an unchanged record.

Agree on the rule before the first deposit

Write the rule in the group chat or on the Summary tab. It should cover who logs receipts, when entries happen, how exceptions are allocated, and what counts as settled.

Please log each charge with its payer and receipt before requesting repayment. We will use equal shares unless an allocation row says otherwise, and mark a settlement Recorded only after the transfer is complete.

To be honest, written rules feel formal for a wedding party. They are easier than reconstructing the month from old payment notifications.

Common spreadsheet mistakes and fixes

Problem Better practice
Payer names are typed freehand Use a dropdown from the participant list
Pending charges enter the reimbursement total Limit totals to Paid and Refunded rows
A reimbursement is entered as a negative wedding expense Record it on the Settlements tab
Every expense is forced into an equal split Use Allocations for exceptions
A formula is overwritten during data entry Protect the Summary and formula ranges
A refund has no matching allocation Add a negative allocation for the refund ID
One status field mixes vendor payment and repayment Keep expense and reimbursement statuses separate

A tracker documents group money; it doesn't decide whether a payment is taxable or deductible. For business, charitable, or tax-reporting questions, get advice for the relevant facts and jurisdiction.

Start with one real transaction, preferably the largest deposit. Add its payer, choose who shares it, and confirm that the Summary and allocation check balance before sharing the file.