PTA groups can set up a free Google Sheets spreadsheet to track shared expenses like field trips, supplies, or events. Start with core columns for date, description, amount, category, paid by, split details, and balances. Add simple formulas for totals, then share with edit access for officers and view-only for members. This works for U.S. PTA volunteers managing informal group funds without apps.

This approach suits small PTAs handling occasional costs. Enter expenses as they occur, calculate shares, and review balances for reimbursements. For example, track who paid for classroom supplies and divide costs equally among participating families.

Core Columns for PTA Shared Expense Tracking

Recommended columns draw from editorial examples adapted for group use. Start with these in Row 1:

  • Date: When the expense happened (e.g., 2026-03-15).
  • Description: Item details (e.g., "Field trip bus rental").
  • Amount: Total cost (e.g., $250).
  • Category: Type like "Field Trip", "Supplies", or "Fundraiser".
  • Paid By: Name or initial of the payer (e.g., "Treasurer J. Smith").
  • # People: Number sharing the cost (e.g., 20 families).
  • Split Type: "Equal" or "Proportional" (e.g., equal for events, proportional for optional items).
  • Split %: Proportion per payer or family if uneven (e.g., 100% for full payer, or custom per Expensesorted blog on family budgets).
  • Individual Share: Formula-calculated amount per person (e.g., =Amount / # People for equal splits).
  • Running Balance: Tracks who owes or is owed (positive for credits, negative for owes).
  • Receipt Link: Google Drive or URL to scanned receipt for records.

These support equal splits (same share for all) or proportional ones (based on family size or involvement). For PTA events, equal often fits fundraisers; proportional works for trips where not all join. Add a "Notes" column for rules like "Only attending families split bus cost."

Setup Steps to Build Your PTA Spreadsheet

Follow these steps for a new sheet:

  1. Go to sheets.google.com and select Blank.
  2. In Row 1, enter headers: Date, Description, Amount, Category, Paid By, # People, Split Type, Split %, Individual Share, Running Balance, Receipt Link, Notes.
  3. Format columns: Date as date type (Format > Number > Date); Amount, Share, Balance as currency (Format > Number > Currency).
  4. Add sample data in Row 2: Date 2026-03-15, Description "Art supplies", Amount $150, Category "Supplies", Paid By "Volunteer A", # People 15, Split Type "Equal".
  5. In Individual Share (Column I, Row 2): Enter =IF(G2="Equal", C2/F2, C2*H2) for equal or %-based.
  6. For Running Balance (Column J): Use =J1 + (H2 * C2) - C2 to track payer credits.
  7. Freeze Row 1 (View > Freeze > 1 row) for easy scrolling.
  8. Share: Click Share button, add treasurer emails as Editors, generate link for members as Viewers.

Test with 3-5 rows. This creates a basic tracker for reimbursements via check or cash at meetings.

Add Formulas for Automatic Calculations and Summaries

Use these low-confidence editorial examples, adapted for PTA from Relayfi's Google Sheets expense tracker guide. Validate in 2026 as formulas may change.

  • Category total (in a Summary sheet or cell A1:B10): =SUMIFS(C:C, D:D, "Field Trip") sums Field Trip costs.
  • Multi-criteria sum (e.g., supplies paid by one person): =SUMIFS(C2:C100, D2:D100, "Supplies", E2:E100, "Volunteer A").
  • Grouped summary (QUERY in new sheet A1): =QUERY(Expenses!A:J, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'") lists totals per category.
  • High expenses filter (new sheet A1): =FILTER(A2:J100, C2:C100>100) shows rows over $100.
  • Budget check (conditional formatting on Amount column): Custom formula =AND(C2>=100, C2<=200) highlights moderate spends (adapt ranges).

For Split % shares, per Expensesorted, multiply Amount by Split % in a helper column. Place formulas in a "Summary" tab (Insert > Sheet). Copy-paste values for static reports.

Sharing, Updates, and Common Mistakes

Share via link: Editors for officers to add expenses; Viewers for parents to check balances. Disable "Anyone with link can edit" for security.

Expensesorted suggests a 10-minute weekly check-in, like Sunday evenings, to enter receipts and confirm balances. PTA officers might review before meetings.

Common mistakes:

  • No receipt links, risking disputes.
  • Unclear split rules (define upfront: "Equal unless noted").
  • Inconsistent updates, leading to errors.
  • Forgetting backups (File > Version history or Drive folder).
  • Over-editing by viewers (use Viewer mode).

Set ground rules in a top note: "Updates by officers only; disputes to treasurer."

When a Spreadsheet Works vs. When to Consider Apps

Use this decision tree for PTA needs:

  • Simple tracking/reimbursements only (e.g., monthly supplies, 10-50 families)? Spreadsheet suffices - manual entry, free, full control.
  • Frequent events with cash/check reimbursements? Spreadsheet for records; pair with in-person settlements.
  • Need payments or receipt scans? Consider apps for automation, but spreadsheets for final records.

If yes to payments: Apps handle requests/splits; export to sheet for archives. Tradeoffs: Spreadsheets mean manual work but no fees/limits; apps add convenience but potential costs. For informal PTAs, start with sheets - upgrade if volume grows.

FAQ

How do I handle uneven splits for PTA families (e.g., income-based)?
Use Split % column: Assign % by family size or voluntary contribution. Formula: Individual Share = Amount * (Family % / 100). Document rules in Notes.

What's the best way to attach receipts in Google Sheets?
Add Receipt Link column with Drive URLs. Upload scans to a shared Drive folder first.

How often should our PTA review the spreadsheet?
Expensesorted recommends 10-minute weekly check-ins to update and adjust.

Can we use this for tax records (PTA 501(c)(3))?
Keep receipts and exports as internal records. Check IRS guidance for 501(c)(3) rules, as PTA status varies.

What if someone disputes a balance?
Review receipts together; use Version history for changes. Define process upfront (e.g., majority vote).

Is Excel the same as Google Sheets for this?
Similar columns/formulas, but Excel lacks real-time sharing. Use OneDrive for group access.

Next, create your sheet and test with past expenses. Define split rules at the next PTA meeting for smooth use.