Utility Bill Splitter

Introduction

Disputes over a shared bill rarely concern the total; they concern who stayed longer or had guests. This page offers three bases: equal halves, headcount, and headcount multiplied by days stayed. Party A is calculated first and Party B takes the remainder, so the two add back to the bill exactly.

The example bill is 386.50. Party A has 2 people for 30 days, or 60 person-days; Party B has 3 people for 22 days, or 66 person-days. On that basis Party A owes 47.62 percent, or 184.05, leaving 202.45 for Party B, with a zero check difference. By headcount Party A would owe 154.60; equal halves would give 193.25.

Amounts are rounded to the cent and Party B absorbs any rounding remainder, so the two shares never exceed the bill by a stray cent.

Key features

• Two modes: Per person-day needs headcount and days; per head needs only the two headcounts.
• Blank is fine: In per-head mode blank days are accepted and no missing-field prompt appears.
• Person-days: Per person-day mode lists each party person-days rather than only a final number.
• Share by amount: Party A share is based on amount payable, not on headcount.
• Reconciliation: The difference between both shares and the bill total has its own row for checking.
• Zero blocked: Zero people is rejected rather than producing a divide-by-zero result.

How to use it

1. Bill total: Enter the amount on this period bill that has to be shared.
2. Split method: Choose per person-day or per head first. In per-head mode the two day boxes can stay empty.
3. Party A people, Party B people: Enter actual occupants for each side. Zero on either side is blocked.
4. Party A days, Party B days: In person-day mode enter how long each side stayed; unequal stays are what shift the ratio.
5. Reconcile: Press Calculate for both shares, then check that the difference cell is zero. Party A share is by amount payable, not by headcount.

Things to keep in mind

• Two modes: Per person-day needs headcount and days; per head needs only the two headcounts.
• Blank days: In per-head mode blank days are fine and raise no missing-field prompt.
• Reconciliation: The difference between both shares and the bill total is listed for checking.
• Party A share: Party A share is by amount payable, not by headcount.
• Zero headcount: Zero people is blocked rather than dividing by zero.

The difference cell is the audit trail: both shares should add back to the bill total exactly, so a non-zero value means something in the inputs was lost during rounding. Party A share is calculated from amount payable rather than headcount, which is why it moves with days in person-day mode. Switch modes with the same inputs to see how much the stays actually matter.

In per person-day mode two people staying 30 days and one staying 15 days do not split the bill equally, because the ratio is built from person-days rather than heads. In per-head mode the same bill divides by three regardless of how long each person stayed. Switching modes with the other boxes unchanged makes the difference obvious.