Use a row-based Google Sheets ledger to split each streaming bill by agreed usage percentages, record who paid, and show who owes whom. A blank sheet is enough for a small group, and you can save the finished layout for the next bill.
Turns out, the sheet cannot measure viewing automatically. It records the rule your group accepts, applies that rule consistently, and keeps payment responsibility separate from cost responsibility.
Choose the split rule first
Usage-based splitting makes sense when one person watches much more than another. It also creates extra work, so agree on a simple method before anyone starts entering numbers.
| Situation | Useful split method | Example |
|---|---|---|
| Everyone uses the service about the same amount | Equal split | Two people pay 50% each |
| Viewing differs clearly | Usage percentage | Alex pays 60% and Jordan pays 40% |
| Members agree to fixed dollar shares | Unequal amount | Alex pays $10 and Jordan pays the remaining balance |
| One person should bear the entire charge | Reimbursement or responsibility split | Alex is assigned 100% and Jordan 0% |
For three equal users, use 33.33%, 33.33%, and 33.34%. The final percentage keeps the row at 100%.
Decide what "usage" means. It might mean viewing hours, profile use, or simply who wants access to the plan. You don't need a perfect watch-time log. Put the agreed rule in the Notes column so nobody has to reconstruct it later.
Set up the streaming split template
Use one row for each charge, not one row for each person. The sample below uses Alex, Jordan, and Taylor; replace those names with your group members.
| Column or group | What it records |
|---|---|
| Date | The date the charge posts |
| Service | Netflix, Disney+, or another subscription |
| Total Cost | The actual amount charged |
| Paid By | The person who paid the bill upfront |
| Split Type | Equal, Usage %, Unequal Amount, or Reimbursement |
| Alex %, Jordan %, Taylor % | Percentage responsibility for equal, usage, or reimbursement rows |
| Alex Fixed, Jordan Fixed, Taylor Fixed | Dollar responsibility for Unequal Amount rows |
| Alex Share, Jordan Share, Taylor Share | Calculated amount each person should bear |
| Alex Paid, Jordan Paid, Taylor Paid | Amount each person paid upfront |
| Alex Net, Jordan Net, Taylor Net | What each person owes or should receive |
| Split Check | Whether percentages or dollar shares add correctly |
| Settled? | Whether the related balance has been paid |
| Notes | Usage rule, receipt location, or change explanation |
The percent columns show who should bear the cost. They do not show who handed over the money.
Format Total Cost and all dollar columns as currency. Format the percentage columns as percentages, so you enter 60%, not 60.
Add formulas for shares and balances
For the formulas below, use this column map:
C: Total CostD: Paid ByE: Split TypeF:H: Alex, Jordan, and Taylor percentagesI:K: Alex, Jordan, and Taylor fixed amountsL:N: Alex, Jordan, and Taylor sharesO:Q: Alex, Jordan, and Taylor paid amountsR:T: Alex, Jordan, and Taylor net balancesU: Split Check
Enter the formulas in row 2, then copy them down for future charges.
| Cell | Formula | Purpose |
|---|---|---|
| L2 | =IF($E2="Unequal Amount",$I2,ROUND($C2*$F2,2)) |
Alex's share |
| M2 | =IF($E2="Unequal Amount",$J2,ROUND($C2*$G2,2)) |
Jordan's share |
| N2 | =IF($E2="Unequal Amount",$K2,$C2-SUM(L2:M2)) |
Taylor's share and rounding remainder |
| O2 | =IF($D2="Alex",$C2,0) |
Amount Alex paid upfront |
| P2 | =IF($D2="Jordan",$C2,0) |
Amount Jordan paid upfront |
| Q2 | =IF($D2="Taylor",$C2,0) |
Amount Taylor paid upfront |
| R2 | =L2-O2 |
Alex's net balance |
| S2 | =M2-P2 |
Jordan's net balance |
| T2 | =N2-Q2 |
Taylor's net balance |
| U2 | =IF($E2="","",IF($E2="Unequal Amount",IF(ROUND(SUM(L2:N2),2)=ROUND($C2,2),"OK","Check amounts"),IF(ROUND(SUM($F2:$H2),4)=100%,"OK","Check percentages"))) |
Checks the row |
For Equal, Usage %, and Reimbursement rows, fill in the percentage columns. For Unequal Amount rows, leave the percentage columns blank and enter dollar amounts in the fixed amount columns.
The final share formula uses the remaining cents after the first two shares. That prevents a one-cent mismatch caused by rounding.
With a $15.99 Netflix charge, Alex at 60% and Jordan at 40% produces shares of about $9.59 and $6.40. If Alex paid the full bill, Alex's net is -$6.40 and Jordan's net is $6.40.
A negative net means that person should receive money. A positive net means that person still owes money.
Create a running balance summary
Add a separate Summary sheet, or place these totals above the transaction table:
| Person | Formula | Meaning |
|---|---|---|
| Alex | =SUM(R2:R1000) |
Alex's total net balance |
| Jordan | =SUM(S2:S1000) |
Jordan's total net balance |
| Taylor | =SUM(T2:T1000) |
Taylor's total net balance |
The balances should add up to zero, apart from a rounding issue that needs correction. If Jordan's summary shows $18.40 and Alex shows -$18.40, Jordan owes Alex $18.40.
The summary is an IOU record. It doesn't prove that a payment happened.
Handle reimbursements without mixing up roles
A reimbursement row has two separate facts: who paid the bill and who should ultimately bear the cost.
Suppose Jordan paid a $15.99 subscription that only Alex should cover. Set Paid By to Jordan, choose Reimbursement, enter Alex at 100% and Jordan at 0%, and leave Taylor at 0%. The sheet shows Alex owing $15.99 and Jordan receiving $15.99.
If the payer and the responsible person are the same, no transfer is due. The row still documents why the charge belongs entirely to that person.
Some expense templates use 100% for the payer because their percentage fields track cash contributions. That is a different convention. In this layout, the percentage fields track cost responsibility, while the Paid By field tracks who fronted the charge.
If two people paid parts of the same bill, a single Paid By dropdown is not enough. Replace it with paid-amount columns and enter the actual amount each person paid. Those amounts should total the bill.
Keep actual settlements in a small Payments sheet with columns for Date, From, To, Amount, Method, Reference, and Notes. Use whatever payment method your group already accepts, then mark the related balance as settled after the transfer.
Make the sheet safe to share
Protect the formula columns so someone doesn't paste over the calculations. Leave the input columns editable, including Date, Service, Total Cost, Paid By, split inputs, Settled?, and Notes.
Add dropdowns for Split Type, Paid By, and Settled?. A percentage validation rule can also flag values below 0% or above 100%. Keep one person responsible for checking the billed amount each month.
Record changes plainly. A note such as "Alex moved out on March 15; use 50% next month" is more useful than an unexplained revised number.
Use this monthly workflow
- Save the bill, receipt, or charge notification in your usual records folder.
- Add one row with the billing date, service name, actual cost, and person who paid.
- Confirm whether the group is using an equal split, usage percentages, fixed amounts, or a reimbursement.
- Enter the agreed inputs and wait for Split Check to show
OK. - Review the Summary sheet and ask for payment using the group's agreed method.
- Add the settlement to the Payments sheet and mark the related balance as settled.
- Keep the row unchanged after settlement, adding a note if the group later agrees to a correction.
If usage changes halfway through a billing period, agree on the treatment first. You can prorate the charge if everyone has reliable dates or hours, or apply the new percentage to the next bill. Record the decision instead of silently rewriting an old row.
Common mistakes to avoid
| Mistake | Better approach |
|---|---|
Entering 60 in a percent cell |
Enter 60% and format the cell as a percentage |
| Treating the payer as the person who owes the bill | Keep Paid By separate from cost responsibility |
| Letting percentages total 99% or 101% | Use Split Check before settling |
| Rounding every share independently | Let the final share absorb the remaining cents |
| Changing an old percentage without explanation | Add a note and keep the original bill history |
| Marking a row settled before money moves | Update Settled? only after recording the payment |
Check the service rules and protect privacy
A spreadsheet only divides the charge. It does not change a streaming provider's account, household, device, or extra-member rules.
Check the service's current terms before sharing access with people in another household. Enter the actual charge you received, especially if a plan or add-on changes.
Keep the tracker minimal. Monthly percentages may be enough. If your group does use detailed viewing logs, store them separately and don't put account passwords in the sheet.
FAQ
Can I track Netflix, Disney+, and other subscriptions together?
Yes. Add one row per service and charge. A Service column lets you filter Netflix separately from music, cloud storage, or other shared plans. Use separate tabs if different subscriptions follow different rules.
What if nobody wants to track watch time?
Use an equal split, a fixed access fee, or another rule the group accepts. A rough agreed percentage is better than pretending the sheet has precise viewing data.
Can I use the same layout in Excel?
Yes. The arithmetic formulas work in Excel, although dropdown and protected-range menus may have different names. Test the first row before copying it through the workbook.
Do I need a separate payment app?
No. The sheet can track shares, reimbursements, and settlement records without moving money. A payment app or bank transfer is only the method your group chooses for settling the balance.
Create the sheet, enter the $15.99 test row, and have everyone approve the split rule before the next charge posts.