SplitExpense

Manage Expenses

Running a household or when going on a group holiday, many expenses and purchases are shared between multiple people but paid only by a few. SplitExpense is an Add-on for Google Sheets to easily manage this.

With SplitExpense you can generate a Google Spreadsheet and share it with everybody. They can add what they have paid for and who the users are that consumed the items. The Add-on works out the consumed and paid totals and the balances for every person. This way you never have to worry about who paid what, just add it to the sheet and let SplitExpense show you.

Quick Start

With the Add-On installed, go to "SplitExpense > Generate New" and click on the "Sample" button. Browse the sheet to get a feel of how it all works.

Once you are ready, hit "Generate New" again and put in your own User Names and Symbols. Click "Generate" to create an empty sheet.

Every User has a one letter symbol of your choosing associated with them. You record the consumers of an item with a list of their symbols. For example "MT" could mean "Mark" and "Tim" were the users. The '*' symbol is special and represents the whole group. The item's cost are split as ratios so "MMT" would mean that "Mark" pays 2/3rds and "Tim" one third.

You can specify that users were only present for certain days by supplying date ranges in this format: yyyy-mm-dd~yyyy-mm-dd;

New users can be added from the menu "SplitExpense > Add User". Check out the Help page for more information on all of this.