Everything you need to track and settle group expenses in Google Sheets™ — on desktop or mobile.
Search for SplitSheet in the Google Workspace™ Marketplace. Click Install and grant the permissions when prompted.
In Google Sheets™, click Extensions → SplitSheet → Open. The SplitSheet sidebar will appear on the right side of your screen.
In the sidebar, type a name into the Add person field and press Enter or click Add. Repeat for each person in your group. Free accounts support up to 3 people — upgrade to add more.
Each row in the spreadsheet is one expense. Fill in the Date, Expense name, Amount, and who Paid. Then check the boxes for each person who was part of that expense — unchecked people won't be included in the split.
Use the Category dropdown on each row to tag expenses as Food, Transport, Hotel, and more. This helps you see a breakdown of spending by type after syncing.
The Notes column lets you add any extra context to an expense — a restaurant name, a reference, or a reminder. It doesn't affect calculations.
Once you've entered your expenses, click the Sync & Recalculate button in the sidebar. SplitSheet will calculate everyone's share and generate a settlement summary showing exactly who owes who and how much.
In the settlement summary at the bottom of your sheet, there's a Settled? column with checkboxes. Check the box when someone has paid — the row will cross out automatically, and the Paid On date will be recorded.
Add-ons need to be installed from a desktop browser. Search for SplitSheet in the Google Workspace™ Marketplace on a computer, install it, and set up your group. Once installed, it'll be available on mobile too.
Open the Google Sheets™ app on your phone (iOS or Android) and navigate to the spreadsheet you've been using with SplitSheet. Make sure you're signed in to the same Google account.
Tap the three dots (⋯) in the top right corner of the screen, then tap Extensions, then tap SplitSheet. The SplitSheet panel will slide up from the bottom of your screen.
The Sync & Recalculate button works great on mobile. Tap it to refresh the settlement summary and see who owes who — useful when you're out and someone asks "wait, how much do I owe?"
You can check off the Settled? checkboxes in the sheet on mobile — just scroll to the settlement summary area. The Paid On date records automatically when you check a box.
The spreadsheet columns are narrow on a phone screen. Adding expenses — filling in dates, amounts, dropdowns, and checkboxes — is much easier on a desktop or laptop. Use mobile mainly for syncing and checking balances.
In Google Sheets™ on mobile, tap the star icon next to your SplitSheet file to pin it to your Starred section. That way you can get to it in one tap instead of searching every time.
Free for groups of 3. No subscriptions, no drama.