A shared Google Sheets workbook can handle a wedding group's deposits, vendor payments, and reimbursements without turning the process into a second job. Set up one payment ledger, record who paid, and keep the agreed split in a separate tab.

Use one row per payment. A venue deposit and final balance are separate events, even when they belong to the same contract. That choice makes due dates, receipts, and reimbursements much easier to check.

Turns out, the formula is the easy part. People need the same status words and the same rule for who owes what. Decide those before you send the sharing invite.

Build the payment ledger first

Create a blank Google Sheet and rename the first tab Expenses. Add these headers in row 1:

Column What to enter Example
A: Expense ID A unique ID for each payment W-001
B: Date Date paid, or date the item was logged Jan 15
C: Due date Vendor payment deadline May 20
D: Description Clear description of the charge Venue deposit
E: Vendor Business or person receiving payment Rosewood Hall
F: Category Expense group Venue
G: Amount Full payment amount $5,000
H: Payer Person or household who paid Bride's family
I: Deposit? Yes or No Yes
J: Payment status Paid, Pending, or Canceled Paid
K: Reimbursement status Not needed, Owed, or Reimbursed Owed
L: Receipt link Link to the receipt, invoice, or contract Shared folder link
M: Notes Terms, split details, or follow-up Final balance due later

Use a new row for every deposit, installment, and final balance. Do not combine an entire vendor contract into one row.

Format column G as currency. Format columns B and C as dates. Freeze the header with View > Freeze > 1 row so the labels stay visible while you scroll.

Use consistent category names, such as Venue, Catering, Photography, Flowers, Attire, Travel, and Rentals. Add dropdowns with Data > Data validation for categories and statuses. Consistent labels keep formulas from splitting one category into several spellings.

Save receipts in a shared folder, then paste each file link into column L. Keep the sheet boring. Boring is good.

Keep budget assumptions on a separate tab

Add a tab named Setup. Put the planned budget there instead of mixing it into the expense ledger.

A1: Total budget       B1: 25000
A4: Contributor        B4: Share %
A5: Contributor 1      B5: 25%
A6: Contributor 2      B6: 25%
A7: Contributor 3      B7: 25%
A8: Contributor 4      B8: 25%

The contributor rows are only an example. Use them when several people are sharing costs, and replace the sample percentages with the arrangement your group accepts. If one person or household is covering the wedding, you can skip this section.

A budget number needs a definition. In the formulas below, "remaining budget" means the planned budget minus payments marked Paid. Pending items stay visible but do not reduce that cash-used figure.

Add formulas that answer useful questions

Create a third tab named Summary. Put labels in column A and formulas in column B. These formulas use the column layout above.

Question Formula
How much has been entered? =SUM(Expenses!G2:G)
How much has been paid? =SUMIF(Expenses!J2:J,"Paid",Expenses!G2:G)
How much is still pending? =SUMIF(Expenses!J2:J,"Pending",Expenses!G2:G)
What remains from the cash-used budget? =Setup!B1-SUMIF(Expenses!J2:J,"Paid",Expenses!G2:G)
How many payments are pending? =COUNTIF(Expenses!J2:J,"Pending")

To summarize paid spending by category, list category names in Summary!A10:A and enter this formula in B10:

=SUMIFS(Expenses!G2:G,Expenses!F2:F,A10,Expenses!J2:J,"Paid")

Copy it down beside each category. A category with no paid expenses returns zero.

You can also create a category summary that expands automatically:

=QUERY(Expenses!A1:M,"select F, sum(G) where J = 'Paid' and F is not null group by F label F 'Category', sum(G) 'Paid total'",1)

Leave the cells below and beside this formula empty. The result needs room to expand.

For a review list of larger items, use a threshold that fits your group:

=IFNA(FILTER(Expenses!A2:M,Expenses!G2:G>100),"No expense is above the review threshold")

The $100 threshold is only an example. Change it to an amount that deserves a second look in your wedding budget.

Calculate uneven contributions with a Shares tab

A ledger records the payer. It does not decide fairness.

Thing is, equal splits are just one option. Your group might have one family covering the venue, friends sharing travel, or contributors using agreed percentages. Write the rule down before collecting reimbursements.

Add a tab named Shares when multiple people are responsible for the same paid expense. Use these columns:

A: Expense ID
B: Contributor
C: Share %
D: Assigned share
E: Settlement status
F: Confirmation link

For each paid expense, create one row per contributor. A $1,200 expense divided equally among four contributors would have four rows at 25% each. Enter 25%, not 25, in the share column.

In D2, enter:

=SUMIFS(Expenses!G:G,Expenses!A:A,A2,Expenses!J:J,"Paid")*C2

