Group Shared Expense Calculator - Free Excel Template - Demo
This Group Shared Expense Calculator template can be used to calculate each person’s share of expenses in a group. For example, when you go on a trip with your friends where multiple people pay for shared expenses. At the end of the trip, you would need to calculate what each person owes and to whom.
Download: https://indzara.com/2016/09/group-exp...
FEATURES
Expenses can be split equally among all friends in a single step
Expenses can be split unequal among any number of friends
Expenses can be split unequal by % or Amount
Report shows all balances among friends
Calculates expense amounts for each friend
Step 1: Enter friends’ names. The template allows up to 12 friends.
Step 2: Enter the expense transactions
Split Type: There are three ways expense can be shared/split.
Split Equal: When the expense is shared equally among all the friends.
Split Unequal – %: When expense is shared unequally among friends and we know the share in %, we can use this split type.
Split Unequal – Amt: When expense is shared unequally among friends and we know the share in actual amounts, we can use this split type.
Step 3: View report
The sheet shows all the individual balances on who owes whom how much. We can also see the total amount a person owes and a person is owed to.
We can also select one friend to highlight that friend’s details and summary.
More Personal Finance Templates:
https://indzara.com/personal-finance-...
Simple and Effective Excel Templates: http://indzara.com/
Free Excel Templates: http://indzara.com/free-excel-templates/
Premium Excel Templates: http://indzara.com/shop/
Small Business Management Templates: http://indzara.com/small-business-exc...
Project Management Templates: http://indzara.com/project-management...
HR Templates: http://indzara.com/hr-excel-templates/
Free Excel Course: http://indzara.com/useful-excel-for-b...
Social:
Subscribe to YouTube: http://www.youtube.com/user/theindzar...
Facebook: / theindzara
YouTube: / theindzara
LinkedIn: / indzara
Twitter: / theindzara
~-~~-~~~-~~-~
Please watch my latest video: "Highlight events, weekends and holidays on calendar in Excel" • Highlight events, weekends and holidays on...
~-~~-~~~-~~-~