Create a shared expense spreadsheet in Google Sheets by setting up columns for wedding costs like Date, Description, Amount, Category (such as Venue or Travel), Payer, Deposit (Y/N), and Status (Paid/Pending). Add basic formulas for totals and summaries, then share with edit access via the Share button. This helps wedding couples, planners, or groups track deposits, vendor payments, guest contributions, and reimbursements without complex apps.

Google Sheets works for small to medium wedding parties managing shared costs among family, friends, or contributors. Log expenses as they occur, review totals monthly, and use the sheet to settle reimbursements via cash, checks, or external apps.

Choose Columns for Wedding Shared Expenses

Start with a clean Google Sheet and enter these column headers in row 1: A1: Date, B1: Description, C1: Amount, D1: Category, E1: Payer, F1: Deposit (Y/N), G1: Status.

These columns cover common wedding needs. Date tracks when the expense happened. Description notes details like "Venue deposit" or "Catering tasting." Amount records the total cost. Category groups items such as Venue, Catering, Travel, Attire, or Flowers. Payer lists who paid upfront, like "Bride's parents" or "Groom." Deposit flags initial payments with Y or N. Status uses Paid, Pending, or Reimbursed.

Tailor categories to your wedding: add Flowers, Photography, or Guest Travel for reimbursements. For multiple payers, use additional columns if tracking couples.

Freeze row 1 for visibility: go to View > Freeze > 1 row. This keeps headers on screen when scrolling.

Add sample rows to test:

  • Row 2: 2026-01-15, Venue deposit, 5000, Venue, Bride's family, Y, Paid
  • Row 3: 2026-02-20, Flight for bridesmaids, 1200, Travel, Friend A, N, Pending

Set Up Basic Formulas for Tracking and Totals

Place formulas in a summary section starting at row 102 or a new sheet tab named "Summary."

For category totals, like all Travel expenses marked as paid: =SUMIFS(C2:C100, D2:D100, "Travel", G2:G100, "Paid"). This sums amounts in column C where category matches "Travel" and status is "Paid," from Relay Financial's expense tracker.

For a full category summary table, use =QUERY(A2:G100, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'"). This lists each category and its total spend, from Relay Financial.

Track remaining budget: enter total budget in B1 (e.g., 25000), then in B2: =$B$1-SUMIF(G:G,"Paid",C:C). This subtracts paid amounts from the total, from Pix Wedding's budget template.

Flag large expenses over $100: =FILTER(A2:G100, C2:C100>100). This shows rows for review, from Relay Financial.

For budget warnings, in a helper column: =AND(C2>=B2*0.8, C2<=B2) to highlight if spending hits 80-100% of budget (format yellow via Format > Conditional formatting), from Relay Financial.

Count pending items: =COUNTIF(G:G,"Pending"). Test all formulas with your sample rows before sharing.

Share the Spreadsheet with Your Wedding Group

Click the Share button (top right, green). Add emails for edit access, or generate a link set to "Editor" for anyone with the link. Restrict further by unchecking "Editors can change permissions and share."

On mobile, tap three dots > Share & Export > Share. Choose edit, comment, or view per person.

Track changes via File > Version history > See version history. This logs who edited what and when.

Protect key cells: right-click summary formulas > Protect range to prevent accidental edits.

Wedding Workflow: Add Expenses, Review, and Reimburse

Log expenses weekly: snap receipt photos, note details, update Payer and Status. Use phone camera to upload images via Insert > Image > Upload.

Run summaries monthly: check QUERY output for category totals. Flag large items with FILTER for group approval.

For splits, discuss rules upfront: equal per person, usage-based (e.g., family covers venue, friends split travel), or proportional to income. Calculate shares manually or add a "Share %" column with =C2/6 for six contributors, then SUMIFS per person.

Review in group calls: share screen, walk through pendings. Reimburse via Venmo, Zelle, or cash after proof (screenshot payment confirmation).

Spreadsheets suffice for small groups (under 10 people) with simple tracking. For payments, pair with apps like Venmo for requests, but keep records here. Switch to apps if needing automated splits or notifications.

Common Mistakes and Fixes for Shared Wedding Spreadsheets

Forgetting to freeze headers (View > Freeze > 1 row) makes scrolling hard - fix immediately.

Wrong permissions block edits: double-check everyone has "Editor," not "Viewer."

Untracked changes: always use version history before/after reviews.

Formula errors: test with samples; if #REF!, adjust ranges like C2:C100.

For guest data, pull RSVPs: =IMPORTRANGE("spreadsheet_url","Guest List!D:D") from a separate RSVP sheet. Grant access first when prompted, from Pix Wedding.

Over-editing: suggest one person approves changes, or use comments (right-click > Comment).

No backups: Sheets autosaves, but download monthly via File > Download > PDF for records.

FAQ

How do I pull guest RSVP data into my expense sheet?
Use =IMPORTRANGE("spreadsheet_url","Guest List!D:D") to import from another Sheet, then =COUNTIF(RSVPStatus,"Yes") for yes counts, from Pix Wedding.

What if someone forgets to update the Paid status?
Set a weekly reminder rule in your group chat. Use conditional formatting to highlight blanks in Status column.

Can I use this for uneven splits like income-based contributions?
Yes, add "Income Share %" column, multiply Amount by share (e.g., =C2*E2), then SUMIFS per person. Discuss tradeoffs: equal is simple, income-based fairer for uneven earnings.

Is a spreadsheet enough for large wedding deposits?
For groups under 10 with clear rules, yes for tracking. For bigger, add written agreements and consider apps for payment proof.

How often should we review the shared sheet?
Weekly for new expenses, monthly for summaries and reimbursements. Align with vendor due dates.

What if we need to export for records?
Go to File > Download > PDF or CSV. Use version history for audits. Keep receipts folder linked via hyperlinks in Description column.

Next, create your sheet with these columns and one formula. Test with two sample expenses, share a test link, and set a first review date.