Copy the formula down. It finds the paid amount for the matching Expense ID and multiplies it by that contributor's percentage.

Check each Expense ID before requesting money. Next to an ID listed in G2, use:

=SUMIF(Shares!A:A,G2,Shares!C:C)

A fully allocated expense should total 100%. If it does not, correct the percentages before sending a request.

On Summary, list each contributor in column A. Then compare paid amounts with assigned shares:

B2: =SUMIFS(Expenses!G:G,Expenses!H:H,A2,Expenses!J:J,"Paid")
C2: =SUMIF(Shares!B:B,A2,Shares!D:D)
D2: =B2-C2

Column B shows what that person paid to vendors. Column C shows their assigned portion. A positive number in column D means they paid more than their assigned portion before settlement; a negative number means their assigned portion exceeds their recorded payments.

This is a starting point for settlement, not an automatic payment request. Mark the Settlement status and add a confirmation link after money changes hands.

Share access without losing control

To be honest, not everyone who needs to see the budget needs edit access.

  1. Click Share and add named email addresses. Use Editor for people entering expenses, Commenter for people who need to ask questions, and Viewer for people who only need to read the totals.
  2. Avoid giving broad link-based edit access unless your group has agreed to it. Named access makes it easier to remove one person later.
  3. Protect the Summary formulas and budget cells through Data > Protect sheets and ranges. Leave the input rows on Expenses editable for the people responsible for updates.
  4. Review File > Version history > See version history if a formula or payment row changes unexpectedly.

If an account shows a setting that lets editors change permissions or share the file, turn it off when you want tighter control. On a phone, open the three-dot menu, choose Share and export, then choose Share.

For visual directions, this Google Sheets permissions guide covers access roles, and this protected ranges guide shows the range protection workflow.

Use a simple review routine

Update the sheet after each payment. Then review it before the next vendor deadline.

Review moment What to check
After a payment Add the row, receipt link, payer, amount, and payment status
Before a due date Sort by Due date and confirm the amount and responsible payer
During a group review Check pending items, category totals, and unusually large charges
After reimbursement Change the status and add the payment confirmation link

Keep payment methods separate from the record. A check, cash transfer, or payment app can move the money, but the spreadsheet should show the request, amount, date, and proof.

A clear request might read:

Please check W-014 in the sheet. Your assigned share is $300, and I paid the vendor on Jan 15. Please use our agreed payment method and mark the Shares row after sending it.

The review cadence should match the payment schedule. A quiet month may need one check before the next due date. A cluster of deposits needs closer attention.

Fix common spreadsheet mistakes early

  • One row covers an entire vendor contract: Split the deposit, installments, and final balance into separate rows.
  • The same person appears under different names: Use a dropdown or copy the approved name exactly.
  • Pending costs reduce the paid budget: Keep the remaining-budget formula tied to Paid unless you intentionally want a committed-cost view.
  • Paid and reimbursed mean the same thing: Keep vendor payment status and reimbursement status in separate columns.
  • A formula gets overwritten: Protect the Summary and Setup ranges.
  • A shared link gives too much access: Use named email access and the narrowest useful role.
  • A reimbursement has no proof: Add a confirmation link before marking the row Reimbursed.

If a formula returns #REF!, check the tab names and column ranges first. If a filtered list has no matches, wrap it in IFNA and show a plain message instead of leaving an error on the Summary tab.

FAQ

Is a separate Shares tab necessary?

No. A simple ledger can be enough when one person pays and the group handles reimbursements informally. Add Shares when costs are uneven, several households contribute, or you need a visible record of each person's portion.

Should pending expenses reduce the remaining budget?

Only if you define remaining budget as planned or committed spending. The example formula subtracts paid rows, so it answers a cash-used question. If you want pending commitments included, use a separate summary formula and label it clearly.

Can families cover different wedding categories?

Yes. Record the actual payer in Expenses, then assign the agreed contributor percentages in Shares. Write unusual arrangements in Notes, such as one family covering the venue while friends share travel.

Does the spreadsheet send reimbursement payments?

No. It tracks amounts, payers, allocations, statuses, and proof. Use the payment method your group already accepts, and keep the transaction record in the sheet.

How many people should have edit access?

Give edit access to the people who actually enter or approve rows. Others can receive comment or view access. A smaller editing group usually makes accidental formula changes easier to identify.

Create the Expenses, Setup, and Summary tabs first. Add Shares if the wedding costs are divided among contributors, then enter one paid deposit and one pending item to test the formulas. Check the totals, protect the formula cells, remove the test rows, and invite named editors only after the workbook behaves as expected.