Why rebuild a split calculator from scratch every time rent comes due? Apple Numbers handles proportional bill splitting smoothly, and a single sheet can last a household for years. It works for partners, roommates, or any small group sharing costs. The concept is straightforward. List everyone's earnings in a People table, let Numbers calculate each person's percentage, and apply that split to every joint bill. A second table logs who paid what.

Take Alex and Jordan. Alex brings home $3,000 each month and Jordan brings home $2,000. Combined, they make $5,000. That puts Alex's share at 60% and Jordan's at 40%. When a $1,000 utility or rent bill arrives, Alex covers $600 and Jordan owes $400. Once you enter the expenses, the sheet shows the final balance to settle. Quick and clean.

Decide the rule before typing

Proportional splitting is a household agreement, not a universal law of fairness. You need to agree on what counts as income before opening your spreadsheet. Decide whether you are logging gross pay or take-home pay, which invoices count as shared, and how often you will review the setup.

Thing is, people often jump straight into software and skip that conversation entirely. Then, when an edge case pops up, they blame the spreadsheet for an argument they never actually resolved. A formula cannot tell you if an annual bonus counts as monthly earnings, whether someone's premium grocery item stays private, or what to do if someone's income drops to zero. That is a human decision.

Method Good fit Tradeoff
Equal split Incomes are close or everyone prefers the same amount A lower earner may carry more of the burden
Income-based split Incomes differ and the group wants contributions tied to earnings Everyone must agree on the income definition
Usage-based split A bill can be measured by person or room You need reliable usage records
Room-size split Bedrooms or private spaces differ The group must agree on how space affects the amount

In this walkthrough, whatever percentage comes from the People table applies to all shared rows. Keeping one shared rate per person saves you a headache.

Create the Numbers template

Start Numbers and open a blank document. If you have not started a fresh sheet before, Apple's guide to creating a spreadsheet covers the initial clicks. Rename the starting table People, then add a second table called Expenses.

  1. In People, create these six columns: Name, Monthly Income, Income Share, Total Owed, Total Paid, and Balance.
  2. Give each person a row. Type Alex with 3000 in row 2, and Jordan with 2000 in row 3.
  3. Set up the Expenses table with five headers: Date, Category, Amount, Paid By, and Shared?. Write Yes if an item splits across the house, or No if it is a personal purchase.
  4. In row 2 of your People table, enter these four formulas:
C2: =IF(SUM(B)=0,0,B2/SUM(B))
D2: =SUMIFS(Expenses::C,Expenses::E,"Yes")*C2
E2: =SUMIFS(Expenses::C,Expenses::D,A2,Expenses::E,"Yes")
F2: =E2-D2

The formula in C2 divides individual earnings by total household income. That IF check prevents an ugly division-by-zero error whenever the income cells sit empty.

Drag those formulas down for each row in your group. Format Monthly Income, Total Owed, Total Paid, and Balance as currency, and set Income Share to percentage format.

Want total household income displayed by itself? Put =SUM(B) in any spare cell outside the data rows. Numbers can reference an entire column at once, so the formula keeps working even if a third person moves in later. Also, if every single row logged in Expenses is always shared, you can leave off the Shared? column and write =SUM(Expenses::C)*C2 for Total Owed, alongside =SUMIFS(Expenses::C,Expenses::D,A2) for Total Paid.

Log each shared expense once

Every payment gets its own line in the Expenses table. Never log the same receipt twice.

Date Category Amount Paid By Shared?
May 1 Rent $1,000 Alex Yes

Alex covered the rent up front. With our sample numbers in place, the People table updates automatically:

Person Income Share Total Owed Total Paid Balance
Alex 60% $600 $1,000 $400
Jordan 40% $400 $0 -$400

Balance uses a simple subtraction: Total Paid - Total Owed. A positive number means the group owes that person money. A negative balance shows what that person still owes to the pot.

Say Alex and Jordan pay the landlord separately, with Alex sending $600 and Jordan sending $400 directly. Enter two separate rows showing what each person actually sent. Do not record the $1,000 charge and then log their payments on top of it.

Marking a line No under Shared? excludes it entirely. The sheet ignores personal runs to the store.

Use a one-bill formula instead

Turns out, you do not always need a two-table sheet for an occasional split. A tiny four-column grid can divide a single invoice in seconds.

Column Holds
B Individual income
C Total group income
D Bill amount
E Individual share

Put this formula into E2:

=(D2/$C$2)*B2

With $3,000 in B2, $5,000 in C2, and a $1,000 bill in D2, cell E2 returns $600.

The dollar signs lock $C$2 in place. As you copy the formula down to Jordan's row, B2 and D2 shift while total income stays anchored. If you prefer pointing and clicking over typing cell coordinates, check Apple's Numbers formula guide for details on the formula editor.

Groups with a flat, agreed-upon split can skip income references entirely:

=D2*0.6
=D2*0.4

Only use flat rates if everyone agreed to ignore actual income changes. These hardcoded formulas will not adjust on their own.

Keep updates and sharing orderly

Formula columns should stay untouched during day-to-day use. One person can maintain the structure while others log bills.

Live spreadsheet formulas calculate in real time, which means modifying someone's income changes all past owed figures instantly, and that can get messy fast if you are halfway through a month and someone updates their salary without warning. If you want a clear record of past months, duplicate the tab, save a dated file, or note the old percentages before adjusting incomes.

Check the numbers every month. A brief text box right next to the table prevents confusion: "Shares based on take-home pay entered May 1."

When sharing via iCloud, grant editing permissions only to the person keeping the books. Send everyone else a view-only link or an exported PDF.

Common mistakes to catch

Mistake Fix
Using C2 instead of $C$2 in the one-bill formula Anchor the total income cell before copying
Marking a personal purchase Yes Change it to No or leave it out
Entering one bill twice Record the actual payments, not the bill total twice
Logging a reimbursement as a new expense Keep reimbursements separate from the original shared charge
Changing income without preserving the old agreement Save a dated copy or note the prior shares
Leaving all incomes blank Use the zero check and agree on a contribution rule before calculating

Remember that spreadsheets track math. They do not initiate bank transfers.

FAQ

How do I calculate total group income in Numbers?

Type =SUM(B) in the People table header or a standalone cell. You can also write =SUM(B2:B3) for two people, but you will need to edit the formula whenever someone joins the household.

Can I use this for rent, utilities, and groceries?

Yes. Add each charge on a fresh line in Expenses, choose the category, tag the payer, and mark it Yes. Keep personal errands marked No.

What does a negative balance mean?

A negative balance means that person has paid less than their share and needs to settle up. A positive figure means they overpaid and are owed a reimbursement.

Can a zero-income person use this template?

The formula will assign them a 0% share without breaking. But to be honest, whether someone pays zero is a household decision, not a math problem. If someone contributes non-financial labor or has irregular freelance earnings, discuss an agreed minimum or baseline rule first.

Enter your group's real take-home figures and add one test expense marked Yes. Verify that the total owed across all rows matches the receipt, delete the test entry, and start your real log.