Shishir's Useful Mini-Templates
/
Splitting Expenses in a Group
Share
Explore
Shishir's Useful Mini-Templates

icon picker
Splitting Expenses in a Group

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

info

How to use this template

It’s pretty simple:
Add each person (or family, etc) to the
People
⁠
table
Add every expense paid to the
Expenses
⁠
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
People
⁠
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
John
johnsmith1234@gmail.com
$330.00
$120.00
Collect from Emily: -$60.00
Collect from David: -$60.00
Notify
Sarah
sjohnson5678@yahoo.com
$70.00
$0.00

Notify
Michael
mdavis4321@hotmail.com
$70.00
$0.00

Notify
Emily
emilywilson9999@aol.com
$0.00
-$60.00
Owe to John: $60.00
Notify
David
dlee7777@gmail.com
$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
7/1/23
ABC Inc.
$100.00
$20.00
7/2/23
XYZ Corp.
$100.00
$20.00
7/1/23
Acme Co.
$50.00
$10.00
7/2/23
Ultra Tech
$50.00
$10.00
7/2/23
Big Supply
$30.00
$10.00
7/3/23
Sarah pay to John
$70.00
$70.00
7/3/23
Michael pay to John
$70.00
$70.00
There are no rows in this table
$470.00
Sum
⁠

Gallery
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.