Use Apple Numbers to build a custom income-based bill split calculator template. Start with a blank spreadsheet by clicking the New Document button in the template chooser, as described in Apple Support's guide to creating a spreadsheet. Add a table with columns for names, monthly incomes, total group income (using the SUM function), expense amounts, and individual shares calculated via formulas like (total expense divided by total group income) times individual income.

This setup helps U.S. roommates, couples, or family members with uneven incomes track proportional shares for rent, utilities, or groceries. Numbers auto-saves changes, making it simple for small groups to maintain records without apps. For example, if total income is $5,000 and one person's income is $2,000 on a $1,000 bill, their share is ($1,000 / $5,000) * $2,000 = $400.

When to Use an Income-Based Split in Numbers

Income-based splits divide expenses proportional to each person's earnings, promoting fairness in uneven-income households like roommates where one earns more or couples with disparate salaries. This differs from equal splits (total expense divided by group size) or per-person splits (fixed amount per user regardless of income).

Consider this decision tree for your group:

  • If all incomes are similar and bills recur simply (e.g., equal rent shares), use equal splits in a basic table.
  • If incomes vary significantly (e.g., one roommate earns twice as much), calculate ratios: individual income divided by total income gives their percentage share.
  • For small groups (2-5 people) with straightforward recurring bills like utilities, spreadsheets suffice for manual entry and formula updates.
  • Switch to apps if you need receipt scanning, automated reminders, or payment requests, as spreadsheets lack those.

One example from Jake Lee's blog describes a 60/40 split where shares follow (expense / total income) times individual income, based on reported earnings ratios. Always agree on the ratio upfront in writing to avoid disputes.

Spreadsheets work best for groups prioritizing privacy and control, without needing app accounts.

Create Your Numbers Spreadsheet and Main Table

Open Numbers on your Mac and create a new document. In the template chooser, select Blank under Spreadsheets or use the New Document button if it's not shown, per Apple Support instructions.

Click the table icon in the toolbar to add a table, or start with the default one. Enter headers in row 1:

  • Column A: Name
  • Column B: Monthly Income
  • Column C: Total Group Income
  • Column D: Expense Amount
  • Column E: Your Share

Enter names and incomes in rows 2 and below (e.g., "Alex" in A2, $3,000 in B2; "Jordan" in A3, $2,000 in B3). In C2, type =SUM(B:B) and press Return to sum all incomes; copy this down if needed. Numbers auto-saves as you work.

Rename the spreadsheet via File > Rename for easy access, such as "Roommate Income Split 2026."

Build Income Ratio Formulas for Shares

Select the cell for the first share (E2). Type = to open the Formula Editor, then build your proportional share. An example is =(D2 / $C$2) * B2, where D2 is the expense, $C$2 anchors the total income (use $ for fixed references), and B2 is individual income. Press Return to apply.

Drag the yellow dot at E2's bottom-right corner to copy the formula down for other rows. For quick sums, select a column and click the SUM button in the toolbar, as noted in Apple Support's formula guide.

Test with data: $1,000 expense (D2), $5,000 total income (C2), $3,000 individual (B2) yields $600 in E2. Use Command-K to edit ranges without losing references.

For fixed ratios like 60/40 agreed upfront, simplify to =D2 * 0.6 in the higher earner's share cell.

Add Expense Tracking and Summary Tables

For ongoing use, add a second table via the toolbar: name it "Expenses." Columns: Date (A), Category (B, e.g., "Rent," "Utilities"), Amount (C), Payer (D).

Link to the main table. In the main table's D2 (Expense Amount), use =SUMIFS(Expenses::C, Expenses::D, A2) to sum amounts paid by a specific person, per an Apple Community forum example.

Add a summary table for balances: columns for Name, Total Paid (SUMIFS from Expenses), Total Owed (SUM of shares), Balance (=Total Paid - Total Owed). Filter rows via the filter icon for dates or categories.

For yearly totals, a forum formula like =IF(LEN(A3)<1,"",SUMIFS(Expenses::C,Expenses::A,">="&DATE(A$1,1,1),Expenses::A,"<"&DATE(A$1+1,1,1),Expenses::B,A3)) sums by year (in A1) and category.

Update the Expenses table as bills arrive, then refresh main table formulas.

Share, Update, and Common Mistakes

Share via File > Share > Send a Copy or Collaborate with iCloud link; set to "Can make changes" for editors or "View only" for payers reviewing balances. Use weekly reviews for income changes or new bills.

Common mistakes:

  • Forgetting $ anchors in totals (e.g., C2 vs $C$2), causing errors when copying.
  • Unprotected formulas: right-click table > Table Settings > protect structure, though collaborators can still edit cells.
  • No group agreement: document ratios (e.g., "Shares based on latest paystubs") to prevent arguments.
  • Overcomplicating: stick to 2-3 tables for small groups.

Update incomes monthly or after raises. Spreadsheets suffice for simple tracking; consider apps for groups needing reminders or exports beyond CSV.

FAQ

How do I calculate total group income in the template?
In cell C2, enter =SUM(B:B) to sum the income column; drag down or copy for consistency.

What's the exact formula for a 60/40 income split on a $500 bill?
For the 60% person: =$500 0.6 (or =D2 0.6). Confirm ratios match group incomes first.

Can I filter expenses by date or roommate in Numbers?
Yes, add filters via the filter icon on the table; or use SUMIFS formulas for dynamic category/date sums.

Do I need to protect the sheet from accidental edits?
Protect table structure in settings, but for shared files, use view-only links to safeguard formulas.

When should I use this over a split-bill app?
Use Numbers for small groups with manual entry and no need for payments or scans; apps for automation in larger or forgetful groups.

How often should our group review income-based shares?
Monthly or after income changes; log agreements and paystubs for reference.

Next, enter your group's real incomes and a sample bill to test formulas. Print or export to PDF for non-digital sign-off on rules.