Use a Google Sheets template with columns for group member names, expense splits, and a "Settling Up" tab to track IOUs. Cross-reference with Cash App CSV or PDF transaction exports for payment proof. This workflow fits U.S. roommates splitting utilities or groceries, travel groups handling trip reimbursements, or friends covering event costs like dinners or gifts.

No paid apps needed. Enter expenses once, apply split rules like equal shares or reimbursements, and use formulas to calculate who owes whom. Export Cash App history monthly to match payments against balances. Real-time editing lets everyone update live, as noted in expensesorted.com guidance on roommate templates.

When a Sheets + Cash App Workflow Fits Shared IOUs

This setup works for occasional shared expenses where groups want free tracking without app subscriptions. Roommates can log rent, utilities, or grocery runs with uneven splits by room size or usage. Travel groups track vacation rentals, gas, or meals, marking reimbursements after one person fronts costs. Friend events like parties or concerts fit too, tallying contributions toward deposits or totals.

Choose this for groups of 2-10 people with weekly or monthly reviews. It is free and customizable but requires manual exports from Cash App for proof. Apps offer auto-splitting, but Sheets handles custom rules like income-based shares better for informal setups. Cash works for tiny groups but lacks records. If expenses exceed low volume or need instant notifications, consider apps instead. For low-volume IOUs, this balances simplicity and detail.

Google Sheets Template Setup Steps

  1. Open Google Sheets and create a new blank spreadsheet. Name it "Group IOU Tracker - [Group Name]".

  2. Rename the first tab "Expenses". Add headers in row 1: A1=Date, B1=Description, C1=Total Amount, D1=Category, E1=Split Type, F1=Notes.

  3. In row 7, starting at G7, enter group member names (e.g., G7=Alice, H7=Bob, I7=Charlie). Below each (rows 8+), enter split percentages for that expense (e.g., 33% each for equal split).

  4. Add a second tab named "Settling Up". This will sum balances using formulas.

  5. Set sharing: Click Share > "Anyone with the link" > Editor. This enables real-time collaboration where updates appear live for all, per expensesorted.com.

  6. Test with sample data: Enter a $60 grocery expense dated today, category "Groceries", split type "Equal", 33% under each name.

Common mistakes include wrong permissions (view-only blocks edits) or over-editing during reviews. Use "Anyone with link can edit" cautiously; add a "Last Updated" cell for accountability.

Key Columns and Split Rules for IOUs

Structure columns for clear IOU tracking. Date (A) uses MM/DD/YYYY. Description (B) notes details like "Utilities - Feb electric". Total Amount (C) is the full cost. Category (D) tags "Rent", "Groceries", "Travel". Split Type (E) specifies "Equal", "Reimbursement", or "Usage" (e.g., room size).

For names in row 7 column G+, enter percentages per expense row. For "Reimbursement", set one person at 100% (the payer) and others at 0%, as shown in cheatsheets.blog template. Uneven splits: 50/30/20 for income differences, or nights-stayed for shared rentals (e.g., 40% for 4 nights out of 10).

Update weekly: One person adds expenses, group reviews splits. Monthly, check "Settling Up" for balances. Store receipt photos in a shared Google Drive folder, linked in Notes (F).

Formulas to Tally Balances and Filter Expenses

Use these formulas as examples to automate IOUs. Test on sample data first. Formulas from editorial sources like relayfi.com and cheatsheets.blog.

In "Expenses" tab:

  • Category totals: =QUERY(A2:D100, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'"). Place in a summary area to group spend by category (relayfi.com).

  • High amounts: =FILTER(A2:D100, C2:C100>100) shows rows over $100 (relayfi.com).

  • Conditional totals: =SUMIFS(C2:C100, D2:D100, "Travel", F2:F100, "Yes") sums travel with a flag (relayfi.com).

In "Settling Up" tab (cheatsheets.blog style):

  • Row 1 headers: A1=Name, B1=Owes (positive), C1=Owed (negative), D1=Balance.

  • Pull names from Expenses!G7+ via =Expenses!G7. For balances, adapt formulas like =SUMPRODUCT((Expenses!G8:G100), Expenses!C$8:C$100) times shares by totals, with adjustments for owes vs owed per name.

Copy for each name. Positive balance means others owe that person; negative means they owe. Filter views for unsettled balances.

Integrating Cash App Transaction History for Records

Cash App does not split or track IOUs natively. Use it for payments, then verify against Sheets (digitalcitizen.life).

Export steps: Open Cash App > Activity tab > Select date range > Export as CSV or PDF. Match transaction dates/amounts to Sheets Description/Amount.

Workflow: Log expense in Sheets > Pay via Cash App > Export history monthly > Paste relevant rows into a "Payments" tab or note status in Expenses Notes (e.g., "Paid 3/15").

Troubleshooting: If history missing, check slow internet, app updates, or login (digitalcitizen.life). Re-download or filter by sender. No real-time sync; manual match needed. Sheets alone suffices for tracking; exports add proof for disputes.

Limitations: Exports viewable in-app but no auto-import to Sheets. For groups, designate one exporter.

Common Mistakes and Sharing Best Practices

Avoid incomplete name columns (add all members in G7+). Untested formulas break on bad data - copy-paste sample rows first. Edit conflicts arise in real-time; use comments for questions (expensesorted.com).

Missing Cash App statuses lead to double-counts; always note "Paid" post-export. Set review cadence: Weekly adds, monthly "Settling Up" check. Use boundaries: Agree on split rules upfront, photo receipts in Drive, not app.

For safety, "Anyone with link can edit" works for trusted groups but switch to "Commenter" for larger ones.

FAQ

How do I handle reimbursements in the template?
Mark Split Type "Reimbursement", set payer at 100%, others 0% (cheatsheets.blog). "Settling Up" shows owed amount.

What if Cash App history is missing payments?
Check internet, app version, login (digitalcitizen.life). Request sender resend or screenshot.

Can this track tax-related shared expenses?
Use category filters (relayfi.com), but check IRS guidance for your situation; not advice.

Is real-time editing safe for groups?
Yes for small trusted groups with edit links (expensesorted.com); use comments to avoid overwrites.

When should I upgrade beyond Sheets + Cash App?
If over low-volume expenses, need auto-payments, or larger groups; consider split-bill apps.

How often to review the "Settling Up" tab?
Weekly for adds, monthly for settles and Cash App exports.

Next, build your template with 3-5 sample expenses. Share the link, agree on rules, and export Cash App history after first payments.