Use Google Sheets to create a free receipt tracker with a category column for shared expenses. Start with columns for Date, Receipt Description, Amount, Category (with dropdown), Paid By, Split Type, and Notes. Add data validation for consistent categories like Rent, Groceries, or Travel. Use formulas such as =SUMIF for category totals, as shown in expensesorted.com guidance.

This setup suits U.S. groups like roommates tracking utilities, travel groups logging meals and gas, or families splitting groceries. It keeps receipt records organized for reimbursements or reviews without needing apps. Enter receipts manually from photos or scans, assign categories, and summarize totals to settle IOUs fairly.

Recommended Columns for Shared Receipt Tracker

For shared expenses, a clear column structure prevents confusion in groups like roommates or trip planners. Core columns include:

  • Date: When the expense happened (e.g., MM/DD/YYYY).
  • Receipt Description: Item or vendor from the receipt (e.g., "Safeway groceries" or "Uber to airport").
  • Amount: Total cost in USD.
  • Category: Dropdown for grouping (e.g., Rent, Utilities, Groceries, Travel, Meals). This column enables quick summaries.
  • Paid By: Name or initial of who covered it (e.g., "Alex" or "Group Venmo").
  • Split Type: How to divide it (e.g., Equal, Per Person, Usage-Based).
  • Notes/Receipt Link: Photo upload link or details like "Receipt photo in shared drive".

These headers draw from expensesorted.com/blog/130_expense_tracker_google_sheets, adapted for group use. Add a second sheet named "Categories" listing options in column B (e.g., B2: Rent, B3: Groceries). This keeps data clean for roommate rent splits or vacation reimbursements.

Setup Steps for Category Column and Data Validation

Follow these steps to build the tracker:

  1. Open Google Sheets and create a new spreadsheet. Name the first sheet "Receipts" and add a second sheet "Categories".
  2. In "Categories" sheet, enter your group's expense types starting in B2 (e.g., B2: Rent, B3: Utilities, B4: Groceries, B5: Travel, B6: Meals).
  3. In "Receipts" sheet row 1, add headers: A1: Date, B1: Receipt Description, C1: Amount, D1: Category, E1: Paid By, F1: Split Type, G1: Notes/Receipt Link.
  4. Select the Category column (D2:D100 or full column D). Go to Data > Data validation. Criteria: List from a range. Enter =Categories!B2:B10. Check "Show dropdown list in cell" and save.
  5. Format Amount as currency (Format > Number > Currency). Add filters via Data > Create a filter for sorting by date or category.

These steps, shown in expensesorted.com/blog/68_how_to_create_expense_tracker_google_sheets, ensure consistent entries. For shared use, click Share button, add emails, and set to Editor for active input or Viewer for records only.

Test with sample data: Enter a roommate utility bill (Date: 01/15/2026, Description: "PG&E bill", Amount: 150, Category: Utilities, Paid By: Jordan).

Formulas for Category Totals and Summaries

Formulas automate summaries for group reviews, like totaling Groceries before settling trip IOUs.

  • SUMIF for single category total: In a summary section (e.g., Receipts!I2 for Groceries total), use =SUMIF(D:D, "Groceries", C:C). This sums Amount (C) where Category (D) matches "Groceries". From expensesorted.com.
  • QUERY for full category summary: In a new sheet "Summary", cell A1: =QUERY(Receipts!A:G, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'", 1). Groups by category with totals, per relayfi.com/blog/google-sheets-expense-tracker-template.
  • FILTER for high amounts: =FILTER(Receipts!A:G, Receipts!C:C>100) shows rows over $100, useful for reviewing large shared costs like deposits.
  • SUMIFS for multi-conditions: =SUMIFS(Receipts!C:C, Receipts!D:D, "Travel", Receipts!E:E, "Alex") totals Alex's Travel expenses.

Paste these in empty cells; adjust ranges like A2:G100 for your data. For group travel, filter Meals to check per-person splits. Editorial sources like relayfi.com note these work in Google Sheets but test for your setup.

Sharing, Update Cadence, and Common Mistakes

Share via the green Share button: Use "Editor" for roommates adding receipts weekly, or "Viewer" for passive group members. Avoid commenting access alone for active groups.

Update cadence: Weekly for active shared expenses (e.g., review after grocery runs); monthly for low-volume like rent. Set Google Calendar reminders: "Review receipts - settle utilities".

Common mistakes:

  • No backups: Download as Excel monthly (File > Download).
  • Unprotected edits: Use protected ranges (Data > Protect sheets and ranges) for formulas.
  • Missing receipts: Always link photos in Notes; store in shared Google Drive folder.
  • Category inconsistencies: Stick to dropdown; avoid free-text like "Food" vs "Groceries".
  • Overlooking splits: Note Split Type to calculate reimbursements later (e.g., =C2/4 for equal split among 4).

These pitfalls lead to disputes in roommate or travel groups.

When a Spreadsheet Works vs. When to Consider Apps

A Google Sheets tracker fits simple U.S. groups with under a few dozen transactions monthly, like roommates logging utilities or friends tracking dinners. It handles manual receipt entry, category grouping, and basic summaries without costs. Pair with a shared Drive folder for photos.

Consider apps if needs grow: receipt scanning for frequent trips, auto-payments for reimbursements, or notifications for larger committees. Spreadsheets stay lightweight for records; apps add workflow layers. Decide based on group size and complexity - start here, scale if manual entry slows.

FAQ

How do I add a dropdown for the category column in Google Sheets?
Select the column, go to Data > Data validation, set criteria to list from Categories!B2:B10. Shown in expensesorted.com.

What formula sums expenses in one category like "Groceries"?
=SUMIF(D:D, "Groceries", C:C) totals the Amount column for that category. From expensesorted.com.

How should I share the tracker with roommates without edit risks?
Use Viewer for read-only access or protect formula ranges; Editor for trusted groups.

Can I track who paid for shared receipts?
Yes, add "Paid By" column and use SUMIFS like =SUMIFS(C:C, E:E, "Alex", D:D, "Groceries").

What if we need currency conversion for group travel?
Use =GOOGLEFINANCE("CURRENCY:EURUSD") for rates, shown in johnnyafrica.com examples; enter converted amounts manually.

Is this setup good for tax records on shared expenses?
It organizes receipts by category for personal review; consult IRS guidance or a tax professional for shared expense rules, as setups vary by situation.

Next, create your sheet, add 2-3 test receipts, share a view-only link, and review totals. Adjust categories to match your group's shared costs.