Shared expense calculator: who owes whom
Split trip, roommate or group expenses. Record who paid, choose participants and calculate balances and repayments, even across currencies.
Your data stays in this tab. We do not send names, amounts or files to our servers. Save a file before closing the tab.
People
Expenses
Add at least one expense to calculate.
Repayments already made
Record these here to reduce the balance. They are not new expenses.
Complete the expenses and calculate to see the result.
How to use the calculator
- Add the people and choose a result currency. You can pay an expense without participating in it.
- Record each original expense, payer and participants. For another currency, enter the rate agreed for that movement.
- Add repayments already made and calculate. Remaining minor units are assigned consistently so every share adds up to the total.
Choose a rule for each expense
- Equal shares when everyone owes the same amount.
- Weights or nights when, for example, people stayed in shared accommodation for different lengths of time.
- Percentages when the group agrees on proportions that add up to 100%.
- Agreed amounts when you already know each person’s exact share.
The rate specifies how many result currency units equal 1 original currency unit. Use your group’s agreed rate. We do not retrieve market rates.
Three friends, three expenses and a balanced result
Ana, Bruno and Carla share accommodation and groceries. Only Ana and Bruno take the taxi. These fictional amounts are in USD, not travel price estimates.
| Person | Paid | Their share | Balance |
|---|---|---|---|
| Ana | $360.00 | $190.00 | Receives $170.00 |
| Bruno | $120.00 | $190.00 | Owes $70.00 |
| Carla | $60.00 | $160.00 | Owes $100.00 |
Bruno pays Ana $70 and Carla pays Ana $100. Ana receives the $170 she paid above her own share. All three balances are now zero. Use the payment method you agree on, then record what happened.
Templates and guides to continue
An editable file with formulas. You can also import it into Google Sheets. Includes a fictional example and instructions to replace it.