Gallery
Shishir's Useful Mini-Templates
Share
Explore

icon picker
Splitting Expenses in a Group

A super simple way to split expenses across multiple people and quickly calculate who should pay whom

info

How to use this template

It’s pretty simple:
Add each person (or family, etc) to the table
Add every expense paid to the table, and just indicate which People it should be split with
Click Notify to send an email to each person with their amounts owed
Result: The table will show how much money each person owes AND who they should pay

To get started:
Copy page to doc
and
Clear People and Expenses table
A couple quick notes:
Split amount is always assumed to be split equally
It is not assumed that Paid By is included in Split with:
This is important because it allows for reimbursements to be just added as Expenses as well.
So if Person X reimburses Person Y, then they add an Expense that is Paid By X and Split with Y .

People
Name
Email
Expenses paid
Total Paid
Total Owed
Amount owed to each person
Notify person
1
John
7/1/23 ABC Inc. $100.00 by John
7/2/23 XYZ Corp. $100.00 by John
7/1/23 Acme Co. $50.00 by John
7/2/23 Ultra Tech $50.00 by John
7/2/23 Big Supply $30.00 by John
$330.00
$120.00
Collect from Emily: -$60.00
Collect from David: -$60.00
Notify
2
Sarah
7/3/23 Sarah pay to John $70.00 by Sarah
$70.00
$0.00

Notify
3
Michael
7/3/23 Michael pay to John $70.00 by Michael
$70.00
$0.00

Notify
4
Emily
$0.00
-$60.00
Owe to John: $60.00
Notify
5
David
$0.00
-$60.00
Owe to John: $60.00
Notify
There are no rows in this table
$470.00
Sum
$0.00
Sum
Expenses
Date
Vendor
Amount
Paid By
Split with
Split Amount
1
7/1/23
ABC Inc.
$100.00
John
Sarah
Emily
David
John
Michael
$20.00
2
7/2/23
XYZ Corp.
$100.00
John
Sarah
Emily
David
John
Michael
$20.00
3
7/1/23
Acme Co.
$50.00
John
Sarah
Emily
David
John
Michael
$10.00
4
7/2/23
Ultra Tech
$50.00
John
Sarah
Emily
David
John
Michael
$10.00
5
7/2/23
Big Supply
$30.00
John
Sarah
John
Michael
$10.00
6
7/3/23
Sarah pay to John
$70.00
Sarah
John
$70.00
7
7/3/23
Michael pay to John
$70.00
Michael
John
$70.00
There are no rows in this table
$470.00
Sum

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.