Use Google Sheets for a free utility bill tracker with a "who owes what" column. Set up columns for Bill Name, Amount Owed, Due Date, Amount Paid, Payer, and a running balance formula showing each person's net owed or due. Adapt templates for shared utilities like electric, water, and internet.

This approach helps U.S. roommates, couples, or small groups track recurring bills without paid apps. Enter bills as they arrive, note payments and shares, and let formulas calculate balances. Everyone sees updates in real time with shared edit access.

Recommended Columns for Utility Bill Tracker with "Who Owes What"

Core columns for bill trackers include Bill Name (e.g., Electric, Water, Internet), Amount Owed (total bill), Due Date, and Amount Paid.

For group sharing, add Payer (who paid upfront) and Split Type (e.g., Equal, Usage-based). Include a "Who Owes What" section with running balances per person. Rename columns to names like Alice, Bob, Charlie for shares owed or reimbursed.

One example marks reimbursements by listing "Reimbursement" in Split Type, with the payer at 100% and others at 0%. This builds a balance column showing net amounts each person owes or is owed.

Variations include adding Notes for usage details (e.g., high electric from AC). Adjust for your split method, like equal shares or income-based.

Column Purpose Example
Bill Name Identifies utility Electric - July
Amount Owed Total bill $150
Due Date Payment deadline 07/15/2026
Amount Paid What was covered $150
Payer Who paid upfront Alice
Split Type Equal or reimbursement Equal
Alice Her share or balance $50 owed
Bob His share or balance $50 owed
Running Balance Who owes what total Alice: +$100 owed to her

Step-by-Step Setup in Google Sheets

  1. Go to sheets.google.com and create a new blank sheet. Name it "Utility Bill Tracker 2026".

  2. In row 1, add headers: A1: Bill Name, B1: Amount Owed, C1: Due Date, D1: Amount Paid, E1: Payer, F1: Split Type, G1: Alice, H1: Bob, I1: Charlie, J1: Running Balance.

  3. Enter sample data in row 2: A2: "Electric", B2: 150, C2: "07/15/2026", D2: 150, E2: "Alice", F2: "Equal".

  4. In G2 (Alice share): Enter a formula for equal split or full reimbursement, such as =IF(F2="Equal", B2/3, IF(E2="Alice", 0, B2)).

  5. Copy the formula across H2 and I2, adjusting names. In J2 (Running Balance): Use a formula for net per bill, or use a summary sheet for totals.

  6. For monthly utilities, add rows as bills arrive. Freeze row 1 (View > Freeze > 1 row) for easy scrolling.

Test with real bills before sharing.

Sharing and Collaboration Rules

Google Sheets supports real-time collaboration, where everyone with edit access updates simultaneously and sees changes live.

Click Share > Add emails or generate a link. Set to "Editor" for active groups like roommates. Use "Viewer" or "Commenter" for others who check balances without edits.

Update cadence: Monthly after bills post, or weekly for high-use households. Assign one person to verify payments. For trust-based groups, real-time works; notify via group chat for changes.

If group size changes, insert/delete columns and copy formulas down.

Useful Formulas for Summaries and Filters

Adapt these formulas for utilities.

  • Category totals: =QUERY(A2:J100, "SELECT A, SUM(B) GROUP BY A LABEL SUM(B) 'Total Owed'") summarizes electric vs. water totals.

  • High bills filter: =FILTER(A2:J100, B2:B100>100) shows rows where Amount Owed exceeds $100.

  • Paid bills only: =SUMIFS(B2:B100, D2:D100, ">0") sums totals for paid utilities.

Place in a "Summary" tab. For per-person owed: Use a formula to flag negative balances (owed to group).

Test ranges like A2:J100 to fit your data.

Common Mistakes and Fixes

Forgetting to copy formulas when adding people or bills leads to blank balances. Fix: Select formula cell, copy, paste to new rows/columns.

Not marking reimbursements properly: Use 100%/0% splits or dedicated column to avoid double-counting.

Irregular updates spark disputes. Set calendar reminders post-bill cycle. Over-editing without notes erases history; add a "Last Updated" column.

Ignoring split variations: Equal works for utilities, but add usage (e.g., water meter reads) in Notes.

When a Spreadsheet Works vs. When to Use an App

Use this decision tree for utility tracking:

  • Low volume (2-4 recurring bills/month) and high trust? Spreadsheet suffices for records.

  • Everyone comfortable with Sheets? Stick here; free, no accounts needed beyond Google.

  • Need receipt photos or auto-payments? Consider apps for scanning, but keep Sheets for "who owes what" backups.

  • Group over 6 or low trust? Apps handle reminders; spreadsheets for exports.

  • Historical records key? Sheets archives easily.

Spreadsheets excel for simple, recurring utilities without blurring tracking and paying. Export to PDF for disputes. Apps suit if scanning or requests grow, but start simple.

FAQ

How do I calculate running "who owes what" balances?
Use a summary row or tab with =SUM(G:G) per person column. Track cumulatively by adding prior balance to new shares.

Can I use this for non-utility shared bills like rent?
Yes, add rows for rent or groceries. Formulas adapt, but separate tabs prevent clutter.

What if group size changes - how to adjust columns?
Insert/delete columns for names, then copy formulas from existing ones and paste.

Is Google Sheets free for group sharing?
Yes, basic version supports unlimited collaborators with edit access.

How often should we review the tracker?
Monthly after bills, or biweekly for active groups; set shared calendar alerts.

Are there printable versions?
Export as PDF (File > Download > PDF) for meetings; print summary tab.

Next, input your latest utility bill and share the sheet. Review balances before payments to confirm fairness.