JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Gallery
Shishir's Useful Mini-Templates
Share
Explore
Gallery
Shishir's Useful Mini-Templates
Shishir's Useful Mini-Templates
Shishir's Useful Mini-Templates
Product Comparison Template
Splitting Expenses in a Group
Wordle Habit Tracker
Dory / Pulse
Debate Judging Center
Storage Tracker
Trip Planner
Wedding Guest Estimation
Splitting Expenses in a Group
A super simple way to split expenses across multiple people and quickly calculate who should pay whom
Shishir Mehrotra
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
People
Name
Email
Expenses paid
Total Paid
Total Owed
Amount owed to each person
Notify person
Name
Email
Expenses paid
Total Paid
Total Owed
Amount owed to each person
Notify person
1
John
johnsmith1234@gmail.com
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
sjohnson5678@yahoo.com
7/3/23 Sarah pay to John $70.00 by Sarah
$70.00
$0.00
Notify
3
Michael
mdavis4321@hotmail.com
7/3/23 Michael pay to John $70.00 by Michael
$70.00
$0.00
Notify
4
Emily
emilywilson9999@aol.com
$0.00
-$60.00
Owe to John: $60.00
Notify
5
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
Expenses
Date
Vendor
Amount
Paid By
Split with
Split Amount
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
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 (
Ctrl
P
) instead.