Skip to content
Splitsheet

Every trip expense, in one shared sheet.

Log who paid and split it evenly, by shares, by percentage, or to the exact cent. Everyone sees the same live balances, and when the trip ends Splitsheet works out who pays whom in as few payments as it can.

Weekend in Montréal

Live demo · edit anything

$490.01

Trip total

  1. Hotel, 2 nights

    Lodging

  2. Dinner in the Plateau

    Food

  3. Taxi to the airport

    Transport

    2
    1
    1

Balances

  • Ava+$119.99

    paid $300.00 · share $180.01

  • Blake−$65.00

    paid $90.00 · share $155.00

  • Casey−$54.99

    paid $100.01 · share $155.00

Settle up2 payments

  • BlakepaysAva$65.00
  • CaseypaysAva$54.99

Try it: switch the taxi to Equal, or take Casey off the hotel.

The ledger

A spreadsheet that does the arithmetic for you.

The trip is the sheet. Add a row, pick who it covers, and every balance on every screen updates, including on your friends' phones.

trip.ethanhaque.ca/trips/amalfi-coast
The Amalfi Coast trip ledger: twelve expenses from an airport transfer to a farewell dinner, each with category, payer, the people it is split between, and the amount, totalling €5,336.75.
  • One row per expense

    Date, category, who paid, and an avatar stack for who it covers.

  • A tab for each person

    Every traveler gets a sheet of their own, with their share of each row and a running balance pinned to the tab bar.

How it works

From the first expense to settling up.

  1. 1

    Start a trip

    Name it, set the dates and currency, and optionally a budget. Add people by name; they do not need an account yet.

  2. 2

    Invite the group

    Send a join link. Someone added by name can claim their spot later, and every expense already logged against them comes along.

  3. 3

    Log as you go, or import

    Add expenses from the ledger, attach a receipt photo, or drop in a card statement CSV. Categories are guessed and duplicates flagged before anything is added.

  4. 4

    Balances update live

    Edits show up for everyone viewing the trip right away, with avatars for who else has it open.

  5. 5

    Settle up

    Splitsheet proposes the fewest payments it can find to clear everyone. Mark each one paid as money changes hands, until everyone is squared up.

trip.ethanhaque.ca/trips/amalfi-coast
The trip overview below the ledger: a balance card per traveler, spending by category, and the settle-up plan listing three payments, each with a Mark paid button.

Step 5 in the app: balances, insights, and the settle-up plan.

The math

Where does the odd cent go?

Split $100 three ways and a naive app shows $33.33 × 3, which is $99.99. Somebody has to carry the extra cent, and every phone in the group has to agree on who.

Taxi to the airport$100.01 · shares 2 : 1 : 1
PersonExact ¢FloorLeftoverCharged
Ava×25000.505000+1$50.01
Blake×12500.2525000$25.00
Casey×12500.2525000$25.00
Total10001.0010000+1$100.01
  1. 1

    Work in whole cents

    $100.01 becomes 10001 cents. Each person’s exact share of that, by weight, is almost never a whole number.

  2. 2

    Round everyone down

    Flooring every share guarantees nobody is overcharged, and leaves a few cents unassigned. Here, 1.

  3. 3

    Hand out the leftovers by largest remainder

    The people who lost the most to rounding get one cent each. Ties go to the lowest member id, so every device lands on the same cent.

Settling up in as few payments as it can

Finding the true minimum gets slow as a group grows, so Splitsheet uses a quick rule: whoever owes the most pays whoever is owed the most, and repeat. It never takes more payments than one fewer than the number of people, but now and then it takes one more than strictly needed. Here is a case where it does.

Greedy plan (what ships)4 payments

  • DeepaysAna$3.00
  • ElipaysAna$1.00
  • ElipaysBen$2.00
  • CypaysBen$1.00

Optimal plan3 payments

  • DeepaysBen$3.00
  • ElipaysAna$3.00
  • CypaysAna$1.00

Features

Budgets, receipts, and the rest.

  • The trips dashboard in light mode: what you are owed and owe across every trip, trip cards for Amalfi Coast and Kyoto in Spring, a friends panel, and recent activity.

    Every trip at a glance

    Your net position across all trips, filtered by upcoming, active, or settled.

  • Budgets with a pace read

    An overall target and per-category caps, measured against the trip dates: on track, ahead of pace, or over.

  • Receipt photos

    Attach a photo to any row. A thumbnail sits in the ledger; click for the full-size lightbox.

  • Insights

    Spending by category and paid-versus-share per person, from the same numbers as the balances.

  • CSV export

    Download the ledger or the settle-up plan as a CSV.

Start your next trip.

Free to use. Create an account, start a trip, and send the link to the group.

Create your trip