Use a Google Sheets template with columns for each person's data usage, the total monthly bill, and formulas to calculate proportional shares. This divides costs fairly based on who uses more data, like a heavy streamer paying more than a light texter.

For U.S. roommates, partners, or small groups on a shared family or group phone plan, this approach works without apps. Enter carrier usage reports monthly, run the formulas, and each person sees their exact share. One group member pays the full bill, then collects reimbursements from others.

When a Usage-Based Phone Split Template Works Best

Usage-based splits suit groups with uneven data habits. A roommate who streams videos or works remotely might use 50 GB monthly, while another sticks to 2 GB of texts and calls. Equal splits ignore this, leading to resentment.

Consider these tradeoffs:

Split Type Best For Drawback
Equal (per person) Similar low usage across group Unfair to light users if one hogs data
Usage-based (data GB) High variance in data needs Requires monthly reports; ignores minutes/texts unless tracked
Income-based Partners with different earnings Needs salary proof; feels intrusive for friends
Flat fee + overage Predictable base + extras Complex if carrier changes plans

Start with a decision tree: Does usage vary by more than 2x? If yes, use usage-based. For 2-6 people with informal trust, a shared Google Sheet handles tracking. Larger groups or frequent disputes may need an app.

Recommended Columns for Your Phone Plan Split Sheet

Set up columns to capture raw data and compute shares. Adapt from editorial roommate expense trackers like those on Expensesorted.com.

Essential columns (row 1 headers):

  • Date: Month/year of bill (e.g., "2026-01").
  • User Name: Roommate or group member (e.g., "Alex", "Jordan").
  • Data Usage (GB): From carrier report.
  • Minutes Used: Optional, if plan charges separately.
  • Texts Sent: Optional.
  • Split Type: "Usage" or "Reimbursement" (mark full payer at 100%, others 0% per Expensesorted.com).
  • Total Plan Cost: Full bill amount (same for all rows that month).
  • Usage %: Formula: individual GB divided by group total GB.
  • Individual Share: Formula: Total Plan Cost times Usage %.
  • Paid?: Yes/No checkbox for tracking reimbursements.
  • Balance: Formula: Individual Share minus payments received.

Example row: "2026-01", "Alex", 20, 500, 1000, "Usage", $120, 40%, $48, Yes, $0.

Add tabs: "Raw Usage" for carrier paste, "Summary" for totals, "Balances" for running IOUs.

Setup Steps to Build and Populate the Template

Follow these steps for a working sheet.

  1. Create a new Google Sheet named "Phone Plan Splits - [Group Name]". Add tabs: Raw Usage, Summary, Balances.

  2. In Raw Usage tab, paste carrier usage report. Copy headers only for the first month. Break down by user as shown in cell phone analysis workflows on Medium. Most carriers email CSV or PDF reports with per-line data GB.

  3. In Summary tab, list users under columns from "Recommended Columns". Enter Total Plan Cost once (e.g., cell G2). Drag down for each user.

  4. Add formulas (detailed next section). Test with sample data: two users, 10 GB total, $100 bill.

  5. Share via link: Click Share > Get link > "Editor" for real-time access. Group members see live updates as in Expensesorted.com roommate templates.

  6. Monthly: After bill, import new report to Raw Usage, refresh Summary formulas, review Balances.

Key Formulas for Usage Proportions and Totals

Use these editorial formulas adapted for phone splits from Relayfi.com's Google Sheets expense tracker guide. Copy-paste into your sheet; adjust ranges.

  • Total Group Data (one cell, e.g., H1): =SUM(C2:C100) (sums Data Usage GB).

  • Usage % (per row, e.g., H2): =C2 / $H$1 (individual GB / group total; format as %). Drag down.

  • Individual Share (per row, e.g., I2): =G2 * H2 (total cost times %).

  • User Monthly Total (Summary tab): =SUMIFS(Summary!I:I, Summary!B:B, "Alex") (totals one user's shares; replace "Alex").

  • High Usage Filter (new tab): =FILTER(A2:I100, C2:C100 > 20) (shows rows over 20 GB).

  • Summary Query: =QUERY(Summary!A:I, "SELECT B, AVG(C), SUM(I) GROUP BY B LABEL AVG(C) 'Avg GB', SUM(I) 'Total Owe'") (per-user averages and totals).

These are editorial examples, not official Google advice. Test on a copy; errors show if ranges mismatch.

Sharing, Updates, and Common Mistakes

Share with "Editor" access for real-time collaboration, where changes appear live for all (Expensesorted.com). Use "Viewer" for disputes-only members. Set update cadence: First of each month, after carrier reports.

Common mistakes:

  • Mismatched headers on carrier import (e.g., "Data Used" vs "GB"); align manually.
  • Forgetting Split Type for reimbursements: One user "Reimbursement" at 100%, others 0%.
  • Over-editing during group sessions; use "Suggesting" mode or comments.
  • Ignoring non-data (minutes); add if plan bills them.
  • No backups: Download monthly as PDF/Excel.

For >10 people or complex needs, consider apps, but sheets suffice for small informal groups.

FAQ

How do I get usage data from my carrier?
Log into your account or check email for monthly PDF/CSV reports. Most break down data by line/user.

What's the difference between usage split and equal split for phones?
Usage pays by GB consumed (fair for variance); equal divides total evenly (simpler but ignores heavy users).

Can I use this for family plans with minors?
Yes, for tracking; get parental usage reports. Not for formal contracts.

How often should we review balances?
Monthly after bills; quarterly for running totals.

What if someone disputes their usage?
Cross-check carrier report together; add Notes column for proof.

Is this template free and private?
Google Sheets is free; data stays private unless you share the link. No central storage.