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.

Fictional examples to try

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

  1. Add the people and choose a result currency. You can pay an expense without participating in it.
  2. Record each original expense, payer and participants. For another currency, enter the rate agreed for that movement.
  3. 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

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.

Fictional example · USD
PersonPaidTheir shareBalance
Ana$360.00$190.00Receives $170.00
Bruno$120.00$190.00Owes $70.00
Carla$60.00$160.00Owes $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.