Yes. A two-person Google Sheets file can calculate a recurring internet split and keep the reimbursement trail in one place. Use one row per bill, enter the agreed percentages, and record the person who paid the provider.

That last column matters. A split method tells you what each person owes; Paid by tells you who fronted the bill. If Partner A pays an $80 bill under a 50/50 agreement, Partner B owes Partner A $40.

Here is a practical layout with formulas you can copy down.

A simple sheet layout

Keep the labels boring. Really. A consistent Internet value makes the summary formulas work, while the notes column can hold the provider name, billing period, and receipt link.

Column Header What to enter
A Date Bill date or due date, used consistently
B Description Internet for each internet bill
C Total amount The full provider charge
D Split method Equal, Income, Usage, or Reimbursement
E Partner A % Partner A's agreed share, such as 50%
F Partner B % Partner B's agreed share
G Partner A share Formula-generated amount
H Partner B share Formula-generated amount
I Paid by The partner who paid the provider
J Owed to payer Formula-generated reimbursement amount
K Status Open or Paid
L Receipt or notes Receipt link, provider, billing period, or rule
M Percent check Confirms the two percentages total 100%

Use these labels for row 1:

Date,Description,Total amount,Split method,Partner A %,Partner B %,Partner A share,Partner B share,Paid by,Owed to payer,Status,Receipt or notes,Percent check

Formulas for shares and reimbursements

Put these formulas in row 2 of the Bills tab, then fill them down. They assume the partner labels are exactly Partner A and Partner B.

G2: =IF(OR($C2="",$E2=""),"",ROUND($C2*$E2,2))
H2: =IF(OR($C2="",$G2=""),"",ROUND($C2-$G2,2))
J2: =IF($I2="Partner A",$H2,IF($I2="Partner B",$G2,""))
M2: =IF(OR($E2="",$F2=""),"",IF(ROUND($E2+$F2,4)=1,"OK","Check"))

Column H uses the remaining cents after Partner A's share. That prevents a one-cent mismatch when a bill cannot divide evenly.

Enter 50%, not 50, in the percentage cells. Google Sheets treats those values very differently. Format columns C, G, H, and J as currency, E and F as percentages, and A as a date.

Use data validation dropdowns for D, I, and K. The split method list can contain Equal, Income, Usage, and Reimbursement; the payer list can contain the two partner labels; and the status list can contain Open and Paid.

If you use real names instead of Partner A and Partner B, change those names inside the J2 formula too.

Pick the split method before the bill arrives

The fairest method depends on what both partners agree feels reasonable. A simple rule that you can explain later is usually more useful than a precise rule nobody follows.

Method Partner A and B percentages Shares on an $80 bill Useful when
Equal 50% and 50% $40 and $40 Both partners want the simplest arrangement
Income-based 62% and 38% $49.60 and $30.40 Incomes differ and both agree on the income measure
Usage-based 70% and 30% $56 and $24 One partner has a consistently higher agreed share of use
Reimbursement 100% and 0% $80 and $0 One partner intentionally covers the entire bill

For an income-based split, divide each partner's agreed income measure by the combined amount, then enter the results as percentages. Decide whether you are using gross or take-home income, and write that choice in the notes.

Usage-based splitting needs a clear proxy. Working from home may support a higher agreed percentage, but router activity rarely proves exactly who used how much data. Set a percentage in advance instead of arguing over every gigabyte.

Reimbursement is separate from Paid by. Partner A may pay the provider for both people under a 50/50 agreement, in which case Partner B still owes Partner A $40. Use 100/0 only when the agreement says Partner A is covering the bill.

Build the calculator in Google Sheets

  1. Create a blank spreadsheet with a Bills tab and a Summary tab.
  2. Add the headers from the layout above to row 1 of Bills.
  3. Enter the four formulas in row 2 and copy them down far enough for your expected billing history.
  4. Apply currency, percentage, and date formatting before entering real bills.
  5. Add dropdowns for split method, payer, and status.
  6. Test the sheet with an $80 row: Internet, Equal, 50% for each partner, Partner A as payer, and Open as the status.
  7. Confirm that G2 and H2 total $80 and J2 shows $40.
  8. After the reimbursement arrives, change the status to Paid.

