Skip to content

1 or 2 credits, some free · 1 credit is about $1

pocketshelf

Group Trip Shared Expenses Tracker

Shared expenses tracker for a group of friends sharing the costs of a trip: who paid, each share and who owes whom, 3 charts. XLSX with a blank copy.

Dashboard tab: Shared spending $2,017, To settle $665, Biggest category Lodging, Settled so far $60; doughnut chart of Shared spending by category ($); column chart of Paid vs fair share, by...Balances tab: columns Person, Paid ($), Share ($), Sent ($), Received ($), Balance ($), In words; 9 sample rows.Expenses tab: columns Date, What, Category, Paid by, Amount ($), Split, Alex share, Sam share, Jordan share, Riley share, Check (auto), Month (auto), Year (auto); 15 sample rows.Settings tab: Currency symbol, Symbol position, Start month, Year and more.

DashboardPreviews of the Dashboard, Balances, Expenses and Settings tabs with sample data, drawn from the file. Fonts and chart styling can differ in Excel, Numbers and Google Sheets.

View full size (opens image)

What's inside

Format
XLSX, CSV
Contents
6 tabs · 3 charts
Version
1.1 · Updated 7 Oct 2026
Licence
Personal What this means
Checked
Checked before it ships
  • group-trip-shared-expenses-tracker.xlsxXLSX · 89 KB
  • group-trip-shared-expenses-tracker-blank.xlsxXLSX · 88 KB
  • group-trip-shared-expenses-tracker.csvCSV · 1 KB
  • LICENSE.txtadded to every download

About this item

A shared expenses tracker for a group of four on a week away, splitting costs evenly or charging one person. It has 6 tabs: Start Here, Dashboard, Expenses, Settle-Ups, Balances, Settings. Each shared cost you log is split evenly or charged to one person. The Dashboard with 3 charts shows what the group spent, how much needs to change hands to settle up ($665 in the sample data) and who pays whom, in one sentence. Log each payback on Settle-Ups and the balances update. Balances lists who paid, each person's share and a plain-words balance such as "Is owed" or "Owes". You get two files: one with sample data so you can see it working, and a blank copy with the same formulas. Nothing is password-locked. Made for Excel (XLSX).

Reviews

No reviews yet.

You might also grab