Use a Google Sheets template with a "Split %" column and income-ratio formula, like =(Total Amount / Total Income) * Person 1 Income for Person 1 Share (example from jakelee.co.uk), to calculate shares automatically. Track Apple Cash reimbursements in a separate column. This workflow separates tracking in spreadsheets from U.S.-only payments via Apple Cash, helping roommates, couples, or friends with uneven incomes split bills like rent or groceries fairly.
For example, with total income of $100 (Person 1: $60, Person 2: $40) and a $500 bill, Person 1's share is $300. Log the Apple Cash transfer after sending, keeping clear records without relying on payment apps for calculations.
When a Spreadsheet + Apple Cash Workflow Fits Shared Expenses
Income-based splits work well for U.S. roommates splitting rent and utilities, couples managing joint budgets with uneven earnings, or small groups handling groceries and trips. Use this when one person earns significantly more and wants to contribute proportionally, rather than equally.
Consider these tradeoffs:
- Income-based: Fairer for uneven earnings, reflects ability to pay, but requires sharing income details and regular updates.
- Equal split: Simpler, no income disclosure, but feels unfair if incomes differ greatly.
- Usage-based: Best for variable costs like utilities, but adds tracking effort.
A spreadsheet handles calculations and history; Apple Cash covers quick reimbursements for U.S. residents. Skip apps if your group prefers free tools and basic recordkeeping. This fits small informal groups like roommates or travel buddies, where trust exists but documentation prevents disputes.
Set Up the Income-Based Bill Split Calculator in Google Sheets
Start with a new Google Sheet. Add these recommended columns in Row 1:
| Column | Purpose | Example |
|---|---|---|
| A: Date | When expense occurred | 2026-01-15 |
| B: Expense Description | What was bought (link receipt) | Rent - Jan |
| C: Total Amount | Full bill | 500 |
| D: Person 1 Income | Monthly/period income | 60 |
| E: Person 2 Income | Monthly/period income | 40 |
| F: Total Income | =D2+E2 (drag down) | 100 |
| G: Split % for Person 1 | =D2/F2 (format as %) | 60% |
| H: Person 1 Share | =(C2/F2)*D2 | 300 |
| I: Person 2 Share | =(C2/F2)*E2 | 200 |
| J: Paid By | Who fronted the cost | Person 1 |
| K: Reimbursed Via Apple Cash? | Yes/No with date | Yes, 2026-01-16 |
Copy formulas down for new rows. For more people, add columns and adjust Total Income as =SUM(D2:F2).
Share via link: Choose "Editor" for collaborators or "Viewer" for read-only. Protect formula columns (right-click > Protect range) to avoid edits. Add a "Split %" column next to expenses for automatic shares.
Calculate Shares Proportional to Income
Enter incomes in columns D and E for the period (e.g., monthly). Total Income auto-sums. Person 1 Share uses the formula =(Total Amount / Total Income) * Person 1 Income, as an example from jakelee.co.uk.
Example: $500 rent, Person 1 income $60 of $100 total. Split % is 60%, so share is (500 / 100) * 60 = 300. Person 2 pays 200.
Common mistakes:
- Forgetting monthly income updates, leading to outdated shares.
- Unprotected formulas, causing accidental breaks.
- No receipt links in descriptions (use Google Drive hyperlinks).
- Vague categories like "misc" instead of "groceries - Costco".
Review bi-weekly: Check new bills, update incomes, confirm balances. Use conditional formatting (Format > Conditional formatting) to highlight unpaid shares in red.
Track Apple Cash Reimbursements in the Template
Keep tracking separate from payments. After calculating shares:
- Front the bill (e.g., Person 1 pays rent).
- Send reimbursement via Apple Cash in Wallet app (U.S. only).
- Log in sheet: Mark "Reimbursed Via Apple Cash?" as "Yes", add Date Sent in new column L, Amount Sent in M, and screenshot link in N.
Add a summary tab: Use =SUMIF(K:K,"No",H:H) for Person 1 outstanding balance.
Workflow: Calculate → Send → Log. Export sheet monthly (File > Download > PDF) for records. This creates an audit trail of IOUs without depending on Apple Cash notifications.
Apple Cash Setup and U.S. Limits for Group Reimbursements
Apple Cash requires U.S. residency and age 18+; those under 18 can participate via Apple Cash Family if invited by the organizer, per Apple Support.
Apple Cash Family accounts have a $2000 rolling seven-day send/receive limit, same as Tap to Cash.
For Family Sharing (iOS 18+): Organizer goes to Settings > [name] > Family to invite members. Under-18 participants need the organizer to set up their Apple Cash account, from Apple's Family page.
Use for reimbursements like "Rent share - $200". Not for tracking - rely on the sheet.
Sharing the Template, Permissions, and Common Mistakes
Share the sheet link with "Editor" for group input or "Commenter" for feedback. Protect ranges for formulas (Data > Protect sheets and ranges). Set notification rules (Tools > Notification rules) for changes.
Monthly cadence: Review incomes together, add bills, clear balances. Backup via File > Version history.
Common mistakes:
- No backups - enable Version history.
- Vague descriptions, complicating disputes.
- Ignoring Apple Cash limits mid-month, delaying reimbursements.
- Over-sharing incomes without agreement.
- Blurring tracking and payments, losing records if app changes.
Test with a small bill first.
FAQ
How do I set up Family Sharing for Apple Cash reimbursements?
Organizer invites via Settings > [name] > Family on iPhone/iPad with iOS 18+, per Apple Support.
What are the exact Apple Cash sending limits for shared expenses?
Apple Cash Family allows up to $2000 send/receive in a rolling seven-day period, from Apple Support.
Can minors use Apple Cash for group bill splits?
Under 18 can via Apple Cash Family if the organizer sets up their account and invites them.
Why use income-based splits over equal splits in the template?
Income-based reflects earning differences for fairness; equal is simpler but ignores disparities.
How often should I update incomes in the Google Sheets calculator?
Monthly or per pay period to keep shares accurate; review bi-weekly for bills.
Is Apple Cash available outside the U.S. for tracking reimbursements?
No, Apple Cash is U.S.-only.
Next, duplicate this template, input your first bill, and test an Apple Cash transfer. Check Apple's site for 2026 updates and discuss income-sharing rules with your group upfront.