The test row catches bad percentage formatting early. It also shows whether the Owed to payer formula matches the way you actually settle bills.

Add a small Summary tab

Use Internet as the exact description for every relevant row. Put the following labels and formulas on Summary:

Total internet billed
=SUMIF($B$2:$B$100,"Internet",$C$2:$C$100)

Partner A's total share
=SUMIF($B$2:$B$100,"Internet",$G$2:$G$100)

Partner B's total share
=SUMIF($B$2:$B$100,"Internet",$H$2:$H$100)

Open reimbursement
=SUMIFS($J$2:$J$100,$B$2:$B$100,"Internet",$K$2:$K$100,"Open")

These ranges cover rows 2 through 100. Expand them if you expect a longer history. Keep the sum range and criteria ranges the same length; the SUMIFS examples from Ablebits show the same range-matching principle.

The summary is most useful for a quick monthly review. It is not necessary for the row-level calculator.

Share the sheet carefully

Share the file with your partner's email address when it contains income percentages, receipt links, or personal notes. Give the partner edit access only if both of you need to enter bills; otherwise, view access may be enough.

If you use a shareable link, review its general access before sending it. Google's file-sharing guidance explains how to choose between specific people and broader link access.

Protect the formula columns or ranges after testing them. Treat protection as an editing safeguard, not a privacy boundary. Anyone who can view the sheet may still see the values in protected cells.

Keep the monthly routine short

When Action
Before the first bill Agree on the split method, percentage basis, payer labels, and what Paid means
When the bill arrives Enter the date, amount, receipt, and split percentages
After someone pays Set Paid by and leave the status as Open
After reimbursement Confirm the money arrived, then change the status to Paid
Before the next bill Check for missing receipts, unusual charges, or a changed agreement

A consistent rule matters more than a clever formula. Thing is, most confusion comes from changing the rule without recording when the change began.

If one partner's income changes, do not rewrite every old row just because the new percentage looks more accurate; put the new percentage on the next bill, add a note, and leave the old record alone so the past still matches what you agreed then.

Limits and common mistakes

Sheets calculates what you enter. It will not verify the provider invoice, confirm that a reimbursement arrived, or settle a disagreement about what counts as fair use.

For a routine household bill, that may be enough. To be honest, a written note and a receipt link often matter more than another dashboard. This tracker is not legal, tax, or financial advice; questions with legal or tax consequences depend on your situation and jurisdiction.

Watch for these mistakes:

  • Entering 50 instead of 50%.
  • Using Paid by to mean who owes money.
  • Marking a reimbursement as paid when the request was only sent.
  • Changing old rows after a new percentage agreement.
  • Sharing an edit link more broadly than intended.
  • Overwriting formulas in G, H, J, or M with typed amounts.

Keep bank passwords, full account numbers, and unrelated private records out of the sheet. Store only the information needed to explain the bill and its settlement.

A few practical questions

What if the person who pays changes each month?

Change the Paid by value on each row. The split percentages stay the same, while the J formula switches the amount owed to the correct payer.

Can I use this for other shared utilities?

Yes. Replace Internet with a consistent label such as Electricity or Water, or create separate summary rows for each description. The same percentage and reimbursement formulas still work.

How do I handle a bill with an odd number of cents?

The H formula assigns the remaining cents to Partner B after rounding Partner A's share. Both shares should then add back to the total amount.

Should I use a link that anyone can edit?

Use specific-person access if the sheet contains income information, receipts, or household notes. A broader link is easier to misdirect, so choose it only when that exposure is acceptable.

Create the Bills tab, enter one $80 test row, and confirm that the two shares total $80 before adding the next invoice.