And we used to get it wrong every time. Today I am here with a Shared Expense Calculator Template. It can be used when you are incurring expenses that are shared by many people (for example, sharing apartment expenses or vacation/trip expenses). All you need to do is enter the details, and it will automatically tell you who owes whom. I wish I had this template back then. Download the Expense Calculator Template Now before you jump in and download the template, here is a little bit about how it works:

Shared Expense Calculator

Excel Formulas – A couple of big formulas, but nothing out of this world. Excel Tables. Conditional Formatting. Custom Number Formatting.

Download the Expense Calculator
Now you know what you need when you sit down to calculate your share of the expenses 🙂 Do you like this shared expense calculator? Are there any other areas where you think an Excel template could be helpful? Share your thoughts in the comments section. You may also like the Following Excel Templates:

Excel Leave Tracker Template. Task Matrix Productivity Template. Employee Timesheet Calculator Template. Vacation Itinerary and Packing List Template.

If you are looking for some online tool to do this, try this. Give a try The excel sheet is good if expenses is shared by all of the friends, but I have few expenses that needs to be calculated only with few. Can you help me with that