Bill Split & Expense Settlement Calculator
Track multiple payments made by different people (a group trip or dinner) and automatically work out who owes whom, with rounding handled and the minimum number of transfers needed to settle up.
Input event name and click create button. Unique URL will be issued to mange the bill split.
What Is a Bill Split Calculator?
This tool automatically works out who should pay whom, and how much, whenever a group's expenses end up scattered across different people — a dinner, a trip, or any situation where one person fronts the money for everyone else. Just enter your members and payments, and the calculator finds a settlement route that keeps the number of transfers to a minimum.
The result is published at a unique URL, so every member who has the link can check the same up-to-date settlement details in real time. There's nothing to install and no account to create, and the sheet is deleted automatically one month after its last update.
How to Use the Bill Split Calculator
- Name your event Give the sheet a name you'll recognize later — a trip or a get-together — and press the create button.
- Add your members Enter everyone taking part. You can add or remove people later as needed.
- Record each payment For every payment, fill in the date, item, amount, payer, and who should share the cost.
- Check the settlement The tool automatically shows who should pay whom, using the route that needs the fewest transfers.
- Share the URL with your group Send the link to everyone involved so they can follow the same settlement details in real time.
Tips for getting more out of it
- Just share the URL with your group members — everyone can check the settlement details in real time. No app installation required.
- The "Payer" is the person who actually paid the money; "Need to pay" are the people who should share the cost. For example, if one person covers a meal for three, the Payer is 1 person and Need to pay is 3 people.
- The settlement calculation uses an algorithm that minimizes the number of transfers. Even with 5 people, settlement can be completed in at most 4 transfers.
- Sheets are automatically deleted one month after the last update. Once settlement is complete, it's a good idea to note down the data for your records.
Where a Bill Splitter Comes In Handy
Splitting costs on a trip
Lodging, transport, and meals are often paid by different people — settle it all in one place.
Dinners and group outings
Let the organizer front the bill and have everyone else's share worked out fairly afterward.
Club and society dues
Track costs that vary event by event, then settle everything together at year end.
Shared living expenses
Keep a running record of rent, utilities, and groceries when splitting a household with roommates or a partner.
Bill-Splitting Glossary
- Payer
- The person who actually handed over the money at the time. If one person covers the bill for the whole group, that person is the payer.
- Need to pay (payee group)
- The people who should ultimately share the cost of a payment. The payer is usually included among them as well.
- Settlement
- The process of comparing what each member paid against what they owe, then working out exactly who should transfer money to whom so every balance reaches zero.
- Minimum-transfer settlement
- An algorithm that finds the smallest possible number of transfers needed to bring every member's balance to zero.
- Deficiency and excess
- The gap between what a member should have paid and what they actually paid. A positive balance means they're owed money; a negative one means they still need to pay.
FAQ
Side Note — The Origin of "Warikan" and "Going Dutch"
The Japanese word "warikan" (割り勘) is said to derive from "warimae kanjō" (割前勘定), an Edo-period term meaning to divide expenses equally among participants. Over time it was shortened to the familiar "warikan" used in modern Japanese.
In English, splitting a bill is often called "going Dutch." The expression dates back to the 17th century, when Dutch people had a reputation for frugality — though interestingly, there is no equivalent native phrase in Dutch itself, making it a distinctly English-language idiom. In most of the world, people simply say "split the bill."
Bill-splitting culture has evolved rapidly in the digital age. Apps such as Venmo and Splitwise have become widespread overseas, while PayPay's money-transfer feature is gaining traction in Japan. Nevertheless, cash remains deeply embedded in Japanese culture, keeping demand high for tools that calculate exactly who owes whom.