Google Sheets works well for siblings who need one shared record for rent, utilities, groceries, or family expenses. One row can show the bill, total, due date, payer, each person's share, payment status, and receipt notes.

Agree on the money rules before entering the first bill. Decide who pays upfront, how each share is calculated, and whether a reimbursement remains open after the bill itself is paid.

Use one row per bill period. That keeps old amounts and receipts visible instead of overwriting the history.

Agree on the split rule before you enter a bill

The spreadsheet cannot decide what is fair for you. It can make the agreed rule visible and repeatable.

Split approach Example Record this
Equal 50% / 50% Use when both siblings share the cost similarly.
Income-based 60% / 40% Note which bills use this ratio.
Usage-based A percentage based on use Add a short explanation in Notes.
One person fronts the bill Alex pays the total first Keep the Payer field separate from each person's share.

The split columns show responsibility, not payment history. If Alex pays a shared $1,200 bill, the sheet can still show Alex at 60% and Jordan at 40%, with Alex listed as the payer.

For an expense that belongs entirely to one sibling, a 100% and 0% allocation can make sense. Don't use that split just because one person temporarily covered a shared bill.

Build the sheet around one bill per row

Open a blank Google Sheet and add the headers below in row 1. Replace the placeholder names with the siblings' actual names.

Column Enter Example or formula
A: Bill name The expense Rent, electricity, or Internet
B: Amount The full bill amount $1,200
C: Payer Who pays the bill upfront Alex
D: Due date The actual date 1/15/2026
E: Alex % Alex's agreed share 60%
F: Jordan % Jordan's agreed share 40%
G: Alex share Calculated amount =B2*E2
H: Jordan share Calculated amount =B2*F2
I: Status The bill's current state Pending, Paid, or Disputed
J: Receipt or notes Proof or context Receipt link or split explanation
K: Split check Confirms the percentages =SUM(E2:F2)

Format columns B, G, and H as currency. Format D as a date, and format E, F, and K as percentages.

Enter 60%, not 60, in a percentage cell. The latter can produce a wildly incorrect share.

Turns out, the payer and the split answer different questions. The payer identifies who covered the bill; the share columns show who should ultimately bear the cost.

For example, a $1,200 rent bill split 60/40 produces a $720 share for Alex and a $480 share for Jordan. If Alex paid the full amount, Jordan's $480 is the reimbursement due to Alex, not another household bill.

If one sibling regularly fronts bills, add an optional Reimbursement status column. Keep that status separate from the bill status because the utility can be paid while the sibling-to-sibling reimbursement is still pending.

Add a new row for each recurring bill period. Use Data > Sort range to sort the entire table by column D; sorting only the due-date column can separate dates from the people and formulas attached to them.

Add due-date alerts with conditional formatting

Colors should answer one question: what needs attention now?

Select A2:K, open Format > Conditional formatting, and choose a custom formula. For overdue bills, use this rule and choose a red fill:

=AND($D2<>"",$I2<>"Paid",$D2<TODAY())

Add a second rule for bills due today. Use an orange fill:

=AND($D2<>"",$I2<>"Paid",$D2=TODAY())

Add a third rule for bills due within the next three days. Use a yellow fill:

=AND($D2<>"",$I2<>"Paid",$D2>TODAY(),$D2<=TODAY()+3)

These rules exclude rows marked Paid, so a completed bill won't continue showing as overdue. Apply a separate green rule to I2:I with the custom formula =$I2="Paid".

The formulas assume column D contains real date values, not text that only looks like a date. Test each rule with a temporary past, current, and future date before relying on the colors.

Thing is, a color is a prompt, not proof that someone paid. Keep the status and receipt note current.

Share access without losing control

Use the sheet's Share settings and choose the narrowest permission that lets the household work together:

  • Viewer: Can read the calendar without editing it.
  • Commenter: Can leave questions or explanations without changing formulas.
  • Editor: Can add bills, update statuses, and change formulas.

Anyone with the link is convenient, but a link can be forwarded. Named access is a better choice for a private household record when everyone can use it.

Consider protecting the formula columns so an ordinary update doesn't overwrite G, H, or K. Keep edit access focused on the fields siblings actually change.

Version history can help you identify when a formula or amount changed. It is useful for sorting out a mistaken edit, but it isn't a substitute for a written agreement or a clear reimbursement record.

Don't put full bank account numbers, login details, Social Security numbers, or other sensitive information in the sheet. A receipt link or short payment note is usually enough.

Use a short weekly review

Set a recurring reminder for a weekly check-in. Ten minutes is enough for a small list of stable bills.

  1. Sort by due date and scan the colored rows.
  2. Add new bills and update amounts when statements arrive.
  3. Check that each split still totals 100%.
  4. Mark the bill paid after the bill itself is paid.
  5. Update the reimbursement status and add a receipt or note.
  6. Record disagreements in a comment instead of silently changing the split.

To be honest, the first review may take longer because you are deciding what belongs in the sheet, but later reviews should be a quick scan rather than a new budgeting meeting.

A useful reminder message is: "Electricity is due Friday. The total is $95, your share is $38, and the receipt is in the sheet. Please confirm when your part is settled."

Know what the sheet can and cannot do

Sheets can track bills, calculate shares, show due dates, and preserve notes. It does not itself move money or verify that a bank or payment-app transfer happened.

Handle the payment separately, then return to the sheet and update the appropriate status. Keep bill payment, reimbursement, and receipt storage as separate steps so one green cell does not imply that every part of the transaction is finished.

A written household agreement may be better when the group has frequent one-off expenses, repeated disputes, or more people than the simple share columns can handle. A separate contribution table can also work better than adding endless new sibling columns.

Apps Script is optional for email reminders. Keep any script separate from the formulas and test it with dummy dates; Google's Apps Script event documentation describes the event objects available to trigger-driven functions.

Fix the common spreadsheet mistakes

Dates pasted as text are a frequent cause of missing alerts. Re-enter the date in a date-formatted cell if a row never changes color.

Entering 60 instead of 60% can multiply the share incorrectly. Check the split total in column K before reviewing the dollar amounts.

Sorting only column D can mismatch a bill with the wrong payer or receipt. Always sort the whole data range.

Overwriting last month's row removes useful history. Add a new row for the next billing period instead.

Finally, don't confuse a paid bill with a settled reimbursement. Keep both statuses visible when one sibling pays upfront.

Test it before sharing

Enter last month's rent and one utility bill first. Add temporary test rows with a past, current, and future due date, then confirm the formulas, split check, currency formatting, and alert colors.

Delete the test rows, choose the sharing permission, and schedule the first weekly review. Your next update should be simple: add the new bill, confirm the split, and attach the proof of payment.