memlow
Sheet template

Split bills template

Going on a trip with friends or sharing a flat? Add each cost and who paid it, and this split bills calculator works out what everyone paid, their fair share and the balance. Above zero means they get money back; below zero means they owe.

Use this template About Memlow Sheets
  • Free
  • Private
  • Works offline
The expense split template in Memlow Sheets: costs with who paid, and each person's total, fair share and balance, with a chart

What's in this split bills sheet

  • A list of costs with the date, what it was for, who paid (picked from a dropdown) and the amount.
  • For each person: what they paid, their fair share of the total and their balance.
  • Positive balances in green and negative ones in red, so who owes is clear at a glance.
  • A chart of what each person paid against their fair share.

Use it on a trip or at home

  1. Put the sheet in a shared notebook, so everyone on the trip adds their own costs from their phone.
  2. Add a name to the Paid by dropdown in Data, Data validation, and a row for that person in the summary.
  3. When everyone has paid up, start a new tab for the next trip.

How to start

  1. Select Use this templateMemlow opens in your browser with a new sheet made from it, in Memlow Sheets. There is nothing to install.
  2. Fill it inType over the samples. Formulas, colours and charts update as you go, and everything is saved on your device, offline too.
  3. Make it yoursAdd rows, columns or tabs, change a formula, or share the sheet in a notebook. In the Android app, the same template is in Sheets, under Start a new sheet.

Questions about splitting bills

How does the split bills calculator work?

It adds up what each person paid, divides the total equally, and shows each balance. Someone above zero gets money back; someone below zero owes that much.

Can everyone add their own costs?

Yes. Share the sheet in a notebook and each person adds costs from their own phone or computer, encrypted end to end.

Is there a simpler version?

Yes. Memlow also has a Shared expenses note template: a table of who paid what, with the total added up.

More sheet templates

See all 12
Sheet templateMonthly budgetA free budget spreadsheetPlan each category, track spending and see what's left.See the template Sheet templateWeekly timetableTimetable templateYour week at a glance, hour by hour.See the template Sheet templateGrade trackerGrade calculator templateScores by subject, with averages worked out.See the template
Handy with this template: Memlow Sheets Note template: Trip planner Get started with Memlow Sheets

Start with a sheet, keep it private.

Memlow Sheets is free, with no AI. Your sheets stay on your device, or in your own Google Drive, encrypted.

Start writing free The Android app
Memlow's notes: colourful cards with checklists, reminders and folders