If you are looking for some online tool to do this, try this.

Vacation Itinerary and Packing List Template.

Employee Timesheet Calculator Template.

You may also like the Following Excel Templates: Now you know what you need when you sit down to calculate your share of the expenses 🙂ĭo 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.

Excel Formulas – A couple of big formulas, but nothing out of this world.

What goes into making this Shared Expense Calculator For the next month, simply duplicate the worksheets. The template is suitable for a month’s budgeting. The template comes with editable cells to customize the expense and income headers. The amount is mentioned in between the two names. Budget calculator is an easy-to-use tool to manage your expenses and income monthly in Excel desktop app, Excel online, and offline format. For example, in the example below, Michael (in red) owes Joe (in Green).

As soon as you enter the details, it automatically shows you the expense sharing summary.

So you can simply select the name from the list. The Who Paid column has a drop down that shows all the names you entered in Step 1.

Enter expenses in the Expense Details tab.

To do this, enter the names in the range A2:A11 in the worksheet ‘Backend Calculation’ (I have a dummy list here.

This could be the number of people on the trip or the number of people in the flat. Create a list of people among whom the expenses are to be shared.Now before you jump in and download the template, here is a little bit about how it works: Shared Expense Calculator All you need to do is enter the details, and it will automatically tell you who owes whom. It can be used when you are incurring expenses that are shared by many people (for example, sharing apartment expenses or vacation/trip expenses). Today I am here with a Shared Expense Calculator Template. At the end of every month, we would sit together, jog our memory to remember expense details, and use a calculator to get each person’s share. Four years ago, I was sharing an apartment with 3 of my friends.

Daily expense tracker excel sheet