How to Make an IOU Tracker in Airtable: Template Guide for Shared Expenses

✨ Community Finance

Published: May 2, 2026

Create an IOU tracker in Airtable by setting up a base with tables for Expenses and People, using formula fields for amounts owed and date calculations, then share via read-only interface. This works well for U.S. groups like roommates splitting utilities, travel friends tracking gas and meals, or families logging uneven contributions to events.

Start with a new base. Add a People table for group members (columns: Name, Email). Create an Expenses table (columns: Date, Description, Amount, Paid By linked to People, Split Among as linked or multi-select to People, Notes). Use formulas like DATETIME_DIFF({Date}, TODAY(), 'days') to show days outstanding, per Airtable's formula field reference.

For balances, link expenses to people and sum owed amounts manually or via rollups. Share through Interfaces for group views without edit risks. Airtable handles tracking, not payments - export data for separate reimbursement via bank apps.

When to Use an Airtable IOU Tracker vs a Spreadsheet

Airtable suits groups needing relational data, like linking one expense to multiple people for splits. It offers Interfaces for clean, app-like views of balances and history.

Google Sheets or Excel often suffice for simple or static groups. Enter expenses in rows, use SUMIF formulas for per-person totals, and share links for comments. No setup for linked tables needed.

Consider your group's activity. For low-activity groups with under 10 expenses a month, a spreadsheet avoids Airtable's learning curve. Frequent updates, multiple linked people per expense, or mobile-friendly interfaces? Airtable fits better. Test a spreadsheet first if your needs stay basic - add columns for Date, Description, Amount, Paid By, and formulas like =SUMIF(PaidByRange, "Person Name", AmountRange) for owed totals.

Switch to Airtable if linking grows complex, like tracking who splits what across roommate rent, utilities, and groceries.

Base Setup Steps for IOU Tracking

Log into Airtable and create a new base named "Group IOU Tracker."

First, build the People table:

Name (single line text, primary field)
Email (email)

Next, add the Expenses table:

Date (date)
Description (long text)
Amount (currency or number)
Paid By (link to People table, allow linking to multiple if one person covers multiples)
Split Among (link to People, allow multiple for even splits)
Notes (long text)

Enter sample data. For a $200 grocery run paid by Alex, split among Alex, Jordan, and Taylor: set Paid By to Alex, Split Among to all three.

Add a formula field in Expenses for Days Outstanding: DATETIME_DIFF({Date}, TODAY(), 'days'). Negative values show future dates; positive track aging.

For basic owed calculations, add a Rollup field in People table. Link from Expenses via "Paid By" or "Split Among," then use SUM(values) divided by split count. Manually note shares until comfortable with views.

Common setup: Group view by Paid By, or calendar by Date for timelines.

Key Formulas for IOU Calculations

Airtable formulas handle date and math basics for IOUs. Use DATETIME_DIFF({Date}, TODAY(), 'days') to flag overdue items, like >30 days for reminders.

Format dates for reports: DATETIME_FORMAT({Date}, 'MM/DD/YYYY'). Parse inputs if needed: DATETIME_PARSE({Description notes}, 'MM/DD/YYYY') for mixed text.

Sum totals with SUM(values) in rollups. Example: In People table, rollup Amount from Expenses where linked as Split Among, then formula {Rolled Amount} / RECORD_COUNT(values) for per-person share.

For aging IOUs, add a formula in Expenses: IF(DATETIME_DIFF({Date}, TODAY(), 'days') > 30, "Overdue", "Current"). Filter views by this.

Running balances challenge users, per Airtable Community forums. Circular references block simple formulas like prior balance plus new amount. Workarounds include lookup fields to prior records or automations to copy values - no guaranteed formula exists without scripts.

Stick to rollups and views for totals owed to/from each person.

Sharing Your IOU Tracker with a Group

Share via Interfaces for read-only access, per Airtable's interface sharing docs. Create an Interface from your base: add Record List or Grid, filter to show balances.

Public Interfaces block updates or deletes. Up to 5,000 collaborators; access requests limited to every 12 hours.

Set base permissions: Owner controls edits; add collaborators with comment-only if needed. Share the Interface link - group views balances without altering data.

Mistake to avoid: Full edit access risks accidental deletes. For payments, export to CSV (File > Download CSV) and settle via apps like Venmo separately.

Weekly reviews keep records current: One person updates expenses, group checks Interfaces.

Common Mistakes and Limitations

Circular formulas fail for running balances - Airtable blocks them to prevent errors, as noted in Airtable Community discussions. Use rollups or manual summaries instead.

Interfaces limit actions like edits; no built-in payments or auto-settlements. Manual entry required for receipts - snap photos in Notes.

Over-sharing edit rights leads to disputes. Set review cadence: Weekly for active roommate or trip groups.

For simple needs, spreadsheets avoid these. Airtable shines for relations but adds setup time.

FAQ

How do I calculate days an IOU has been outstanding?

Use DATETIME_DIFF({Date}, TODAY(), 'days') in a formula field. Positive numbers show age; filter views for >30 days.

Can I make a running balance column for each person's total owed?

Not easily with formulas due to circular reference limits, per Airtable Community forums. Use rollups for totals owed/received, or automations for updates.