Use a Google Sheets template with a linked Google Form for receipt entry, core columns for shared expense details, and formulas like SUMIFS or QUERY to summarize totals by category, payer, or date. This setup, drawn from finoptimal.com and relayfi.com guidance, helps U.S. groups splitting roommate bills, rent, utilities, groceries, travel costs, or event expenses by providing a free, editable receipt tracker without needing apps for basic recordkeeping.

Groups managing shared money with roommates, partners, friends, family, clubs, teams, or travel mates can log receipts in one place. Payers enter details via form to avoid edit conflicts. Formulas calculate who owes what, supporting equal splits, usage-based shares, or income-adjusted contributions. Export as PDF for records when settling up.

Core Columns for a Simple Receipt Tracker Template

Start with a new Google Sheet and set up these essential columns in row 1 for logging shared expenses. Tailor them to group needs like roommate utilities or trip meals, based on finoptimal.com template components.

  • A: Date - Entry date, formatted as MM/DD/YYYY.
  • B: Amount - Total cost in USD, e.g., 45.50.
  • C: Category - Rent, Utilities, Groceries, Gas, Meals, Flights, etc.
  • D: Payer - Name or initial of who paid, e.g., "Alex" or "J.S.".
  • E: Paid For - List of people or "All" for equal splits; use commas for uneven shares like "Alex, Jordan (50%)".
  • F: Receipt Proof - Link to Google Drive photo/upload or "Cash - noted".
  • G: Notes - Details like "Utilities for March" or "Split 2/3".

Example row for roommate utilities: 03/15/2026 | 120.00 | Utilities | Alex | All | [Drive link] | Electric bill, even split.

Add a second sheet named "Summary" for formulas. Freeze row 1 (View > Freeze > 1 row) for easy scrolling.

Set Up Data Entry with Google Forms

Link a Google Form to auto-populate the sheet, preventing edit overlaps in groups. Finoptimal.com describes this for capturing spending data via forms.

  1. In Google Sheets, go to Tools > Create a new form.
  2. Add questions matching columns: Date (date picker), Amount (short answer, number validated), Category (dropdown: Rent, Utilities, etc.), Payer (dropdown of group names), Paid For (short answer), Receipt Proof (file upload, links to Drive), Notes (paragraph).
  3. In form editor, click Responses > Select response destination > Select your sheet > New sheet named "Responses".
  4. Test: Submit a form entry. It populates Responses sheet starting row 2.
  5. Copy data to main sheet if needed, or reference Responses directly in formulas.

Group members get the form link via email or chat. They submit without accessing the sheet.

Add Summary Formulas for Shared Expense Insights

Use formulas on the Summary sheet to total expenses by category or payer. Adapt these from relayfi.com examples for shared groups.

For category totals: In A1 "Category", B1 "Total". In B2:
=QUERY(Responses!A:G, "SELECT C, SUM(B) GROUP BY C LABEL SUM(B) 'Total'")
This lists categories with sums, e.g., Groceries $250.

For payer totals:
=QUERY(Responses!A:G, "SELECT D, SUM(B) GROUP BY D LABEL SUM(B) 'Total'")
Shows what Alex paid: $450.

Filter large expenses over $100:
=FILTER(Responses!A:G, Responses!B:B>100)
Displays rows for review.

Sum utilities paid by Alex:
=SUMIFS(Responses!B:B, Responses!C:C, "Utilities", Responses!D:D, "Alex")

For recent data (last 30 days, adjust date):
=QUERY(Responses!A:G, "SELECT C, SUM(B) WHERE A >= date '2026-02-15' GROUP BY C ORDER BY SUM(B) DESC LABEL SUM(B) 'Total'")
From finoptimal.com for Responses sheet queries.

Add conditional formatting (Format > Conditional formatting): For amounts in Summary, yellow if over budget. Use relayfi.com rule: =AND(B2>=100, B2<=125) for a $125 utilities budget warning.

Share the Template with Your Group

Set permissions to allow group edits while protecting summaries. From Tiller Help Center:

  1. Click Share (upper right).
  2. Add group emails with Editor access.
  3. For view-only starters: Recipient clicks green "View only" button top-left to request edit access.
  4. Owner approves via notification or shares directly with their Google account email.

Protect formulas: Data > Protect sheets and ranges. Select Summary sheet, set "Restrict who can edit this range" to only you. Group edits Receipts/Responses but not summaries.

View-only lets opening and viewing but no edits or comments.

Common Mistakes and Fixes in Group Receipt Tracking

  • Permission issues: View-only blocks adds. Fix: Request via button or owner re-shares (Tiller Help).
  • Formula breakage: Form changes columns. Fix: Lock ranges before sharing; test post-updates.
  • Incomplete receipts: No proof link. Fix: Form requires upload; review weekly.
  • Edit conflicts: Multiple direct edits. Fix: Use form only.
  • Unprotected ranges: Accidental formula deletes. Fix: Protect Summary.

Review weekly: Compare payer totals to owed shares (e.g., equal split = total/participants). Export (File > Download > PDF) monthly. Backup via Version history.

When This Template Works vs. When to Use More

This suffices for small U.S. groups under 10 people with infrequent expenses like roommates splitting rent/utilities or trips with 5-8 friends. Manual entry tracks IOUs, reimbursements via Venmo/Zelle notes, and rules like "groceries 50/50".

Tradeoffs: No auto-payments or scans; group must submit promptly. For 10+ people, frequent events, or scanning needs, consider apps separating tracking from payments - but spreadsheets handle basics without fees.

Decision tree:

  • Low volume (<20 receipts/month), trust-based group? Use this.
  • High volume, disputes, or photos? Add Drive folder; if too much, explore receipt-scanning apps alongside.
  • Recurring only (rent)? Simple sheet without form.

Next: Create sheet, test form with sample data, share link.

FAQ

How do I request edit access if the sheet is view-only?
Click the green "View only" button top-left to request. Owner approves (Tiller Help Center).

What does a basic QUERY formula look like for category totals?
=QUERY(Responses!A:G, "SELECT C, SUM(B) GROUP BY C LABEL SUM(B) 'Total'") (relayfi.com).

Can I protect only the summary sheet while allowing receipt edits?
Yes, Data > Protect sheets and ranges > Select Summary > Restrict to owner (Tiller Help Center).

How often should our group review the tracker?
Weekly for active groups; monthly for low-volume like rent.

Is this template good for tracking tax-deductible group expenses?
It logs details for records; check IRS guidance for your U.S. situation, as deductibility varies.

What if someone forgets to add a receipt photo?
Form can require upload; follow up in group chat for cash notes.