How to Set Up a Payment Reminder System for Small Teams

✨ Community Finance

Published: May 5, 2026

Small teams can set up a payment reminder system using a shared Google Sheets tracker with summary formulas, filters for overdue items, and basic scripts for date-based email alerts. Share via email collaborators for real-time updates. This approach helps U.S. roommates, travel groups, clubs, or committees prompt reimbursements on split bills like rent, utilities, trips, or events without paid apps.

Start with a simple sheet for expense records. Add formulas from Relay.fi's Google Sheets expense tracker guide to flag high amounts or overdue payments. Use scripts outlined in Medium's automation tutorial for email nudges when due dates pass.

Build a Shared Google Sheets Tracker for Expense Records

Set up a Google Sheets tracker as the foundation for reminders. Use these practical columns: Date, Description, Amount, Paid By, Owed By, Status (e.g., Pending, Paid), Due Date.

For example:

Date	Description	Amount	Paid By	Owed By	Status	Due Date
2026-01-15	Utilities	$120	Alice	Bob, Carol	Pending	2026-02-01
2026-01-20	Groceries	$45	Bob	Alice, Carol	Paid	2026-02-05

This structure supports equal splits, per-person shares, or usage-based prompts. Update weekly during team check-ins to keep records current. For small teams under 5 people, weekly cadence works well; larger groups may need bi-weekly scans.

Share the sheet via the Share tab and add team email addresses as editors, as noted in Corrie Haffly's roommate expense post. Google Sheets supports real-time collaboration where editors see live changes, according to ExpenseSorted's guide.

Set permissions to "Editor" for all to allow updates. Avoid "Viewer" only, as it blocks status changes needed for reminders. Common mistake: forgetting to notify collaborators via email after sharing.

Add Formulas to Flag and Summarize Overdue Payments

Formulas help spot issues manually before sending reminders. Place them in a "Summary" tab.

Use =FILTER(A2:D100, B2:B100>100) to display rows where Amount exceeds $100 (adjust ranges to your data), per Relay.fi. This flags big expenses like trip deposits needing quick reimbursement.

For category totals, try =QUERY(A2:D100, "SELECT C, SUM(D) GROUP BY C LABEL SUM(D) 'Total'") to group and sum by Description column.

Conditional sums work with =SUMIFS(B2:B100, D2:D100, "Travel", F2:F100, "Yes") for totals matching criteria like category and status.

Flag overdue items in a Status column with =IF(TODAY()>G2, "Overdue", Status). For budget checks, adapt Relay.fi's =AND(C2>=B2*0.8, C2<=B2) to highlight when spending nears limits (e.g., replace with Amount and group total ranges).

These tie to split fairness. For equal splits, sum Owed By equally. For usage-based (e.g., more nights stayed), add a Usage column and adjust SUMIFS. Review filters weekly to prompt manual emails for high or overdue items.

Set Up Script-Based Email Reminders for Due Dates

For automation, add Google Apps Script for date-triggered emails. Go to Extensions > Apps Script.

Basic workflow, attributed to Medium: Write a script checking Due Date column. If TODAY() > due date and Status = "Pending", send email to Owed By with details.

Sample steps:

In Apps Script, use SpreadsheetApp.getActiveSpreadsheet() to access sheet.
Loop rows: if condition met, MailApp.sendEmail(recipient, "Payment Reminder", "You owe $"+amount+" for "+description+". Due: "+dueDate).
Set trigger: Time-driven, daily, to run check.

Test on a copy first. Limit to 5-10 recipients to avoid spam flags. For small teams, this cuts manual work but takes 30-60 minutes initial setup.

Decision tree for cadence:

Teams <5: Manual weekly review + script for critical dates.
Teams 5-10: Daily script runs. Tradeoffs: Scripts save time long-term but require basic coding comfort; manual checks suit low-volume groups with few expenses monthly.

Common mistakes: Not handling time zones in dates; forgetting to authorize script permissions.

Review Cadence and Documentation Basics

Maintain the system with a checklist:

Weekly: Scan filters for overdue/high amounts; update Status.
Monthly: Export receipts (link photos in Description column); review totals.
Per reminder: Note "Reminded on [date]" in a Notes column.

Receipt workflow: Upload photos to Google Drive, paste shareable links in cells. This supports reimbursements without apps.

Tradeoffs in splits for reminders:

Equal split: Simple prompts ("Everyone owes $X").
Usage-based: More columns/formulas, fairer for uneven use (e.g., room size).
Income-based: Add Income column, but discuss boundaries upfront to avoid disputes.

Sheets suffice for lightweight groups with <20 expenses/month. For frequent events, consider if manual nudges scale. U.S. informal records like this aid informal reimbursements; for disputes, consult professionals, as rules vary by state.

Next steps: Create your sheet, add 2-3 test rows, share with one teammate, and run a formula check.